Completed
) Compare the dynamic (ability to update when source data changes) aspects of Formulas and Power Query.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Intro to Import, Clean and Transform Data for this section of the class
- 2 ) Use VLOOKUP to create better labels for our data set and for our PivotTable Report with % of Column Totals and a Slicer (Filter)
- 3 ) Get rid of extra spaces with the TRIM Function
- 4 ) Get rid of extra spaces with Flash Fill
- 5 ) Formula: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates. TEXT function, Custom Number Format “0000-00-00” and add zero (any math operation) to convert number stroed as te…
- 6 ) Text To Column: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates.
- 7 ) Power Query: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates.
- 8 ) Formula: Split Region and City from Same Cell. LEFT and SEARCH functions.
- 9 ) Flash Fill: Split Region and City from Same Cell.
- 10 ) Text To Columns: Split Region and City from Same Cell.
- 11 ) Formulas: Get Date and Sales from a transaction description in a single cell. See the MID, SUBSTITUTE, SEARCH and REPLACE functions.
- 12 ) Power Query: Get Department, Product, Date and Sales from a transaction description in a single cell.
- 13 ) Compare the dynamic (ability to update when source data changes) aspects of Formulas and Power Query.
- 14 ) Summary and Conclusion
