Hello Excel Power Query, My New BFF
Learn to unlock Excel’s Power Query tool to automatically extract, transform, load and update routine data.
India Pricing:
₹32,390
Learning Mode:
Virtual
Power Query is one of the smartest, most powerful tools ever developed for Excel, with astonishing capabilities for extracting, transforming, and loading data. In this two-hour course, you’ll see how to leverage Power Query to take your Excel productivity to a new, exciting level.
Excel spreadsheets used in the class and are yours to keep, along with detailed directions showing how to replicate all the Power Query functions demonstrated in class.
What You Will Learn
- Scraping data from web tables, transforming it in Excel, and updating it with a single click.
- Fixing problem source data for use in analyses.
- Calculating medians per gender/job title.
- Merging and transforming multiple files in a folder, then adding or transforming additional files with a single click.
- Unpivoting problem sales commission data.
- Automating routine data transformation — such as merging, splitting, and removing columns; filtering and replacing data; rounding and sorting; converting text to numbers and dates; and more!
Who Will Benefit from This Course?
This course is ideal for compensation professionals who regularly use Excel to analyze large quantities of data – and who want to work faster and more efficiently.
Become a Member
Members gain exclusive access to research, publications, networking opportunities and more!