Tutorialspoint

NEW YEAR, NEW DEALS! Get upto 80% OFF! Use: NEWYEAR

Microsoft Excel - Advanced Excel Formulas And Function

person icon Nikhil Lakhyani

4.3

Microsoft Excel - Advanced Excel Formulas And Function

Master Class of Microsoft Excel - Advanced Excel Formulas And Functions

updated on icon Updated on Jan, 2026

language icon Language - English

person icon Nikhil Lakhyani

English [CC]

category icon Business,Business Analytics and Intelligence,Excel

Lectures -60

Resources -2

Quizzes -10

Duration -3 hours

Lifetime Access

4.3

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

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 an 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, and how they can be applied in a number of ways.

I have divided this course into different sections, including:

  • Working With Excel List

  • List Functions

  • Data Validation

  • Working With A Large Set Of Excel Data

  • Excel Conditional Functions

  • Excel Lookup Functions

  • Excel Text-Based Functions

  • Auditing An Excel Worksheet

Protecting Excel Worksheet and Workbook

Working with Excel What If? Tools And So On.

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!

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

Goals

  • 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 formula and functions like Name Ranges, Vlookup, Hlookup and many more.

  • Learn how we can work with a large set of Excel data.

  • Learn how we can audit our Excel Worksheet.

  • Learn how we can protect our Worksheet and Workbook with a Password.

  • Learn how we can Master "What If?" Tools.

Prerequisites

  • You must have basic Microsoft Excel knowledge.

Microsoft Excel - Advanced Excel Formulas And Function

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

2 Lectures
  • play icon Course Introduction 01:14 01:14
  • play icon Excel Exercise File 00:26 00:26

Working With An Excel List

10 Lectures
Tutorialspoint

Excel List Functions

6 Lectures
Tutorialspoint

Excel Data Validation

4 Lectures
Tutorialspoint

Working With Large Sets Of Excel Data

6 Lectures
Tutorialspoint

Working With Excel Conditional Functions

9 Lectures
Tutorialspoint

Working With Excel Lookup Functions

6 Lectures
Tutorialspoint

Working With Excel Text Based Functions

4 Lectures
Tutorialspoint

Auditing An Excel Worksheet

5 Lectures
Tutorialspoint

Protecting Excel Worksheets And Workbook

4 Lectures
Tutorialspoint

Using "What-If Analysis" Tools In Excel

4 Lectures
Tutorialspoint

Instructor Details

Nikhil Lakhyani

Nikhil Lakhyani

Hi, Myself Nikhil Lakhyani.

I have over ten years of experience in teaching various subjects.

Now, I am continuing my teaching passion in Tutorials Point.

My talent is taking complex subjects and making them simple to learn.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515