Referencing Data in Excel 2016 for Mac
Excel 2016 (Mac)
| Intermediate
- 7 videos | 32m 56s
- Earns a Badge
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
WHAT YOU WILL LEARN
-
reference cells in Excel 2016 for Macuse data across multiple worksheets in Excel 2016 for Macchoose between absolute and relative cell referencesname your data ranges in Excel 2016 for Mac
-
activate and deactivate automatic updatesuse the formula auditing tools in Excel 2016 for Macidentify formula error messages in Excel 2016 for Mac
IN THIS COURSE
-
1.Referencing your cells in Excel 2016 for Mac6m 3sUP NEXT
-
2.Using data across multiple worksheets in Excel 2016 for Mac3m 56s
-
3.Choosing between absolute & relative cell references in Excel 2016 for Mac5m 40s
-
4.Naming your data ranges in Excel 2016 for Mac3m 33s
-
5.Activating automatic updates in Excel 2016 for Mac3m 7s
-
6.Using formula auditing in Excel 2016 for Mac4m 55s
-
7.Understanding formula errors in Excel 2016 for Mac5m 42s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.YOU MIGHT ALSO LIKE

Course
Using data in Sheets 2022