Need help? Talk to an expert: (904) 638-5743

Private Training

Instructors

# 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:
• Avaliable Seats: Limited seats remaining!
• Tickets: Get your ticket HERE

### 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