Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel Formulas and Functions For Basic to Expert
Rating: 4.3 out of 5(62 ratings)
7,097 students

Microsoft Excel Formulas and Functions For Basic to Expert

Master Every Essential and Advanced Excel Formula & Function to Boost Productivity, Analyze Data & Solve Complex Problem
Created bySkillify Academy
Last updated 8/2025
English

What you'll learn

  • Relative and Absolute Cell References
  • CONCATENATE function
  • Date and DATEDIF Functions
  • EDATE and EOMONTH Functions
  • CHOOSE and SWITCH Functions
  • LEFT, MID, RIGHT & LEN Functions
  • UPPER, LOWER, PROPER & TRIM Functions
  • YEAR, MONTH, DAY, HOUR, MINUTE & SECOND Functions
  • SORT and SORTBY Functions
  • FILTER and UNIQUE Function
  • INDEX, MATCH, XMATCH and EXTACT Function
  • Approximate MATCH and EXTACT Function
  • VLOOKUP Function
  • XLOOKUP Function
  • Approximate MATCH with VLOOKUP Functions
  • DROP DOWN List & Filtering
  • Dependent DROP DOWN List
  • Most Common Excel Shortcut Keys

Course content

1 section • 34 lectures • 4h 2m total length

  • Course Intro2:45
  • Introduction to the Excel Interface7:58
  • Relative and Absolute Cell References5:59
  • Working with Error Function8:36

    Learn to detect and handle Excel errors with iferror, iserror, and error types, and apply not found and Vlookup error handling for clean, reliable data.

  • CONCATENATE function7:38
  • WORKDAY and WORKDAY.INT Functions7:29
  • Logical Operators IF, AND,OR & NOT9:00

    Learn how to use excel logical operators if, and, or, not to make data-driven decisions with conditional evaluations; apply multi-criteria rules for pass/fail using scores, attendance, and extra credit.

  • SUM, SUMIF, SUMIFS & SUMPRODUCT Functions7:53

    Master powerful Excel calculations with sum, sumif, sumifs, and sumproduct functions to analyze data, filter by region north, multiply quantity by price, and compute total sales.

  • COUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS Functions8:22

    Explore Excel’s count functions to quickly tally data: count counts numbers, countA counts non-empty cells, countBlank finds empty cells, and countIf and countIfs apply single or multiple criteria.

  • AVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS Functions7:50
  • MIN() and MAX() Functions5:00

    Use the min and max functions in Excel to find the smallest and largest values. Pair them with the if function to test if values equal the min or max.

  • SMALL and LARGE Functions6:49
  • ROW, ROWS, COLUMN and COLUMNS Functions5:45
  • Date and DATEDIF Functions8:03
  • EDATE and EOMONTH Functions6:36

    Explore how to use EDATE and EOMONTH to add or subtract months from a start date and to get the last day of a month, with deadlines and renewals.

  • CHOOSE and SWITCH Functions9:40
  • LEFT, MID, RIGHT & LEN Functions6:31
  • UPPER, LOWER, PROPER & TRIM Functions6:34
  • YEAR, MONTH, DAY, HOUR, MINUTE & SECOND Functions8:01
  • SORT and SORTBY Functions6:45
  • FILTER and UNIQUE Function8:50
  • SEQUENCE function9:13
  • FREQUENCY Function4:24
  • TRANSPOSE Function5:49
  • INDEX, MATCH, XMATCH and EXTACT Function9:09
  • Approximate MATCH and EXTACT Function7:42
  • VLOOKUP Function4:46
  • HLOOKUP Function5:13
  • XLOOKUP Function6:57
  • MATCH with VLOOKUP Functions6:22
  • Approximate MATCH with VLOOKUP Functions4:53
  • DROP DOWN List & Filtering7:09
  • Dependent DROP DOWN List8:41
  • Most Common Excel Shortcut Keys9:52

Requirements

  • No prior Excel experience is required

Description

Unlock the full potential of Microsoft Excel and become a spreadsheet master with this comprehensive course on formulas and functions. Whether you're a complete beginner or an experienced user looking to sharpen your skills, this course will guide you from the fundamentals to advanced techniques, transforming you from an Excel user to an Excel powerhouse.


Are you tired of:

  • Manually calculating data and making costly errors?

  • Struggling to create dynamic reports and dashboards?

  • Wasting hours on repetitive tasks that could be automated?


If so, this course is for you!

I'll start with the building blocks of Excel formulas, covering everything from basic arithmetic to essential functions like SUM, AVERAGE, MIN, and MAX. You'll learn the correct syntax, understand cell referencing, and build a strong foundation for more complex operations.


I'll dive into the world of logical, text, lookup, and financial functions. You'll master powerful tools like IF, VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, TEXTJOIN, CONCATENATE, and many more. We'll tackle real world scenarios, showing you how to clean data, perform powerful lookups, and automate decision making within your spreadsheets.


The final section of the course is dedicated to advanced topics that will truly set you apart. You'll learn to create complex nested formulas, work with array formulas, and discover the power of data validation and conditional formatting to make your data interactive and intuitive. I'll also introduce you to the exciting world of Excel's new dynamic array functions like FILTER, UNIQUE, SORT, and SORTBY, which are revolutionizing how we work with data.


What you will learn:

  • Fundamentals: The absolute essentials of formulas, cell references, and basic functions.

  • Essential Functions: Master the most commonly used functions for calculations and data analysis.

  • Logical & Text Functions: Create powerful decision making formulas and manipulate text strings with ease.

  • Lookup & Reference Functions: Perform advanced data lookups using VLOOKUP, HLOOKUP, XLOOKUP, and INDEX/MATCH.

  • Dynamic Array Functions: Harness the power of Excel's latest functions to filter, sort, and extract data dynamically.

  • Advanced Techniques: Learn to create nested formulas, array formulas, and use data validation for error free data entry.

  • Practical Applications: Apply your knowledge through hands-on exercises and real world case studies.


By the end of this course, you'll have the confidence to build robust, efficient, and dynamic spreadsheets. You'll not only be able to solve complex problems but also impress your colleagues and superiors with your newfound Excel expertise.


Enroll now and start your journey to becoming an Excel master!

Who this course is for:

  • Anyone who uses Excel and wants to save time and automate repetitive tasks.
  • Students and professionals who want to improve their data analysis skills.
  • Business owners and entrepreneurs who need to manage their finances and data more efficiently.
  • Users looking to upgrade their skills and learn basic to advanced techniques.

Report abuse