Completed
) Power Query to Clean, Transform and Import Data into Excel to we can build a PivotTable Report with Calculated Columns
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Formulas, Cell Reference and Number Formatting Basics
- 3 ) ROUND Function
- 4 ) IF Function
- 5 ) SUMIFS and COUNTIFS Functions
- 6 ) VLOOKUP Function
- 7 ) VLOOKUP & SUMIFS to create Payroll Report
- 8 ) Define Data Analysis and Business Intelligence
- 9 ) PivotTables
- 10 ) Excel 2016 Data Model PivotTable from Two Different Tables
- 11 ) Flash Fill
- 12 ) Charts: Column, Bar, Line and X-Y Scatter Charts
- 13 ) Power Query to Clean, Transform and Import Data into Excel to we can build a PivotTable Report with Calculated Columns
- 14 ) Summary
