Productivity & Collaboration Tools     Microsoft Office 365     Excel 365

---

The power of Excel 365 lies in the support given when using formulas with your data, which automatically update when the underlying data changes to ensure your calculations are always up to date. In this course, you will observe how to perform simple and more advanced calculations with formulas, including the use of built-in formulas such as SUM and COUNT, as well as working with formulas that include IFS, SWITCH, MAXIFS, MINIFS, COUNTA, OFFSET, COUNTIFS, MOD, QUOTIENT, and AVERAGEIFS.

You will start by discovering how to perform simple calculations within an individual cell; then explore how to use formulas to create automated cumulative totals in a table and insert subtotals. Following this, you will learn how to use different formulas to count cells in a range. Learn how to perform logical operations such as IFS and SWITCH, MAXIFS, and MINIFS, and keep your data up to date with COUNTA and OFFSET formulas. Finally, you will explore how to configure default formula options, find data with multiple conditions, factorize the results of a division, and calculate average values under different criteria.

---

---

Objectives

Excel 365: Performing data calculations using formulas discover the key concepts covered in this Microsoft 365: Performing data calculations using formulas in Excel 365 course perform simple calculations in Excel 365 create automated running totals in Excel 365 count cells in a range in Excel 365 use the IFS and SWITCH functions in Excel 365 use the MAXIFS and MINIFS functions in Excel 365 use the OFFSET function in Excel 365 configure default formula options in Excel 365 calculate averages with different conditions in Excel 365 determine the remainder of a simple division in Excel 365 Knowledge Check: Performing data calculations using formulas in Excel 365