Excel 365 – Data references

Overview

Explore how to use reference cells in Excel for Office 365 in this 10-clip course, which teaches students how to use cell coordinates to extract certain values from cells, to reference individual cells, to a range of cells and in whole columns and rows. First, you will learn how to refer to data from different workbooks. Next, you’ll consider when to use absolute, relative, and mixed cell references using the Fill function, or how to copy formulas to a different cell or spreadsheet. You’ll 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 shows you how to view, edit, and delete named intervals. You will learn how to use the INDIRECT formula to refer to a cell indirectly. You’ll learn how to use Watch Window to monitor multiple data entries in separate spreadsheets simultaneously and how to turn automatic updates on and off. Finally, you will learn how to audit formulas in Excel.

Objectives

• refer to cells in your Excel worksheet
• use data from multiple worksheets to refer to data for formulas
• define absolute and relative cell references
• name data ranges to refer to data, and make calculations easier
• use the Name Manager panel to view, edit, and delete existing named ranges
• perform calculations using constant values
• use indirect cell reference
• monitor data for changes and errors
• enable and configure automatic updates
• use tools audit of formulas to track data