Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns

Basic Excel Business Analytics - Clean & Transform Data - Formulas, Flash Fill, Power Query, Text To Columns

ExcelIsFun via YouTube Direct link

) Power Query: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates.

7 of 14

7 of 14

) Power Query: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates.

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. 1 ) Intro to Import, Clean and Transform Data for this section of the class
  2. 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. 3 ) Get rid of extra spaces with the TRIM Function
  4. 4 ) Get rid of extra spaces with Flash Fill
  5. 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. 6 ) Text To Column: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates.
  7. 7 ) Power Query: Convert ISO Dates like 20140212 (Year, Month, Day) to Serial Number Dates.
  8. 8 ) Formula: Split Region and City from Same Cell. LEFT and SEARCH functions.
  9. 9 ) Flash Fill: Split Region and City from Same Cell.
  10. 10 ) Text To Columns: Split Region and City from Same Cell.
  11. 11 ) Formulas: Get Date and Sales from a transaction description in a single cell. See the MID, SUBSTITUTE, SEARCH and REPLACE functions.
  12. 12 ) Power Query: Get Department, Product, Date and Sales from a transaction description in a single cell.
  13. 13 ) Compare the dynamic (ability to update when source data changes) aspects of Formulas and Power Query.
  14. 14 ) Summary and Conclusion

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.