Referencing Data

Excel 2013 (Windows)
  • 10 Videos | 1h 9m 6s
  • Earns a Badge
Likes 20 Likes 20
Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.

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
    7m 49s
    UP NEXT
  • Playable
    2. 
    Using data across multiple worksheets
    7m 5s
  • Locked
    3. 
    Choosing between absolute & relative cell references
    8m 35s
  • Locked
    4. 
    Naming your data ranges
    6m 43s
  • Locked
    5. 
    Performing calculations using constant values
    9m 11s
  • Locked
    6. 
    Using cell references indirectly
    6m 22s
  • Locked
    7. 
    Keeping an eye on your data
    6m 26s
  • Locked
    8. 
    Activating automatic updates
    4m 12s
  • Locked
    9. 
    Using formula auditing
    5m 12s
  • Locked
    10. 
    Understanding formula errors
    7m 32s

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 132 Likes 132  
Likes 115 Likes 115  
Likes 146 Likes 146  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 86 Likes 86  
Likes 146 Likes 146  
Likes 704 Likes 704