Microsoft Excel is used in many jobs and at home to organize data and perform reliable, repeat calculations. This course focuses on navigating Excel, entering data, performing calculations, modifying worksheets, formatting cells, and applying styles and themes.
We are now offering both in-person and live online sessions. Check session details for format.
To participate in the live online sessions, you must have
- a computer
- reliable internet connectivity
- Microsoft Excel version 2016 or later (preferably)
- computer audio with microphone or headphones with microphone
- webcam, built-in or added – strongly recommended for interaction with the instructor and class participants
This course can be applied to the following certificate:
Business Analysis Certificate
Course Outline/Topics
Lesson 1: Getting Started With Excel
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
Lesson 2: Performing Calculations
Topic A: Create Worksheet Formulas
Topic B: Insert Functions
Topic C: Reuse Formulas and Functions
Lesson 3: 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
Lesson 4: 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
Lesson 5: Printing Workbooks
Topic A: Preview and Print a Workbook
Topic B: Set Up the Page Layout
Topic C: Configure Headers and Footers
Lesson 6: Managing Workbooks
Topic A: Manage Worksheets
Topic B: Manage Workbook and Worksheet Views
Topic C: Manage Workbook Properties
Prerequisites
Experience using Windows
Instructor
Jennifer Buchholz is the founder of Excel & Flourish, a Microsoft Partner and Microsoft Certified Trainer who specializes in M365 adoption and training. She’s based in Milwaukee and has served companies in a variety of industries across the U.S. She… read more