Get startedGet started for free

Managing Columns

More data files are coming your way. This time, you have been asked to load a file on drug administrations and set it up for a quick ad-hoc analysis of prescription dates by doctor.

Your boss will fill you in with the details on which fields to keep and load into the workbook.

If you lost any progress, load the 1_1_managing_columns.xlsx workbook from the Exercises folder and open the Power Query editor.

This exercise is part of the course

Introduction to Power Query in Excel

View Course

Exercise instructions

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise