Loading Events

« All Events

Virtual Excel Bootcamp (October 2022)

October 31 @ 1:00 pm - November 3 @ 5:00 pm EDT



The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Virtual Excel Bootcamp (Oct 2022)
$ 1,995.00 $ 1,596.00

Boot Camp Details

The Introduction to Excel Boot Camp is an intensive course that is designed to get you using 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 better analyze your data. You will also learn all about PivotTables, PivotCharts, and Power Pivot. This class will take you from Excel novice to PRO in four days!


This course was created with the May 2022 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 1: Excel Basics
• Intro to Excel
• Cell References
• Notation Styles
• Keyboard shortcuts
• Naming ranges and cells


Module 2: 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)
• Lookup and Reference Functions (MATCH, VLOOKUP)
• Conditional Formatting


Module 3: Anatomy of an Excel Model
• Variables vs. Scenarios
• Forecast Planning


Module 4: Working with Excel Tables
• Overview
• Sorting
• Filtering
• Aggregations


Module 5: Leveraging Excel Charts
• Creating and Designing Charts


Module 6: Using the Form Controls
• Enabling the Developer Tab
• Form Control Basics


Module 7: Data Visualization Principles
• Spatial Position
• Gestalt Principles
• The Problem with Pie Charts


Module 8: PivotTables
• PivotTables
• PivotCharts


Module 9: Power Query
• Data Cleansing with Power Query in Excel


Module 10: Building Data Models with Power Pivot
• Hierarchies
• Relationships


Module 11: Building Analytical Calculations with DAX
• Calculated Columns
• Calculated Measures
• Time Intelligence


Module 12: Designing Excel Reports (Connecting to Power BI Datasets)
• Excel and Power BI, better together


October 31 @ 1:00 pm EDT
November 3 @ 5:00 pm EDT
Event Categories:


Allison Gonzalez