Master Excel Functions: Unlock the Power of Formulas for Enhanced Data Analysis
Created by Team Mammoth
·
43 lectures
01
Skill level
All levels
02
Sections
8
03
Lectures
43
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
8
Sections
✓
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.
+ Introduction to the Course 5 lectures Preview
1.2 Introduction of the instructor
Locked
1.3 Course requirements
Locked
1.1 Introduction to the Course
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.5 Create A Vlookup() Function
Locked
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions
Locked
2.6 Section Summary
Locked
+ Excel Math and Finance Functions Projects 6 lectures
3.3 Calculate minimums, maximums and averages from data sets
Locked
3.1 What will we learn in this section
Locked
3.2 Aggregate Data Using Both The Sum And Subtotal Functions
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.3 Build a holiday date calculator
Locked
4.2 Work with Excel’s date manipulation functions
Locked
4.1 What will we learn in this section
Locked
4.4 Section Summary
Locked
+ Excel Text and Information Functions Projects 8 lectures
5.2 Split textual data apart
Locked
5.3 Manipulate textual data
Locked
5.1 What will we learn in this section
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.2 How to filter items in a list
Locked
6.1 What will we learn in this section
Locked
6.3 Sorting List without messing up the data
Locked
6.6 Section Summary
Locked
6.5 Remove duplicates from a list
Locked
6.4 How to freeze rows or columns
Locked
+ 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.7 Section Summary
Locked
7.6 Create an invoice template in Excel
Locked
+ Conclusion 1 lecture
8.1 Course Summary and Next Steps
Locked
Instructors
Taught by people who ship.
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?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.