24+ Best Advanced Excel Formulas and Functions

Master 24+ Advanced Excel Formulas and Functions like Conditional Functions and etc to increase your productivity.

It’s time to learn Advanced Excel Formulas and Functions.

What you’ll learn

  • Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch..
  • Automate, streamline and completely revolutionize your workflow with Excel Advance Formulas and Functions Like Name Ranges, Vlookup, Hlookup and many more..
  • Write advanced conditional, text, date and lookup functions..
  • Master unique tips & techniques that you won’t find in ANY other course, guaranteed..
  • Get LIFETIME access to project files, quizzes, and 1-on-1 expert support.

Course Content

  • Introduction –> 2 lectures • 2min.
  • Working With Large Set Of Excel Data –> 5 lectures • 21min.
  • Working With Excel Conditional Function –> 8 lectures • 37min.
  • Working With Lookup Function In Excel –> 5 lectures • 24min.
  • Working With Excel Text Based Functions –> 3 lectures • 9min.
  • Working With Formula Auditing In Excel Worksheet –> 4 lectures • 12min.
  • Protecting Excel Worksheets And Workbooks –> 3 lectures • 8min.
  • Using “What-If Analysis” Tools In Excel –> 3 lectures • 14min.
  • Working With Color Cells –> 1 lecture • 3min.

Auto Draft


It’s time to learn Advanced Excel Formulas and Functions.

Whether you’re starting from scratch or aspiring to become an absolute Excel power user, you’ve come to the right place.

This course will give you understanding of the Advanced Excel Formulas and Functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

This Microsoft Excel – Advanced Excel Formulas & Functions Course will tell you simply what each formula does, how they can be applied in a number of ways.

I have divided this course in different sections including:

  • Conditional Functions
  • Lookup Functions
  • Text-Based Functions
  • Formula Auditing
  • Protecting Excel Worksheet and Workbook
  • What-if Analysis Tools
  • Working With Color Cells

As the founder of Nikkyani Academy. My teaching style is conversational, authentic, easy and to the point, and I will always communicate complex/ difficult concepts in a framework that is clear and easy to understand.

If you’re looking for the Course where you can learn Microsoft Excel – Advanced Excel Formulas & Functions that you need to know to become an absolute Excel Hero, you’ve found it.

See you in the course!

Nikk ( Founder, Nikkyani Academy)


*NOTE: Full course includes downloadable resources, course quizzes and lifetime access and a 30-day moneyback guarantee. Most lectures compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021 & Office 365.


Get Tutorial