5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office for Mac 2016     Microsoft Office for Mac 2016: Excel (No Assessments)

To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.



Objectives

Microsoft Excel 2016 for Mac: Referencing Data

  • reference cells in Excel 2016 for Mac
  • use data across multiple worksheets in Excel 2016 for Mac
  • choose between absolute and relative cell references
  • name your data ranges in Excel 2016 for Mac
  • activate and deactivate automatic updates
  • use the formula auditing tools in Excel 2016 for Mac
  • identify formula error messages in Excel 2016 for Mac