Basic Accounting Equation



Class Notes       Excel 2016 Training Videos:

                          Introductory Video

Class 01              01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting

Class 02              02: Excel Fundamentals: Comprehensive Formula Lesson

Class 03              03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model 

Class 04              04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table

Class 05              05: Excel Array Formulas: Comprehensive Lessons

Class 06              06: Conditional Calculations with Excel Formulas: Comprehensive Lessons

Class 07              07 MAXIFS, MINIFS & IFS Functions for Conditional Calculations  

Class 08              08: Text Formulas and Text Functions to Join and Extract Data

Class 09              09: Date Formulas and Date Functions, including Fiscal Quarter & Year

Class 10              10: Excel Data Validation (List, Custom & More), Comprehensive Lesson

Class 11              11: Lookup Functions & Formulas, Comprehensive Lessons

Class 12              12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula 

Class 13              13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE

Class 14              14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa

Class 15              15: Excel Charts to Visualize Data: Comprehensive Lesson

Class 16              16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas

Class 17              17: Excel Dashboard PivotTable, Data Model, and DAX Formula 

Class 18              18: Clean & Transform Data: Replace, Text To Columns, Formulas

Class 19              19: Transform Data Sets using Advanced Filter (8 Examples) 

Class 20              20: Power Query (Get & Transform) Import Multiple Excel Files

Class 21              21: Power Query Import Multiple Excel Workbooks with Multiple Sheets

Class 22              22: How To Build Data Model & DAX Formulas in Power Pivot  

N/A                     Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New

Class 23              23: Intro to Power BI Desktop to Create Data Model & Visualization  

Class 24              24: Financial Functions: PMT, RATE, NPER and FV

N/A                     25: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more…

Class 26              26: Macro Recorder Basics & Copying VBA Code From Internet