US $19.97

Advanced Formulas in Excel

——   Created by Simon Sez IT

Share this course:

NEW
Course
12
Lessons
2h 07m
Lesson time
intermediate
Skill level

More about this course

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this Advanced Formulas in Excel course, we focus on a set of Excel formulas and tools that enable you to perform complex tasks and analysis.

We start by looking at how to filter a dataset and sort using formulas. After that, we look at how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles and so much more! We end by looking at how to use XLOOKUP.

This course includes follow-along instructor files so you can immediately practice what you learn. This short course is not for Excel beginners. You will need an intermediate knowledge of Excel to get the most from this course.

In this course you will learn how to:

  • Filter a dataset using a formula
  • Sort a dataset using formulas and defined variables
  • Create multi-dependent dynamic drop-down lists
  • Perform a 2-way lookup
  • Make decisions with complex logical calculations
  • Extract parts of a text string
  • Create a dynamic chart title
  • Find the last occurrence of a value in a list
  • Look up information with XLOOKUP
  • Find the closest match to a value

12 Lessons

Section 1: Introduction
3 mins
Introduction
free preview
8 mins
Filter a dataset using a formula
free preview
Section 2: Advanced Formulas
14 mins
Sort a dataset using a formula and defined variables
11 mins
Multiple dependent dynamic drop-down lists
12 mins
Perform a 2-way lookup
17 mins
Make decisions with complex logical calculations
17 mins
Extracting parts of a text string
14 mins
Creating a dynamic chart title
14 mins
Finding the last occurrence of a value in a list
11 mins
Looking up information with XLOOKUP
9 mins
Find the closest match to a value
2 mins
Course Close
Section 3: Course Close
View more lessons +

About the instructor

Simon Sez IT
Simon Sez IT
  • 1 review
  • 34 courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon …

Read more
This course is included in Arbington Premium
$15/month gets you access to every course. Start your 14 day trial today. ☝️

Class benefits

  • Certificate of Completion
  • 30 day satisfaction guarantee
  • 24/7 streaming access
  • Direct teacher access
  • 2h 07m of on-demand video
  • 1 downloadable file
  • Have a coupon?
  • Checkout