Save time cleaning up and managing your data with Excel’s popular power tool
schedule1.5h
4.7(174)
Bigger Brains
•
Powering Productivity, One Brain at a Time!
207 Courses
• 4396 Reviews
Combining TV-style video production with modern graphics and animation, Bigger Brains courses are popular with both learners and training professionals around the world. Our top teachers and subject...
Kathy Jones
•
Certified Trainer
Kathy is a Microsoft Certified education/training professional with experience in all aspects of training. Her strengths include classroom presentations, organizational skills, problem-solving, progra...
About this course
Save time cleaning up and managing your data with Excel’s popular power tool
Have you spent a lot of time performing repetitive cleanup tasks on your data, using multiple VLOOKUP functions to merge data, or trying to combine multiple datasets? If so, then Excel’s Power Query tool will transform how you work. You’ll learn how to connect to multiple data sources and set up queries to remove unneeded data, manipulate existing data, and even create new columns. And the best part is, once you’ve set up your query, you’ll just refresh it when you need to perform those tasks. Microsoft-certified trainer Kathy Jones will show you how to use the Power Query Editor to perform all of these functions and streamline your workflow in the process.