Referencing Data

Excel 2016 (Windows)    |    Intermediate
  • 10 Videos | 51m 2s
  • Includes Assessment
  • Earns a Badge
Likes 66 Likes 66
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.

WHAT YOU WILL LEARN

  • Referencing your cells
    Using data across multiple worksheets
    Choosing between absolute & relative cell references
    Naming your data ranges
    Performing calculations using constant values
  • Using cell references indirectly
    Keeping an eye on your data
    Activating automatic updates
    Using formula auditing
    Understanding formula errors

IN THIS COURSE

  • Playable
    1. 
    Referencing your cells
    6m 14s
    UP NEXT
  • Playable
    2. 
    Using data across multiple worksheets
    4m 3s
  • Locked
    3. 
    Choosing between absolute & relative cell references
    6m 23s
  • Locked
    4. 
    Naming your data ranges
    3m 16s
  • Locked
    5. 
    Performing calculations using constant values
    4m 8s
  • Locked
    6. 
    Using cell references indirectly
    3m 16s
  • Locked
    7. 
    Keeping an eye on your data
    5m 52s
  • Locked
    8. 
    Activating automatic updates
    3m 23s
  • Locked
    9. 
    Using formula auditing
    5m 51s
  • Locked
    10. 
    Understanding formula errors
    4m 36s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 282 Likes 282  
Likes 809 Likes 809  
Likes 70 Likes 70