Referencing data in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 7 Videos | 21m 31s
- Includes Assessment
- Earns a Badge
- CPE
In Excel 365, manipulating data requires knowing how to reference cells. This involves using cell coordinates to extract a specified cell's value. You can reference individual cells, a range of cells, or entire columns and rows. In this course, you will learn about absolute and relative cell references and how to use data references across multiple worksheets. 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 work with named ranges to refer to data and facilitate calculations, how to use cell references indirectly, and how to perform calculations using constant values. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this Referencing data in Excel 365 coursereference cells in Excel 365reference data used across worksheets and workbooks in Excel 365choose between absolute and relative references in Excel 365
-
use cell references indirectly in Excel 365manage named data ranges in Excel 365perform calculations using constant values in Excel 365
IN THIS COURSE
-
1.Overview: Referencing data in Excel 36551sUP NEXT
-
2.Referencing your cells3m 28s
-
3.Referencing data used across worksheets3m 48s
-
4.Choosing between absolute and relative references4m 16s
-
5.Using cell references indirectly3m
-
6.Managing named data ranges3m
-
7.Performing calculations using constant values3m 9s
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.