Microsoft Excel Advanced Formulas

Microsoft Excel Advanced Formulas

If you want to master Excel, you need to know how formulas work together to accomplish complex tasks. In this course, you will focus on a set of Excel formulas, functions, and tools that enable you to perform complex tasks and analysis. Start by looking at how to filter a dataset and sort using formulas. After that, look at how to create multi-dependent drop-down lists, 2-way lookups, text extraction, dynamic chart titles and so much more! Finish the course by looking at how to use XLOOKUP.

New Course - Not Enough Reviews Yet
11 student views

Course Goal

  • Sort a dataset using advanced Excel formulas and defined variables
  • Learn Advanced Excel formulas, functions, and tools to perform complex tasks and analysis
  • Create multi-dependent dynamic drop-down lists in Excel
  • Make decisions with complex logical calculations to effectively utilize Excel's most Advanced functions

Who This Training Is For

  • All SAP professionals
  • Consultants
  • End users
  • Executives and Managers
  • IT/Business analysts
  • Project Managers


  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Microsoft Excel Advanced Formulas certificate


Simon Calder

4.7 Average Rating

149 Reviews

1055 Students

24 Courses

Simon Calder

Teaching Business Software

The IT in Simon Sez IT stands for Information Technology. In a nutshell: We make business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design, and QuickBooks. Self-paced, affordable software training is what Simon Sez IT is all about. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you're new to a certain technology or just technology shy in general. Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.

Student Feedback

New Course - Not Enough Reviews Yet

Language: English
Level: Expert
Duration: 2.5 hours
Type:  Instructor-led
Category: Technology

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Business