Referencing Data in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 10 videos | 47m 2s
  • Includes Assessment
  • Earns a Badge
Likes 100 Likes 100
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 in Excel 2016 for Windows
    6m 14s
    UP NEXT
  • Playable
    2. 
    Using data across multiple worksheets in Excel 2016 for Windows
    4m 3s
  • Locked
    3. 
    Choosing between absolute & relative cell references in Excel 2016 for Windows
    6m 23s
    FREE ACCESS
  • Locked
    4. 
    Naming your data ranges in Excel 2016 for Windows
    3m 16s
    FREE ACCESS
  • Locked
    5. 
    Performing calculations using constant values in Excel 2016 for Windows
    4m 8s
    FREE ACCESS
  • Locked
    6. 
    Using cell references indirectly in Excel 2016 for Windows
    3m 16s
    FREE ACCESS
  • Locked
    7. 
    Keeping an eye on your data in Excel 2016 for Windows
    5m 52s
    FREE ACCESS
  • Locked
    8. 
    Activating automatic updates in Excel 2016 for Windows
    3m 23s
    FREE ACCESS
  • Locked
    9. 
    Using formula auditing in Excel 2016 for Windows
    5m 51s
    FREE ACCESS
  • Locked
    10. 
    Understanding formula errors in Excel 2016 for Windows
    4m 36s
    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 Managing Data in Excel 2019 for Windows
Likes 50 Likes 50  
Course Referencing data in Excel 365
Course Finding & Grouping Data in Excel 2019 for Windows
Likes 95 Likes 95  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Formatting Data in Excel 2016 for Windows
Likes 231 Likes 231  
Course Basic Formulas in Excel 2016 for Windows
Likes 335 Likes 335  
Course Configuring Options & Settings in Excel 2016 for Windows
Likes 60 Likes 60