Lesson 1: The Excel environment
• Navigating a worksheet
• Spreadsheet terminology
• Getting help
• Saving a workbook
• Opening a saved workbook.
Lesson 2: Entering and editing data
• Entering and editing text and values
• Entering and editing formulas
• Saving and updating workbooks
Lesson 3: Modifying a worksheet
• Moving and copying data
• Moving and copying formulas
• Inserting and deleting ranges, rows, and
• columns
• Cell comments
Lesson 4: Using functions
• Entering functions
• AutoSum
• Common functions
(SUM, MAX, MIN, COUNT, COUNTA,
COUNTIF, AVERAGE, MODE)
• Text functions (UPPER, LOWER,
PROPER, LEFT, MID, RIGHT)
Lesson 5: Formatting
• Text formatting
• Row and column formatting
• Number formatting
• Conditional formatting
• Additional formatting options
Lesson 6: Charts
• Inserting different chart types.
• Resizing and deleting a Chart
• Chart Title or Labels
• Chart Background Color
• Column, Bar, Line or Pie Slice Colors
• Copying and Moving Charts
Lesson 7: Working with sheets
• Inserting a New Worksheet
• Deleting a Worksheet
• Copying and moving a Worksheet
Lesson 8: Protecting Excel
• File Level Protection
• Workbook, Worksheet Protection
Lesson 9: Printing
• Preparing to print
• Page Setup options
• Printing worksheets
Lesson 10: Case Study
• Modifying existing worksheet
• Use shortcut keys
• Create and email worksheet
• Real Life examples