Excel Office 365: Referencing Data


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how to use reference cells in Excel for Office 365 in this 10-video course, which shows learners how to use cell coordinates to extract specified cell values, to reference individual cells, a range of cells, and entire columns and rows. First, learn how to reference data stored in different workbooks. Then you will examine when to use absolute, relative, and mixed cell references using the Fill function, or to copy formulas to a different cell or spreadsheet. You will learn how to name data ranges, how to refer to them in later calculations, and how to edit, adjust, and manage named ranges. This course demonstrates how to visualize, edit, and remove name ranges. You will learn how to use the INDIRECT formula to refer to a cell indirectly. You will learn how to use the Watch Window to monitor selected data entries from separate spreadsheets simultaneously, and how to activate and deactivate automatic updates. Finally, you will learn how to audit formulas in Excel.



Expected Duration (hours)
0.8

Lesson Objectives

Excel Office 365: Referencing Data

  • reference cells in your Excel worksheet
  • use data across multiple worksheets to reference data for formulas
  • define absolute and relative cell references
  • name data ranges to refer to date 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_msex365_11_enus

    Expertise Level
    Intermediate