From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Reference data using structured references
From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)
Reference data using structured references
- [Instructor] Let's talk about how to reference your data and formulas using structured references. When you convert a range of data to a table format, Excel names the table and assigns a range name to the data in each column. When we create formulas in a table, Excel automatically uses structured references. In this video, I'll demonstrate how to create a formula with a structured reference both on the same worksheet where the data is located and on a different worksheet. These are skills you might be asked to demonstrate during the Excel 2016 MOS Expert Exam. I have the 02_03 exercise file open, so let's get started. We're going to focus on our payroll worksheet. You can see that the data's already been converted to a table. Looking up at the Table Tools Design tab, I can see that the table name is still the default name, "Table1". That's how it names them. "Table1", "Table2", "Table3". It's just sequential. So let's go ahead and rename this table "Payroll". Remember when you're…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Manage workbooks4m 45s
-
(Locked)
Reference data in another workbook4m 28s
-
(Locked)
Reference data using structured references4m 7s
-
(Locked)
Protect worksheets and workbooks5m 27s
-
(Locked)
Challenge: Manage workbook options and settings1m 46s
-
(Locked)
Solution: Manage workbook options and setting7m 17s
-
-
-
-
-
-