Limited time · 90% off Premium Membership - claim $199 deal →
For Teams For Libraries Sign in
EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Excel Functions and Formulas - Fundamentals to Pro in 5 Hours
Mammoth Club All levels 9 sections 45 lectures

Excel Functions and Formulas - Fundamentals to Pro in 5 Hours

This 5-HOUR bundle is all about going beyond the basics—teaching you how to turn Excel formulas into tools that drive real analysis and decision-making.

Created by Team Mammoth
01
Skill level
All levels
02
Sections
9
03
Lectures
45
04
Instructor
Team Mammoth
What's inside

This course includes.

✓
9
Sections
✓
45
Lectures
✓
43
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content

Curriculum & lectures.

9 sections · 45 lectures
+ Welcome! 2 lectures
Submit a Question / Feedback Locked
AI Edge, a Mammoth Club Daily Briefing Locked
+ Introduction to the Course 5 lectures
1.1 Introduction to the Course Locked
1.2 Introduction of the instructor Locked
1.3 Course requirements Locked
1.4 How to get Excel Locked
Full Course Source Files Locked
+ Excel Logic and Lookup Functions Projects 6 lectures
2.1 What will we learn in this section Locked
2.2 Create An If() Function Locked
2.3 Nest And() Andor Or() Functions Within Reference Functions Locked
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions Locked
2.5 Create A Vlookup() Function Locked
2.6 Section Summary Locked
+ Excel Math and Finance Functions Projects 6 lectures
3.1 What will we learn in this section Locked
3.2 Aggregate Data Using Both The Sum And Subtotal Functions Locked
3.3 Calculate minimums, maximums and averages from data sets Locked
3.4 Use the Forecast function to forecast numbers along a trend Locked
3.5 Generate a net present value using a formula Locked
3.6 Section Summary Locked
+ Excel Date and Time Functions Projects 4 lectures
4.1 What will we learn in this section Locked
4.2 Work with Excel’s date manipulation functions Locked
4.3 Build a holiday date calculator Locked
4.4 Section Summary Locked
+ Excel Text and Information Functions Projects 8 lectures
5.1 What will we learn in this section Locked
5.2 Split textual data apart Locked
5.3 Manipulate textual data Locked
5.4 Replace portions of textual data Locked
5.5 Put textual data back together with formulae Locked
5.6 Work with key informational functions Locked
5.7 Use the Hyperlink function Locked
5.8 Section Summary Locked
+ Excel Lists 6 lectures
6.1 What will we learn in this section Locked
6.2 How to filter items in a list Locked
6.3 Sorting List without messing up the data Locked
6.4 How to freeze rows or columns Locked
6.5 Remove duplicates from a list Locked
6.6 Section Summary Locked
+ Other Excel useful functions 7 lectures
7.1 What will we learn in this section Locked
7.2 COUNT, COUNTA and COUNTIF Functions Locked
7.3 Create a drop down list Locked
7.4 Work with ISNUMBER and SEARCH functions within text functions Locked
7.5 Format row based on a cell value Locked
7.6 Create an invoice template in Excel Locked
7.7 Section Summary Locked
+ Conclusion 1 lecture
8.1 Course Summary and Next Steps Locked
Description

About this course.

You’ve used Excel—but have you unlocked what it can really do?


This 5-HOUR bundle is all about going beyond the basics—teaching you how to turn Excel formulas into tools that drive real analysis and decision-making.


Start by mastering essentials! Then take it further—learn how to build nested formulas, handle errors with IFERROR, and apply logical conditions that adapt to your data.


Rather than memorizing formulas, you’ll understand how and when to use them.


By the end, you’ll be able to:

✔ Clean and organize messy data

✔ Build formulas that adapt to changing inputs

✔ Extract insights instantly using dynamic, structured logic

✔ Apply advanced functions with confidence


Expect a hands-on approach: real scenarios, real datasets, and clear explanations that stick.


This isn’t just another intro course. It’s your path to speaking Excel fluently—using formulas as a second language.


🎁 Comes with lifetime access and fully downloadable Excel files to follow along, explore, and reuse in your own work.

Instructors

Taught by people who ship.

Team Mammoth

Team Mammoth

Instructor

Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.

Ready to start building?

This 5-HOUR bundle is all about going beyond the basics—teaching you how to turn Excel formulas into tools that drive real analysis and decision-making.

Buy lifetime access →