Excel Classes
Mastering Excel
- Level 1
Excel INTRODUCTION Sep 14th – Learn BasicsOnline Class with Live InstructorCost: $169.99- Spreadsheet Layout & Formatting
- Dropdown Selections & Conditional Formatting
- Basic Formulas & Percentages
- Core Functions (
SUM,AVERAGE,COUNTA) - Sorting & Filtering Data
RegisterFor Beginners - Small GroupSep 14, 202611:00 AM to 3:00 PM EDT10:00 AM to 2:00 PM CDT9:00 AM to 1:00 PM MDT8:00 AM to 12:00 PM PDT - Level 2Mastering Excel – Intermediate Sep 3rd WorkShopOnline Class with Live InstructorCost: $169.99
- Absolute vs. Relative Cell References
- Multi-Sheet Formulas & Linkages
- Dynamic Excel Models & Table Objects
- Data Validation & Duplicate Removal
- Functions (
SUMIFS,AVERAGEIFS,COUNTIFS)
RegisterFormulas Linking to Other Sheets, SUMIFS, COUNTIFSSep 03, 202611:00 AM to 3:00 PM EDT10:00 AM to 2:00 PM CDT9:00 AM to 1:00 PM MDT8:00 AM to 12:00 PM PDT - Level 3Mastering Excel – InterPLUS Sep 4th WorkShopOnline Class with Live InstructorCost: $179.99
- Pivot Tables
- Shortcuts for Managing Large Datasets
- Lookup Functions (
XLOOKUP,VLOOKUP) - Data Summarization & Reporting
- Data Merging & Basic Charts
RegisterPivot Tables, VLOOKUP, XLOOKUP ..Sep 04, 202611:00 AM to 3:00 PM EDT10:00 AM to 2:00 PM CDT9:00 AM to 1:00 PM MDT8:00 AM to 12:00 PM PDT - Level 4Mastering Excel – Advanced Sep 8th WorkShopOnline Class with Live InstructorCost: $189.99
- Logical Tests
- Functions (
IF,IFS) - Logical Functions (
AND,ISBLANK) - Nested Formulas
- Working with Dates &
DATEFunction - Compare Two Tables
- Functions (
XMATCH,ISNUMBER)
RegisterIF, IFS, AND, XMATCH, Nesting, Dates & MoreSep 08, 202611:00 AM to 3:00 PM EDT10:00 AM to 2:00 PM CDT9:00 AM to 1:00 PM MDT8:00 AM to 12:00 PM PDT
Power BI Classes
Mastering Power BI
- Level 1
Power BI INTRODUCTION Jul 28th – Power PivotOnline Class with Live InstructorCost: $499.99RegisterVisualizations, Measures, Basic DAXJul 28, 20259:30 AM to 1:15 PM EDT8:30 AM to 12:15 PM CDT7:30 AM to 11:15 AM MDT6:30 AM to 10:15 AM PDT - Level 2Power BI INTERMEDIATE Jul 29th – Power QueryOnline Class with Live InstructorCost: $599.99RegisterPower Query – Prep, Reshape, Merge and Append DataJul 29, 20252:00 PM to 6:00 PM EDT1:00 PM to 5:00 PM CDT12:00 PM to 4:00 PM MDT11:00 AM to 3:00 PM PDT
- Level 3Power BI LEVEL 3 Jul 30th – DAX FunctionsOnline Class with Live InstructorCost: $699.99RegisterDAX, Context, CALCULATEJul 30, 20259:30 AM to 1:00 PM EDT8:30 AM to 12:00 PM CDT7:30 AM to 11:00 AM MDT6:30 AM to 10:00 AM PDT
- Level 4Power BI LEVEL 4 Aug 1st – M LanguageOnline Class with Live InstructorCost: $699.99RegisterM Language – Learn the Language of Power QueryAug 01, 20252:00 PM to 6:00 PM EDT1:00 PM to 5:00 PM CDT12:00 PM to 4:00 PM MDT11:00 AM to 3:00 PM PDT