Referencing Data in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 7 videos | 32m 56s
  • Earns a Badge
Likes 12 Likes 12
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Referencing your cells in Excel 2016 for Mac
    6m 3s
    UP NEXT
  • Playable
    2. 
    Using data across multiple worksheets in Excel 2016 for Mac
    3m 56s
  • Locked
    3. 
    Choosing between absolute & relative cell references in Excel 2016 for Mac
    5m 40s
    FREE ACCESS
  • Locked
    4. 
    Naming your data ranges in Excel 2016 for Mac
    3m 33s
    FREE ACCESS
  • Locked
    5. 
    Activating automatic updates in Excel 2016 for Mac
    3m 7s
    FREE ACCESS
  • Locked
    6. 
    Using formula auditing in Excel 2016 for Mac
    4m 55s
    FREE ACCESS
  • Locked
    7. 
    Understanding formula errors in Excel 2016 for Mac
    5m 42s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Solving data problems in Excel 365
Course Using data in Sheets 2022
Channel TOSA Excel
Likes 169 Likes 169