Referencing Data in Excel 2016 for Windows
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 cells in Excel 2016 for Windows6m 14sUP NEXT
-
2.Using data across multiple worksheets in Excel 2016 for Windows4m 3s
-
3.Choosing between absolute & relative cell references in Excel 2016 for Windows6m 23s
-
4.Naming your data ranges in Excel 2016 for Windows3m 16s
-
5.Performing calculations using constant values in Excel 2016 for Windows4m 8s
-
6.Using cell references indirectly in Excel 2016 for Windows3m 16s
-
7.Keeping an eye on your data in Excel 2016 for Windows5m 52s
-
8.Activating automatic updates in Excel 2016 for Windows3m 23s
-
9.Using formula auditing in Excel 2016 for Windows5m 51s
-
10.Understanding formula errors in Excel 2016 for Windows4m 36s
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.