Advanced Excel: Excel Formulas & Functions & Pivot Tables

Name: Advanced Excel: Excel Formulas & Functions & Pivot Tables
Rating: 4.9 (31 reviews)

Master Advanced Excel Formulas & Functions & Pivot Tables and Tips and Many More

Created byB Lakshmi R

Last updated 7/2026

English

What you'll learn

Master Advanced Excel Formulas and Functions to perform complex calculations, automate tasks, and analyze data efficiently using functions such as IF, IFS, XLO
Build Dynamic and Error-Free Worksheets by applying logical, lookup, text, date, and financial functions to solve real-world business and reporting challenges.
Create and Analyze Pivot Tables and Pivot Charts to summarize large datasets, generate meaningful insights, and build interactive reports for decision-making.
Improve Productivity with Advanced Data Analysis Techniques including data validation, conditional formatting, named ranges, dynamic formulas, and dashboard-rea

Course content

3 sections • 39 lectures • 20h 50m total length

Introduction6:17
master advanced excel formulas and functions, pivot tables, and dynamic arrays to analyze data, automate calculations, and create interactive reports from real-world datasets.

Excel 10139:50
Formatting42:34
Format cells and data in Excel to apply clear, consistent styling that improves readability and analysis across formulas, functions, and pivot tables.
Conditional Formatting22:15
Data Clearning55:42
Master data cleaning in Excel by applying advanced formulas and functions. Utilize pivot tables to organize cleaned data.
Functions1:02:26
Master advanced Excel formulas and functions, and pivot tables, as this course deepens your skills in Excel through formulas, functions, and pivot tables.
Functions Mixology in Excel27:40
Importance of Excel5:25
Master Excel to organize, analyze, and visualize data with formulas, functions, and pivot tables. Enhance productivity, automate tasks, manage finances, and drive better decisions in personal and professional settings.
New Functions Introduced By Microsoft40:33
Explore new functions introduced by Microsoft and master advanced Excel formulas, functions, and pivot tables to enhance data analysis.
Business Finance Functions23:32
Explore how Excel's financial functions—fv, fv schedule, pv, npv, xnpv, irr, mirr, xirr, nper, pmt, ppmt, rate—analyze investments, loans, and cash flows through practical garden and farm stand examples.
Business Finance Functions38:35
Explore business finance functions in Excel, applying advanced formulas, functions, and pivot tables to analyze financial data efficiently.
Pivot Tables22:23
Master pivot tables in Excel by cleaning data, building pivot tables, and analyzing revenue by class type, teacher, and time with slicers and timelines.
Lookup Functions29:01
Reviewing & Troubleshooting33:21
Review and troubleshoot advanced Excel formulas, functions, and pivot tables to verify accuracy and resolve common issues across spreadsheets.
Customizations & Collaborations17:06
Tips and Tricks in Excel6:38
Boost your Excel productivity with tips like autofill and flash fill, shortcuts, freeze panes, quick analysis, conditional formatting, AutoSum, paste special, and data validation.
Creating Macros Using VBA18:02
Build automation in Excel by creating and running macros with VBA, using the Developer ribbon and Visual Basic Editor to record, edit, and deploy custom scripts.
Excel Dashboard in Micrsoft Excel36:06
Excel Dashboard in Micrsoft Excel53:26
Master Microsoft Excel dashboards by applying advanced formulas, functions, and pivot tables to analyze data and present insights clearly.
Advanced Pivot Tables44:05
Master advanced pivot tables in Excel to analyze data using formulas and functions, enabling efficient data summarization and insights.
Advanced Uses of LookUp Functions1:00:45
Explore advanced uses of lookup functions in Excel, applying them with formulas and pivot tables to analyze data efficiently.
VBA Foundations1:02:37
Writing VBA Code39:05
Master writing VBA code to automate Excel tasks, integrating advanced formulas, functions, and pivot tables for efficient data analysis.
Your VBA Tool Kit25:49
Master a VBA toolkit for Excel, covering for each and for next loops, variable declaration, if and select case logic, and file handling with practical examples.
Debugging18:23
Beautifying Code43:05
Enhance readability and efficiency of advanced Excel formulas and functions by beautifying code and organizing pivot tables for clearer data insights.
UserForms & ActiveX Controls35:29
Master userforms and ActiveX controls in Excel to streamline data entry. Leverage formulas, functions, and pivot tables to enhance analysis and reporting.
Creating Your OWN Functions18:36
Learn to build your own Excel functions with user defined function (UDF) and DIY functions, using modules and function procedures, with examples like ColorSum, biz age, num only.
Productivity Hacks1:05:10
Discover productivity hacks for Excel by leveraging advanced formulas, functions, and pivot tables to speed up data analysis and reporting.
Financial Modeling Tools35:55
Explore financial modeling tools in advanced Excel, using essential formulas, functions, and pivot tables to analyze data and build robust models.

Requirements

No prior Excel experience needed—just a willingness to learn and level up your excel skills.

Description

Advanced Excel: Formulas, Functions & Pivot Tables is a comprehensive online course designed to help learners unlock the full power of Microsoft Excel for data analysis, reporting, and business productivity. Whether you are a student, working professional, analyst, accountant, or business user, this course will equip you with the advanced Excel skills needed to work efficiently with large datasets and make data-driven decisions. You will learn everything in this course from beginner to Advanced and real world projects enabling you to have real world knowledge.

Throughout the course, you will learn how to use powerful Excel formulas and functions, including logical, lookup, text, date, and mathematical functions. You will gain hands-on experience with advanced tools such as IF, IFS, XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, TEXT functions, and error-handling techniques to automate calculations and streamline workflows.

The course also covers Pivot Tables and Pivot Charts in depth, enabling you to summarize, analyze, and visualize large amounts of data with ease. You will learn how to create interactive reports, generate meaningful insights, and build professional dashboards for business reporting.

By the end of this course, you will be able to confidently analyze complex data, automate repetitive tasks, create dynamic reports, and use advanced Excel features to improve productivity and support informed decision-making in real-world scenarios.

Who this course is for:

This course is designed for those who want to learn from beginner to Advanced Excel

Advanced Excel: Excel Formulas & Functions & Pivot Tables

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

Microsoft Excel - Beginner to Advanced29 lectures • 17hr 4min

ChatGPT Fundamentals for Microsoft Excel9 lectures • 3hr 41min

Requirements

Description

Who this course is for: