Build Excel Functions
- Description
- Curriculum
- FAQ
- Reviews
Buff your skills to keep your job and get a raise in ANY economic climate. This course BUNDLE keeps your skills sharp and your paycheque up!
- Logic and lookup functions
- Math and finance functions
- Date and time functions
- Text and information functions
- List functions and more
This masterclass is without a doubt the most comprehensive course available anywhere online. Even if you have zero experience, this course will take you from beginner to professional.
Frequently Asked Questions
How do I obtain a certificate?
Each certificate in this bundle is only awarded after you have completed every lecture of the course.
Many of our students post their Mammoth Interactive certifications on LinkedIn. Not only that, but you will have projects to show employers on top of the certification.
Is this an eBook or videos?
The majority of this course bundle will be video tutorials (screencasts of practical coding projects step by step.) We will also have several PDFs and all source code.
Can’t I just learn via Google or YouTube?
This bundle is much more streamlined and efficient than learning via Google or YouTube. We have curated a massive 5-course curriculum to take you from absolute beginner to starting a high-paying career.
How will I practice to ensure I’m learning?
With each section there will be a project, so if you can build the project along with us you are succeeding. There is also a challenge at the end of each section that you can take on to add more features to the project and advance the project in your own time.
Mammoth Interactive is a leading online course provider in everything from learning to code to becoming a YouTube star. Mammoth Interactive courses have been featured on Harvard’s edX, Business Insider and more.
Founder and CEO John Bura has been programming since 1997 and teaching since 2002. John has created top-selling applications for iOS, Xbox and more. John also runs SaaS company Devonian Apps, building efficiency-minded software for technology workers like you.
Try a course today.
-
52.1 What will we learn in this sectionVideo lesson
-
62.2 Create An If() FunctionVideo lesson
-
72.3 Nest And() Andor Or() Functions Within Reference FunctionsVideo lesson
-
82.4 Work With Choose(), Vlookup(), Index(), And Match() FunctionsVideo lesson
-
92.5 Create A Vlookup() FunctionVideo lesson
-
102.6 Section SummaryVideo lesson
-
113.1 What will we learn in this sectionVideo lesson
-
123.2 Aggregate Data Using Both The Sum And Subtotal FunctionsVideo lesson
-
133.3 Calculate minimums, maximums and averages from data setsVideo lesson
-
143.4 Use the Forecast function to forecast numbers along a trendVideo lesson
-
153.5 Generate a net present value using a formulaVideo lesson
-
163.6 Section SummaryVideo lesson
-
215.1 What will we learn in this sectionVideo lesson
-
225.2 Split textual data apartVideo lesson
-
235.3 Manipulate textual dataVideo lesson
-
245.4 Replace portions of textual dataVideo lesson
-
255.5 Put textual data back together with formulaeVideo lesson
-
265.6 Work with key informational functions for evaluatingVideo lesson
-
275.7 Use the Hyperlink function to build navigational menus inside an Excel WorksVideo lesson
-
285.8 Section SummaryVideo lesson
-
296.1 What will we learn in this sectionVideo lesson
-
306.2 How to filter items in a listVideo lesson
-
316.3 Sorting List without messing up the dataVideo lesson
-
326.4 How to freeze rows or columnsVideo lesson
-
336.5 Remove duplicates from a listVideo lesson
-
346.6 Section SummaryVideo lesson
-
357.1 What will we learn in this sectionVideo lesson
-
367.2 COUNT, COUNTA and COUNTIF FunctionsVideo lesson
-
377.3 Create a drop down listVideo lesson
-
387.4 Work with ISNUMBER and SEARCH functions within text functionsVideo lesson
-
397.5 Format row based on a cell valueVideo lesson
-
407.6 Create an invoice template in ExcelVideo lesson
-
417.7 Section SummaryVideo lesson

External Links May Contain Affiliate Links read more