Referencing Data
Excel 2016 (Windows)
| Intermediate
- 10 Videos | 47m 2s
- Includes Assessment
- Earns a Badge
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.
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 cells6m 14sUP NEXT
-
2.Using data across multiple worksheets4m 3s
-
3.Choosing between absolute & relative cell references6m 23s
-
4.Naming your data ranges3m 16s
-
5.Performing calculations using constant values4m 8s
-
6.Using cell references indirectly3m 16s
-
7.Keeping an eye on your data5m 52s
-
8.Activating automatic updates3m 23s
-
9.Using formula auditing5m 51s
-
10.Understanding formula errors4m 36s
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.