Virtual Microsoft Excel Bootcamp
Event description
The Introduction to Excel Bootcamp is an intensive course that is designed to get you to use Excel comfortably. You will first learn about the structure of Excel, then you will dive right into learning different types of formulas and functions. Next, you will discover how to create models, tables, and charts to analyze your data better. You will also learn all about PivotTables, PivotCharts, and Power Pivot. This class will take you from Excel novice to PRO in four days!
Prerequisites
This course was created with the current version of Excel 365, but all features will also work in Excel 2010, 2013, and 2016 as well as Excel 365. Students should have a general knowledge of Excel prior to starting the class.
System Requirements
- Windows 11, Windows 10, Windows 8, or Windows 7
- Microsoft Excel
Course Outline:
- Module 01
- Excel Basics
- Intro to Excel
- Cell References
- Notation Styles
- Keyboard shortcuts
- Naming ranges and cells
- Conditional Formatting
- Module 02 – Working with Excel Tables
- Overview
- Sorting
- Filtering
- Aggregations
- Module 03 – Working with Functions and Formulas
- Formula Editing Tips
- Text Formulas (TRIM, LEFT)
- Date Formulas (DATE, DAY, HOUR)
- Logical Formulas (AND, IF)
- Math and Statistical Functions (AVERAGE, SUM)
- Date and Time Functions (TODAY, MONTH)
- IF Formulas
- Lookup and Reference Functions (INDEX and MATCH, VLOOKUP)
- Conditional Formatting
- Module 04 – Leveraging Excel Charts
- Creating and Designing Charts
- Module 05 – Data Visualization Principles
- Spatial Position
- Gestalt Principles
- The Problem with Pie Charts
- Module 06 – PivotTables
- PivotTables
- PivotCharts
- Module 07 – Power Query
- Data Cleansing with Power Query in Excel
- Module 8 – Building Data Models with Power Pivot
- Hierarchies
- Relationships
- DAX
- Module 9 – Designing Excel Reports (Connecting to Power BI Datasets)
- Excel and Power BI, better together
- Module 10 – Advanced Excel Elements
- Python in Excel
- Protecting and hiding information and formulas
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Microsoft Excel Bootcamp (May 13, 2024 – 5/16/24) | $1,995.00 | |
Add an event to your calendar
Instructor – Allison Gonzalez
Allison graduated from Flagler College in 2011. She has worked in management and training for tech companies for the past decade. As a Microsoft Certified Trainer, her primary focus is helping our customers learn the ins and outs of Power BI, along with Excel and Teams.