JOIN THE EXCEL REVOLUTION
ENROLL IN A CLASS TODAY
Embark on a journey to level up your skills. Our public classes foster teamwork, expert instruction, and practical exercises in a welcoming space with classes for each skill level. We offer Excel, Power BI, and AI classes.
Excel Training Options
New to Excel or no formal training? Start with Excel Introduction for a solid foundation. Mastered basics? Try intermediate: Excel Formulas and Functions or Pivot Tables. Feeling advanced? Explore Excel Power Query and Power Pivot, or Macro Programming Introduction.
Need help choosing? Use our AI chatbot (bottom right), Contact Form or call us at 817-841-9560 to get guidance on our Excel courses.
Excel Introduction
Beginner Level | 1 Day Class- The Excel Environment
- Ribbon, Quick Access Toolbar, Shortcuts, and Navigation
- Workbooks, Sheets, Columns, Rows, Cells
- Formatting Cells, Freeze Pane, and Tables
- Formulas and Functions
- Statistical, IF and XLOOKUP Functions
- Visual Charts
- Pivot Tables
- Data Validation and Conditional Formatting
Excel Formulas and Functions
Intermediate Level | 1 Day Class- Formulas and Function Basics
- Arithmetic & Aggregation Functions
- Date, Time, & Financial Functions
- Text & Data Cleaning Functions & Flash Fill
- Logical & Conditional Functions
- Lookup & Reference Functions
- Dynamic Array Functions
Excel Pivot Tables
Intermediate Level | 1 Day Class- Introduction to Pivot Tables
- Golden Rules of Data Preparation
- Core Mechanics & Architecture
- Advanced Pivot Table Features
- Pivot Charts and Slicers
- Building Interactive Dashboards
Excel Power Query & Power Pivot
Advanced Level | 1 Day Class- Power Suite Overview
- Power Query: Extract, Transform, and Load
- Power Pivot: Data Models
- DAX (Data Analysis Expressions)
- DAX Calculated Columns and Measures
- Power Pivot Tables
Excel Macro Programming
Advanced Level | 3 Day Class- VBA Macro Programming Overview
- Recording and Understanding Macros
- Visual Basic Editor and Excel Object Model
- Variables, Data Types and Logic
- Control Structures
- Looping Through Ranges and Sheets
- Procedures and Functions
- Connecting to Data Sources
- User Interaction Events and Automation
- User Forms & Basic User Interface
- Performance Tuning
Need Help Picking?
Need help choosing the right Excel course? Try our AI chatbot (bottom right), Contact Form or call 469-620-8729 to get guidance on the right Excel course for you.
Power BI and Artificial Intelligence (AI) Options
We come from Excel, but we also have a few other tricks in our bag with our Power BI and Artificial Intelligence (AI) courses. We can help you ramp up with Power BI and we can help you level up with AI in your everyday tasks.
Power BI Desktop Introduction
Advanced Level | 2 Day Class- Power BI Overview, Ecosystem, and Workflow
- Power Query: Connecting to Data
- Power Query: Extract, Transform, and Load
- Data Modeling and Relationships
- DAX Calculated Columns and Measures
- Visualizations and Dashboards
- Performance Optimization
The AI-Augmented Professional
Beginner Level | 1 Day Class- AI Foundations for Business Professionals
- The Skill That Changes Everything — Prompting
- AI for Everyday Business Tasks
- AI + Documents, Data & Analysis
- Building Personal AI Workflows
- Best Practices and Common Pitfalls
Need Help Picking?
Need help choosing the right Excel course? Try our AI chatbot (bottom right), Contact Form or call 469-620-8729 to get guidance on the right Excel course for you.