Sale!

Mynda Treacy – The Excel Power Query Course

$259 $55

Power Query is a free add-in built by Microsoft for Excel users like you and I. It’s available in all Desktop versions of Excel 2010 and 2013. And in Excel 2016, 2019, 2021 and Office 365 it’s built right into the Data tab in the Get and Transform group

  • Course’s name: Mynda Treacy – The Excel Power Query Course
  • Size: 1 GB
  • Delivery Method: Instant Download (You will receive the download link through your email right after making the payment)
  • Last Update: 2023

Chat with us or contact us via email coursesdownload.uk@gmail.com if you want to pay with Paypal or Credit Card

Description

Mynda Treacy – The Excel Power Query Course

Do you spend time each month cleaning and transforming data into the right format before you can even begin to analyse it or incorporate it into your reports?

Power Query is a free add-in built by Microsoft for Excel users like you and I. It’s available in all Desktop versions of Excel 2010 and 2013.

Power Query Ribbon
And in Excel 2016, 2019, 2021 and Office 365 it’s built right into the Data tab in the Get and Transform group:

Power Query Ribbon Excel 2016
It’s also available in Power BI Desktop.

You can download Power Query here. Note: the system requirements on this link are out of date as Power Query now works in all Excel 2010 Desktop SKU’s.

Mac users: Power Query won’t run on a Mac, sorry 🙁 You can install Windows on Mac using Parallels, Boot Camp or VMWare Fusion and then install Excel 2013 or later running under a VM.

Click here for a full list of Excel versions supporting Power Query.

What you get in the Power Query course:

  • Hands on Learning – Each Power Query topic I teach you comes with the practice file used in the video, so at every stage you can practice what you learn which helps retain knowledge and build confidence.
  • Download the completed Excel Power Query files created during filming and use them as a reference tool that you can go back to later on to refresh your memory.
  • The training is delivered online and tutorials are available to watch 24/7 so you can learn at your own pace. Pause, rewind, replay as many times as you like.
  • With just 6.5 hours of video tutorials you’ll be up and running with Power Query. I cover everything from installing Power Query, getting your data from a range of different sources, cleaning and transforming data, merging, unpivoting, and even writing and editing basic queries using the new Power Query language informally known as M.
  • Compatible with Excel 2010, 2013, 2016, 2019 and Office 365 – the videos are filmed in Excel 2013 and where there is a difference in Excel 2010 I cover that too. So whichever version you have you’ll know what to do. Note: in Excel 2016 onward Power Query has been integrated into the Data tab under the ‘Get and Transform’ group.
  • As with all of my courses the pace is pretty fast because I hate courses that waffle on and waste your time. I like to get straight to the point so you’re up to speed fast, and I’ve designed it so that if you need to re-watch anything you can rewind and replay the videos as many times as you like.
  • The average video length is under 5 minutes! So you can fit it in on a coffee break, on the train or bus to work, at the airport, or anywhere you have a spare 5 minutes and an internet connection.
  • 12 months access to the video tutorials and file downloads so you can refer back to them again and again. There’s even a download option where you can download all videos in the course and keep them on your own PC forever.
  • When you’ve finished I’ll send you a ‘Certificate of Completion’ saying you’ve completed the course, which you can add to your resume/CV arsenal.
  • BONUS e-Book: M is for (Data) Monkey by Ken Puls and Miguel Escobar. This book is not only a great reference point for Power Query, but will also extend your M programming abilities by teaching you various approaches to common data cleansing scenarios that can be easily solved with Power Query. The e-book is delivered via email 31 days after joining the course.

Sale Page: https://www.myonlinetraininghub.com/excel-power-query-course

Proof Download

Reviews

There are no reviews yet.

Be the first to review “Mynda Treacy – The Excel Power Query Course”