Introduction
  • Introducing the trainer and the course
  • Important Information on Extensive Support and Live Virtual Sessions
Data Manipulation in Excel and setting the foundation.
  • How Excel handles different data types
  • Data consistency, starting with the end in view
  • Building Datasheets that can scale
  • Sorting
  • Filtering
  • Data Cleaning part 1
  • Data Cleaning part 2
  • Data Formatting
Charts
  • Charts part 1
  • Charts part 2
Creative Excel Use and Tips
  • Creative Excel Features part 1
  • Creative Excel Features part 2
  • Specials -- Creative Excel Use part 1
  • Specials -- Creative Excel Use part 2
  • Special Video -- Excel Keyboard Shortcuts part 1
  • Special Video -- Excel Keyboard Shortcuts part 2
Business Data Analysis
  • Pivot Table, Pivot Chart and PowerPivot
  • Mail Merge
  • Business Data Analysis, part 1
  • Business Data Analysis, part 2
  • Business Data Analysis, part 3
  • Business Data Analysis, part 4
  • Forecasting using Excel 2016 Forecast tool
  • Data Visualization - part 1
  • Data Visualization - part 2
  • Excel Reports And Presentation
  • NamedRange, Goal Seek, Scenario Manager - part 1
  • NamedRange, Goal Seek, Scenario Manager - part 2
  • Protecting_Workbook_Worksheet_Printing
  • Excel Web Query
  • Power Excel Functions - part 1
  • Power Excel Functions - part 2
  • Power Excel Functions - part 3
  • Power Excel Function - SUMPRODUCT
  • New Excel Function - XLOOKUP
  • New Excel Function - UNIQUE
  • New Excel Function - SORT
Live Session on Advanced Filtering, Custom List, Data Validation, Charts...
  • Live Session - Part 1 Covering Advanced Filtering in-depth
  • Live Session - Part 2 Covering Custom Lists and Data Validation
  • Live Session - Part 3 Covering Dynamic Charts
  • Live Session - Part 4 Covering Conditional Formating and New Excel Formulas
  • Live Session - Part 5 Covering New Excel Charts and Intro to Infographics
  • Live Session - Part 6 Covering Questions and Answers
  • PowerQuery for automating report data update
Power BI
  • Power BI part 1
  • Power BI part 2
  • Power BI part 3
  • DAX Tutorial #1: CROSSJOIN
  • DAX #2: Meet the most popular DAX formula -- CALCULATE
  • DAX #3: VALUES, another must know DAX formula
  • DAX #4: CALENDAR, every sales/operations analyst friend
  • DAX #5: SUMMARIZE
Excel VBA
  • Excel Macros
  • Userform and more Macros - part 1
  • Userform and more Macros - part 2
Difference Between Data Analysis, Business Analysis, BI and Big Data
  • Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_1
  • Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_2
  • Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_3
  • Data Analysis vs Business Analysis vs Business Intelligence vs Big Data part_4
Demonstration of Pivot Table vs Power Pivot vs Power BI
  • Pivot Table vs Power Pivot vs Power BI part 1
  • Pivot Table vs Power Pivot vs Power BI part 2
  • Pivot Table vs Power Pivot vs Power BI part 3