# Referencing data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
• 7 videos | 21m 31s
• Includes Assessment
• CPE
Rating 4.6 of 416 users (416)
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

• This 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.
• To 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.
• 3.  Referencing data used across worksheets
In 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.
• 4.  Choosing between absolute and relative references
Moving 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.
• 5.  Using cell references indirectly
In 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.
• 6.  Managing named data ranges
Any 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.
• 7.  Performing calculations using constant values
In 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.

## 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.

## YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users (21)
Rating 4.5 of 380 users (380)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 1014 users (1014)
Rating 4.6 of 1179 users (1179)
Rating 4.5 of 2242 users (2242)