Have more than 30 attendees? Issues during checkout? Or want to register your team directly with the help of a BusinessWatch Network Customer Representative? Please Reach Out To: [email protected]

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. (VBA still has its place.)

Why you 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.

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.

IMPORTANT NOTE: Power Query/Get and Transform is not available on the Mac platform, the mobile platform or Excel Online (Excel in a web browser).