Referencing cells in Excel 365 (2023)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.