Click here for the brochure.
The Basics
Create a New Workbook
Option 1
- Click File
- Click New
- Double Click workbook
Option 2
- Press Ctrl + N on your keyboard
Open a Workbook
Option 1
- Click File
- Click Open
- Select your file if it’s displayed
- Browse through various drives or online accounts connected
- Press Open
Option 2
- Press Ctrl + O on your keyboard
To Undo 
Option 1
- Click Undo
Option 2
- Press Ctrl + Z on your keyboard
Repeat
Option 1
- Click Redo
Option 2
- Press Ctrl + Y on the keyboard
Close a Workbook
Option 1
- Click the Close button
Option 2
- Click Ctrl + W on the keyboard
Get Help
Option 1
- Press F1
Option 2
- Type in Search bar
- It says Tell Me What you Want to Do
Cell Addresses
- Look at the name box for its address
Select a Cell
- Click or use the keyboard arrows
Select a Cell Range
Option 1
- Click and hold the corner and drag
Option 2
- Hold down Shift while clicking desired cells
Select an Entire Worksheet
Option 1
- Click Select All button
Option 2
- Click Ctrl + A on the keyboard
Minimize the Ribbon
Option 1
- Click the Minimize Ribbon
Option 2
- Press Ctrl + F1 on the keyboard
Change Program Settings
- Click File
- Select Options
- Make your Changes
- Press the OK button when done
Enable Macros
- Click File
- Select Options
- Click Customize Ribbon
- Check the Developer box
- Press the OK button when done
Use Zoom
Option 1
- Click and drag on the Zoom bar
- or Click the + & – buttons
Option 2
Click Ctrl and – or Ctrl and +
Change Views
- Click the View tab
- Select a View from the options
- Normal: Normal view
- Page Break Preview: Shows the breaks when printing
- Page Layout: Shows how it will look when printing
- Custom Views: Save views for quick access later
Editing
Edit a Cells Contents
Option 1
- Double-click the cell
- Start Typing
Option 2
- Select the cell
- Click the Formula Bar
- Start Typing
Clear a Cells Contents
Option 1
- Select the cell
- Press Delete
Option 2
- Click the Home tab
- Click Clear button
- Select Clear Contents option
Cut, Copy and Paste Data
Cut | Copy | Paste | |
Option 1
|
Press Ctrl + X | Press Ctrl + C | Press Ctrl + V |
Option 2
|
Click the Cut button | Click the Copy button | Click the Paste button |
Option 3
|
|
|
|
Preview an Item before Printing
- Click File
- Click Print
- Change options as needed before printing
Paste Special
- Use the Paste button list arrow
- Select paste special
Insert a Column or Row
Option 1
- Right-click the column/row label
- Select Insert
Option 2
- Click the Home tab
- Click in the row/column you want to remove
- Click the Insert button
- Select Insert Sheet Rows or Insert Sheet Columns
Delete a Column or Row
Option 1
- Right-click the column/row label
- Select Delete
Option 2
- Click the Home tab
- Click in the row/column you want to remove
- Click the Delete button
- Select Delete Sheet Rows or Delete Sheet Columns
Insert a Comment
- Right click where you want the Comment
- Select Insert Comment
Formulas and Functions
Total a Cell Range
Option 1
- Click the cell where you want the total
- Click the AutoSum button
Option 2
- Highlight the cells you want to be totalled
- Click the Quick Analisis icon
- Select Totals
- Pick Sum or other preferred option
Enter a Fo
rmula
- Type = then the equation you want
Insert a Function
- Select the cell
- Press Insert a Function
Reference a Cell in a Formula
Option 1
- Just type in the cell reference(ex =B5)
Option 2
- Click the cell to reference
Create an Absolute Cell Reference
- Absolute references do not change when copied or filled.
- Can use an absolute reference to keep a row and/or column constant.
Option 1
- Precede the references with $
Option 2
- Press F4
- ex. A1 to $A1 to $A$1
Formatting
Format Text
- Use the Font options
- Colour, Size etc.
Format Values
- Use the Number group
- Change the display to Time, Currency etc.
- Click More for more options
Copy Formatting with the Format Painter
- Select cells you want to copy the format of
- Click the Format Painter
- Click the cell to change
Format a Cell Range as a Table
- Click Home tab
- Highlight the cells for the table
- Click Format as Table
- Choose the desired design
Apply Conditional Formatting
- Select the cells to edit
- Click the Home tab
- Click the Conditional Formatting button
- Select one of the options
- Highlight Cells Rules
- Top/Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
Adjust Column Width or Row Height
Option 1
- Click and Drag accordingly
- You can see the sizing while dragging it
Option 2
- Double click it for it to auto-adjust
Option 3
- Click the Home tab
- Click the Format button
- Select a Sizing Option
- Row Height
- AutoFit Row Height
- Column Width
- AutoFit Column Width
Workbook Management
Insert a New Worksheet
- Click the Insert Worksheet button
Delete a Worksheet
- Right click the tab
- Press Delete
Rename a Worksheet
Option 1
- Right click the tab
- Press Rename
- Type in the name
Option 2 
- Double click the name
- Type in the new name
Change a Worksheets Tab color
- Right click the tab
- Select Tab Color
- Select a preferred color
Move or Copy a Worksheet
Option 1
- Click and drag the tab
Option 2
- Press Ctrl at then click to copy it
Freeze Panes
- Click the View tab
- Click Freeze Panes button
- Select your option
- Unfreeze Panes
- Freeze Top Row
- Freeze First Column
Adjust Page Margins, Orientation, Size and Breaks
- Click Page Layout tab
- Use the Page Setup grouping
- Click more for more options
Protect or Share a Workbook
- Click Review tab
- Use the protect options
- Protect Sheet
- Protect Workbook
- Share Workbook
- Protect and Share
- Allow Users to Edit Ranges
- Track Changes
Recover AutoSaved Versions
- Click File
- Look under the Manage Workbook section
- Select an AutoSaved version
Charts
- Click the Insert tab
- Pick a chart from the grouping
- Click More for more options
Keyboard Shortcuts
Keys | Task | Keys | Task |
Ctrl + O | Open a workbook | Shift + Enter | Up One Cell |
Ctrl + N | Create New | Ctrl + Home | To Cell A1 |
Ctrl + S | Save | F5 | Go to Dialog box |
Ctrl + P | Preview and print | Ctrl + X | Cut |
Ctrl + W | Close a Workbook | Ctrl + C | Copy |
F1 | Help | Ctrl + V | Paste |
F7 | Spelling check | Ctrl + Z | Undo |
F9 | Calculate Worksheets | Ctrl + Y | Redo |
F4 | Create Reference | Ctrl + F | Find |
Tab | Right One Cell | Ctrl + A | Select All |
Shift + Tab | Left One Cell | F2 | Edit Selected Cell |
Enter | Down Once Cell | Delete | Clear Contents |
Click here for the brochure.