Referencing Data
Excel 2010 (Windows)
| Intermediate
- 10 Videos | 43m 42s
- 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
-
Referencing your cellsUsing data across multiple sheetsChoosing between absolute & relative cell referencesNaming your data rangesPerforming calculations using constants
-
Using cell references indirectlyKeeping an eye on your dataActivating automatic updatesUsing formula auditingUnderstanding formula errors
IN THIS COURSE
-
1.Referencing your cells5m 16sUP NEXT
-
2.Using data across multiple sheets3m 35s
-
3.Choosing between absolute & relative cell references4m 32s
-
4.Naming your data ranges4m 36s
-
5.Performing calculations using constants5m 20s
-
6.Using cell references indirectly4m 15s
-
7.Keeping an eye on your data4m 8s
-
8.Activating automatic updates3m 4s
-
9.Using formula auditing3m 42s
-
10.Understanding formula errors5m 13s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.