This course is intended for anyone who wants to gain a foundational understanding of Microsoft Excel. In this course, you will learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.
Participants should have a basic knowledge of and experience with Windows, including being able to start programs, switch between programs, locate saved files, and close programs.
To successfully attend this course, students will need a two-screen computer set-up and the desktop version (the web-based version is not suitable) of Microsoft Excel 2016 or newer installed and ready to use.
Course Outline
- 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
- Function wizard
- Printing Workbooks
- Page layouts
- Using page break preview
- Headers & Footers