Formulas and Functions
Learning Outcomes
Get More Info
data, Tech & ai skills in






What’s Included
Basic Arithmetic Operations
Basic Arithmetic Operations
Apart from the basic arithmetic operators (+ - x /), Excel has in-built functions such as SUM and COUNT, which I'll show you in this lesson.
Conditional Arithmetic
Conditional Arithmetic
COUNTIF and SUMIF apply conditions to basic arithmetic functions. This enables us to calculate subtotals such as total revenue for a given month, location and product type.
Max, Min and Average Functions
Max, Min and Average Functions
Basic statistics can quickly yield helpful insights from our datasets. Here I show you how to use Excel's statistics formulas on a company's sales data.
Logical Operators
Logical Operators
Operators such as AND, IF and OR give you much more control when performing data queries in Excel. Find out how to use them in this lesson.
Using the Switch Function
Using the Switch Function
Testing many IF conditions can become difficult to follow. The Switch function provides an alternative that is useful in certain situations.
Naming and Anchoring Cells
Naming and Anchoring Cells
Writing many formulas in Excel can get tedious and time-consuming. Naming and anchoring cells are two techniques that you can use to make the process faster and easier.
Array Formulas
Array Formulas
Array formulas allow you to perform calculations on multiple cells. Here I show you how to use them to create Max(IF) and Min(IF) functionality.
More On Array Formulas
More On Array Formulas
In this lesson, we'll see how to create array constants, and use them to calculate an array of sales with low revenue. We'll also see how to use an array formula to count unique values in a dataset.
Using SUMPRODUCT for Conditional Arithmetic
Using SUMPRODUCT for Conditional Arithmetic
SUMPRODUCT is a highly versatile formula that can be used in a number of different situations. In this lesson, we'll see how SUMPRODUCT can be used to perform conditional arithmetic, letting us calculate revenue for particular customer and products.
Adding Multiple Conditions to SUMPRODUCT
Adding Multiple Conditions to SUMPRODUCT
In this lesson, we'll see some more advanced uses of SUMPRODUCT. We'll see how we can identify sales or revenue satisfying multiple conditions using a single SUMPRODUCT function.
Consolidating Multiple Datasets
Consolidating Multiple Datasets
Excel's Consolidate tool lets you quickly combine and summarize data from multiple sheets in your workbook. Learn how to use it in this lesson.
Generating Random Numbers
Generating Random Numbers
Sometimes you may want to introduce randomness into your Excel spreadsheets. In this lesson, we'll look at RAND and RANDBETWEEN, Excel's two functions for generating random numbers, and use them to divide orders into multiple groups.
