EN
Start unlimited
Catalog Courses Books Assets Newsletter Merch About Contact Blogs
Cart Sign in Start unlimited
Catalog / All levels / Excel Functions Mastery Course
Mammoth Club All levels 8 sections 43 lectures

Excel Functions Mastery Course

Accelerate your Excel skills by mastering advanced Excel functions.

Created by John Bura
01
Skill level
All levels
02
Sections
8
03
Lectures
43
04
Instructor
John Bura
What's inside

This course includes.

✓
8
Sections
✓
43
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.

8 sections · 43 lectures
+ 01. 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
+ 02. 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
+ 03. 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
+ 04. 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
+ 05. Excel Text 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
+ 06. 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
+ 07. Other Excel useful functions 7 lectures
7.1 What will we learn in this section Locked
7.3 Create a drop down list Locked
7.2 COUNT, COUNTA and COUNTIF Functions 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
+ 08. Summary 1 lecture
8.1 Course Summary and Next Steps Locked
Description

About this course.

Learn to master Excel functions in this all-in-one course.

Learn how to work with logic and lookup functions with hands on projects.

Work with math and finance functions, including forecasting.

Build a holiday date calculator as you learn date and time functions.

Work with key text and information functions to build hands on projects.

And much more!

A SCHOOL YOU CAN TRUST

  • Lifetime access that never expires
  • Project-based curriculum to superboost your portfolio
  • Graduation certificate for every course
  • Absolute beginner-friendly
  • New courses every month
  • Efficient lectures with step by step explanations
  • Relevant industry topics 8 years of award-winning course delivery
  • 1.3 million students in 186 countries
  • Learn with free tools and affordable courses

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.

Instructors

Taught by people who ship.

John Bura

John Bura

Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.

Ready to start building?

Accelerate your Excel skills by mastering advanced Excel functions.

Buy lifetime access →