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 course
reference cells in Excel 365
reference data used across worksheets and workbooks in Excel 365
choose between absolute and relative references in Excel 365 -
use cell references indirectly in Excel 365
manage named data ranges in Excel 365
perform calculations using constant values in Excel 365
IN THIS COURSE
-
51sThis video outlines the key content covered in this Microsoft 365: Referencing data in Excel 365 course, including how to reference a cell or range of cells, how to use absolute and relative cell references when copying or automating formulas, and how to perform calculations using constant values in Excel 365. FREE ACCESS
-
3m 28sTo use the contents of a particular cell or cell range to manipulate data in Excel 365, you must know how to reference them. In this video, you will learn how to reference cells in Excel 365. FREE ACCESS
-
3. Referencing data used across worksheets3m 48sIn Excel 365, you can refer to data contained in completely different workbooks. In this video, you will explore how to reference data across worksheets and workbooks in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 1.1.2 Reference data in other workbooks. FREE ACCESS
-
4. Choosing between absolute and relative references4m 16sMoving or automating a formula in Excel 365 automatically adjusts the cell references it contains, but you can maintain the original cell reference. In this video, you will explore how to choose between absolute and relative references in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.1.1 Insert relative, absolute, and mixed references. FREE ACCESS
-
5. Using cell references indirectly3mIn Excel 365, you can reference cells indirectly when you want to manipulate data without adjusting formulas manually. In this video, you will learn how to use cell reference indirectly in Excel 365. FREE ACCESS
-
6. Managing named data ranges3mAny changes to named ranges in Excel 365 impact wherever the named range is used. In this video, you will explore how to manage named data ranges in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 2.3.1 Define a named range. FREE ACCESS
-
7. Performing calculations using constant values3m 9sIn Excel 365, you can use constant values so you don't have to update every formula when you want to change the value. In this video, you will discover how to perform calculations using constant values in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.1.2 Reference named ranges and named tables in formulas. FREE ACCESS
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.
