Referencing cells in Excel 365 (2023)

Excel 365 (2023)    |    Beginner
  • 8 videos | 27m 23s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.2 of 5 users Rating 4.2 of 5 users (5)
References are Excel are a way to refer to a cell, range, worksheet, or workbook in a formula. This course shows you how to use references to create formulas that dynamically update as the referenced cells change. The course begins by covering the basics of referencing. You will learn how to reference cells, ranges, rows, and columns. You will then see how to use them with the most common functions and operators in Excel to perform simple calculations. Next, the course explores the differences between relative references, which change as they are copied to other rows or columns, and absolute references, which stay the same. You will see how to use both types of reference in a formula, as well as mixed references, a combination of the two. In addition, you will learn how to reference cells in external worksheets and workbooks. You will also see how to give names to cells and ranges and to reference values by name. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the referencing cells in excel 365 course
    Reference cells, ranges, rows, and columns
    Use the functions average(), sum(), max(), and min() and arithmetic operators
    Choose between relative and absolute cell references
  • Use mixed references to copy formulas across rows and columns
    Reference data in a different worksheet or workbook
    Define and manage named ranges
    Reference named ranges in formulas

IN THIS COURSE

  • 1m 4s
    This video outlines the key content covered in the Referencing cells in Excel 365 course, including performing simple calculations, using absolute and relative references, and using mixed references. FREE ACCESS
  • 3m 55s
    In Excel, references are a way of indicating the values inside one or more cells. You can use cell references to copy values from one cell to another or use them inside of functions to perform calculations. In this video, you will see how to reference individual cells, as well as how to reference multiple cells, ranges, rows, and columns within the SUM() function. FREE ACCESS
  • Locked
    3.  Performing simple calculations in Excel 365
    5m 10s
    It is easy to get started using formulas in Excel. In this video, you will discover how to calculate the average, maximum, minimum, and sum of a set of values. This video aligns with MO-210 Microsoft Excel Exam objective: Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions. FREE ACCESS
  • Locked
    4.  Using absolute & relative references in Excel 365
    3m 54s
    By default, references to cells, rows, columns, and ranges are relative. This means they change when formulas are filled or copied into other cells. It is also possible to create an absolute reference in Excel. Absolute references will always refer to the same, fixed location when copied to another cell. Find out how to use absolute and relative references in this tutorial. This video aligns with MO-210 Microsoft Excel Exam objective: Insert relative, absolute, and mixed references. FREE ACCESS
  • Locked
    5.  Using mixed references in Excel 365
    2m 44s
    Mixed references combine the concepts of relative and absolute references. A mixed reference can refer absolutely to the column but relatively to the row, or vice-versa. These kinds of references are especially useful in matrices, where you need to copy formulas across rows and down columns at the same time. This video aligns with MO-210 Microsoft Excel Exam objective: Insert relative, absolute, and mixed references. FREE ACCESS
  • Locked
    6.  Referencing external data in Excel 365
    2m 15s
    This video aligns with MO-211 Microsoft Excel Expert Exam objective: Reference data in other workbooks. FREE ACCESS
  • Locked
    7.  Defining named ranges in Excel 365
    4m 7s
    By default, cells in a worksheet are referred to by their column letter and row number. However, it is possible to assign names to cells and ranges, making them easier to reference. In this video, you will see how to define and manage named ranges. This video aligns with MO-210 Microsoft Excel Exam objective: Define a named range. FREE ACCESS
  • Locked
    8.  Referencing named ranges in Excel 365
    4m 14s
    Named ranges can help make the meaning of your formulas more transparent. In addition, named ranges act as absolute references, keeping their value even as formulas are copied to other cells. This video shows you how to use named ranges in formulas. This video aligns with MO-210 Microsoft Excel Exam objectives: Navigate to named cells, ranges or workbook elements; and Reference a named range. 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 Performing data calculations using formulas in Excel 365
Rating 4.5 of 1501 users Rating 4.5 of 1501 users (1501)
Course Using references in Word 365
Rating 4.6 of 37 users Rating 4.6 of 37 users (37)
Course Working with tables in Excel 365 (2023)
Rating 4.0 of 5 users Rating 4.0 of 5 users (5)