Course details

Excel 2019 for Windows: Referencing Data

Excel 2019 for Windows: Referencing Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Manipulating data in Excel begins with knowing how to reference cells. This involves using cell coordinates to extract the specified cells value. You can reference individual cells, a range of cells and entire columns and rows. In this 10-video course, you will discover absolute and relative cell references, by using data across multiple worksheets, and formula auditing in Excel 2019. 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 create named ranges to refer to data and facilitate calculations; how to use the Name Manager to visualize, edit, and delete existing named ranges; and how to perform calculations using constant values. Finally, learn how to use cell references indirectly; how to monitor data entries for changes and errors; how to activate and configure automatic updates; and how to use formula auditing tools to track data.



Expected Duration (hours)
0.7

Lesson Objectives

Excel 2019 for Windows: Referencing Data

  • reference cells in your Excel worksheet
  • use data across multiple worksheets to reference data for formulas
  • define absolute and relative cell references
  • create named ranges to refer to data and facilitate calculations
  • use the Name Manager to visualize, edit, and delete existing named ranges
  • perform calculations using constant values
  • use cell references indirectly
  • monitor data entries for changes and errors
  • activate and configure automatic updates
  • use formula auditing tools to track data
  • Course Number:
    ds_msex2019_11_enus

    Expertise Level
    Intermediate