The CFI Power Query Power-Up Challenge

One Week to Transform & Test Your Power Query Skills

Written by CFI Team

Published July 5, 2023

Updated July 18, 2023

Strengthen your business intelligence skills in just one week with The CFI Power Query Power-Up Challenge. After seven daily challenges you can complete in less than 20 minutes each, your Power Query expertise will help you supercharge your use of Excel, saving time and reducing errors.

Power Query is a business intelligence tool included with Microsoft Office that’s used for data prep and transformation, fundamental to a well-rounded Excel skill set. If you’re looking to start or build a career in data analysis, quantitative analysis, or business intelligence—or bring leveled-up data skills to any area of finance—this challenge will give you the Power Query power you need.

What you’ll learn:

Common transformations such as group by, pivot, and unpivot.
Extracting data using split columns and conditional columns.
Consolidation of data from multiple tables or files.
Future Proofing queries by thinking ahead to ensure automation keeps working.
Apply techniques to short examples and real world datasets using finance and airline data.

This is a free challenge that can be taken by all CFI members—sign up for a free membership (no credit card required!) if you don’t have one already. You’ll receive a daily email to complete that day’s challenge in your dashboard, each one taking less than 20 minutes.

This is a follow-up to The CFI Excel-erator Challenge, but you don’t have to complete one to take the other! Take the Excel-erator Challenge if you want to hone more general data analysis skills in Excel before focusing on Power Query.

Good luck! And be sure to share your progress on LinkedIn using the #CFIPOWERUP hashtag to connect with your fellow Power Query challengers!

Registration is closed.
Get ready to power up your Power Query for Excel skills starting July 19th!