Excel - Power Query: Turn Bad Data into Great Data in Minutes
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded excel trainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for plural sight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Do you spend time each month importing data into Excel from other sources such as CSV files, text files, web pages, databases and SharePoint?
Do you spend more time than is necessary getting your data into the right format for your reports, performing repetitive "data cleaning and transforming" tasks such as removing unnecessary rows and columns, filtering out data that you don’t need, converting text to numbers or dates, splitting or merging columns, removing "weird" characters or combining files together?
Would you like to be able to do all of this with the click of a button? With Power Query (known as Get and Transform in Excel 2016 and later) you can automate loading and updating external data into Excel and cleaning and transforming data. Of course, you can also do all of this with macros but who wants to learn VBA when you can do it using the Power Query Editor with a much shorter learning curve!
- Import data into Excel from sources such as text files, web pages and databases
- Avoid Excel’s "million-row limitation”
- Keep the imported data in sync with the source data using just two clicks
- Save a ton of time - automate the cleaning process
Course Level - Intermediate
Who Should Attend
This training is aimed at users of Excel who wish to learn about Power Query/Get and Transform. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.
Why Should Attend
If you work with, analyze and generate reports from external datasets and need to clean the data each time it is imported, having a good understanding and working knowledge of Power Query/Get and Transform is a must!