<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

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

Virtual Microsoft Excel Bootcamp

  • Start: Jan 22, 2024 8:00 AM EST
  • End: Jan 25, 2024 4:00 PM EST
  • Cost: $1,995.00
  • Instructor: Allison Gonzalez
  • Event Categories: ,
  • Avaliable Seats: Limited seats remaining!
  • Missed your change to sign up, but still want to get in on the fun? Contact us!
Image of the event

Event description

The Introduction to Excel Boot Camp 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

Add an event to your calendar

Add to Calendar
Event Instructor Image
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.