# Referencing Data

Excel 2019 (Windows)
• 10 Videos | 58m 35s
• Includes Assessment
• Earns a Badge
• CPE
• PMI PDU
Likes 84
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.

## 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
use formula auditing tools

## IN THIS COURSE

• 1.
• 2.
Using data across multiple worksheets
• 3.
Choosing between absolute & relative cell references
• 4.
Naming your data ranges
• 5.
Managing named ranges
• 6.
Performing calculations using constant values
• 7.
Using cell references indirectly
• 8.
Keeping an eye on your data
• 9.
• 10.
Using formula auditing

## 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 Managing Data
Likes 25
Likes 74
Likes 212

Likes 146
Likes 41
Likes 279