Mastering Microsoft Excel Formulas
Become an Excel formulas wizard
Updated on Jun, 2025
Language - English
IT and Software ,Other IT and Software,Excel
Lectures -59
Resources -9
Duration -4 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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
Curriculum
Check out the detailed breakdown of what’s inside the course
Introductions and Aggregate Functions
9 Lectures
-
Introduction
02:15
02:15
-
Understanding Excel Function Syntax (Arguments and Inputs)
05:32
05:32
-
Understanding Expressions
05:29
05:29
-
Understanding Expressions (Part 2)
00:53
00:53
-
Introduction to Excel Aggregate Functions
07:03
07:03
-
Excel Aggregate functions (part 2)
04:32
04:32
-
Replicating formulas and using the AUTOSUM feature
05:45
05:45
-
Calculating SUBTOTALS on filtered data
05:07
05:07
-
Counting data in ranges of cells
03:34
03:34
Manipulating texts with Excel Text Functions
6 Lectures
Working with Dates using Excel Date Functions
10 Lectures
Combining Excel Functions in a single formula
5 Lectures
Cell Referencing Styles
4 Lectures
Logical and Data Summary Functions
14 Lectures
Handling Lookup operations in Excel with Lookup functions
10 Lectures
Practice Files
1 Lectures
Instructor Details
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.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now