Description

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.

• 1. Intro to the Course
  • Excel Functions | Intro to the Course | 1.1

    8:48

  • Excel Functions | Intro of the Instructor | 1.2

    3:31

  • Excel Functions | Course Requirements | 1.3

    4:04

  • Excel Functions | How to Get Excel | 1.4

    9:33

• 2. Excel Logic and Lookup Functions Projects
  • Excel Functions | Section Learnings | 2.1

    1:34

  • Excel Functions | Create An If() Function | 2.2

    3:24

  • Excel Functions | Nest And() And/Or Or() Functions Within Reference Functions

    6:37

  • Excel Functions | Work With Choose(), Vlookup(), Index(), And Match() Functions | 2.4

    6:19

  • Excel Functions | Create A Vlookup() Function | 2.5

    3:33

  • Excel Functions | Section Summary | 2.6

    9:38

• 3. Excel Math and Finance Functions Projects
  • Excel Functions | Section Learnings | 3.1

    2:24

  • Excel Functions | Aggregate Data Using Both The Sum And Subtotal Function | 3.2

    5:15

  • Excel Functions | Calculate Minimums, Maximums, and Averages From Data Sets | 3.3

    3:39

  • Excel Functions | Use the Forecast Function to Forecast Numbers Along a Trend | 3.4

    6:57

  • Excel Functions | Generate a Net Present Value Using a Formula | 3.5

    6:13

  • Excel Functions | Section Summary | 3.6

    7:39

• 4. Excel Date and Time Functions Projects
  • Excel Functions | Section Learnings | 4.1

    1:15

  • Excel Functions | Work With Excel's Date Manipulation Functions | 4.2

    10:10

  • Excel Functions | Build a Holiday Date Calculator | 4.3

    6:10

  • Excel Functions | Section Summary | 4.4

    4:43

• 5. Excel Text and Information Functions Projects
  • Excel Functions | Section Learnings | 5.1

    3:47

  • Excel Functions | Split Textual Data Apart | 5.2

    4:01

  • Excel Functions | Manipulate Textual Data | 5.3

    5:47

  • Excel Functions | Replace Portions of Textual Data | 5.4

    4:43

  • Excel Functions | Put Textual Data Back Together With Formulae | 5.5

    6:19

  • Excel Functions | Work With Key Informational Functions For Evaluating And Responding Correctly to Errors in Routine Excel Calculations | 5.6

    12:01

  • Excel Functions | Use the Hyperlink Function to Build Navigational Menus Inside an Excel Worksheet | 5.7

    4:36

  • Excel Functions | Section Summary | 5.8

    6:26

• 6. Excel Lists
  • Excel Functions | Section Learnings | 6.1

    4:08

  • Excel Functions | How to Filter Items in a List | 6.2

    8:25

  • Excel Functions | Sorting List Without Messing up the Data | 6.3

    10:10

  • Excel Functions | How to Freeze Rows or Columns | 6.4

    9:53

  • Excel Functions | Remove Duplicates From a List | 6.5

    6:52

  • Excel Functions | Section Summary | 6.6

    6:33

• 7. Other Excel Useful Functions
  • Excel Functions | Section learnings | 7.1

    2:09

  • Excel Functions | COUNT, COUNTA and COUNTIF Functions | 7.2

    11:58

  • Excel Functions | Create a Drop Down List | 7.3

    11:38

  • Excel Functions | Work With ISNUMBER and SEARCH Functions Within Text Functions | 7.4

    11:19

  • Excel Functions | Format Row Based on a Cell Value | 7.5

    10:54

  • Excel Functions | Create An Invoice Template in Excel | 7.6

    24:17

  • Excel Functions | Section Summary | 7.7

    4:47

• 8. Course Summary
  • Excel Functions | Course Summary and Next Steps | 8.1

    23:32