Excel Essentials

Course curriculum

1. What's Covered in the Course
  FREE PREVIEW
2. Check and Optimize Performance
3. Essential Keyboard Shortcuts
  FREE PREVIEW
1. Getting Started: The Ribbon, Quick Access Toolbar, and Commands
1. Copying and Moving Data
2. Moving and Copying Worksheets
3. Hide and Split Columns and Rows
4. Paste Special Shortcuts & Tricks
1. Working with Workbooks and Worksheets
2. File and Workbook
3. Using Save and Save As (Part 1)
4. Using Save and Save As (Part 2)
5. Using Undo and Redo
1. Functions: Getting Started
2. Formula by Example with AI
1. AutoFit, AutoFill, Absolute Reference, Working with Columns and Rows, and Merge Cells
2. AutoFill Text, Dates, and Numbers
3. AutoFill quiz
1. Use Find and Replace command
1. Print Area, Print Selections, and Printing Gridlines
2. Show and Print Formulas
3. Page Break Preview
4. Printing, Repeat Header Rows, and Print Options
5. Print Keyboard Shortcuts
1. Working with Flash Fill
1. Charts: Getting Started
1. Sorting: Getting Started
2. Filters: Getting Started
3. 3 Filtering Tips
1. Conditional Formatting: Getting Started

Enroll today