Advanced Formulas in Excel - Short Course image
course

Advanced Formulas in Excel - Short Course

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks.

Popularity
4.5 stars rating 4.5 stars rating 4.5 stars rating 4.5 stars rating 4.5 stars rating 4.5 stars rating
Audio English
Folder lesson (120 mins)
course

Advanced Formulas in Excel - Short Course

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks.

Popularity
4.5 stars rating 4.5 stars rating 4.5 stars rating 4.5 stars rating 4.5 stars rating 4.5 stars rating

What you'll learn

The Certificate in Advanced Formulas in Excel - Short Course Course will teach you:
check-circle Filter a dataset using a formula check-circle Sort a dataset using formulas and defined variables check-circle Create multi-dependent dynamic drop-down lists check-circle Perform a 2-way lookup check-circle Make decisions with complex logical calculations check-circle Extract parts of a text string check-circle Create a dynamic chart title check-circle Find the last occurrence of a value in a list check-circle Look up information with XLOOKUP check-circle Find the closest match to a value

Course Description

Microsoft Excel remains one of the best tools for formula analysis. In this course, we focus on the specific formulas, and tools that Excel has to help conduct advanced formula calculations.

We start by looking at how to filter a dataset and sort using formulas. After that, we look at a number of tools and functions that can be used to perform calculations before finally moving onto the advanced skill of looking up information using XLOOKUP.

This course also includes practice exercises so you can immediately put into practice the new formula techniques that you have learnt.