Referencing Data

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.