Build Beginner Lookup and Finance Functions in Excel Spreadsheets
01
Skill level
All levels
02
Sections
4
03
Lectures
21
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
4
Sections
✓
21
Lectures
✓
21
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.
+ Intro to Mammoth Interactive 2 lectures
00 About Mammoth Interactive
Locked
01 How to Learn Online Effectively
Locked
+ 01. Introduction to the Course 5 lectures
1.1 Introduction
Locked
1.2 instructor
Locked
1.3 requirements
Locked
1.4 How to get Excel
Locked
01 Source Files
Locked
+ 02. Excel Logic and Lookup Functions Projects 7 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
02 Source Files
Locked
+ 03. Excel Math and Finance Functions Projects 7 lectures
3.1 What will we learn
Locked
3.2 Aggregate Data
Locked
3.3 Calculate min, max and averages
Locked
3.4 Use the Forecast
Locked
3.5 Generate a net present value
Locked
3.6 Section Summary
Locked
03 Source Files
Locked
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.