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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
