SKILLSHARE ULTIMATE EXCEL COURSE 12 GET TRANSFORM DATA WITH POWER QUERY-iLLiTERATE
Submitted by milohaze on Fri, 04/26/2019 - 16:03
Category:
Genre:
This class is #12 in a series called the Ultimate Excel Course.
In this class you will learn how to use the magic of Power Query in Excel. Power Query has changed the way that we import, shape and load data into Excel. And if you are not familiar with it, you want to get up to speed FAST.
It was introduced with the 2010 version of Excel as an add-in. In Excel 2016 it became part of the Excel, so no add-ins required. So if you have 2016 great. If not just quickly Google and install the add-in. Takes 30 seconds.
This class will really show you the incredible power of this feature and why I think it must be learnt by all Excel users. It seriously is a game-changer. And this course really just skims the surface of its capabilities, but will really open your eyes.
During the class we will use it to import data from the web, text files, from a folder in a directory and even combine multiple worksheets into 1 with the click of a button.
Power Query makes importing, cleaning and transforming data as easy as any other skill in Excel. You won't need intense formulas (although they can be done also).
In this class you will learn how to use the magic of Power Query in Excel. Power Query has changed the way that we import, shape and load data into Excel. And if you are not familiar with it, you want to get up to speed FAST.
It was introduced with the 2010 version of Excel as an add-in. In Excel 2016 it became part of the Excel, so no add-ins required. So if you have 2016 great. If not just quickly Google and install the add-in. Takes 30 seconds.
This class will really show you the incredible power of this feature and why I think it must be learnt by all Excel users. It seriously is a game-changer. And this course really just skims the surface of its capabilities, but will really open your eyes.
During the class we will use it to import data from the web, text files, from a folder in a directory and even combine multiple worksheets into 1 with the click of a button.
Power Query makes importing, cleaning and transforming data as easy as any other skill in Excel. You won't need intense formulas (although they can be done also).