Power Query makes solving common data tasks easy. A lot of precious time is usually spent on repetitive manual work such as cut-and-paste tasks or combining columns and applying filters. The Power Query tool makes it much easier to perform such tasks. An added benefit is that Power Query is easier to use than other BI tools.
This CPE course is designed to equip participants with the essential skills to use Excel and Power BI Query Editor to create powerful calculated columns. Through a mix of theoretical explanations and practical demonstrations, learners will understand how to create dynamic columns in Tables that store the raw data, which can, in turn, drive business intelligence and decision-making.
The course is structured to provide a step-by-step approach, ensuring participants can apply what they have learned directly to their professional roles. This course is ideal for data analysts, business intelligence professionals, and anyone involved in data processing or reporting who seeks to enhance their skill set in data manipulation within Excel and Power BI.
Topics Covered:
Join this CPE course to Enhance your Excel skills. Explore advanced techniques and unlock the full potential of your data analysis capabilities.
Owner, The Excel Trainer
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Course Level
Credits
Instructional Method
Pre-requisites
Advance Preparation
MY-CPE LLC, 1600 Highway 6 south, suite 250, sugar land, TX, 77478
MY-CPE LLC (Sponsor Id#: 143597) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors.
WR
Fantastic class. Thank you!
Access to 13000+ Hours of Continuing Education Approved Content Know More
Subscribe To Access
