(Live/Recorded Masterclass Session with Live Q&A)
Note : It will be a mixed live/recorded version where attendee will receive the login credentials for the course one prior to the event. After watching recorded masterclass, Live Q&A session via Zoom/Teams will be held as mention on the below date. Note that the attendees will be granted with a full year of access to the recorded version of Masterclass (but without the Q&A part.)

What will Attendee Learn?
In this course, you’ll learn how Power Query can clean up, reshape and combine your data with ease – no matter where it comes from. Converting ASCII files into tables, combining multiple text files in one shot and even un-pivoting data is not only simple, but an investment in the future refreshable with a single click when next needed.

If you need to learn one skill in Excel today, how to work with Power Query is it. Not only will it change the way you “Get & Transform” data in Excel, but it’s also the system used to collect data for Power BI, meaning these skills are transferable to other programs.
✔ Review of Essential Tools
✔ Importing Data
✔Appending and Merging Tables
✔ Pivoting, Un-Pivoting and Transposing Data
✔ Conditional Logic
✔ Best Practices

Recommended Attendee
Anyone who needs to pull data into Excel, clean it up and/or consolidate it. Experience working with Pivot Tables is an asset, but not required ✔ Excel Users

Q&A Session Length : 2 days x 4 hours per day (+/-aprox.)
Date : 08th September 2022 & 09th September 2022
Time : 18:30 to 23:00 hrs – Azerbaijan Time (GMT +4)

Click here for speaker info