Referencing Data

Excel 2019 (Windows)    |    Intermediate
  • 10 Videos | 43m 35s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 123 Likes 123
Manipulating data in Excel begins with knowing how to reference cells. This involves using cell coordinates to extract the specified cells value. You can reference individual cells, a range of cells and entire columns and rows. In this 10-video course, you will discover absolute and relative cell references, by using data across multiple worksheets, and formula auditing in Excel 2019. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to reference data for formulas; and how to define absolute and relative cell references. Next, you will learn how to create named ranges to refer to data and facilitate calculations; how to use the Name Manager to visualize, edit, and delete existing named ranges; and how to perform calculations using constant values. Finally, learn how to use cell references indirectly; how to monitor data entries for changes and errors; how to activate and configure automatic updates; and how to use formula auditing tools to track data. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Referencing Data Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • reference cells in a worksheet
    use data across multiple worksheets
    use absolute and relative cell references
    name a data range
    manage named ranges
  • perform calculations using constant values
    use cell references indirectly
    keep an eye on data
    deactivate automatic updates
    use formula auditing tools

IN THIS COURSE

  • Playable
    1. 
    Referencing your cells
    5m 32s
    UP NEXT
  • Playable
    2. 
    Using data across multiple worksheets
    5m 9s
  • Locked
    3. 
    Choosing between absolute & relative cell references
    5m 17s
    FREE ACCESS
  • Locked
    4. 
    Naming your data ranges
    4m 43s
    FREE ACCESS
  • Locked
    5. 
    Managing named ranges
    2m 34s
    FREE ACCESS
  • Locked
    6. 
    Performing calculations using constant values
    4m 50s
    FREE ACCESS
  • Locked
    7. 
    Using cell references indirectly
    4m 28s
    FREE ACCESS
  • Locked
    8. 
    Keeping an eye on your data
    4m 19s
    FREE ACCESS
  • Locked
    9. 
    Activating automatic updates
    2m 48s
    FREE ACCESS
  • Locked
    10. 
    Using formula auditing
    3m 56s
    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 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

COURSE Adding & arranging data in Excel 365
Likes 13 Likes 13  
COURSE Manipulating PivotTable data in Excel 365
COURSE Managing Data
Likes 50 Likes 50  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Inserting PivotTables
Likes 231 Likes 231  
COURSE Getting Started
Likes 561 Likes 561  
COURSE Working with Different Chart Styles
Likes 41 Likes 41