Start free

Browse › Excel Productivity

Can You Build a Dynamic Workbook in Microsoft Excel?

Expert

Part of Excel Productivity Topic: Essential IT

Access

StationX Infrastructure Labs — 3 attempts per lab

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab

Already have access? Sign in.

New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.

What you'll do

In this lab, you will create a dynamic workbook that uses formulas and functions to transform data.

  1. Import data from a text file
  2. Modify the style of the table
  3. Implement formulas and functions within the table to transform the data
  4. Implement charts to visualize the data