StationX
Start free

Browse › Excel Expert Productivity

Can You Create a Comprehensive Workbook that Contains Data Analysis, Advanced Formulas, Macros, and Charts?

Guided

Part of Excel Expert 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 comprehensive workbook that contains data analysis, advanced formulas, macros, and charts.

  1. Include multiple worksheets with data on sales figures, expenses, and profits
  2. Create advanced formulas to calculate total sales, expenses, and profits
  3. Use macros to automate repetitive tasks, such as formatting, data entry, and data analysis
  4. Create advanced charts, including Box & Whisker, Combo, Funnel, Histogram, Sunburst, and Waterfall charts, to visualize the data