NEED HELP? TALK TO AN EXPERT (904) 638-5743

Loading Events

« All Events

Virtual Excel Bootcamp (October 2022)

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

$1,596.00

Tickets

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!

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

Details

Start:
October 31 @ 1:00 pm EDT
End:
November 3 @ 5:00 pm EDT
Cost:
$1,596.00
Event Categories:
,

Organizer

Allison Gonzalez