Virtual Excel Bootcamp (October 2022)
October 31 @ 1:00 pm - November 3 @ 5:00 pm EDT
$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!
Prerequisites
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