Referencing Data
Excel 2019 (Windows)
| Intermediate
- 10 Videos | 43m 35s
- Includes Assessment
- Earns a Badge
- CPE
Manipulating data in Excel begins with knowing how to reference cells. This involves using cell coordinates to extract the specified cells value. You can reference individual cells, a range of cells and entire columns and rows. In this 10-video course, you will discover absolute and relative cell references, by using data across multiple worksheets, and formula auditing in Excel 2019. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to reference data for formulas; and how to define absolute and relative cell references. Next, you will learn how to create named ranges to refer to data and facilitate calculations; how to use the Name Manager to visualize, edit, and delete existing named ranges; and how to perform calculations using constant values. Finally, learn how to use cell references indirectly; how to monitor data entries for changes and errors; how to activate and configure automatic updates; and how to use formula auditing tools to track data. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Referencing Data Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
reference cells in a worksheetuse data across multiple worksheetsuse absolute and relative cell referencesname a data rangemanage named ranges
-
perform calculations using constant valuesuse cell references indirectlykeep an eye on datadeactivate automatic updatesuse formula auditing tools
IN THIS COURSE
-
1.Referencing your cells5m 32sUP NEXT
-
2.Using data across multiple worksheets5m 9s
-
3.Choosing between absolute & relative cell references5m 17s
-
4.Naming your data ranges4m 43s
-
5.Managing named ranges2m 34s
-
6.Performing calculations using constant values4m 50s
-
7.Using cell references indirectly4m 28s
-
8.Keeping an eye on your data4m 19s
-
9.Activating automatic updates2m 48s
-
10.Using formula auditing3m 56s
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.