Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel: Advanced Excel Formulas and Functions
New
Rating: 5.0 out of 5(4 ratings)
16 students

Microsoft Excel: Advanced Excel Formulas and Functions

Learn Microsoft Excel formulas and functions from zero step by step, build real skills, organize data, and work faster.
Created by365 Analysts
Last updated 5/2026
English

What you'll learn

  • Go from complete beginner to confident Excel user with this step-by-step course.
  • A Beginner's Guide to Microsoft Excel. Learn Excel Spreadsheets, Formulas, Shortcuts, Macros
  • Knowledge of all the essential Excel formulas
  • Increase your efficiency by learning how to create and use important Excel shortcuts
  • Harness full potential of Excel by creating Pivot tables with slicers

Course content

6 sections16 lectures38m total length
  • What is a Formula1:52
  • Basic Math Operations in Excel2:14
  • SUM Function1:49
  • Total Row in Tables (Smart Way)1:27
  • Average, Minimum, and Maximum Functions2:06
  • Absolute Reference2:23
  • Basic Formulas Quiz

Requirements

  • No experience needed, you'll learn everything you need to know right from the beginning.

Description

This course contains the use of artificial intelligence.
This course is designed to take you from zero to a confident Excel user step by step.

We start from the very beginning, assuming you have no experience at all.

You will learn Excel in a simple and clear way, with detailed explanations and real practice so you truly understand what you are doing.

We begin with the fundamentals:

What Excel is and how it works
Understanding rows, columns, and cells
Exploring the interface, ribbon, and tools
Typing and organizing data correctly

Then we move into core skills:

Formatting data to make it clean and professional
Adjusting rows and columns
Using tools like wrap text, format painter, and flash fill
Managing sheets, hiding, protecting, and organizing your work

After building a strong foundation, we go deeper:

Creating real tables and expanding data
Sorting data in different ways
Filtering data, including advanced filtering and filtering by color
Using smart tools to clean and fix messy data

Then we move into the most important part of Excel:

Formulas and functions explained in a simple way
Understanding how Excel thinks
Using calculations to solve real problems

After that, you will learn:

Working with large datasets
Data analysis techniques
Creating summaries and insights
Building simple reports

We also cover:

Best practices for organizing files
Working faster with smart techniques
Avoiding common mistakes beginners make

This course is built around practice.

You will not just watch.

You will build, try, fix, and repeat.

By the end of this course, you will be able to:

Understand Excel with confidence
Work with data in a clean and organized way
Use formulas to solve real problems
Analyze and sort information
Create professional worksheets

This course is perfect for:

Complete beginners
Students
Professionals who want to improve their Excel skills
Anyone who wants to move from basic use to real understanding

No previous experience is required.

All you need is Excel and the willingness to learn step by step.

This course focuses on clarity, practice, and real understanding

because that is what actually builds skill.

Who this course is for:

  • Anyone curious to learn excel from beginner to Advanced in short time.