Referencing Data

Excel 2010 (Windows)
  • 10 Videos | 43m 42s
  • Earns a Badge
Likes 14 Likes 14
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

  • Referencing your cells
    Using data across multiple sheets
    Choosing between absolute & relative cell references
    Naming your data ranges
    Performing calculations using constants
  • 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
    5m 16s
    UP NEXT
  • Playable
    2. 
    Using data across multiple sheets
    3m 35s
  • Locked
    3. 
    Choosing between absolute & relative cell references
    4m 32s
  • Locked
    4. 
    Naming your data ranges
    4m 36s
  • Locked
    5. 
    Performing calculations using constants
    5m 20s
  • Locked
    6. 
    Using cell references indirectly
    4m 15s
  • Locked
    7. 
    Keeping an eye on your data
    4m 8s
  • Locked
    8. 
    Activating automatic updates
    3m 4s
  • Locked
    9. 
    Using formula auditing
    3m 42s
  • Locked
    10. 
    Understanding formula errors
    5m 13s

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 26 Likes 26  
Likes 1 Likes 1  
Likes 6 Likes 6