Referencing cells in Excel 365 (2023)

“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.”