The Complete Recession Proof Excel, Machine Learning, Python
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
Watch Promo Enroll in Course
Do you want to succeed no matter the economy? This Kickstarter is for you.
Whether there's inflation, deflation, or stagflation, you NEED to keep your skill sharp to be competitive in the job market. Learn to produce and be useful in order to protect yourself in any economy.
There is NO better way of achieving this than learning Excel.
This huge 120-HOUR course bundle is designed to keep your skills sharp. Whether you want that major promotion or to get a new high-paying job.
Businesses LOVE self-starters.
There's NO better way to spend your free time than to learn how to build practical projects in Excel.
The Complete Career-Saving Excel, Machine Learning + Python is designed to give you top-earning projects that will make your resume shine above everybody else.
This 120-hour bundle is BEGINNER-FRIENDLY and has a TON of practical content.
Get this and so much more in our eDegree.
New and updated 23-COURSE BUNDLE based on our previous Excel eDegree, which raised over $100,000 here on Kickstarter.
Show your support by backing us right away.
Learn to build projects in:
- Financial analysis
- Dashboards
- Python programming
- Decentralized machine learning
- Predicting stocks
- Reports
- Charts
- Power BI
- Power Query
- DAX programming
- M programming
- SQL
- Google BigQuery
- Data Engineering
- Machine Learning Masterclass
- Cryptocurrency
- Blockchain
- Artificial intelligence
- VBA macros
- Ethereum
- Truffle
- Fullstack dApp Development
- React
- Solidity
- JavaScript
- Data Science
- Automation
- Google's TensorFlow
- Differential privacy
- Selenium automation
- OpenPyXL automation
- Neural networks
- Deep learning
- Amazon Honeycode
- Pandas
- Scikit
- Much more
Stop dreaming and start doing!
Have a look at some of the projects we will build together in this CAREER FREEDOM bundle.
1/23 - Excel to Python Data Science Automation (2 Hours)
- Compare Excel vs Python, both of which you will learn
- Learn how to seamlessly transition from Excel to Python
Build beginner projects, a taste of more to come:
- Excel automation with Python data modeling
- Use Bank Marketing Excel File in Python
- Manipulate Excel file with Python for Marketing Analytics
- Manipulate Excel Sheets with Pandas
- Build Excel Filters in Python
- Aggregate Excel Data with Python and Pivot Tables
2/23 - Build USEFUL, beginner Excel projects (5 Hours)
- Build your first expense tracker in Excel in 15 minutes!
- Build your first graphs
- Build an income statement
- Build a productivity chart
- Build a budget and more
3/23 - Master Excel Functions (5 Hours)
Build projects with important and time-saving Excel functions
- Logic and lookup functions
- Math and finance functions
- Date and time functions
- Text and information functions
- List functions and more
4/23 - Build PivotTables in Excel (5 Hours)
- Build an expense report PivotTable
- Analyze sales reports with PivotTables
- Slice and dice data
- Connect to databases and more
5/23 - Build practical Excel charts for data visualization (5 Hours)
- Use chart tools
- Build basic charts and graphs
- Build advanced charts and graphs and more
6/23 - Perform financial analysis in Excel (5 Hours)
- Calculate key performance indicators
- Learn to forecast
- Build a loan schedule
- Manage accounts receivable
- Build statement models and more
- Use powerful finance methods that will get you hired
7/23 - Analyze data with advanced techniques (5 Hours)
- Build dashboards in Excel
- Build a scrolling data table
- Show top indicators
- Build a scrollable line chart
- Add interactivity to your reports and more
8/23 - Beginners Excel Power Query and M Masterclass (5 Hours)
- Supercharge Data Transformation
- Use Power Query to format data
9/23 - Advanced Excel Power Query and M Masterclass (5 Hours)
- Clean and Transform Data
- Code in the Power Query M formula language and more
10/23 - Power BI (5 Hours)
- Analyze data with the DAX programming language in Power BI
- Build artificial intelligence projects with Power BI and more
11/23 - Excel VBA programming and macros (5 Hours)
- Cut your work time in half with Excel automation
- Build macros, variables and conditionals
12/23 - Advanced Excel VBA (5 Hours)
- Repeat actions with loops
- Build custom functions to perform tasks
- Build tables and charts with VBA
- And much more
13/23 - Learn to program in Python from scratch (5 Hours)
- Code in the #1 language for data science and machine learning
14/23 - Automate Excel files with Python OpenPyXL (5 Hours)
- Build worksheets and charts with OpenPyXL
- Build an employee timelog
- Scrape the web and more
15/23 - Automate web tasks with Selenium Python (5 Hours)
- Find elements on a webpage with Selenium
- Automate searching the web with Selenium
- Automate browser and mouse actions
- Scrape the web for images and more
16/23 - Build 7 applications in Amazon Honeycode (5 Hours)
- Build an app from data tables
- Build automated notifications
- Build a simple survey database
- Build an inventory management database
- Build a to do list database and more
17/23 - Truffle Fullstack dApp Development with React, Solidity and JavaScript (20 Hours)
- Blockchain Introduction
- Solidity Introduction
- Command line fundamentals
- Build blockchain backend for social media smart contracts
- Deploy social media smart contract to blockchain
- Web development Introduction
- JavaScript Introduction
- React Introduction
- Install MetaMask cryptocurrency wallet
- Connect to smart contract in app with Web3
- Build social media dApp with Ethereum Web3
18/23 - Blockchain and Cryptocurrency Machine Learning (10 Hours)
Data Science and Machine Learning
- Build linear and polynomial regression machine learning models with Blockchain API
- Cluster cryptocurrencies with machine learning techniques
- Classify cryptocurrency data with machine learning
- Build neural networks with Google's TensorFlow on cryptocurrency stock data
Differential Privacy and Federated Learning
- Build a differential privacy project to encrypt datasets
- Build a deep learning differential privacy query
- Encrypt data sent to a machine learning model with federated learning
19/23 - Python SQL Ethereum Data Science with Google BigQuery (5 Hours)
- Google Cloud Platform and BigQuery Introduction
- SQL Introduction
- Simple BigQuery Python SQL queries
- Simple BigQuery Ethereum queries
20/23 - Machine Learning Fundamentals (1 Hour)
- Probability and Statistics for Machine Learning
- Distributions in Machine Learning
- Machine Learning Optimization
21/23 - Data Engineering and Machine Learning Masterclass (1 Hour)
- Load, clean and encode data
- Data engineering for machine learning
- Build regression and discretizer models
- Data transformation and feature selection for ridge regression
22/23 - Build beginner artificial intelligence projects (2 Hours)
- Build machine learning models with Python, Pandas and Scikit
- Build a neural network
23/23 - Data science with stocks, Excel and machine learning (5 Hours)
- Track stocks in Excel
- Predict stocks with data science in Excel
- Predict stocks with linear regression in Excel
- Build machine learning and deep learning models to predict stocks
Requirements
- No Excel, programming or machine learning experience needed - We'll teach you everything you need to know.
- A free trial or paid license of Excel.
- A Mac or PC computer. A PC is required for the courses on Power BI, Power Query and PivotTables.
We'll walk you through, step-by-step how to get all the software installed and set up.
Welcome to the The Complete Career-Saving Excel, Machine Learning + Python, the only course you need to learn Excel. With over 50,000 reviews, our courses are some of the HIGHEST RATED courses online!
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.
Here's why:
- This bundle is a taught by 5+ instructors with decades of Excel and programming experience.
- We've taught 1 million+ students how to code and many have gone on to become professional developers or start their own tech startup.
- You'll save $108,000, the average cost of 23 coding bootcamps. You'll learn completely online at your own pace. You'll get lifetime access to content that never expires.
- The course has been updated to be 2023 ready. You'll learn the latest tools and technologies used at large companies such as Google, Microsoft and Amazon.
We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a data analyst, machine learning specialist or similar.
The Complete Career-Saving Excel, Machine Learning + Python includes 1080p HD video tutorials and builds your Excel knowledge while making real-world projects.
Testimonials
Sign up today, and look forward to:
- 120 hours of HD Video Lectures
- Easy to view on mobile
- Excel files
- Source code
- Machine learning models
- Time-saving VBA macros
- Fully Fledged Projects
- Programming Resources
- Downloads
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.
Read more FAQs in the FAQ tab.
About Mammoth Interactive
Mammoth Interactive's mission is to close the tech skills gap by providing affordable and accessible courses primarily targeting beginners. Our instructors make video tutorials that are practical and to the point. Learning at Mammoth Interactive will be the next step to improving your career and your life.
Trusted Company with 32 Kickstarter Campaigns
Unlock Your Completion Certificate
Upon completing each course in this bundle, you'll receive a Completion Certificate. You can feature this certificate on your resume and LinkedIn.
This early-bird sale is only available on Kickstarter.
Don't miss out! Limited spots. Get the bundle while supplies last.
Show your support by backing us right away, and sharing with friends and colleagues. Don't miss out on joining an awesome, career-focused community!
Risks and challenges
We are a dedicated team with multiple successful projects under our belt. We will work as hard as possible to deliver this course bundle by the deadline with the content outlined above. We're excited to get started and release this course bundle with all brand-new content. The entire team at Mammoth Interactive is dedicated to making each course better than the last. Here's to another amazing project dedicated to its first backers here on Kickstarter.
Your Instructor
Alexandra Kropf is Mammoth Interactive's CLO and a software developer with extensive experience in full-stack web development, app development and game development. She has helped produce courses for Mammoth Interactive since 2016, including the Coding Interview series in Java, JavaScript, C++, C#, Python and Swift.
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.
Over 12 years, Mammoth Interactive has built a global student community with 4 million courses sold. Mammoth Interactive has released over 350 courses and 3,500 hours of video content.
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.
Course Curriculum
-
Start00 Project Overview - Excel Automation With Python Data Modeling (0:55)
-
Start01 Read Excel File With Python (6:42)
-
Start02 Reshape Data For Data Modeling (5:29)
-
Start03 Build A Linear Regression Model With Python (5:01)
-
Start04 Visualize Machine Learning Predictor With Python (6:22)
-
StartSource FIles
-
Start2.1 What will we learn in this section (1:33)
-
Start2.2 Create An If() Function (3:24)
-
Start2.3 Nest And() Andor Or() Functions Within Reference Functions (6:37)
-
Start2.4 Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
-
Start2.5 Create A Vlookup() Function (3:32)
-
Start2.6 Section Summary (9:37)
-
Start02 Source Files
-
Start3.1 What will we learn in this section (2:23)
-
Start3.2 Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
-
Start3.3 Calculate minimums, maximums and averages from data sets (3:39)
-
Start3.4 Use the Forecast function to forecast numbers along a trend (6:57)
-
Start3.5 Generate a net present value using a formula (6:13)
-
Start3.6 Section Summary (7:38)
-
Start03 Source Files
-
Start5.1 What will we learn in this section (1:59)
-
Start5.2 Split textual data apart (4:00)
-
Start5.3 Manipulate textual data (5:46)
-
Start5.4 Replace portions of textual data (4:42)
-
Start5.5 Put textual data back together with formulae (6:18)
-
Start5.6 Work with key informational functions for evaluating and responding correctly to errors in routine Excel calculations (12:00)
-
Start5.7 Use the Hyperlink function to build navigational menus inside an Excel Worksheet (4:35)
-
Start5.8 Section Summary (6:26)
-
Start05 Source Files
-
Start6.1 What will we learn in this section (4:08)
-
Start6.2 How to filter items in a list (8:24)
-
Start6.3 Sorting List without messing up the data (10:09)
-
Start6.4 How to freeze rows or columns (9:53)
-
Start6.5 Remove duplicates from a list (6:51)
-
Start6.6 Section Summary (6:32)
-
Start06 Source Files
-
Start7.1 What will we learn in this section (2:09)
-
Start7.2 COUNT, COUNTA and COUNTIF Functions (11:57)
-
Start7.3 Create a drop down list (11:38)
-
Start7.4 Work with ISNUMBER and SEARCH functions within text functions (11:18)
-
Start7.5 Format row based on a cell value (10:54)
-
Start7.6 Create an invoice template in Excel (24:17)
-
Start7.7 Section Summary (4:46)
-
Start8.1 Course Summary and Next Steps (23:32)
-
Start07 Source Files
-
Start3.1 What Will We Learn In This Section (1:01)
-
Start3.2 Introduction To Formatting Pivottables (3:29)
-
Start3.3 Build An Expense Report (6:03)
-
Start3.4 Format The Expense Report Pivottable (4:18)
-
Start3.5 Finalize The Expense Report Pivottable (5:40)
-
Start3.6 Section Summary (2:12)
-
Start3.7 Challenge (1:04)
-
Start03 Source Files
-
Start4.1 What Will We Learn In This Section (8:46)
-
Start4.2 What Are Excel Tables (7:23)
-
Start4.3 Sales Report Analysis With Pivottables (9:21)
-
Start4.4 Modify Source Data (3:58)
-
Start4.5 Format The Sales Report (8:38)
-
Start4.6 Complete The Sales Report Analysis (3:38)
-
Start4.7 Section Summary (3:03)
-
Start4.8 Challenge (1:46)
-
Start04 Source Files
-
Start5.1 What Will We Learn In This Section-1 (1:23)
-
Start5.2 What Is Slicing Data-2 (3:41)
-
Start5.3 Slicing Data Project-3 (5:40)
-
Start5.4 Data Slicer Tools-4 (14:09)
-
Start5.5 Link Slicers To Multiple Pivottables-5 (8:03)
-
Start5.6 Section Summary-6 (2:32)
-
Start5.7 Challenge-7 (2:04)
-
Start05 Source Files
-
Start6.1 What Will We Learn In This Section-1 (2:30)
-
Start6.2 Connect To Databases-3 (2:06)
-
Start6.3 Import Data Sources-4 (3:58)
-
Start6.4 Use Pivottables To Refine Data-5 (4:41)
-
Start6.5 Consolidate Your Data Table-6 (3:17)
-
Start6.6 Format Large Data Sets-7 (4:51)
-
Start6.7 Slicer And Timeline In Large Data Sets-8 (4:36)
-
Start6.8 Refresh And Drill Down From Databases-9 (4:46)
-
Start6.9 Section Summary-10 (4:01)
-
Start6.10 Challenge-2 (2:01)
-
Start06 Source Files
-
Start3.1 What Will We Learn In This Section-1 (1:35)
-
Start3.2 Chart Design-2 (6:38)
-
Start3.3 Working With Chart Formats-3 (4:35)
-
Start3.4 Chart Types-4 (2:08)
-
Start3.5 Primary & Secondary Axis-5 (4:20)
-
Start3.6 Chart Templates-6 (3:25)
-
Start3.7 Section Summary-7 (2:50)
-
Start3.8 Challenge-8 (1:23)
-
Start4.1 What Will We Learn In This Section (1:20)
-
Start4.2 Excel Column Charts (4:13)
-
Start4.3 Column Charts Challenge (1:08)
-
Start4.4 Excel Bar Charts 1 (3:12)
-
Start4.5 Bar Charts Challenge (0:48)
-
Start4.6 Excel Line Charts-36 (3:52)
-
Start4.7 Line Charts Challenge-37 (0:48)
-
Start4.8 Excel Pie Charts-38 (5:01)
-
Start4.9 Pie Charts Challenge-39 (0:57)
-
Start4.10 Excel Area Charts-3 (2:27)
-
Start4.11 Area Charts Challenge-4 (0:50)
-
Start4.12 Excel Scatter Charts-5 (4:00)
-
Start4.13 Scatter Charts Challenge-6 (0:41)
-
Start4.14 Excel Bubble Charts-7 (5:12)
-
Start4.15 Bubble Charts Challenge-8 (0:54)
-
Start4.16 Excel Stock Charts-9 (3:07)
-
Start4.17 Stock Charts Challenge-10 (0:56)
-
Start4.18 Excel Surface Charts-11 (4:42)
-
Start4.19 Surface Charts Challenge-12 (0:43)
-
Start4.20 Excel Radar Charts-14 (2:58)
-
Start4.21 Radar Charts Challenge-15 (0:38)
-
Start4.22 Excel Treemap Charts-16 (2:31)
-
Start4.23 Treemap Charts Challenge-17 (1:03)
-
Start4.24 Excel Sunburst Charts-18 (2:36)
-
Start4.25 Sunburst Charts Challenge-19 (0:59)
-
Start4.26 Excel Histogram & Pareto Charts-20 (4:02)
-
Start4.27 Histogram & Pareto Charts Challenge-21 (1:04)
-
Start4.28 Excel Waterfall Charts-22 (5:26)
-
Start4.29 Waterfall Charts Challenge-23 (0:46)
-
Start4.30 Excel Box&whisker Charts-24 (3:24)
-
Start4.31 Box&whisker Charts Challenge-25 (1:03)
-
Start4.32 Excel Sparklines-26 (3:44)
-
Start4.33 Sparklines Challenge-27 (0:53)
-
Start4.34 Excel Color Scales-28 (3:42)
-
Start4.35 Color Scales Challenge-29 (0:49)
-
Start4.36 Excel 3D Map (4:35)
-
Start4.37 3D Map Challenge (1:45)
-
Start4.38 Section Summary (10:13)
-
Start04 Source Files
-
Start5.1 What Will We Learn In This Section-1 (2:23)
-
Start5.2 Data Visualization With Pivot Chart And Slicers-7 (7:04)
-
Start5.3 Challenge Data Visualization With Pivot Chart And Slicers-8 (1:34)
-
Start5.4 Create Break Even Chart-9 (9:24)
-
Start5.5 Challenge Break Even Chart-10 (1:11)
-
Start5.6 Rating Star Chart-11 (7:09)
-
Start5.7 Challenge Star Rating-12 (1:28)
-
Start5.8 Drop Down Menu For Chart-13 (16:30)
-
Start5.9 Challenge Drop Down Menu Chart-14 (1:20)
-
Start5.10 Risk Score Chart-2 (11:03)
-
Start5.11 Challenge Risk Score Chart-3 (1:22)
-
Start5.12 Dynamic Chart Update (8:10)
-
Start5.13 Challenge Dynamic Chart Update (1:47)
-
Start5.14 Section Summary (6:48)
-
Start6.1 Course Summary And Next Steps (16:29)
-
Start2.1 What Will We Learn In This Section (2:35)
-
Start2.2 Preparing Data Source For P&l (16:08)
-
Start2.3 Create P&l Structure (13:27)
-
Start2.4 Adding Data To P&l (19:48)
-
Start2.5 Calculating Variances (11:51)
-
Start2.6 Balance Sheet Structure (10:43)
-
Start2.7 Adding Values On Bs From Different Files Format (20:38)
-
Start2.8 Cash Flow Structure (10:25)
-
Start2.9 Calculating Cash Flow (11:04)
-
Start2.10 Challenge (1:35)
-
Start3.1 What Will We Learn In This Section (5:48)
-
Start3.2 Forecast With Scenarios (23:30)
-
Start3.3 How To Calculate Finance Main KPI's (15:38)
-
Start3.4 Fixed Assets Roll Forward (18:29)
-
Start3.5 Loan Schedule (13:54)
-
Start3.6 Accounts receivable Management Basics (20:49)
-
Start3.7 Customers Rank (11:56)
-
Start3.8 Create Budgets Categories (19:45)
-
Start3.9 Challenge (1:25)
-
Start4.1 Course Summary And Next Steps (31:21)
-
Start2.1 What Will We Learn In This Section-1 (1:20)
-
Start2.2 What Are Dashboards-2 (5:39)
-
Start2.3 Answers You Need Before You Start A Dashboard-3 (7:45)
-
Start2.4 Best Practices For Dashboard Layout-4 (4:42)
-
Start2.5 Best Practices For Dashboard Colors-5 (3:54)
-
Start2.6 Section Summary-6 (3:40)
-
StartSource Code
-
Start4.1 What will we learn in this section (2:48)
-
Start4.2 Build a Combo Box (10:44)
-
Start4.3 Complex Lookup (14:36)
-
Start4.4 Build a Scrolling Data Table (11:40)
-
Start4.5 Conditionally Format Actual Values vs Budgeted Values (10:52)
-
Start4.6 Conditional Headers (9:25)
-
Start4.7 Section Summary (3:01)
-
StartSource Code
-
Start6.1 What will we learn in this section (3:20)
-
Start6.2 Prepare Data for Scrolling Chart (14:19)
-
Start6.3 Scrollable Line Chart (11:17)
-
Start6.4 Remove Crashing Lines (4:12)
-
Start6.5 Toggle Visibility of Line Series (9:56)
-
Start6.6 Finetune the Line Series (7:08)
-
Start6.7 Section Summary (5:34)
-
StartSource Code
-
Start7.1 What will we learn in this section (1:56)
-
Start7.2 Add Interactivity to Reports with Pivot Slicers (10:44)
-
Start7.3 Column Chart Controlled by Slicer (6:47)
-
Start7.4 Pivot SLicer Sorting (4:26)
-
Start7.5 Select Only 1 Slicer (2:13)
-
Start7.6 Dynamic Comments with SLicers (11:36)
-
Start7.7 Section Summary (2:58)
-
StartSource Code
-
Start8.1 What will we learn in this section (1:01)
-
Start8.2 Add Calculations for Variances in Pivot Tables (4:23)
-
Start8.3 Conditional Formatting in Pivot Tables (7:04)
-
Start8.4 Refresh Pivot Table with Easy VBA (7:49)
-
Start8.5 Section Summary (2:33)
-
StartSource Code
-
Start9.1 Course Summary and Next Steps (10:27)
-
Start01 Build M Functions To Perform Tasks (8:13)
-
Start02 Call Functions (5:10)
-
Start03 Use The Each Keyword (2:33)
-
Start04 Change A Table With A Function (7:30)
-
Start05 Loop An Action With A Recursive Function (8:02)
-
Start06 Calculate Price After Discount 1 (6:09)
-
Start07 Use Optional Parameters To Combine Text (5:13)
-
Start08 Transform A List With A Function (2:09)
-
Start09 Calculate Number Of Working Days (12:20)
-
StartBuild M functions to perform tasks - Source Files
-
Start01 Build A Function (3:21)
-
Start02 Build A Closure (6:27)
-
Start03 Build A Function In A Record (4:23)
-
Start04 Count Fibonacci Numbers With A Recursive Function (7:04)
-
Start05 Remove Html Tags (9:19)
-
Start06 Build A For Each Loop (9:37)
-
StartBuild M functions to perform tasks - Source Files
-
Start01 Select A Column From A Table (3:40)
-
Start02 Select A Value At A Row And Column (3:05)
-
Start03 Select Row Where A Condition Is Met (3:53)
-
Start04 Cross Join Tables (8:40)
-
Start05 Join Tables On A Key (5:48)
-
Start06 Change Column Types (3:48)
-
Start07 Fill A Table With Random Values (7:12)
-
StartWork with tables in M - Source Files
-
Start04.00 Topics Overview (1:30)
-
Start04.01 Object Hierarchymp4 (5:10)
-
Start04.02 Change Multiple Worksheets (7:05)
-
Start04.03 Add And Count Worksheets (6:01)
-
Start04.04 Get Path Of A Workbook (5:14)
-
Start04.05 Open And Close Workbooks (8:41)
-
Start04.06 Loop Through Worksheets And Workbooks (8:19)
-
Start04.07 Build A Sales Calculator (11:53)
-
Start04.08 Change Charts (10:30)
-
Start04 Source Files
-
Start05 Source Files
-
Start05.00 Topics Overview (1:22)
-
Start05.01 Program A Range Of A Spreadsheet (6:55)
-
Start05.02 Use Cells Instead Of A Range (6:04)
-
Start05.03 Use A Range Variable (6:04)
-
Start05.04 Select A Range (4:52)
-
Start05.05 Access A Row (4:35)
-
Start05.06 Copy And Paste A Range (8:45)
-
Start05.07 Clear A Range (3:59)
-
Start05.08 Count A Range (4:21)
-
Start06.00 Topics Overview (1:03)
-
Start06.01 Find The Current Region Of A Cell (7:23)
-
Start06.02 Dynamic Range Program (7:11)
-
Start06.03 Resize A Range (2:30)
-
Start06.04 Select Entire Rows And Columns (6:33)
-
Start06.05 Offset Property (3:32)
-
Start06.06 End Property (5:06)
-
Start06 Source Files
-
Start07.00 Topics Overview (1:21)
-
Start07.01 Union And Intersect Of Ranges (4:24)
-
Start07.02 Detect Content (5:37)
-
Start07.03 Build A Range Program (5:47)
-
Start07.04 Change Text Color (4:30)
-
Start07.05 Bold A Range (2:39)
-
Start07.06 Change Cell Color (5:04)
-
Start07.07 Work With Areas (4:55)
-
Start07.08 Find Differences In Ranges (8:17)
-
Start07 Source Files
-
Start11.00 Topics Overview (1:58)
-
Start11.01 Select Case (5:42)
-
Start11.02 Build A Commission Calculator Project (6:11)
-
Start11.03 Find Remainder With Mod (3:11)
-
Start11.04 Check Number Program (6:38)
-
Start11.05 K Smallest Value Program (6:54)
-
Start11.06 Group By Font Style (6:45)
-
Start11.07 Remove Empty Cells (5:26)
-
Start11 Source Files
-
Start13.00 Topics Overview (1:40)
-
Start13.01 Loop Through Defined Range (3:37)
-
Start13.02 Loop Through Entire Column (3:29)
-
Start13.03 Do Until Loop (3:22)
-
Start13.04 Use Step To Increment (4:22)
-
Start13.05 Build A Pattern Project (4:49)
-
Start13.06 How To Sort (5:32)
-
Start13.07 Sort By Related Data (8:15)
-
Start13.08 Delete Duplicate Values (6:10)
-
StartSource Files
-
Start14.00 Topics Overview (1:28)
-
Start14.01 Join Strings (3:13)
-
Start14.02 Extract Substrings From Left Or Right (3:07)
-
Start14.03 Extract Substring At Middle (4:12)
-
Start14.04 Get Length Of A String (2:40)
-
Start14.05 Get Substring Position (3:16)
-
Start14.06 How To Split Strings (4:56)
-
Start14.07 Reverse Characters (4:10)
-
Start14.08 Change String Casing (3:28)
-
Start14.09 Count Words In A Range (8:17)
-
StartSource Files
-
Start16 Source Files
-
Start16.00 Topics Overview (1:18)
-
Start16.01 One Dimensional Array (5:46)
-
Start16.02 Two Dimensional Array (6:26)
-
Start16.03 Change Array Size (4:54)
-
Start16.04 Build An Array (5:09)
-
Start16.05 Populate Row With Array (3:21)
-
Start16.06 Array Length (6:47)
-
Start16.07 Split String Into An Array (4:28)
-
Start16.08 Join Array Into A String (3:49)
-
Start18 Source Files
-
Start18.00 Topics Overview (1:36)
-
Start18.01 How To Access Excel Functions (4:28)
-
Start18.02 Disable Screen Updating (3:19)
-
Start18.03 Disable Alerts (3:38)
-
Start18.04 Show Progress Of Macro (6:35)
-
Start18.05 Read Data From A File (6:35)
-
Start18.06 Write Data To A File (5:10)
-
Start02. Variables (19:17)
-
Start03. Type Conversion Examples (10:04)
-
Start04. Operators (7:04)
-
Start05. Operators Examples (21:52)
-
Start06. Collections (8:23)
-
Start07. Lists (11:38)
-
Start08. Multidimensional List Examples (8:05)
-
Start09. Tuples Examples (8:34)
-
Start10. Dictionaries Examples (14:24)
-
Start11. Ranges Examples (8:30)
-
Start12. Conditionals (6:41)
-
Start13. If Statement Examples (10:16)
-
Start14. If Statement Variants Examples (11:18)
-
Start15. Loops (7:00)
-
Start16. While Loops Examples (11:30)
-
Start17. For Loops Examples (11:18)
-
Start18. Functions (7:47)
-
Start19. Functions Examples (9:16)
-
Start20. Parameters And Return Values Examples (13:46)
-
Start21. Classes And Objects (11:13)
-
Start22. Classes Example (13:11)
-
Start23. Objects Examples (9:54)
-
Start24. Inheritance Examples (17:26)
-
Start25. Static Members Example (11:03)
-
Start26. Summary And Outro (4:06)
-
StartSource Files
-
Start02.01 Make a Workbook (11:01)
-
Start02.02 Save a Workbook (3:51)
-
Start02.03 Read a Workbook (8:02)
-
Start02.04 Work with Rows and Columns (8:07)
-
Start02.05 Use a Formula (8:41)
-
Start02.06 Use Dates (7:18)
-
Start02.07 Merge and Unmerge Cells (7:11)
-
Start02.08 Fold a Range (6:17)
-
Start02.09 Make a New Sheet (3:17)
-
Start02.10 Copy Data to a Sheet (4:35)
-
Start02.11 Remove a Sheet (3:45)
-
Start02 Source Files
-
Start01.01 Find Elements By Name (14:50)
-
Start01.02 Find Elements By Id (7:34)
-
Start01.03 Find Elements By Xpath (12:29)
-
Start01.04 Find Input Field By Xpath (13:44)
-
Start01.05 Find Elements By Css Selector (9:14)
-
Start01.06 Find Elements By Link Text (7:47)
-
Start01.07 Find Elements By Partial Link Text (8:05)
-
Start01.08 Find Elements By Classname (6:22)
-
Start01.09 Find Elements By Tagname (7:29)
-
Start01 Source Files
-
Start01 Data Cell (15:34)
-
Start02 Content Box (5:25)
-
Start03 Button (9:53)
-
Start04 Blank Block (4:04)
-
Start05 Blank List (13:24)
-
Start06 Column List (7:47)
-
Start07 Stacked List (8:21)
-
Start08 Form (7:35)
-
Start09 Input Field (6:57)
-
Start10 Picklist (8:12)
-
Start11 Number (6:13)
-
Start12 Percentage (5:06)
-
Start13 Currency (3:15)
-
Start14 Contact (4:37)
-
Start15 Date (4:25)
-
Start16 Segment (3:53)
-
Start17 Screen (4:39)
-
Start00 Build A Profit Splitter Contract-1 (11:48)
-
Start01 Build A Contract With Limited Addresses-2 (11:40)
-
Start02 Build A Contract And Library-3 (15:01)
-
Start03 Build A Contract With A Limited Time Transaction-4 (10:20)
-
Start04 Build Contracts With Inheritance-5 (13:22)
-
Start05 Build Contracts With Visibility Modifiers-6 (10:50)
-
Start06 Build A Contract With Mutability Modifiers-7 (10:20)
-
Start07 Build An Abstract Contract-8 (13:09)
-
Start08 Build A Bank Contract-9 (9:25)
-
Start09 Access Struct Value-10 (4:13)
-
StartSource Files
-
Start01. Course Requirements (2:55)
-
Start02. What Is Jsbin (3:15)
-
Start03. Setting Up The Html Document (2:41)
-
Start04. Header Tags And Paragraphs Tags (4:06)
-
Start05. Styles (3:32)
-
Start06. Bold Underline And Italic Tags (3:10)
-
Start07. Adding In A Link (1:38)
-
Start08. Adding In A Image (3:00)
-
Start09. Adding A Link To An Image (1:54)
-
Start10. Lists (4:03)
-
Start11. Tables (3:29)
-
Start12. Different Kinds Of Input (4:59)
-
Start13. Adding In A Submit Button (3:01)
-
Start01. Variables (5:36)
-
Start02. JavaScript (10:24)
-
Start03. Numbers (4:52)
-
Start04. Booleans (5:22)
-
Start05. If Statements (4:27)
-
Start06. Arrays (8:31)
-
Start07. For Loops (9:16)
-
Start08. While Loops (4:33)
-
Start09. Objects (8:02)
-
Start10. Functions (6:09)
-
Start11. Foreach (3:54)
-
Start12. Map Functions (5:22)
-
Start13. Using Objects As Dictionary (2:45)
-
Start14. Switch Statements (6:38)
-
Start15. Destructuring-1 (5:30)
-
Start16. Spread Operator-1 (6:56)
-
Start17. String Templates-1 (6:37)
-
Start18. Error Handling-1 (5:45)
-
Start19. Let And Const Keywords-1 (3:39)
-
Start20. Do-while-1 (1:45)
-
Start21. Sets-1 (5:42)
-
Start22. Maps-1 (4:39)
-
Start23. Stacks-1 (6:06)
-
Start24. Queues-1 (11:49)
-
Start25. For Loop (5:11)
-
Start26. Recursive Functions-1 (7:13)
-
Start27. Loop Labeling-1 (5:18)
-
Start28. 2d Arrays-1 (21:59)
-
Start29. Settimeout-1 (7:02)
-
Start30. Sentimental-1 (11:21)
-
Start31. Functions With Optional Parameters-1 (15:10)
-
Start32. Basic Regular Expression-1 (5:53)
-
Start33. Handle Keypress Events-1 (22:45)
-
Start34. Priority Queue-1 (15:54)
-
Start35. Add and delete Object Property-1 (2:44)
-
Start37. Concat-1 (3:12)
-
Start38. Flat And Flatmap-1 (2:06)
-
Start00A Project Preview (2:12)
-
Start00B What Is Linear Regression (5:03)
-
Start01 Collect Data From Blockchain Api (12:57)
-
Start02 Join CSV Files With Blockchain Data (9:01)
-
Start03 Process Data (4:06)
-
Start04 Visualize Data (11:19)
-
Start05 Create X And Y (6:15)
-
Start06 Build A Linear Regression Model (4:59)
-
Start07 Build A Polynomial Regression Model (5:53)
-
StartSource Files
-
Start00A Project Preview (3:02)
-
Start00B What Is Unsupervised Learning (8:17)
-
Start01 Collect Crypto Data With Cryptocompare API (9:35)
-
Start02 Clean Data (8:10)
-
Start03 Process Text Features (7:26)
-
Start04A What Is Principal Component Analysis (7:27)
-
Start04B Reduce Data Dimensionality With Principal Component Analysis (4:41)
-
Start05A What Is K Means Clustering (11:58)
-
Start05B Cluster Cryptocurrencies With K-Means Clustering (7:41)
-
Start06 Machine Learning With Optimal Number Of Clusters (4:48)
-
Start07 Visualize Clusters (5:25)
-
StartSource Files
-
Start00A Project Preview (2:12)
-
Start00B What Is A Recurrent Neural Network (6:38)
-
Start01 Load Stock Data With Yahoo Finance API (7:20)
-
Start02 Visualize Data (8:27)
-
Start03 Build A Training Dataset (8:04)
-
Start04 Build Features And Labels (10:37)
-
Start05 Build A Tensorflow Lstm Neural Network (12:04)
-
Start06 Load Test Data With An API (7:32)
-
Start07 Build Features And Labels For Testing The Neural Network (10:42)
-
Start08 Visualize Model's Predictions (8:42)
-
StartSource Files
-
Start00A Gradient Boosting Introduction (8:40)
-
Start00B What Is A Light Gradient Boosted Regression Ensemble (5:08)
-
Start01 Load Stock Data With Yahoo Finance API (5:08)
-
Start02 Build A Light GBM (7:59)
-
Start03 Find Best Number Of Trees (8:46)
-
Start04 Find Best Tree Depth (5:23)
-
StartSource Files
-
Start00 What Is Differential Privacy (7:18)
-
Start01 Differential Privacy Project Introduction (13:16)
-
Start02 Build An Initial Database (3:05)
-
Start03 Build A Parallel Database (4:04)
-
Start04 Build Multiple Parallel Databases (3:09)
-
Start05 Determine If Query Leaks Private Data (5:12)
-
Start06 Calculate Sensitivity Of Mean Query (6:29)