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
    FREE ACCESS
  • Locked
    4. 
    Naming your data ranges
    3m 36s
    FREE ACCESS
  • Locked
    5. 
    Activating automatic updates
    3m 10s
    FREE ACCESS
  • Locked
    6. 
    Using formula auditing
    4m 58s
    FREE ACCESS
  • Locked
    7. 
    Understanding formula errors
    5m 45s
    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 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

CHANNEL Excel: Supplemental Resources
Likes  1
COURSE Referencing Data
Likes  66
COURSE Formatting data
Likes  1