Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Build Beginner Lookup and Finance Functions in Excel Spreadsheets
Intro to Mammoth Interactive
00 About Mammoth Interactive (1:05)
01 How to Learn Online Effectively (13:39)
01. Introduction to the Course
1.1 Introduction to the Course (8:47)
1.2 Introduction of the instructor (3:30)
1.3 Course requirements (4:03)
1.4 How to get Excel (9:33)
01 Source Files
02. Excel Logic and Lookup Functions Projects
2.1 What will we learn in this section (1:33)
2.2 Create An If() Function (3:24)
2.3 Nest And() Andor Or() Functions Within Reference Functions (6:37)
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
2.5 Create A Vlookup() Function (3:32)
2.6 Section Summary (9:37)
02 Source Files
03. Excel Math and Finance Functions Projects
3.1 What will we learn in this section (2:23)
3.2 Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
3.3 Calculate minimums, maximums and averages from data sets (3:39)
3.4 Use the Forecast function to forecast numbers along a trend (6:57)
3.5 Generate a net present value using a formula (6:13)
3.6 Section Summary (7:38)
03 Source Files
2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience