Excel Power Query & Dashboards – 2 of 3
What You'll Learn
Key takeaways from this session
Calculations without formulas – the power of The Query Editor Ribbon
Combining data using Append & Merge Queries (and the difference between them)
Convert a single text string into multiple rows
Unpivot – the hidden gem and unsung hero of The Query Editor
Earn PDU Credits
PMI Professional Development Units
Total PDUs Available
For credential maintenance
PDU Breakdown
Ways of Working
Technical & process skills
Business Acumen
Strategic & organizational
Power Skills
Leadership & interpersonal
Watch the complete webinar to claim your PDU credits and maintain your PMI certification.
About the Presenter
TheExcelTrainer
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.



