Microsoft Excel Training – Level 1

1. Identifying parts of the Excel screen
2. Using & customizing the quick access tool bar
3. Using shortcut keys
4. Using the scroll bars & the status bar
5. Using page zooming

1. Activating a cell using the mouse
2. Moving around using the keyboard
3. Moving around using the name box or go to command
4. Moving to other worksheets within a workbook
5. Shortcuts to navigate

1. Selecting a single cell or a range of cells
2. Selecting non-adjacent cells or ranges of cells
3. Selecting a range of cells using shift key
4. Selecting a column, row, or worksheet
5. Selecting multiple worksheets

1. Entering types of data: text, numbers, & dates
2. Editing, replacing or deleting contents in a cell
3. Editing cell content using the formula bar
4. Using spelling & grammar check
5. Using undo or redo

1. Opening a new blank workbook
2. Saving a workbook & creating a new folder
3. Shortcuts to open & save a new workbook
4. Saving a workbook onto an external hard drive, CD RW or USB drive
5. Creating a new workbook using a built-in template on your computer
6. Working with the compatible mode

1. Opening an Excel workbook
2. Closing a workbook & exiting Excel
3. Shortcuts to open, close, or save

1. Cutting & pasting data
2. Copying & pasting data
3. Moving or copying data with drag & drop
4. Using the clipboard
5. Cut, copy & paste shortcuts
6. Using the paste special command

1. Using the status bar to do quick calculations without using formulas

1. Common Microsoft Excel Functions: Average, Count, Max, Min & Sum
2. Entering functions with the insert function button
3. Entering functions directly in the active cell
4. Using AutoSum command
5. Common Date & Time functions: Now, Date, & Today
6. Common Text functions: Right, Left, Upper, & Lower

1. Understanding absolute & relative cell references
2. Mixed absolute & relative cell references
3. Creating formulas with absolute, mixed & relative cell references

1. Inserting or deleting columns & rows
2. Increasing or decreasing column width & row height
3. Auto fitting column width & row height
4. Hiding or unhiding columns & rows
5. Shortcuts to insert or delete columns & rows

1. Using AutoFill or Autocomplete to enter text
2. Using the fill handle to enter custom lists
3. Filling a range of cells with the same data
4. Using the fill handle to enter sequence numbers, days or months

1. Inserting, formatting & modifying chart & axis titles
2. Formatting chart & plot area
3. Formatting wall & floor area
4. Changing legend location
5. Changing chart layouts or styles
6. Adding data table
7. Using data label options
8. Formatting data series