Microsoft Excel allows users to create and manage spreadsheets to manipulate data used in personal finance, budget preparation, financial and investment analysis, business modeling, sales forecasting and other calculating and analytical applications.
We are now offering both in-person and live online sessions. Check session details for format.
To participate in live online courses, you must have
- a computer
- reliable internet connectivity
- Microsoft Excel version 2016 or later preferably
- computer audio 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: Customizing the Excel Environment
- Configure Excel Options
- Customize the Ribbon and the Quick Access Toolbar
- Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
- Use Range Names in Formulas
- Use Specialized Functions
- Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional Formatting
- Analyze Data by Using Text and Logical Functions
- Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
- Create and Modify Tables
- Sort Data
- Filter Data
- Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
- Create Charts
- Modify and Format Charts
Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Slicers
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