Ending In:
$2,600
98% off
Courses
13
Lessons
596
Enrolled
425
Courses
13
Lessons
596
Enrolled
425
What's Included
Introduction to Excel
$200 Value
Automate Excel Files with Python OpenPyXL
$200 Value
Web Automation with Selenium Python
$200 Value
Data Science with Stocks, Excel & Machine Learning
$200 Value
Machine Learning for Absolute Beginners
$200 Value
Python for Absolute Beginners & All Ages
$200 Value
Intermediate Excel VBA
$200 Value
Beginners Excel VBA
$200 Value
Excel Financial Analysis
$200 Value
Excel Charts & Visualization
$200 Value
Excel Functions Mastery Course
$200 Value
Introduction to PivotTables in Excel
$200 Value
The Ultimate Amazon Honeycode Guide: Build 7 Apps
$200 Value
Product Details
Access
Lifetime
Content
1.0 hours
Lessons
6
Introduction to Excel
Deep Dive Into the Most Popular Spreadsheet Tool on the Market
By Mammoth Interactive | in Online Courses
Start with the basics to build a solid foundation. In this course, you'll cover all of the basic functions of Excel in detail, and you will learn not only how to use it but also some powerful tools to allow you to understand how it works. Jump into working with your first graphs in this project-based course. Learn how to add multiple sheets and much more! There is a difference between repeating something and understanding it.
- Access 6 lectures & 1 hour of content 24/7
- Use Excel from the very basics
- Learn how to use Excel's basic tools
- Explore the fundamental functions of Excel
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
Course Outline
- Your First Program
- Intro Section
- 01. Introduction To Excel - 16:52
- 02. Introduction To Graphs - 4:59
- 03. Adding In Multiple Sheets - 5:39
- 04. Making A Simple But Effective Income Statement - 9:31
- 05. Making A Productivity Chart In Excel - 9:26
- 06. Making A Budget - 6:23
Access
Lifetime
Content
4.0 hours
Lessons
49
Automate Excel Files with Python OpenPyXL
Bring the Power of Python to Your Excel Spreadsheets
By Mammoth Interactive | in Online Courses
This course will teach you about Excel automation from scratch. With 49 lectures, you'll learn how to run OpenPyXL, manipulate tasks, format cells and so much more. Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work!
- Access 49 lectures & 4 hours of content 24/7
- Run Openpyxl on the web
- Learn simple sheet manipulate tasks with OpenPyXL
- Work with tables to automate your worksheets
- Format cells with Python
- Build 2D charts with Python and data
- Build an employee time log project to put in your portfolio
- Scrape the web & save it to an Excel file
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Intro to Mammoth Interactive
- 01 How to Learn Online Effectively - 13:39
- 00 About Mammoth Interactive - 1:05
- 01 Introduction to the Course
- 01.00 Course Overview - 2:20
- 01.01 Run Openpyxl on the Web - 1:45
- Source Files
- 02 Use OpenPyXL and Sheets
- 02.01 Make a Workbook - 11:01
- 02.02 Save a Workbook - 3:51
- 02.03 Read a Workbook - 8:02
- 02.04 Work with Rows and Columns - 8:07
- 02.05 Use a Formula - 8:41
- 02.06 Use Dates - 7:18
- 02.07 Merge and Unmerge Cells - 7:11
- 02.08 Fold a Range - 6:17
- 02.09 Make a New Sheet - 3:17
- 02.10 Copy Data to a Sheet - 4:35
- 02.11 Remove a Sheet - 3:45
- Source Files
- 03.01 Worksheet Tables
- 03.01 Build a Table - 15:50
- 03.02 Style a Table - 8:55
- Source Files
- 03.02 Format Cells
- 03.01 Import Dataset - 4:19
- 03.02 Style a Cell - 6:47
- 03.03 Make a Named Style - 6:57
- 03.04 Copy a Style - 4:59
- Source Files
- 04 Build 2D Charts
- 04.01 Make a Chart - 11:04
- 04.02 Build Line Charts - 15:30
- 04.03 Build a Pie Chart - 14:09
- 04.04 Build a Scatter Chart - 11:22
- 04.05 Build an Area Chart - 8:21
- Source Files
- 05 Project - Employee Timelog
- 05.01 Project Setup - 4:29
- 05.02 Expand Columns to Fit Content - 6:35
- 05.03 Add Dates - 7:34
- 05.04 Add Days of the Week - 7:11
- Source Files
- 07 Update a Spreadsheet
- 07.01 Set Up Update Information - 3:44
- 07.02 Update the Spreadsheet - 5:41
- Source Files
- 08 More Chart Types
- 08.01 Build a Stock Chart - 9:13
- 08.02 Build a Doughnut Chart - 9:22
- 08.03 Build a Bubble Chart - 8:53
- Source Files
- 09 Web Scraping
- 09.01 Import Web Driver - 8:06
- 09.02 Scrape a Web Page - 6:06
- 09.03 Parse Page Data - 9:17
- 09.04 Put Data into Excel Sheet - 6:22
- 09.05 Clean Data - 4:38
- Source Files
Access
Lifetime
Content
5.0 hours
Lessons
37
Web Automation with Selenium Python
Automate Your Spreadsheets & Boring Work with Python Programming
By Mammoth Interactive | in Online Courses
Learning how to code is a great way to jump into a new career or enhance your current career. Coding is the new math and learning how to code will propel you forward for any situation. In this course, you'll learn hands-on Python Selenium web automation. This course is project-based helping you get better at automating your boring data work.
- Access 37 lectures & 5 hours of content 24/7
- Install Seleniuim & Visual Studio Code to get started
- Automate finding elements on a webpage with multiple different techniques
- Learn how to automate simple tasks, including a google search & navigating menus
- Handle popups & alerts with Selenium
- Learn how to avoid errors with waits
- Automate browser commands including setting window size
- Automate mouse actions to navigate any objects on a webpage
- Build a hands-on image search project to scrape image data from the web
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Intro to Mammoth Interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- 00 Getting Started with Selenium
- 00.00 What You'll Learn - 5:42
- 00.01 Install Selenium - 9:11
- 00.02 Download Visual Studio Code - 4:10
- 00 Source Files
- 01 Automate Finding Elements
- 01.01 Find Elements By Name - 14:50
- 01.02 Find Elements By Id - 7:34
- 01.03 Find Elements By Xpath - 12:29
- 01.04 Find Input Field By Xpath - 13:44
- 01.05 Find Elements By Css Selector - 9:14
- 01.06 Find Elements By Link Text - 7:47
- 01.07 Find Elements By Partial Link Text - 8:05
- 01.08 Find Elements By Classname - 6:22
- 01.09 Find Elements By Tagname - 7:29
- 01 Source Files
- 02 Beginner's Automation with Selenium
- 02.01 Automate A Google Search - 19:41
- 02.02 Automate Navigating A Dropdown Menu - 16:22
- 02.03 Automate Changing Tabs - 15:41
- 02.04 Automate Alert Popups - 13:26
- 02 Source Files
- 03 Avoid Errors with Waits
- 03.01 Explicit Waits - 21:03
- 03.02 Implicit Waits - 8:45
- 03 Source Files
- 04 Automate Browsers Commands
- 04.01 Automate Window Size - 12:04
- 04.02 Get Title And Url - 4:12
- 04.03 Automate Closing Vs Quitting Windows - 4:06
- 04 Source Files
- 05 Automate Mouse Actions Search
- 05.01 Mouse Hover - 14:01
- 05.02 Automate Mouse Click - 7:39
- 05.03 Right Click - 6:26
- 05.04 Automate Double Click - 8:36
- 05.05 Click, Hold And Release - 7:17
- 05 Source Files
- 06 Automate Images Search
- 06.01 Web Scrape Images - 13:29
- 06.02 Automate Downloading Images - 27:34
- 06 Source Files
Access
Lifetime
Content
4.0 hours
Lessons
46
Data Science with Stocks, Excel & Machine Learning
Snag the Most In-Demand Role in the Tech Field Today
By Mammoth Interactive | in Online Courses
Start a career in data science by learning how to combine your Excel knowledge with Python programming, machine learning, and data science. Take your spreadsheets to the next level by learning the essentials of coding specifically tailored for data science in Excel. Completely tailored for beginners, this is a life-changing course you don't want to miss.
- Access 46 lectures & 4 hours of content 24/7
- Understand basic machine learning concepts
- Get a quick introduction to Python
- Project track stocks in Excel
- Explore linear regression on stock data in Excel
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Intro to Mammoth Interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- 00 Welcome to the Course
- Course Overview - 5:43
- Source Files
- 01 Project - Track Stocks in Excel
- 01.00 What You'll Learn - 2:01
- 01.01 Pull In Stock Data - 8:21
- 01.02 Pull In More Stock Information - 5:08
- 01.03 Calculate Equity And Returns - 11:56
- 01.04 Calculate Selling Strategy - 9:25
- 01.05 Calculate Total Returns - 4:28
- 01 Source Files
- 02A Other Techniques of Stock Prediction in Excel
- 02.01 Pull Historical Stock Data - 2:31
- 02.02 Predict Stocks With Moving Average - 9:34
- 02.03 Visualize Accuracy - 3:48
- 02.04 What Is Exponential Smoothing - 4:15
- 02.05 Predict Stocks With Exponential Smoothing - 7:37
- 02A Source Files
- 02B Linear Regression on Stock Data in Excel
- 02.00 What You'll Learn - 1:46
- 02.01 Pull Historical Stock Data - 5:49
- 02.02 What Is Linear Regression - 4:45
- 02.03 Linear Regression On Stock Data In Excel - 8:04
- 02.04 Check Accuracy Of Linear Regression - 12:53
- 02B Source Files
- 03A Machine Learning Project Introduction
- 03.00 What You'll Learn - 2:01
- 03.01 Build Models On The Web - 5:05
- 03.02 What Libraries Will We Use - 5:56
- Source Files
- 03B Your First Machine Learning Stock Prediction Project
- 03.01 Scrape Data Via API - 16:42
- 03.02 Define Variables - 11:36
- 03.03 Split Dataset For Training And Testing - 7:33
- 03.04 Build A Linear Regression Model - 9:16
- 03.05 Predict Stock Prices - 10:14
- 03.06 Calculate Model Accuracy - 14:17
- 03.07 Predict To Buy Or To Sell - 7:23
- 03 Source Files
- 04 Deep Learning Project for Stock Market Prediction
- 04.00 Recurrent Neural Networks - 6:23
- 04.01 Import Stock Data - 9:19
- 04.02 What Is Shaping Data - 5:18
- 04.03 Shape Training And Testing Data - 12:06
- 04.04 What Is Scaling Data - 6:35
- 04.05 Scale Data For Training - 11:24
- 04.06 What Is Keras - 3:24
- 04.07 Build A Keras Model - 14:03
- 04.08 Scale And Shape Data For Testing - 5:33
- 04.09 Test The Model - 5:15
- 04 Source Files
Access
Lifetime
Content
1.0 hours
Lessons
19
Machine Learning for Absolute Beginners
Learn to Build Machine Learning Models Using Spreadsheet Data
By Mammoth Interactive | in Online Courses
This course contains 19 hands-on lectures on machine learning models, datasets, attributes, and more. In this course, you'll train your first model with Python’s Pandas and Scikit-learn libraries, very popular tools for machine learning. Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.
- Access 19 lectures & 1 hour of content 24/7
- Learn types of machine learning models
- Load datasets & visualize attributes
- Train your first model with Python's Pandas & Scikit-learn libraries
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Introduction to Mammoth interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- 01 Course Introduction
- 01.01 Course Overview - 4:17
- 01.02 Build Models on the Web - 2:26
- Source Files
- 02 Build Machine Learning Models for Absolute Beginners
- 02.01 Types of Machine Learning Models - 11:39
- 02.02 Load Dataset - 11:42
- 02.03 Visualize Attributes - 12:57
- Source Files
- 03 Train a Model with Pandas and Scikit-learn
- 03.01 Import Dataset - 4:19
- 03.02 Make a Prediction - 6:32
- 03.03 Train a Model - 7:58
- Source Files
- 04 Build a Neural Network
- 04.01 What are Neural Networks - 6:15
- 04.02 Set Up Project - 8:39
- 04.03 Set Up Data - 7:56
- 04.04 Train a Model - 6:42
- 04.05 Make a Prediction - 5:05
- Source Files
Access
Lifetime
Content
5.0 hours
Lessons
49
Python for Absolute Beginners & All Ages
Learn Python from Scratch Instantly in Your Browser
By Mammoth Interactive | in Online Courses
Do you spend too much time on the computer, phone, or tablet? Don't you wish you could do something more productive together? Why not learn a life long valuable skill that will lead to a career that pays 2 times the national average? Included in this course is material for beginners to get comfortable with the Python interfaces.
4.3/5 average rating:
★ ★ ★ ★
★
- Access 49 lectures & 5 hours of content 24/7
- Learn the basics of computer programming
- Start coding with Python
- Explore topics like arithmetic operators, strings, lists, & more
- Make an If statement & source code
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Intro to Mammoth Interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- 01 Introduction to the Course
- 01.01 What Will I Learn - 3:57
- 01.01 What Will I Learn (PDF)
- 01.01 What Will I Learn (POWERPOINT)
- 02 Introduction to Computer Science
- 02.01 What is Python - 3:32
- 02.02 How do Computers Make Decisions - 5:30
- 02.03 How Do Computers Work with Numbers - 3:44
- 02.04 How Do Computers Repeat Tasks - 6:03
- 02.05. How Can Computers Search for Data - 13:50
- 02.06 How Can Computers Sort Data - 4:31
- 02.07 How Fast Are Algorithms - 7:07
- 02.08 What is the Binary Number System - 13:51
- PDF Files
- PowerPoint Files
- 03 Code Python on the Web
- 03.01 What Is Google Colab - 4:28
- 03.02 What If I Get Errors - 2:38
- 03.03 How Do I Terminate A Session - 0:59
- 03.04 How Do I Enable Corgi Mode - 0:59
- Source Code
- 04 Python Variables
- 04.01 What Is A Variable - 8:24
- 04.02 What Are Data Types - 8:18
- 04.03 What Is A Boolean - 6:35
- 04.04 What Are F Strings - 6:03
- Source Code
- 05 The Number Doctor Python Operators
- 05.01 Simple Arithmetic Operators - 10:57
- 05.02 Modulo Arithmetic Operator - 8:39
- 05.03 Floor Division - 6:15
- 05.04 Exponents - 4:16
- 05.05 Less Or Greater - 8:59
- 05.06 Can I Check Equality - 7:16
- 05.07 Can I Check Not Equal To - 6:13
- 05.08 What Is BEDMAS Order Of Operations - 20:08
- Source Code
- 06 The String Doctor Operate on Strings
- 06.01 Can I Add Strings - 3:40
- 06.02 Can I Add String Variables - 4:51
- 06.03 Can I Operate On Strings And Integers - 6:26
- Source Code
- 07 The List Ninja
- 07.01 Can I Make A List Variable - 5:34
- 07.02 Can I Compare Lists - 4:22
- 07.03 Watch Out! Don't Make This List Mistake - 3:34
- 07.04 Can I Get An Item From A List - 6:32
- 07.05 List Ninja! Can I Slice A List - 9:20
- 07.06 Be A Master Ninja! Are There More Ways To Slice A List - 5:09
- 07.07 Be A Master Ninja! The Third Way - 11:43
- 07.08 Can I Check If An Item Is In A List - 7:38
- 07.09 Can I Check If An Item Is Not In A List - 7:42
- 07.10 Can I Add Items To A List - 9:45
- 07.11 Can I Add Items To A List Another Way - 7:04
- 07.12 Can I Remove Items From A List - 5:35
- 07.13 Can I Delete Items From A List Another Way - 9:11
- 07.14 Can I Delete A Range - 8:29
- Source Code
- 08 If Statements
- 08.01 Can I Make An If Statement - 8:38
- Source Code
Access
Lifetime
Content
5.0 hours
Lessons
74
Intermediate Excel VBA
Take Your Automation to the Next Level by Programming with Visual Basic for Applications
By Mammoth Interactive | in Online Courses
Learn intermediate VBA skills in this hands-on course. Only beginner VBA skills required. It contains 74 lectures introducing you to beyond basic VBA concepts including loops, strings, functions, arrays, and much more. By the end of this course, you'll be able to show progress, read and write data, and more.
- Access 74 lectures & 5 hours of content 24/7
- Build projects with loops, a fundamental programming concept
- Learn to manipulate strings to automate your Excel workflow
- Build custom functions, including a calculator, to maximize your Excel potential
- Build arrays, a key programming data structure, in VBA
- Learn to work with dates to schedule procedures & much more
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: intermediate
Requirements
- Any device with basic specifications
Course Outline
- Intro to Mammoth Interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- Course Intro
- Intermediate Course Overview - 2:50
- 12 Introduction to Loops
- 12.00 Topics Overview - 0:57
- 12.01 Single Loop - 5:59
- 12.02 Double Loop - 5:14
- 12.03 Triple Loop - 6:24
- 12.04 Do While Loop - 5:34
- 12.05 Build A Commission Table - 5:33
- Source Files
- 13 Loop Projects
- 13.00 Topics Overview - 1:40
- 13.01 Loop Through Defined Range - 3:37
- 13.02 Loop Through Entire Column - 3:29
- 13.03 Do Until Loop - 3:22
- 13.04 Use Step To Increment - 4:22
- 13.05 Build A Pattern Project - 4:49
- 13.06 How To Sort - 5:32
- 13.07 Sort By Related Data - 8:15
- 13.08 Delete Duplicate Values - 6:10
- Source Files
- 14 String Manipulation
- 14.00 Topics Overview - 1:28
- 14.01 Join Strings - 3:13
- 14.02 Extract Substrings From Left Or Right - 3:07
- 14.03 Extract Substring At Middle - 4:12
- 14.04 Get Length Of A String - 2:40
- 14.05 Get Substring Position - 3:16
- 14.06 How To Split Strings - 4:56
- 14.07 Reverse Characters - 4:10
- 14.09 Count Words In A Range - 8:17
- 14.08 Change String Casing - 3:28
- Source Files
- 15 Build Custom Functions
- 15.00 Topics Overview - 1:19
- 15.01 Make And Use Your Own Function - 6:33
- 15.02 Pass Arguments To A Function - 7:43
- 15.03 Custom Calculator Function - 6:22
- Source Files
- 16 Build Arrays
- 16.00 Topics Overview - 1:18
- 16.01 One Dimensional Array - 5:46
- 16.02 Two Dimensional Array - 6:25
- 16.03 Change Array Size - 4:54
- 16.04 Build An Array - 5:09
- 16.05 Populate Row With Array - 3:21
- 16.06 Array Length - 6:47
- 16.07 Split String Into An Array - 4:28
- 16.08 Join Array Into A String - 3:49
- Source Files
- 17 Work with Dates
- 17.00 Topics Overview - 1:12
- 17.01 Delay A Procedure - 4:12
- 17.02 Schedule A Procedure - 4:18
- 17.03 Count Years - 5:20
- 17.04 Count Days Between Dates - 2:41
- 17.05 Count Weekdays Between Dates - 4:51
- 17.06 Sort Dates - 6:27
- Source Files
- 18 Application Object
- 18.00 Topics Overview - 1:36
- 18.01 How To Access Excel Functions - 4:28
- 18.02 Disable Screen Updating - 3:19
- 18.03 Disable Alerts - 3:38
- 18.04 Show Progress Of Macro - 5:36
- 18.05 Read Data From A File - 6:35
- 18.06 Write Data To A File - 5:10
- Source Files
- 19 VBA Projects
- 19.00 Topics Overview - 0:52
- 19.01 Build A Table - 4:47
- 19.02 Build A Table Of Contents - 11:47
- 19.03 Build A Table Of Contents 2 - 4:42
- 19.04 Combine Worksheets - 17:42
- 19.05 Combine Worksheets By Column - 15:48
- Source Files
- 20 Programming Charts
- 20.00 Topics Overview - 1:20
- 20.01 Program A Chart - 6:12
- 20.03 Delete Charts Programatically - 2:19
- 20.02 Program An Embedded Chart - 4:59
- Source Files
Access
Lifetime
Content
5.0 hours
Lessons
74
Beginners Excel VBA
Basic Coding & Automation of Microsoft Excel Perfect for Beginners
By Mammoth Interactive | in Online Courses
Microsoft Excel itself is already helpful in managing and sorting data. But when working with more complex sets, you'll be needing to take things to a higher level. In this course, you'll build your first macros Learn Excel Visual Basic for Applications to automate your Excel workflow.
- Access 74 lectures & 5 hours of content 24/7
- Learn how to send messages with MsgBox
- Automate workbooks with the Workbook object
- Program ranges with the Range object
- Manipulate range properties with VBA macros
- Build hands-on projects to automate Excel
- Learn the fundamentals of programming: variables, conditionals, & more with VBA projects
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specifications
Course Outline
- Intro to Mammoth Interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- 01 Course Introduction
- 01.00 Course Overview - 2:24
- 02. About Macros
- 02.00 How To Save Macros - 1:34
- Source Files
- 03 Send Messages with MsgBox
- 03.00 Topics Overview - 0:53
- 03.01 Build A Simple Message - 3:34
- 03.02 Build An Advanced Message - 5:10
- 03.03 Empty A Sheet With The Msgbox Function - 6:44
- 03.04 Prompt User For Input - 7:29
- Source Files
- 04 Workbook and Worksheet Object
- 04.00 Topics Overview - 1:30
- 04.01 Object Hierarchy - 5:10
- 04.02 Change Multiple Worksheets - 7:05
- 04.03 Add And Count Worksheets - 6:01
- 04.04 Get Path Of A Workbook - 5:14
- 04.05 Open And Close Workbooks - 8:41
- 04.06 Loop Through Worksheets And Workbooks - 8:19
- 04.07 Build A Sales Calculator - 11:53
- 04.08 Change Charts - 10:30
- Source Files
- 05 Work with the Range Object
- 05.00 Topics Overview - 1:22
- 05.01 Program A Range Of A Spreadsheet - 6:55
- 05.02 Use Cells Instead Of A Range - 6:04
- 05.03 Use A Range Variable - 6:04
- 05.04 Select A Range - 4:52
- 05.05 Access A Row - 4:35
- 05.06 Copy And Paste A Range - 8:45
- 05.07 Clear A Range - 3:59
- 05.08 Count A Range - 4:21
- Source Files
- 06 Work with Range Properties
- 06.00 Topics Overview - 1:03
- 06.01 Find The Current Region Of A Cell - 7:23
- 06.02 Dynamic Range Program - 7:11
- 06.03 Resize A Range - 2:30
- 06.04 Select Entire Rows And Columns - 0:42
- 06.05 Offset Property - 3:32
- 06.06 End Property - 5:06
- Source Files
- 07 More Range Projects
- 07.00 Topics Overview - 1:21
- 07.01 Union And Intersect Of Ranges - 4:24
- 07.02 Detect Content - 5:37
- 07.03 Build A Range Program - 5:47
- 07.04 Change Text Color - 4:30
- 07.05 Bold A Range - 2:39
- 07.06 Change Cell Color - 5:04
- 07.07 Work With Areas - 4:55
- 07.08 Find Differences In Ranges - 8:17
- Source Files
- 08 Variables
- 08.00 Topics Overview - 1:38
- 08.01 Integer Data Type - 2:58
- 08.02 String Data Type - 2:20
- 08.03 Double Data Type - 2:54
- 08.04 Boolean Data Type - 4:05
- 08.05 Retain Variable Value - 2:54
- 08 Source Files
- 09 Work with Conditionals
- 09.00 Topics Overview - 1:26
- 09.01 If Then Statement - 4:38
- 09.02 Else Statement - 4:55
- 09 Source Files
- 10 Work with AND, OR and NOT
- 10.00 Topics Overview - 1:21
- 10.01 Greeting Program - Logical Operator And - 4:00
- 10.02 Logical Operator Or - 5:36
- 10.03 Logical Operator Not - 3:15
- Source Files
- 11 Build Conditionals Projects
- 11.00 Topics Overview - 1:58
- 11.01 Select Case - 5:42
- 11.02 Build A Commission Calculator Project - 6:11
- 11.03 Find Remainder With Mod - 3:11
- 11.04 Check Number Program - 6:38
- 11.05 K Smallest Value Program - 6:54
- 11.06 Group By Font Style - 6:45
- 11.07 Remove Empty Cells - 5:26
- Source Files
Access
Lifetime
Content
5.0 hours
Lessons
29
Excel Financial Analysis
Learn Excel Statement Models & Finance Models
By Mammoth Interactive | in Online Courses
In this course, you'll go from complete novice to someone with enough knowledge to build a balance sheet and learn to calculate cash flow with Excel statement models. You'll take advantage of Excel's most essential functions and formulas to help you create statement models and build practical projects.
- Access 29 lectures & 5 hours of content 24/7
- Learn everything you need to know about financial analysis
- Build a balance sheet
- Learn to calculate cash flow with Excel statement models
- Learn finance methods to build practical projects
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
Course Outline
- 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 - 4:16
- 1.2 Why should you learn Financial Analysis - 4:22
- 1.3 Introduction of the instructor - 6:24
- 1.4 Course requirements (what software, experience) - 5:46
- Source Files
- 02. Excel Statement Models
- 2.1 What will we learn in this section - 2:35
- 2.2 Preparing Data Source for P&L - 16:08
- 2.3 Create P&L Structure - 13:27
- 2.4 Adding Data to P&L - 19:48
- 2.5 Calculating Variances - 11:51
- 2.6 Balance Sheet Structure - 10:43
- 2.7 Adding Values on BS from different files format - 20:38
- 2.8 Cash Flow Structure - 10:25
- 2.9 Calculating Cash Flow - 11:04
- 2.10 Challenge - 1:35
- Source Files
- 03. Excel Finance Methods
- 3.1 What will we learn in this section - 5:48
- 3.2 Forecast with scenarios - 23:29
- 3.3 How to Calculate Finance main KPI's - 15:38
- 3.4 Fixed Assets Roll Forward - 18:29
- 3.5 Loan Schedule - 13:54
- 3.6 AR Management Basics - 20:49
- 3.7 Customers Rank - 11:56
- 3.8 Create Budgets Categories - 19:45
- 3.9 Challenge - 1:25
- Source Files
- Course Summary
- 4.1 Course Summary and Next Steps - 31:21
Access
Lifetime
Content
4.0 hours
Lessons
73
Excel Charts & Visualization
Learn How to Build Excel Charts & Visualize Data
By Mammoth Interactive | in Online Courses
This Excel course will have you interpret and visualize data patterns in a better way. With 73 lectures, you'll be able to use Excel to make presentations, charts, axes, pivot tables, and much more. Easily create a bunch from scratch and use it to make an impressive portfolio.
- Access 73 lectures & 4 hours of content 24/7
- Learn the basics of charts & how to make an impact with visualization
- Communicate with your end user & make data understandable
- Choose the right chart for your dataset
- Master Excel chart tools including templates, axes & different chart formats
- Build many different projects, including pie charts, line charts & bar charts
- Track rating stars & risk scores as you build dynamic chart projects
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
Course Outline
- Intro to Mammoth Interactive
- 00 About Mammoth Interactive - 1:05
- 01 How to Learn Online Effectively - 13:39
- 01. Intro to course
- 1.1 Introduction To The Course - 4:46
- 1.2 Why Should You Learn About Charts And Data Visualization - 4:31
- 1.3 Introduction Of The Instructor - 2:08
- 1.4 Course Requirements (what Software, Experience) - 2:36
- 02. Charts and Basics
- 2.1 What Will We Learn In This Section - 1:21
- 2.2 Main Principles And Chart Visualization Impact - 2:38
- 2.3 Choosing The Correct Chart - 1:56
- 2.4 Communicate With The End User - 2:18
- 2.5 Section Summary - 2:59
- 2.6 Challenge - 2:12
- 03 Excel Chart Tools
- 3.1 What Will We Learn In This Section - 1:35
- 3.2 Chart Design - 6:38
- 3.3 Working With Chart Formats - 4:35
- 3.4 Chart Types - 2:08
- 3.5 Primary & Secondary Axis - 4:20
- 3.6 Chart Templates - 3:25
- 3.7 Section Summary - 2:50
- 3.8 Challenge - 1:23
- 04 Working with Basic Excel Charts & Graphs
- 4.1 What Will We Learn In This Section - 1:20
- 4.2 Excel Column Charts - 4:13
- 4.3 Column Charts Challenge - 1:07
- 4.4 Excel Bar Charts - 3:12
- 4.5 Bar Charts Challenge - 0:48
- 4.6 Excel Line Charts - 3:52
- 4.7 Line Charts Challenge - 0:48
- 4.8 Excel Pie Charts - 5:01
- 4.9 Pie Charts Challenge - 0:57
- 4.10 Excel Area Charts - 2:27
- 4.11 Area Charts Challenge - 0:49
- 4.12 Excel Scatter Charts - 4:00
- 4.13 Scatter Charts Challenge - 0:41
- 4.14 Excel Bubble Charts - 5:12
- 4.15 Bubble Charts Challenge - 0:54
- 4.16 Excel Stock Charts - 3:07
- 4.17 Stock Charts Challenge - 0:56
- 4.18 Excel Surface Charts - 4:42
- 4.19 Surface Charts Challenge - 0:43
- 4.20 Excel Radar Charts - 2:58
- 4.21 Radar Charts Challenge - 0:38
- 4.22 Excel Treemap Charts - 2:31
- 4.23 Treemap Charts Challenge - 1:03
- 4.24 Excel Sunburst Charts - 2:36
- 4.25 Sunburst Charts Challenge - 0:59
- 4.26 Excel Histogram & Pareto Charts - 4:02
- 4.27 Histogram & Pareto Charts Challenge - 1:03
- 4.28 Excel Waterfall Charts - 5:25
- 4.29 Waterfall Charts Challenge - 0:46
- 4.30 Excel Box&whisker Charts - 3:24
- 4.31 Box&whisker Charts Challenge - 1:03
- 4.32 Excel Sparklines - 3:44
- 4.33 Sparklines Challenge - 0:53
- 4.34 Excel Color Scales - 3:42
- 4.35 Color Scales Challenge - 0:49
- 4.36 Excel 3d Map - 4:35
- 4.37 3d Map Challenge - 1:45
- 4.38 Section Summary - 10:13
- 05. Excel Advanced Data Visualization
- 5.1 What Will We Learn In This Section - 2:23
- 5.2 Data Visualization With Pivot Chart And Slicers - 7:04
- 5.3 Challenge Data Visualization With Pivot Chart And Slicers - 1:34
- 5.4 Create Break Even Chart - 9:24
- 5.5 Challenge Break Even Chart - 1:11
- 5.6 Rating Star Chart - 7:09
- 5.7 Challenge Star Rating - 1:28
- 5.8 Drop Down Menu For Chart - 16:30
- 5.9 Challenge Drop Down Menu Chart - 1:20
- 5.10 Risk Score Chart - 11:03
- 5.11 Challenge Risk Score Chart - 1:22
- 5.12 Dynamic Chart Update - 8:10
- 5.13 Challenge Dynamic Chart Update - 1:47
- 5.14 Section Summary - 6:48
- 06. Course Summary And Next Steps
- Course Summary And Next Steps - 16:29
Access
Lifetime
Content
5.0 hours
Lessons
51
Excel Functions Mastery Course
Accelerate Your Excel Skills by Mastering Advanced Excel Functions
By Mammoth Interactive | in Online Courses
Whether you're starting from square one or aspiring to become an absolute Excel wizard, this is the right place for you. This all-in-one course has got your back so you'll easily play the most popular spreadsheet tool on the market. You'll be able to create spreadsheets that are comprehensive yet visually pleasing.
- Access 51 lectures & 5 hours of content 24/7
- Learn how to work with logic & lookup functions with hands on projects
- Work with math & finance functions, including forecasting
- Build a holiday date calculator as you learn date & time functions
- Work with key text & information functions to build hands on projects
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
Course Outline
- 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
- 04. Excel Date and Time Functions Projects
- 4.1 What will we learn in this section - 1:14
- 4.2 Date manipulation - 10:10
- 4.3 Build a holiday date calculator - 6:09
- 4.4 Section Summary - 4:43
- 04 Source Files
- 05. Excel Text and Information Functions Projects
- 5.1 What will we learn in this section - 3:46
- 5.2 Split textual data apart - 4:00
- 5.3 Manipulate textual data - 5:46
- 5.4 Replace portions of textual data - 4:42
- 5.5 Put textual data back together with formulae - 6:18
- 5.6 Work with key informational functions - 12:00
- 5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet - 4:35
- 5.8 Section Summary - 6:26
- 05 Source Files
- 06. Excel Lists
- 6.1 What will we learn in this section - 4:08
- 6.2 How to filter items in a list - 8:24
- 6.3 Sorting List without messing up the data - 10:09
- 6.4 How to freeze rows or columns - 9:53
- 6.5 Remove duplicates from a list - 6:51
- 6.6 Section Summary - 6:32
- 06 Source Files
- 07. Other Excel useful functions
- 7.1 What will we learn in this section - 2:09
- 7.2 COUNT, COUNTA and COUNTIF Functions - 11:57
- 7.3 Create a drop down list - 11:38
- 7.4 Work with ISNUMBER and SEARCH functions within text functions - 11:18
- 7.5 Format row based on a cell value - 10:54
- 7.6 Create an invoice template in Excel - 24:17
- 7.7 Section Summary - 4:46
- 07 Source Files
- 08. Course Summary
- 8.1 Course Summary and Next Steps - 23:32
Access
Lifetime
Content
3.0 hours
Lessons
51
Introduction to PivotTables in Excel
Work with PivotTables & Databases in This Career Advancing Course
By Mammoth Interactive | in Online Courses
Learn everything you need to know about pivot tables in this comprehensive course. Go all the way from answering “what is a pivot table?” to building portfolio ready projects. This course contains 51 lectures helping you slice and manage data to your advantage.
- Access 51 lectures & 3 hours of content 24/7
- Build your first basic pivot table to start
- Build an expense report from start to finish
- Perform sales report analysis with pivot tables & get that raise
- Slice data with powerful data slicer tools & link slicers to multiple pivot tables
- Connect to databases to import your data sources & format large datasets
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Microsoft Excel
Course Outline
- 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 - 3:43
- 1.2 Why Should You Learn Pivottables - 3:17
- 1.3 Introduction Of The Instructor - 3:17
- 1.4 Course Requirements (what Software, Experience) - 6:10
- 01 Source Files
- 02. PivotTables Fundamental Projects
- 2.1 What We Learn In This Section - 1:21
- 2.2 What Is A Pivot Table - 2:01
- 2.3 Pivottables Basics - 2:52
- 2.4 Pivottable Compliant Data Sources - 2:12
- 2.5 Build A Basic Pivottable - 4:17
- 2.6 Section Summary - 2:12
- 2.7 Challenge - 1:23
- 02 Source Files
- 03. Format PivotTables
- 3.1 What Will We Learn In This Section - 1:01
- 3.2 Introduction To Formatting Pivottables - 3:29
- 3.3 Build An Expense Report - 6:03
- 3.4 Format The Expense Report Pivottable - 4:18
- 3.5 Finalize The Expense Report Pivottable - 5:40
- 3.6 Section Summary - 2:12
- 3.7 Challenge - 1:04
- 03 Source Files
- 04. Excel Tables
- 4.1 What Will We Learn In This Section - 8:45
- 4.2 What Are Excel Tables - 7:23
- 4.3 Sales Report Analysis With Pivottables - 9:21
- 4.4 Modify Source Data - 3:58
- 4.5 Format The Sales Report - 8:38
- 4.6 Complete The Sales Report Analysis - 3:38
- 4.7 Section Summary - 3:03
- 4.8 Challenge - 1:46
- 04 Source Files
- 05. Slice and Dice Your Data
- 5.1 What Will We Learn In This Section - 1:23
- 5.2 What Is Slicing Data - 3:41
- 5.3 Slicing Data Project - 5:40
- 5.4 Data Slicer Tools - 14:09
- 5.5 Link Slicers To Multiple Pivottables - 8:03
- 5.6 Section Summary - 2:32
- 5.7 Challenge - 2:04
- 05 Source Files
- 06. Connect to Databases
- 6.1 What Will We Learn In This Section - 2:30
- 6.2 Connect To Databases - 2:06
- 6.3 Import Data Sources - 3:58
- 6.4 Use Pivottables To Refine Data - 4:41
- 6.5 Consolidate Your Data Table - 3:17
- 6.6 Format Large Data Sets - 4:51
- 6.7 Slicer And Timeline In Large Data Sets - 4:36
- 6.8 Refresh And Drill Down From Databases - 4:46
- 6.9 Section Summary - 4:01
- 6.10 Challenge - 2:01
- 06 Source Files
Access
Lifetime
Content
5.0 hours
Lessons
38
The Ultimate Amazon Honeycode Guide: Build 7 Apps
Build Apps to Automate Data Entry: Make Inventory Management Apps & More Easy Business Projects
By Mammoth Interactive | in Online Courses
Amazon Honeycode combines the familiar interface of a spreadsheet with the data management capability of a database. Import your CSV files into this Amazon Web Service, and instantly create mobile and web applications for your team. All without coding. Completely tailored for beginners, this is a business changing course you don't want to miss. Use Amazon Honeycode's no-code app builder to create custom apps that help your team manage work and achieve its goals.
3.2/5 average rating:
★ ★ ★
★ ★
- Access 38 lectures & 5 hours of content 24/7
- Import spreadsheets into Amazon Honeycode
- Instantly create mobile & web applications for your team
- Transform your spreadsheets into custom apps to automate tracking data, automation & much more
- Build an app backwards using any CSV file
- Learn how to use every single object available for app development in Amazon Honeycode
Mammoth Interactive
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
4.2/5 Instructor Rating:
★ ★ ★ ★
★
Mammoth Interactive produces XBOX 360, iPhone, iPad, Android, HTML 5, ad-games, and more. It's owned by top-rated instructor John Bura. Mammoth Interactive recently sold a game to Nickelodeon! John has been contracted by many different companies to provide game design, audio, programming, level design, and project management. To this day John has 40 commercial games that he has contributed to. Several of the games he has produced have risen to number 1 in Apple's app store. In his spare time, John likes to play ultimate Frisbee, cycle and work out.
Important Details
- Length of time users can access this course: lifetime
- Access options: desktop & mobile
- Redemption deadline: redeem your code within 30 days of purchase
- Updates included
- Experience level required: beginner
Requirements
- Any device with basic specification
Course Outline
- 01 Introduction to Course
- 01 Course Overview - 4:00
- 02 How To Sign Up - 1:21
- 03 Beta - 0:46
- 02 Build Your First App
- 01 Project Overview - 5:48
- 02 Set Up Data Tables - 10:26
- 03 Build Your First App - 12:12
- 04 Customize App And Add Navigation - 7:54
- 05 Add Automated Notifications - 9:38
- 06 CSV File
- 03 Build an App Backwards with Data
- CSV File Resource
- 01 Project Overview - 2:27
- 02 Format Data - 22:14
- 03 Build The App - 23:48
- 04 Style And Customize The App - 20:31
- 05 Automation And Edge Cases - 10:38
- 04 Content Tracker
- 01 Content Tracker Overview - 4:49
- 02 Content Tracker Database - 13:29
- 05 Build Apps with Objects
- 01 Data Cell - 15:34
- 02 Content Box - 5:25
- 03 Button - 9:53
- 04 Blank Block - 4:04
- 05 Blank List - 13:24
- 06 Column List - 7:47
- 07 Stacked List - 8:21
- 08 Form - 7:35
- 09 Input Field - 6:57
- 10 Picklist - 8:12
- 11 Number - 6:13
- 12 Percentage - 5:06
- 13 Currency - 3:15
- 14 Contact - 4:37
- 15 Date - 4:24
- 16 Segment - 3:53
- 17 Screen - 4:39
- 07 Inventory Management
- 01 Inventory Management Overview - 7:06
- 02 Inventory Management Database - 12:57
- 08 To Do List
- 01 To Do List Overview - 4:34
- 02 To Do List Database - 11:12
Terms
- Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.