Referencing Data

Excel Microsoft 365 (Windows)    |    Intermediate
  • 10 Videos | 52m 28s
  • Includes Assessment
  • Earns a Badge
Likes 115 Likes 115
Explore how to use reference cells in Excel for Office 365 in this 10-video course, which shows learners how to use cell coordinates to extract specified cell values, to reference individual cells, a range of cells, and entire columns and rows. First, learn how to reference data stored in different workbooks. Then you will examine when to use absolute, relative, and mixed cell references using the Fill function, or to copy formulas to a different cell or spreadsheet. You will learn how to name data ranges, how to refer to them in later calculations, and how to edit, adjust, and manage named ranges. This course demonstrates how to visualize, edit, and remove name ranges. You will learn how to use the INDIRECT formula to refer to a cell indirectly. You will learn how to use the Watch Window to monitor selected data entries from separate spreadsheets simultaneously, and how to activate and deactivate automatic updates. Finally, you will learn how to audit formulas in Excel.

WHAT YOU WILL LEARN

  • reference cells in your Excel worksheet
    use data across multiple worksheets to reference data for formulas
    define absolute and relative cell references
    name data ranges to refer to date and facilitate calculations
    use the Name Manager to visualize, edit, and delete existing named ranges
  • perform calculations using constant values
    use cell references indirectly
    monitor data entries for changes and errors
    activate and configure automatic updates
    use formula auditing tools to track data

IN THIS COURSE

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

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 122 Likes 122  
Likes 1408 Likes 1408  
Likes 704 Likes 704