Create Account

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

Excel 365 Power Query Get and Transform Data like a Pro
11-07-2019, 05:56 AM,
Excel 365 Power Query Get and Transform Data like a Pro
[Image: 01372efe1ca9aab852bfca1563b6c2f9.jpg]
Excel 365 Power Query - Get and Transform Data like a Pro
.MP4 | Video: 1280x720, 30 fps® | Audio: AAC, 44100 Hz, 2ch | 1.49 GB
Duration: 3 hours | Genre: eLearning Video | Language: English

Learn how to get and transform data like a pro using Excels Power Query
What you'll learn
Learn how to transform and clean data using Excels Power Query
Learn how to navigate Power Query and Connect to data sources
Learn how to work with column, row and table transformations
Get an introduction to M
Learn how to use parameters and custom functions
This course has been recorded in Excel 365, I would suggest using Excel 2016 and later for this course
An understanding of working in Excel is required
Are you ready to take your data analysis skills in excel to the next level? Do you want to learn how to connect to and transform data like a pro?
This course has been designed to take you from a beginner Power Query user to an advanced user in no time. Power Up on your Power Query Skills today.
In this course, we will first give you Your first look at Power Query and connecting to data sources. From there we will move into combining data and simple transformations, such a merge and append. We will look in detail at row and column transformations and then we will deep dive into table transformations.
After this, we will move on to more advanced power query. We will learn how to use Power Query to add new columns to our data and we will then Connect and Transform More Complex Data Structures. Finally, we will then introduce you to the powerful M code that runs power query and you will learn how to use parameters and create custom functions
So if you are interested in learning more, why don't you hop into the preview section and take a look.
This course is a hands-on practical course with workbooks to download and activities to complete
Who this course is for:
Excel users wishing to up skill in Power Query for data cleaning and data transformations

[Image: 7bb1653b46495bcdb667e0a99f81d8dd.jpg]



Possibly Related Threads...
Thread Author Replies Views Last Post
  Vanessa Ed Edwards - The Power of Happiness smack 0 61 01-17-2020, 01:14 AM
Last Post: smack
  T.Harv Eker - Secrets of Inner Power 2.0 marketingprofits 0 53 01-12-2020, 11:35 PM
Last Post: marketingprofits
  Secrets of Inner Power 2.0 with T. Harv Eker smack 0 76 01-11-2020, 07:46 PM
Last Post: smack
  Shaun T - Transform 20 G_P2018 0 47 01-02-2020, 06:27 AM
Last Post: G_P2018
  Power Study Complete G_P2018 0 86 01-02-2020, 06:23 AM
Last Post: G_P2018
  Transmutation Club - Mastering The Power Of Sex Energy Transmutation G_P2018 0 61 12-29-2019, 05:40 AM
Last Post: G_P2018
  Jason Capital - Power Influence System G_P2018 0 56 12-28-2019, 12:36 AM
Last Post: G_P2018
  Jeff Sauer - Fb Ads Complete Data Master Package G_P2018 0 121 12-20-2019, 09:41 PM
Last Post: G_P2018
  Facebook Ads Ads Complete Data Master Package by Jeff Sauer marketingprofits 0 159 12-17-2019, 12:46 AM
Last Post: marketingprofits
  FB Ads Complete Data Master Package with Jeff Sauer smack 0 114 12-16-2019, 11:43 PM
Last Post: smack

Forum Jump:

Users browsing this thread: 2 Guest(s)

Community Software by MyBB.