Get startedGet started for free

Working with structured cell references

Adventure Works is a global retail brand that sells bikes, bike parts, and accessories. Your role is to work as an Analyst to support their management teams understanding of their sales data.

In this exercise, we'll be working with their Sales table which contains all orders from 2017. We'll start by creating a new column that uses structured cell references to perform a calculation.

If you lost progress, close any open reports and load 1_4_working_with_structured_references.xlsx from the Workbooks folder on your local computer.

This exercise is part of the course

Introduction to Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise