Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Complete Recession Proof Excel, Machine Learning, Python
00 Mammoth Interactive Courses Introduction
00 About Mammoth Interactive (1:11)
01 How to Learn Online Effectively (13:44)
Source Files
LEVEL 0 - Course Introduction
Introduction To The Complete Recession Proof Excel, Machine Learning, Python (3:34)
LEVEL 1 - Introduction to Excel - Excel to Python Data Science Automation Masterclass - Overview
00 Course Overview - Excel To Python (7:06)
Source Files - 00 Course overview - Excel to Python
Excel to Python Data Science Automation Masterclass - 01 Excel automation with Python data modeling
00 Project Overview - Excel Automation With Python Data Modeling (0:55)
01 Read Excel File With Python (6:42)
02 Reshape Data For Data Modeling (5:29)
03 Build A Linear Regression Model With Python (5:01)
04 Visualize Machine Learning Predictor With Python (6:22)
Source FIles
Excel to Python Data Science Automation Masterclass - 02 Use Excel File in Python
01 Use Excel File In Python (9:56)
02 Manipulate Excel File With Python (4:30)
03 Build Dictionaries With Python (3:51)
Source Files - Use Excel File in Python
Excel to Python Data Science Automation Masterclass - 03 Manipulate Excel Sheets with Python
01 Import Data File Into A Pandas Dataframe (6:22)
02 Excel Sheet Manipulation With Python (6:01)
03 Get Excel Sheet Information With Python (4:15)
Source Files
Excel to Python Data Science Automation Masterclass - 04 Build Excel Filters in Python
01 Build View Excel Functions In Python (5:58)
02 Build Filter Excel Functions In Python (3:31)
03 Build Filter Functions On Blockchain Dataset (11:04)
Source Files
Excel to Python Data Science Automation Masterclass - 05 Aggregate Excel Data with Python
01 Aggregate Excel Data With Python (11:21)
02 Build Excel Pivot Tables In Python (5:19)
Source Files
Excel Expense Tracker in 15 Minutes
01 Quick Win - Track Spendings And Savings In Excel (9:58)
02 Make Your Expense Tracker More Readable (5:53)
Source Files
LEVEL 2 - Excel Data Analysis - Excel Functions Mastery Course - Intro
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
Excel Functions Mastery Course - 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
Excel Functions Mastery Course - 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
Excel Functions Mastery Course - 04. Excel Date and Time Functions Projects
4.1 What will we learn in this section (1:14)
4.2 Work with Excel’s date manipulation functions (10:10)
4.3 Build a holiday date calculator (6:09)
4.4 Section Summary (4:43)
04 Source Files
Excel Functions Mastery Course - 05. Excel Text and Information Functions Projects
5.1 What will we learn in this section (1:59)
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 for evaluating and responding correctly to errors in routine Excel calculations (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
Excel Functions Mastery Course - 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
Excel Functions Mastery Course - 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)
8.1 Course Summary and Next Steps (23:32)
07 Source Files
Introduction to PivotTables in Excel - Overview
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
Introduction to PivotTables in Excel - 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
Introduction to PivotTables in Excel - 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
Introduction to PivotTables in Excel - Excel Tables
4.1 What Will We Learn In This Section (8:46)
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
Introduction to PivotTables in Excel - Slice and Dice Your Data
5.1 What Will We Learn In This Section-1 (1:23)
5.2 What Is Slicing Data-2 (3:41)
5.3 Slicing Data Project-3 (5:40)
5.4 Data Slicer Tools-4 (14:09)
5.5 Link Slicers To Multiple Pivottables-5 (8:03)
5.6 Section Summary-6 (2:32)
5.7 Challenge-7 (2:04)
05 Source Files
Introduction to PivotTables in Excel - Connect to Databases
6.1 What Will We Learn In This Section-1 (2:30)
6.2 Connect To Databases-3 (2:06)
6.3 Import Data Sources-4 (3:58)
6.4 Use Pivottables To Refine Data-5 (4:41)
6.5 Consolidate Your Data Table-6 (3:17)
6.6 Format Large Data Sets-7 (4:51)
6.7 Slicer And Timeline In Large Data Sets-8 (4:36)
6.8 Refresh And Drill Down From Databases-9 (4:46)
6.9 Section Summary-10 (4:01)
6.10 Challenge-2 (2:01)
06 Source Files
Excel Charts and Visualization - 01. Intro to course
1.1 Introduction To The Course-1 (4:46)
1.2 Why Should You Learn About Charts And Data Visualization-2 (4:31)
1.3 Introduction Of The Instructor-3 (2:08)
1.4 Course Requirements (what Software, Experience)-4 (2:36)
Excel Charts and Visualization - 02. Charts and Basics
2.1 What Will We Learn In This Section-1 (1:21)
2.2 Main Principles And Chart Visualization Impact-2 (2:38)
2.3 Choosing The Correct Chart-3 (1:56)
2.4 Communicate With The End User-4 (2:18)
2.5 Section Summary-5 (2:59)
2.6 Challenge-6 (2:12)
Excel Charts and Visualization - 03 Excel Chart Tools
3.1 What Will We Learn In This Section-1 (1:35)
3.2 Chart Design-2 (6:38)
3.3 Working With Chart Formats-3 (4:35)
3.4 Chart Types-4 (2:08)
3.5 Primary & Secondary Axis-5 (4:20)
3.6 Chart Templates-6 (3:25)
3.7 Section Summary-7 (2:50)
3.8 Challenge-8 (1:23)
Excel Charts and Visualization - 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:08)
4.4 Excel Bar Charts 1 (3:12)
4.5 Bar Charts Challenge (0:48)
4.6 Excel Line Charts-36 (3:52)
4.7 Line Charts Challenge-37 (0:48)
4.8 Excel Pie Charts-38 (5:01)
4.9 Pie Charts Challenge-39 (0:57)
4.10 Excel Area Charts-3 (2:27)
4.11 Area Charts Challenge-4 (0:50)
4.12 Excel Scatter Charts-5 (4:00)
4.13 Scatter Charts Challenge-6 (0:41)
4.14 Excel Bubble Charts-7 (5:12)
4.15 Bubble Charts Challenge-8 (0:54)
4.16 Excel Stock Charts-9 (3:07)
4.17 Stock Charts Challenge-10 (0:56)
4.18 Excel Surface Charts-11 (4:42)
4.19 Surface Charts Challenge-12 (0:43)
4.20 Excel Radar Charts-14 (2:58)
4.21 Radar Charts Challenge-15 (0:38)
4.22 Excel Treemap Charts-16 (2:31)
4.23 Treemap Charts Challenge-17 (1:03)
4.24 Excel Sunburst Charts-18 (2:36)
4.25 Sunburst Charts Challenge-19 (0:59)
4.26 Excel Histogram & Pareto Charts-20 (4:02)
4.27 Histogram & Pareto Charts Challenge-21 (1:04)
4.28 Excel Waterfall Charts-22 (5:26)
4.29 Waterfall Charts Challenge-23 (0:46)
4.30 Excel Box&whisker Charts-24 (3:24)
4.31 Box&whisker Charts Challenge-25 (1:03)
4.32 Excel Sparklines-26 (3:44)
4.33 Sparklines Challenge-27 (0:53)
4.34 Excel Color Scales-28 (3:42)
4.35 Color Scales Challenge-29 (0:49)
4.36 Excel 3D Map (4:35)
4.37 3D Map Challenge (1:45)
4.38 Section Summary (10:13)
04 Source Files
Excel Charts and Visualization - 05. Excel Advanced Data Visualization
5.1 What Will We Learn In This Section-1 (2:23)
5.2 Data Visualization With Pivot Chart And Slicers-7 (7:04)
5.3 Challenge Data Visualization With Pivot Chart And Slicers-8 (1:34)
5.4 Create Break Even Chart-9 (9:24)
5.5 Challenge Break Even Chart-10 (1:11)
5.6 Rating Star Chart-11 (7:09)
5.7 Challenge Star Rating-12 (1:28)
5.8 Drop Down Menu For Chart-13 (16:30)
5.9 Challenge Drop Down Menu Chart-14 (1:20)
5.10 Risk Score Chart-2 (11:03)
5.11 Challenge Risk Score Chart-3 (1:22)
5.12 Dynamic Chart Update (8:10)
5.13 Challenge Dynamic Chart Update (1:47)
5.14 Section Summary (6:48)
6.1 Course Summary And Next Steps (16:29)
Excel Financial Analysis - 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)
Excel Financial Analysis - 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)
Excel Financial Analysis - 03. Excel Finance Methods
3.1 What Will We Learn In This Section (5:48)
3.2 Forecast With Scenarios (23:30)
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 Accounts receivable Management Basics (20:49)
3.7 Customers Rank (11:56)
3.8 Create Budgets Categories (19:45)
3.9 Challenge (1:25)
4.1 Course Summary And Next Steps (31:21)
Data Visualization - 01. Introduction to the Course
1.1 Introduction To The Course-1 (8:27)
1.2 Introduction Of The Instructor-2 (3:11)
1.3 Course Requirements-3 (2:59)
1.4 How To Get Excel-4 (4:13)
Source files
Data Visualization - 02. Dashboards Introduction
2.1 What Will We Learn In This Section-1 (1:20)
2.2 What Are Dashboards-2 (5:39)
2.3 Answers You Need Before You Start A Dashboard-3 (7:45)
2.4 Best Practices For Dashboard Layout-4 (4:42)
2.5 Best Practices For Dashboard Colors-5 (3:54)
2.6 Section Summary-6 (3:40)
Source Code
Data Visualization - 03. Build a Dashboard Project
3.1 What will we learn in this section (1:16)
3.2 Build a Wireframe in Excel (5:42)
3.3 Prepare Raw Data for Dashboard (5:57)
3.4 Prepare Calculation sheet (13:01)
3.5 Section Summary (6:08)
Source Code
Data Visualization - 04. Scrolling Data Table
4.1 What will we learn in this section (2:48)
4.2 Build a Combo Box (10:44)
4.3 Complex Lookup (14:36)
4.4 Build a Scrolling Data Table (11:40)
4.5 Conditionally Format Actual Values vs Budgeted Values (10:52)
4.6 Conditional Headers (9:25)
4.7 Section Summary (3:01)
Source Code
Data Visualization - 05. Show Top Indicators
5.1 What will we learn in this section (1:50)
5.2 Show Top Matches Over and Under Budget (9:20)
5.3 List Box to Select Indicators (5:11)
5.4 Toggle Between Top Over or Under (12:50)
5.5 Section Summary (2:19)
Source Code
Data Visualization - 06. Scrollable Line Chart
6.1 What will we learn in this section (3:20)
6.2 Prepare Data for Scrolling Chart (14:19)
6.3 Scrollable Line Chart (11:17)
6.4 Remove Crashing Lines (4:12)
6.5 Toggle Visibility of Line Series (9:56)
6.6 Finetune the Line Series (7:08)
6.7 Section Summary (5:34)
Source Code
Data Visualization - 07. Interactivity
7.1 What will we learn in this section (1:56)
7.2 Add Interactivity to Reports with Pivot Slicers (10:44)
7.3 Column Chart Controlled by Slicer (6:47)
7.4 Pivot SLicer Sorting (4:26)
7.5 Select Only 1 Slicer (2:13)
7.6 Dynamic Comments with SLicers (11:36)
7.7 Section Summary (2:58)
Source Code
Data Visualization - 08. Finetune the Dashboard
8.1 What will we learn in this section (1:01)
8.2 Add Calculations for Variances in Pivot Tables (4:23)
8.3 Conditional Formatting in Pivot Tables (7:04)
8.4 Refresh Pivot Table with Easy VBA (7:49)
8.5 Section Summary (2:33)
Source Code
9.1 Course Summary and Next Steps (10:27)
LEVEL 3 - Power BI and Power Query - Beginners Excel Power Query and M Masterclass - 01 Course Overview
01 What Are Power Query And M (8:16)
02 Course Overview (6:16)
Source Files
Beginners Excel Power Query and M Masterclass - 02 Build your first M queries
01 Capitalize A Table Column (6:39)
02 Build An Expression With Let (17:09)
Source Files
Beginners Excel Power Query and M Masterclass - 03 Join tables with M
01 Build And Reference Tables (8:08)
02 Append And Combine Tables (5:33)
03 Inner Join Tables (5:33)
Join tables with M - Source Files
Beginners Excel Power Query and M Masterclass - 04 Build M functions to perform tasks
01 Build M Functions To Perform Tasks (8:13)
02 Call Functions (5:10)
03 Use The Each Keyword (2:33)
04 Change A Table With A Function (7:30)
05 Loop An Action With A Recursive Function (8:02)
06 Calculate Price After Discount 1 (6:09)
07 Use Optional Parameters To Combine Text (5:13)
08 Transform A List With A Function (2:09)
09 Calculate Number Of Working Days (12:20)
Build M functions to perform tasks - Source Files
Beginners Excel Power Query and M Masterclass - 05 Work with lists in M
01 Build A List With Each (5:16)
02 Concatenate Items In A List (5:01)
03 Iterate Over A List (4:17)
04 Iterate Over A List With Recursion (3:26)
Source Files
Beginners Excel Power Query and M Masterclass - 06 Build M variables to store data
01 Calculate Affiliate Revenue (4:37)
02 Variable Types (5:49)
03 Variable Scope - Where Can You Use Variables (8:57)
04 Order Of Evaluation (5:18)
Source Files
Beginners Excel Power Query and M Masterclass - 07 Aggregate table data with M
01 Count Rows (7:32)
02 Calculate Profits Per Quarter (5:55)
03 Group Similar Rows (5:59)
04 Sort A Table (5:27)
05 Query Data From Another Spreadsheet (7:18)
06 Find Where Sales Met Quota (2:55)
Source Files
Beginners Excel Power Query and M Masterclass - 08 Work with tables in M
01 Build Tables (6:55)
02 Work With Tables (5:37)
03 Fill In A Table (3:27)
Source Files
Beginners Excel Power Query and M Masterclass - 09 Build conditions with M if expressions
01 Build Conditions With If Expressions (8:14)
Source Files
Beginners Excel Power Query and M Masterclass - 10 Work with M data types
01 Manipulate Text (11:34)
02 Work With Numbers (3:00)
03 Work With Date, Time And Duration (7:52)
Source Files
Beginners Excel Power Query and M Masterclass - 11 Build queries for tables with M
01 Filter A Table By Row (6:59)
02 Format A List Of Values Into A Table (7:57)
Build queries for tables with M - Source Files
Beginners Excel Power Query and M Masterclass - 12 Build calculations for tables with M
01 Build Address Labels (8:26)
02 Calculate Percentage Of Total (6:44)
03 Calculate Sales Rank (7:04)
04 Count Number Of Distinct Rows (6:59)
Source Files
Beginners Excel Power Query and M Masterclass - 13 Fetch data from the web with M
01 Query Tables From The Web (7:15)
02 Search For Links On The Web (8:09)
03 Check If A Webpage Exists (6:24)
Source Files
Advanced Excel Power Query and M Masterclass - 00 Course overview
00 Course Overview - Advanced Excel Power Query And M (4:09)
01 What Are Power Query And M (8:15)
Course overview - Source Files
Advanced Excel Power Query and M Masterclass - 01 Build expressions with let
01 Build Nested Let Expressions (3:53)
02 Build A List With A Sequence (2:43)
03 Build An Unnamed Record (4:14)
Build expressions with let - Source Files
Advanced Excel Power Query and M Masterclass - 02 Build expressions with each
01 Work With The Each Keyword (5:00)
02 Generate A List (5:40)
03 Find An Entry In A Record (2:16)
04 Select Items From A List (5:06)
05 Serialize A Column (13:43)
06 Find Best Match Of Values (21:49)
Build expressions with each - Source Files
Advanced Excel Power Query and M Masterclass - 03 Build M functions to perform tasks
01 Build A Function (3:21)
02 Build A Closure (6:27)
03 Build A Function In A Record (4:23)
04 Count Fibonacci Numbers With A Recursive Function (7:04)
05 Remove Html Tags (9:19)
06 Build A For Each Loop (9:37)
Build M functions to perform tasks - Source Files
Advanced Excel Power Query and M Masterclass - 04 Work with tables in M
01 Select A Column From A Table (3:40)
02 Select A Value At A Row And Column (3:05)
03 Select Row Where A Condition Is Met (3:53)
04 Cross Join Tables (8:40)
05 Join Tables On A Key (5:48)
06 Change Column Types (3:48)
07 Fill A Table With Random Values (7:12)
Work with tables in M - Source Files
Advanced Excel Power Query and M Masterclass - 05 Pivot a table
00 What Is Pivoting (1:28)
01 Pivot A Table (12:05)
Pivot a table - Source Files
Advanced Excel Power Query and M Masterclass - 06 Build expressions with evaluate
01 Build An Expression With Evaluate (3:06)
02 Build A Nested Evaluate Expression (3:04)
03 Use Global Library Functions (2:27)
Build expressions with evaluate - Source Files
Advanced Excel Power Query and M Masterclass - 07 Work with matrices in M
00 How To Multiply Matrices (3:03)
01 Build Matrices In M (4:32)
02 Multiply Matrics (17:45)
Work with matrices in M - Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 01. Introduction To The Course
1.1 Introduction To Power BI (7:08)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 02. Get Started in Power BI
2.1 Installing Power BI (5:10)
2.2 Getting Started With PowerbI (16:17)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 03. Get Started in the Power Query Editor
3.1 Power Query Editor (8:53)
3.2 Getting Started With Power Query Editor (24:18)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 04. Work with Data in Power Query
4.1 Working With Data In Power Query (16:29)
4.2 Working With Data In Power Query (19:08)
4.3 Working With Data In Power Query Editor (13:32)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 05. Build Tables
5.1 Fact And Dimension Table (14:48)
5.2 Building Tables (7:41)
5.3 Date Dim Extract And Transform (8:42)
5.4 Extract Functionalities (6:05)
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 06. Analyze Data With Dax In Power BI
6.1 Data Analysis Expression Dax In Power BI (7:04)
6.2 Working With Data Analysis Expression DAX (12:16)
6.3 Measures Filters (10:00)
6.4 Measures All (6:06)
6.5 Iterators (6:30)
6.6 Iterators2 (7:36)
6.7 Iterators3 (8:27)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 07. Work with DAX Functions and Operators
7.1 Time Intelligence DAX (9:04)
7.2 Time Intelligence Functions (8:33)
7.3 Demo And Examples (9:25)
7.4 Date Table (4:31)
Source Files
Beginners Microsoft Power BI, DAX and Power Query with Artificial Intelligence - 08. Artificial Intelligence With Power BI
8.1 AI With PowerBI-1 (21:43)
8.2 AI With PowerBI-2 (19:27)
8.3 AI With PowerBI-3 (22:12)
Source Files
LEVEL 4 - Excel Automation Programming - Beginners Excel VBA - 01-02 Course Introduction
01.00 Course Overview (2:24)
01.01 How To Save Macros (1:34)
01-02 Source Files
Beginners Excel VBA - 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)
03 Source Files
Beginners Excel VBA - 04 Workbook and Worksheet Object
04.00 Topics Overview (1:30)
04.01 Object Hierarchymp4 (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)
04 Source Files
Beginners Excel VBA - 05 Work with the Range Object
05 Source Files
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)
Beginners Excel VBA - 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 (6:33)
06.05 Offset Property (3:32)
06.06 End Property (5:06)
06 Source Files
Beginners Excel VBA - 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)
07 Source Files
Beginners Excel VBA - 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
Beginners Excel VBA - 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
Beginners Excel VBA - 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)
10 Source Files
Beginners Excel VBA - 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)
11 Source Files
Intermediate Excel VBA - Overview & Introduction to Loops
12.00.00 Course Overview (2:50)
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)
12 Source Files
Intermediate Excel VBA - 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)