Mynda Treacy – My Online Training Hub – The Excel Power Query Course

Description

Mynda Treacy – My Online Training Hub – The Excel Power Query Course

Do you do repetitive data cleansing tasks, such as:

Delete rows, columns, and blanks

Filtering out data you don’t need

Adjusting the layout to work in a PivotTable

Splitting or joining columns and text

Remove special characters and spaces from your data

Merging worksheets and text/CSV files together

Extracting data from an extern database

Incorporating the next month’s data to an existing report

….and all the other laborious repetitive tasks that put you to sleep and give you RSI

You’d be amazed at the tasks that macros can do in seconds if you knew how. Maybe you have macros that do it all, but maintaining the VBA code current is a constant task and no one knows how to update it.

The Good News

If you have Excel 2010 or later. Power Query To automate the tasks:

1. Access your data from anywhere
2. Cleansing and reformatting your data so it works in PivotTables, etc.
3. Updating your reports Power Query Updates to existing or new Tables, PivotTables, or Power Pivot models

What you get when you buy the Power Query course:

• Hands on Learning – Each Power Query The practice file for each topic I teach you is included in the video. This allows you to practice what you have learned, which helps you retain knowledge and builds confidence.
• Get the complete version 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. You can pause, rewind, and replay as many times you want.
• With just 6.5 hours of video tutorials you’ll be up and running with Power Query. I cover everything, from installing Power QueryYou can get your data from many different sources, clean and transform it, merge it, unpivot, or even write and edit basic queries using the new Power Query Informally, the language is known as M.
• Compatible with Excel 2010, 2013, 2016, 2019 and Office 365 – the videos are filmed in Excel 2013. 2013 and where there’s a difference Excel 2010 I also cover this. So whichever version you have you’ll know what to do. Not applicable to: Excel 2016 onward Power Query This information has been integrated under the ‘Get and Transform’ group in the Data tab.
• 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-You can rewind and replay any video as many times you wish.
• The The average length of a video is less than 5 minutes. You can do it during a coffee break, while waiting for the train or bus to work, or wherever you have 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.

Get Mynda Treacy – My Online Training Hub – The Excel Power Query Course Download