Power Query: Advanced Functionality Every User Needs to Know
Summary
If you’ve mastered the basics of Power Query but want to take your skills to the next level, join us, for a 90-minute workshop. We’ll provide step by step guidance for streamlining the combining, merging, and restructuring of your imported data - so that it’s in the right format for reporting.
Gain must-have skills and join us for this hands-on training to discover:
- Append & merge queries: Uses for combining data & their differences
- Advanced functions & ways to work with Power Query parameters
- How to quickly convert a single text string into multiple rows
- Solutions for simplifying queries using parameters
Program Highlights
We’ll cover the following & more!
- Working with text & dates
- Combining files from a single folder
- Simplifying queries using parameters
- Creating conditional and custom columns
- Converting a single text string into multiple rows
- Changing the layout so it will work in a PivotTable
- Appending tables with different column structures
- Appending data from multiple files into a single list
- Converting a table into a list in 2 clicks using Unpivot
Additional tools:
- Your questions & specific use-cases will be addressed in real-time, all throughout the workshop
- A 15-minute question & answer, plus wrap-up & review session
Program Benefits
It’s becoming more common for folks to use the Power Query feature of Excel to import data from external sources, such as databases, CSV files, and web pages.
However, they spend far too long combining, merging, and generally restructuring the imported data to ensure that it’s in the right format for reporting.In this workshop, we’ll put an end to that. You’ll gain solutions for turning bad data into useable data, in minutes!If you'd like this program customized for your organization, call us at 1-800-964-6033. We're certain we can fulfill your training needs, while making it fit in your budget!
About The Speaker
