Get and Transform Data in Microsoft Excel

Subscribe!
Get and Transform Data in Microsoft Excel is a great way to manage data.
and if you have a few minutes, I'm gonna teach you how to use it.
It creates a link to your information and then lets you automate the data cleanup.
It's crazy easy to use and It lets you connect to lots of different data types.

00:00 Introduction to Get and Transform Data
01:18 Connecting to Data
01:59 Previewing the Data
02:23 The Power Query Editor
02:45 Split Columns
03:31 Data Types and Right Click Commands
04:00 Undo Query Actions
04:20 Calculated Columns
05:42 Returning Data to Excel
#excel
#msexcel #microsoft #excel #msexcel #data #dataanalytics
For training or consulting, drop me a line at:
562-341-5148 ext. 700