Referencing cells in Excel 365 (2023)
Excel 365 (2023)
| Beginner
- 8 videos | 27m 23s
- Includes Assessment
- Earns a Badge
- CPE
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 4sThis 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 55sIn 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
-
3. Performing simple calculations in Excel 3655m 10sIt 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
-
4. Using absolute & relative references in Excel 3653m 54sBy 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
-
5. Using mixed references in Excel 3652m 44sMixed 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
-
6. Referencing external data in Excel 3652m 15sWith Excel 365, data can be referenced not only within a workbook but also from external spreadsheets or workbooks. In this video, learn how to link data across different files. This video aligns with MO-211 Microsoft Excel Expert Exam objective: Reference data in other workbooks. FREE ACCESS
-
7. Defining named ranges in Excel 3654m 7sBy 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
-
8. Referencing named ranges in Excel 3654m 14sNamed 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.
