Referencing data in Excel 365

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

  • 51s
    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. FREE ACCESS
  • 3m 28s
    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. FREE ACCESS
  • Locked
    3.  Referencing data used across worksheets
    3m 48s
    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. FREE ACCESS
  • Locked
    4.  Choosing between absolute and relative references
    4m 16s
    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. FREE ACCESS
  • Locked
    5.  Using cell references indirectly
    3m
    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. FREE ACCESS
  • Locked
    6.  Managing named data ranges
    3m
    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. FREE ACCESS
  • Locked
    7.  Performing calculations using constant values
    3m 9s
    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. 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.

YOU MIGHT ALSO LIKE

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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

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