Referencing data in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 7 Videos | 21m 31s
  • Includes Assessment
  • Earns a Badge
  • Certification 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

  • Playable
    1. 
    Overview: Referencing data in Excel 365
    51s
    UP NEXT
  • Playable
    2. 
    Referencing your cells
    3m 28s
  • Locked
    3. 
    Referencing data used across worksheets
    3m 48s
    FREE ACCESS
  • Locked
    4. 
    Choosing between absolute and relative references
    4m 16s
    FREE ACCESS
  • Locked
    5. 
    Using cell references indirectly
    3m
    FREE ACCESS
  • Locked
    6. 
    Managing named data ranges
    3m
    FREE ACCESS
  • Locked
    7. 
    Performing calculations using constant values
    3m 9s
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13  
COURSE Complete Guide to Excel 365: Getting Started
Likes 219 Likes 219  
COURSE Solving data problems in Excel 365