Microsoft Excel 2021

About This Course

• Course Description

Getting Started with Excel 2021

• Topic A: Navigate the Excel User Interface
• Topic B: Use Excel Commands
• Topic C: Create and Save a Basic Workbook 
• Topic D: Enter Cell Data 
• Topic E: Use Excel Help 

Performing Calculations

• Topic A: Create Worksheet Formulas 
• Topic B: Insert Functions 
• Topic C: Reuse Formulas and Functions

Modifying a Worksheet

• Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows 
• Topic B: Search for and Replace Data 
• Topic C: Use Proofing and Research Tools 

Formatting a Worksheet

• Topic A: Apply Text Formats 
• Topic B: Apply Number Formats
• Topic C: Align Cell Contents 
• Topic D: Apply Styles and Themes
• Topic E: Apply Basic Conditional Formatting
• Topic F: Create and Use Templates 

Printing Workbooks

• Topic A: Preview and Print a Workbook 
• Topic B: Set Up the Page Layout 
• Topic C: Configure Headers and Footers 

Managing Workbooks

• Topic A: Manage Worksheets 
• Topic B: Manage Workbook and Worksheet Views 
• Topic C: Manage Workbook Properties

Appendix A: Microsoft® Office Excel® 2021 Common Keyboard Shortcuts

Appendix B: Adding Borders and Colors to Worksheets

• Topic A: Add Borders and Colors to Worksheets 

Appendix C: Basic Excel Customization

• Appendix Introduction 
• Topic A: Customize General Options and the Excel UI