Description: This course is intended for anyone who wants to gain a foundational understanding of Microsoft Excel. Participants will learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.
Prerequisites: A basic knowledge of and experience with Windows, including being able to start programs, switch between programs, locate saved files, and close programs.
Note: Access to the Excel desktop app is required for this course.
Modules:
Foundations
- Getting to know Excel
- Ribbon/Quick Access Toolbar
- Getting Help
- Create a workbook
- Templates
- Themes and variants
Basic Navigation and Formatting
- Navigating a workbook
- Adding worksheets
- Basic cell formatting
Basic Formulas and Functions
- Order of Operations
- Using the formula bar
- Autosum
- The function wizard
Printing Workbooks
- Page layouts
- Using page break preview
- Headers & Footers