Course Content
Lesson 1: Getting Started
- Starting Excel
- Opening a Workbook
- Understanding the Display Screen
- Working with the Ribbon
- Exploring the File Tab
- Working with the Quick Access Toolbar
- Switching Between Opened Workbooks
- Using Excel Help
Lesson 2: Entering Data
- Moving the Cell Pointer
- Selecting a Range of Cells
- Creating a New Workbook
- Inserting, Renaming, and Deleting Worksheets
- Entering Constant Values
- Using Auto Fill to Enter Data
- Saving a Workbook
- Editing Cell Contents
- Clearing Cell Contents
- Working with Undo and Redo
- Closing a Workbook
Lesson 3: Using Formulas
- Entering Formulas
- Using Auto Fill with Formulas
- Using the SUM Function
- Summing Columns or Rows Automatically
- Using Statistical Functions
- Working with the Range Finder
- Using Formula Error Checking
Lesson 4: Working with Constant Values and Formulas
- Copying and Pasting Constant Values and Formulas
- Cutting and Pasting Constant Values and Formulas
Lesson 5: Formatting Worksheets
- Formatting Numbers
- Changing the Font Format
- Aligning Cell Contents
- Applying Cell Styles
Lesson 6: Modifying Columns and Rows
- Changing Column & Row Width
- Inserting and Deleting Columns or Rows
Lesson 7: Editing Workbooks
- Working with AutoCorrect
- Checking Spelling
- Using Find and Replace
Lesson 8: Printing Worksheets
- Using Print Preview & Working with Print Settings
- Using Page Setup Tools
- Working in Page Layout View
- Using Page Break Preview & Printing a Worksheet