Referencing Data
Excel 2013 (Windows)
| Intermediate
- 10 Videos | 1h 9m 6s
- Earns a Badge
Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.
WHAT YOU WILL LEARN
-
Referencing your cells
Using data across multiple worksheets
Choosing between absolute & relative cell references
Naming your data ranges
Performing calculations using constant values -
Using cell references indirectly
Keeping an eye on your data
Activating automatic updates
Using formula auditing
Understanding formula errors
IN THIS COURSE
-
1.Referencing your cells7m 49sUP NEXT
-
2.Using data across multiple worksheets7m 5s
-
3.Choosing between absolute & relative cell references8m 35s
-
4.Naming your data ranges6m 43s
-
5.Performing calculations using constant values9m 11s
-
6.Using cell references indirectly6m 22s
-
7.Keeping an eye on your data6m 26s
-
8.Activating automatic updates4m 12s
-
9.Using formula auditing5m 12s
-
10.Understanding formula errors7m 32s
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.
