excel
Page 1
Blank page.
Page 2: Introduction to MS-Excel
Excel is a computer program for creating electronic spreadsheets.
Users can organize data, create charts, and perform calculations.
It allows for large spreadsheets, efficient data reference, and better information storage.
Operates similarly to other Microsoft office products with shared functions and shortcuts.
Page 3: Overview of Excel
Microsoft Excel consists of workbooks; each workbook can have infinite worksheets.
Worksheets are made up of columns and rows.
The intersection of a column and a row is termed a cell (e.g., cell D5).
Bottom tabs represent different worksheets; scrolling buttons help in navigation.
Page 4: Office Button Commands
New: Open a new workbook (CTRL + N).
Open: Open an existing document (CTRL + O).
Save: Save the document (CTRL + S).
Save As: Save a copy of the document (F12).
Print: Print document (CTRL + P).
Prepare: Prepare document for distribution.
Send: Send a copy to others.
Publish: Distribute document.
Close: Close the document (CTRL + W).
Page 5: Tabs and Ribbon Structure
There are seven tabs across the top of the Excel window.
Groups: Sets of related commands displayed on tabs.
Commands: Buttons, menus, or boxes for entering information.
The ribbon consists of ribbons, tabs, groups, and commands.
Page 6: Working with Cells - Copy and Paste
To copy: Select cells, click Copy in Home tab.
To paste: Select destination cells and click Paste.
Page 7: Working with Cells - Cut and Paste
To cut: Select cells, click Cut in Home tab.
To paste: Select destination cells and click Paste.
The cut information will be removed from the original location.
Page 8: Formatting Text - Bold, Italics, Underline
Select a cell, click the desired text format command (Bold, Italics, Underline).
To change font style, select cells, and choose from Font Style drop-down.
Page 9: Formatting Text - Font Size and Borders
To change font size: Select cells and choose from Font Size drop-down.
To add a border: Select cells and click the Borders drop-down for options.
Page 10: Formatting Text - Text Color and Fill Color
To change text color: Select cells, click Text Color drop-down.
To add fill color: Select cells and click the Fill command for color options.
Page 11: Conditional Formatting - Apply and Remove
To apply: Select cells, go to Home tab - Styles group, click Conditional Formatting.
To remove: Select Conditional Formatting and choose Clear Rules.
Page 12: Conditional Formatting - Manage Rules
Manage rules by selecting Conditional Formatting and choosing Manage Rules.
Edit, delete, or change the order of rules using the dialog box.
To apply new formatting: Select Conditional Formatting and New Rules.
Page 13: Inserting Rows and Columns
To insert rows: Select the row below where the new row will appear, click Insert in Home tab.
To insert columns: Select the column to the right of where the new column will appear, click Insert.
Page 14: Editing - Fill Handle
Use the Fill Handle to copy content or to extend a series.
For a single cell selected, drag to fill the same content.
For two cells selected, Excel continues the pattern (e.g., 4, 8 becomes 12, 16).
Page 15: Sorting Data
To sort alphabetically: Select a cell in the target column, choose Sort A to Z.
To sort numerically: Select a cell in the target column, select Sort from Smallest to Largest.
Page 16: Cell Referencing - Relative Reference
A relative cell reference (A1) changes if the cell position changes.
Example: SUM formula from C1 moved to D3 also shifts reference to B3, C3.
Page 17: Cell Referencing - Absolute Reference
An absolute cell reference ($A$1) remains fixed regardless of cell position changes.
Examples maintain original references even when formulas are copied elsewhere.
Page 18: Cell Referencing - Mixed References
A mixed reference has either an absolute column or absolute row and relative counterpart.
Examples: $A1 (absolute column), A$1 (absolute row).
Page 19: Functions - DATEDIF Syntax
DATEDIF: =DATEDIF(START_DATE, END_DATE, "INTERVAL")
INTERVAL can be "D", "M", "Y", etc.
Page 20: Functions - SUMIF Syntax
SUMIF: =SUMIF(RANGE, CRITERIA, SUM_RANGE)
SUM_RANGE determines which cells will add under given conditions.
Page 21: Functions - IF Syntax
IF: =IF(LOGICAL TEST, VALUE IF TRUE, VALUE IF FALSE)
Returns value based on logical conditions check.
Page 22: Text Functions Syntax
TEXT Functions:
LOWER: =LOWER(TEXT)
UPPER: =UPPER(TEXT)
PROPER: =PROPER(TEXT)
Page 23: Text Functions - Character Extraction
Functions:
LEFT: =LEFT(TEXT, NUM_CHARS)
RIGHT: =RIGHT(TEXT, NUM_CHARS)
MID: =MID(TEXT, STARTNUM, NUM_CHAR)
Page 24: Other Functions
NOW: Current date and time.
TODAY: Current date only.
MOD: Remainder after division.
LEN: Number of characters in a string.
SUM: Adds all numbers in a range.
Page 25: Function Auditing
Trace Precedents: Indicates cells affecting current cell value.
Trace Dependents: Indicates cells affected by the current cell's value.
Page 26: Shortcut Keys (Part 1)
Keys for various functions such as editing cells (F2), creating charts (F11), inserting comments (SHIFT + F2), and more.
Page 27: Shortcut Keys (Part 2)
Provides keys for downfilling, rightfilling, inserting symbols, current date and time.
Page 28: Shortcut Keys (Part 3)
Keys for applying number formats, currency formats, and other formatting options in Excel.