Completed
) Intro to Import, Clean and Transform Data for this section of the class
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