Referencing Data

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

COURSE Using Formulas to Obtain Data
Likes 0 Likes 0  
COURSE Creating & Editing Macros
Likes 43 Likes 43  
COURSE Extracting Information with Formulas
Likes 20 Likes 20