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 cellsUsing data across multiple worksheetsChoosing between absolute & relative cell referencesNaming your data rangesPerforming calculations using constant values
-
Using cell references indirectlyKeeping an eye on your dataActivating automatic updatesUsing formula auditingUnderstanding 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.