Referencing Data

Excel 2016 (Mac)
  • 7 Videos | 33m 17s
  • Earns a Badge
Likes 10
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
    6m 6s
    UP NEXT
  • Playable
    2. 
    Using data across multiple worksheets
    3m 59s
  • Locked
    3. 
    Choosing between absolute & relative cell references
    5m 43s
  • Locked
    4. 
    Naming your data ranges
    3m 36s
  • Locked
    5. 
    Activating automatic updates
    3m 10s
  • Locked
    6. 
    Using formula auditing
    4m 58s
  • Locked
    7. 
    Understanding formula errors
    5m 45s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes  1
Likes  66
Likes  1