Completed
Free Advanced Excel Course at YouTube
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel 2016 Intermediate to Advanced - Comprehensive Calculations and Data Analysis
Automatically move to the next video in the Classroom when playback concludes
- 1 Free Advanced Excel Course at YouTube
- 2 Highline Excel 2016 Class 01: Excel Fundamentals: Efficiency, Data, Data Sets, Formatting
- 3 Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples)
- 4 Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model
- 5 Introduction to Power Query & Power Pivot Data Model in Excel 2016 (Excel Magic Trick 1468)
- 6 Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table…
- 7 Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lessons: 12 Examples
- 8 Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons
- 9 Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS Functions for Conditional Calculations
- 10 Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data
- 11 Highline Excel 2016 Class 09: Date Formulas and Date Functions, including Fiscal Quarter & Year
- 12 Highline Excel 2016 Class 10: Excel Data Validation (List, Custom & More), Comprehensive Lesson
- 13 Highline Excel 2016 Class 11: Lookup Functions & Formulas, Comprehensive Lessons, 20 Examples
- 14 Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula.
- 15 Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE
- 16 Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa
- 17 Highline Excel 2016 Class 15: Excel Charts to Visualize Data: Comprehensive Lesson 11 Chart Examples
- 18 Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas
- 19 Excel Magic Trick 1379: Power Query Combine Binary "Expand Button" Update January 2017
- 20 Highline Excel 2016 Class 17: How to Build Excel Dashboard PivotTable, Chart, Conditional Formatting
- 21 Highline Excel 2016 Class 18: Clean & Transform Data: Replace, Flash Fill, Text To Columns, Formulas
- 22 Highline Excel 2016 Class 19: Transform Data Sets using Advanced Filter (8 Examples)
- 23 Highline Excel 2016 Class 20: Power Query Import Multiple Excel Files & PivotTable Show Values As
- 24 Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets
- 25 Highline Excel 2016 Class 22: How To Build Data Model & DAX Formulas in Power Pivot
- 26 Excel Magic Trick 1299: Automatic Calendar Table in Data Model, New in Excel 2016
- 27 Highline Excel 2016 Class 23: Intro to Power BI Desktop to Create Data Model & Visualization
- 28 Highline Excel 2016 Class 24: Financial Functions: PMT, RATE, NPER and FV 12 Examples
- 29 Highline Excel 2016 Class 25: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more…
- 30 Highline Excel 2016 Class 26: Macro Recorder Basics & Copying VBA Code From Internet
