# Performing data calculations using formulas in Excel 365

Excel    |    Beginner
• 10 videos | 31m 23s
• Includes Assessment
• CPE
Rating 4.5 of 1501 users (1501)
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

## WHAT YOU WILL LEARN

• 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

## IN THIS COURSE

• This video outlines the key content covered in the Microsoft 365: Performing data calculations using formulas in Excel 365 course, including how to create automated running totals, configure your default formula options, and how to calculate average with different conditions.
• In Excel 365, simple and complex calculations are easy. In this video, you will discover how to perform simple calculations. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.2.1 Perform calculations by using the AVERAGE(), MAX(), MIN(), and SUM() functions.
• 3.  Creating automated running totals
If you have organized your data entries into chronological order, a cumulative total can be created once and then applied automatically to the rest of your data entries. In this video, you will learn how to create automated running totals in Excel 365.
• 4.  Counting cells in a range
Excel 365 has formulas that count cells based on conditions you set. In this video, you will explore how to count cells in a range in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.2.2 Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions. As well as MOS MO-201 / Excel Expert Certification exam objective: 3.1.1 Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions
• 5.  Using the IFS and SWITCH functions
The IFS and SWITCH functions allow you to test multiple conditions without nesting the IF function. With IFS you can use different operators while with SWITCH you can get a result for a non-exact match. In this video, you will explore how to use the IFS and SWITCH functions in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.1.1 Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions.
• 6.  Using the MAXIFS and MINIFS functions
If you're looking for the minimum and maximum values that meet a specific criterion, Excel 365 has two functions that can help you find it. In this video, you will explore how to use the MINIFS and MAXIFS functions. This video aligns MOS MO-201 / Excel Expert Certification exam objective: 3.1.1 Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions.
• 7.  Using the OFFSET function
With Excel 365, there's no need to constantly modify formulas as you're updating your tables and adding new data entries. In this video, you will discover how to use the OFFSET function in Excel 365.
• 8.  Configuring your default formula options
In Excel 365, you can customize various elements, including formulas, for your own convenience. In this video, you will learn how to configure default formula options. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 1.2.4 Configure formula calculation options.
• 9.  Calculating average with different conditions
If you want to find out an average, but you want to use specific criteria, Excel 365 has a function you can use. In this video, you will explore how to calculate the average with different conditions in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.1.1 Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions.
• 10.  Determining the remainder of a simple division
If you want to perform a simple division in Excel 365, you can use the QUOTIENT function and then use the MOD function to determine the remainder. In this video, you will discover how to factorize the results of a division.

## 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

Rating 4.5 of 449 users (449)
Rating 4.4 of 163 users (163)
Rating 4.6 of 416 users (416)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 416 users (416)
Rating 4.6 of 1179 users (1179)
Rating 4.6 of 1009 users (1009)