Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Mastering Microsoft Excel Formulas

person icon Ahmed Oyelowo

4.6

Mastering Microsoft Excel Formulas

Become an Excel formulas wizard

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Ahmed Oyelowo

category icon IT and Software ,Other IT and Software,Excel

Lectures -59

Resources -9

Duration -4 hours

Lifetime Access

4.6

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

In this course, I have simplified the explanations that will make you quicky understand how to use Excel functions to write formulas.

I am a current 5 times Microsoft MVP, a Certified Microsoft Office Specialist Excel Expert and a Microsoft Certified Trainer with several years of teaching and consulting experience.

This course will advance your knowledge of Excel to solving excel problems by writing excel formulas using excel functions.

You will quickly learn and master basic and advanced Excel functions including SUMIF, VLOOKUP, XLOOKUP, CONCATENATE, EOMONTH, INDEX & MATCH and so many more everyday Excel functions.

Enroll now to begin with the easiest to understand Excel formulas course you will find anywhere.

Goals

By the end of this course, you will:

  • Understand how Excel Functions Syntax work
  • Understand Cell Referencing Styles
  • Master Text functions to manipulate text data in Excel
  • Master Date functions to manipulate date functions in Excel
  • Master Lookup functions to find and use data in other parts of excel
  • Master Logical functions to implement IF conditions in Excel
  • Master Aggregate and Statistical functions to summarize excel data

Prerequisites

  • Basic understanding of working with excel
  • Microsoft Excel version 2013 & above or Microsoft 365
Mastering Microsoft Excel Formulas

Curriculum

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

Introductions and Aggregate Functions

9 Lectures
  • play icon Introduction 02:15 02:15
  • play icon Understanding Excel Function Syntax (Arguments and Inputs) 05:32 05:32
  • play icon Understanding Expressions 05:29 05:29
  • play icon Understanding Expressions (Part 2) 00:53 00:53
  • play icon Introduction to Excel Aggregate Functions 07:03 07:03
  • play icon Excel Aggregate functions (part 2) 04:32 04:32
  • play icon Replicating formulas and using the AUTOSUM feature 05:45 05:45
  • play icon Calculating SUBTOTALS on filtered data 05:07 05:07
  • play icon Counting data in ranges of cells 03:34 03:34

Manipulating texts with Excel Text Functions

6 Lectures
Tutorialspoint

Working with Dates using Excel Date Functions

10 Lectures
Tutorialspoint

Combining Excel Functions in a single formula

5 Lectures
Tutorialspoint

Cell Referencing Styles

4 Lectures
Tutorialspoint

Logical and Data Summary Functions

14 Lectures
Tutorialspoint

Handling Lookup operations in Excel with Lookup functions

10 Lectures
Tutorialspoint

Practice Files

1 Lectures
Tutorialspoint

Instructor Details

Ahmed Oyelowo

Ahmed Oyelowo

With over a decade of experience in business intelligence and data analytics, Ahmed Oyelowo is a highly respected industry leader and educator. As a 5-time Microsoft MVP, Ahmed is recognized globally for his contributions to the Power BI community, having helped thousands of professionals master the art of data visualization, reporting, and analytics.

As the Managing Partner at Foresight BI & Analytics, Ahmed has worked with businesses across various sectors, including finance, telecommunications, and healthcare, to deliver robust data solutions that drive decision-making. His unique ability to simplify complex concepts has made him a trusted advisor to executives and a sought-after instructor for aspiring data professionals.

Key Achievements:

  • Microsoft MVP (5x): Consistently awarded for exceptional leadership and contributions to the Power BI ecosystem.
  • Top-Rated Instructor: Creator of the highest-rated and best-seller courses (Excel and Power BI), with thousands of positive reviews.
  • Founder of VisuaWise Community: A thriving community of data analysts passionate about turning charts into insights.
  • Bootcamp Leader: Facilitator of multiple Power BI and data analytics bootcamps, where hundreds of students have gained hands-on skills through practical, real-world projects.
  • Power BI Expert: Specializes in designing dashboards and reports that translate raw data into actionable insights, with expertise in developing end-to-end Power BI projects for international clients.

Why Learn From Ahmed:

  • Real-World Experience: Ahmed combines his deep technical knowledge with real-world business applications, ensuring students gain practical, job-ready skills.
  • Expert Educator: Ahmed has empowered thousands of students to take their careers to the next level in data analytics.
  • Comprehensive Approach: Ahmed’s courses are meticulously structured to cover everything from beginner to advanced topics, making complex concepts accessible without the need for extensive coding.
  • Supportive Mentor: Beyond just teaching, Ahmed is passionate about building a supportive learning environment. His students benefit from lifetime access to course materials and an active community for continued growth.

If you're looking to elevate your data analytics career, Ahmed's courses provide the tools, insights, and mentorship you need to succeed in today's data-driven world.

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