Referencing Data in Excel 2010 for Windows

Excel 2010 (Windows)    |    Intermediate
  • 10 videos | 43m 42s
  • Earns a Badge
Likes 17 Likes 17
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 in Excel 2010 for Windows
    5m 16s
    UP NEXT
  • Playable
    2. 
    Using data across multiple sheets in Excel 2010 for Windows
    3m 35s
  • Locked
    3. 
    Choosing between absolute & relative cell references in Excel 2010 for Windows
    4m 32s
    FREE ACCESS
  • Locked
    4. 
    Naming your data ranges in Excel 2010 for Windows
    4m 36s
    FREE ACCESS
  • Locked
    5. 
    Performing calculations using constants in Excel 2010 for Windows
    5m 20s
    FREE ACCESS
  • Locked
    6. 
    Using cell references indirectly in Excel 2010 for Windows
    4m 15s
    FREE ACCESS
  • Locked
    7. 
    Keeping an eye on your data in Excel 2010 for Windows
    4m 8s
    FREE ACCESS
  • Locked
    8. 
    Activating automatic updates in Excel 2010 for Windows
    3m 4s
    FREE ACCESS
  • Locked
    9. 
    Using formula auditing in Excel 2010 for Windows
    3m 42s
    FREE ACCESS
  • Locked
    10. 
    Understanding formula errors in Excel 2010 for Windows
    5m 13s
    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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Referencing Data in Excel 2016 for Windows
Likes 100 Likes 100  
Course Referencing data in Excel 365
Book Microsoft Excel Professional 2021 Guide: A Complete Excel Reference, Loads of Formulas and Functions, Shortcuts, and Numerous Screenshots to Become an Excel Expert

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Formulas in Excel 2010 for Windows
Likes 21 Likes 21  
Course Tools in Excel 2010 for Windows
Likes 72 Likes 72  
Course Manipulating Data in Excel 2010 for Windows
Likes 18 Likes 18