Virtual Microsoft Excel Bootcamp
- Start: Jan 21, 2025 9:00 AM EST
- End: Jan 24, 2025 5:00 PM EST
- Cost: $1,995.00
- Instructor: Angelica Choo Quan
- Event Categories:
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
- Need help convincing your boss? We can help.
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 (Jan 21, 2025 – 1/24/25) | $1,995.00 | |
Add an event to your calendar
Instructor – Angelica Choo Quan
Shortly after graduating from the University of Florida in 2012, Angelica moved to Jacksonville and began her career as a high school Biology teacher. As a trainer at Pragmatic Works, her primary goal is to help individuals feel more comfortable and confident using Power BI. While not in the office, she enjoys traveling around the city of Jax to check out local eateries, live music events, and performing arts.