Members Monday - Members Monday Video Library
Buy now
Learn more
MM Content Navigators
MM Content Navigator VOL 1 After MM52
MM Content Navigator VOL 2 After MM115 CM.xlsm
How To Use The Content Navigators - Video Walkthrough
MM Download Files Link
MM Download Files Link
MM0150
Link To Live Session
MM0149
Link To Live Session
MM0148
Link To Live Session
MM0147
Link To Live Session
MM0146
Link To Live Session
MM0145
Link To Live Session
MM0144
Link To Live Session
MM0143
Members_ Monday _143.mp4
MM0142
Link To Live Session
MM0141
Link To Live Session
MM0140
Link To Live Session
MM0139
Link To Live Session
MM0138
Link To Live Session
MM0137
Link To Live Session
MM0136
Link To Live Session
MM0135
Link To Live Session
MM0134
Link To Live Session
MM0133
Link To Live Session
MM0132 - A Career In Excel?
Link To Live Session
MM0131 - 23 Excel Keyboard Shortcuts For 2023!
Link To Live Session
MM0130 - Dependency Diagrams For Excel Models
Link To Live Session
MM0129 - A General Theory Of Data Analysis In Excel?
Link To Live Session
MM0128 - Getting To Know Power Query (Finally!)
Link To Live Session
MM0127 - Simple Dashboard Generation
Link To Live Session
MM0126 - Homework Reviews And VBA Task Continuation
Link To Live Session
MM0125 - Using A Matrix To Control A VBA Routine
Link To Live Session
MM0124 - Member Showcase 2023
Link To Live Session
MM0123
Link To Live Session
MM0122 - Homework Reviews And Conditional Formatting Question
Link To Live Session
MM0121
Link To Live Session
MM0120 - Have Dynamic Array Formulae 'Changed Everything'?
Link To Live Session
MM0119
Link To Live Session
MM0118
Link To Live Session
MM0117
Link To Live Session
MM0116
Link To Live Session
MM0115 - What To Do When You Are Stuck In Excel! (And How To Copy A Chart To Powerpoint)
Members Monday #115 - What To Do When You Are Stuck In Excel! (And How To Copy A Chart To Powerpoint)
MM0114 - How To Work With Complicated Logic In A Simple Way
Members Monday #114 - How To Work With Complicated Logic In A Simple Way
MM0113 - How to Improving An Inefficient Excel File And Monica's Learning Journey
Members Monday #113 - How to Improving An Inefficient Excel File And Monica's Learning Journey
MM0112 - Advanced Applications Of FILTER And How To Design A Professional Excel Solution
Members Monday #112 - Advanced Applications Of FILTER And How To Design A Professional Excel Solution
MM0111 - How To Present A Chart And The FILTER Formula
Members Monday #111 - How To Present A Chart And The FILTER Formula
MM0110 - Excel Data Transfer Options And Homework Reviews
Members_ Monday #110 - Excel Data Transfer Discussion and Homework Reviews
MM0109 - Creating A Betting Analysis In Excel With A Visualisation
Members_ Monday #109 - Building A Trading Model For Football Data
MM0108 - Secrets Of the Random Task Generator 2
Members_ Monday #108 - Secrets Of The Random Task Generator 2
MM0107 - Secrets Of The Random Task Generator
Members_ Monday #107 - Secrets Of The Random Task Generator 1
MM0106 - An Incomplete Guide To Pivot Tables
Members_ Monday #106 - An Incomplete Guide To Pivot Tables.mp4
MM105 - Excel VBA Vs. Excel Formulae
Members_ Monday #105 - Excel VBA vs. Excel Formulae
MM0104 - Fixing An Inefficient Excel File For Jakob
Members_ Monday #104 - Fixing An Inefficient Excel File For Jakob
MM0103 - Dynamic Chart Challenge Homework Reviews
Dynamic Chart Challenge Homework Reviews
MM0102 - How To Export Excel Reports To Powerpoint … And A Chart Challenge 1.
How To Export Excel Reports To Powerpoint … And A Chart Challenge 1
MM0101 - Excel 101!
Members Monday #101 - Excel 101!
MM0100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)
Delayed 2 days
Members' Monday #100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)
MM0099 - Two-Hour Excel VBA Absolute Beginner Course (Part 2_2)
Delayed 2 days
Members' Monday #99 - Two-Hour Excel VBA Absolute Beginner Course (Part 2_2)
MM0098 - Two-Hour Excel VBA Absolute Beginner Course (Part 1/2)
Members' Monday #98 - Two-Hour Excel VBA Absolute Beginner Course (Part 1_2)
MM0097 - Use Excel VBA To Create Powerpoint Presentations 3
Getting Started With Excel VBA For Powerpoint 3
MM0096 - Use Excel VBA To Create Powerpoint Presentations 2
Getting Started With Excel VBA For Powerpoint 2
MM0095 - Use Excel VBA To Create Powerpoint Presentations 1
Getting Started With Excel VBA For Powerpoint 1
MM0094 - Referencing Sheets And Workbook Events
Referencing Sheets And Workbook Events
MM0093 - Q&A With Chris And The MM Community
Q&A With Chris And The MM Community
MM0092 - How Many Worksheets Do You Need?
How Many Worksheets Do You Need
MM0091 - Chris's Data Cleansing Challenge
Chris's Data Cleansing Challenge
MM0090 - Position Control In Excel VBA With Jakob
Make Dynamic Range Definition EASY With Excel VBA
MM0089 - Exploring SUMPRODUCT
Exploring SUMPRODUCT
MM0088 - Your 2022 Excel Gameplan
Your Excel Gameplan For This Year
MM0087 - Christmas Q&A
Exploring The Langage Of VBA
MM0086 - De-duplicating Data Across Multiple Files 3
De-duplicate Data Across Multiple Files With Excel VBA 3
MM0085 - De-duplicating Data Across Multiple Files 2
De-Duplicating Data Across Multiple Files
MM0084 - De-duplicating Data Across Multiple Files 1
De-Duplicating Data Across Multiple Files
MM0083 - Excel's Text Formulae
Excel's Text Formulae
MM0081 - Excel's 20 Information Formulae
Excel's 20 Information Formulae
MM0080 - Mastering Excel's 25 Date & Time Formulae
Mastering Excel's 25 Date & Time Formulae
MM0079 - Mastering Excel's Logical Functions
Mastering Excel's 11 Logical Functions
MM0078 - How Many Of Excel's 500 Formulae Do You Know?
How Many Of Excel's '500' Formulae Do You Know
MM0077 - A Loop Within A Loop With Excel VBA
How To Create A Loop Within A Loop In Excel VBA
MM0076 - Solving A Real-World Excel VBA Problem For A Member
Solving A Real-World VBA Problem For A Member
MM0075 - Create A Report In Another File Using Excel VBA
Create A Report In Another File With Excel VBA
MM0074 - How To Create A Report In Another File
Options For Creating A Report In Another File
MM0073 - 3 Small Excel VBA Challenges
3 Small Excel VBA Challenges
MM0072 - The Perfect Excel Line Chart?
All About Line Charts
MM0071 - The Perfect Excel Bar Chart?
The Perfect Excel Bar Chart
MM0070 - All About Pie Charts
All About Pie Charts
MM0069 - More Data Input Tips And Tricks
More Data Input Tips And Tricks
MM0068 - Data Input Tips And Tricks
Data Input Tips And Tricks
MM0067 - Creating An Invoice Generator
Copy , Rename And Delete Sheets With Excel VBA 2
MM0066 - Copy, Rename And Delete Sheets With Excel VBA
Copy, Rename And Delete Sheets With Excel VBA
MM0065 - Building An Excel VBA Application For The World's Toughest Client ;-)
Building An Excel VBA Application For The World's Toughest Client
MM0064 - Two Way Lookups In Excel With XLOOKUP
Two Way Lookups In Excel With XLOOKUP
MM0063 - 5 Steps To A Successful Excel Project
5 Steps To A Successful Excel Project
MM0062 - How To Analyse Times And Dates In Excel
How To Analyse Times And Dates In Excel
MM0061 - VBA-Based Optimisation In Excel
Advanced Optimisation With Excel VBA
MM0060 - 25/01/21 - Excel Optimisation Basics
Excel Optimisation Basics
MM0059 - 18/01/21 - 5 Excel Data Management Principles
5 Excel Data Management Principles
MM0058 - 11/01/21 - Workbook Event Macros: Pros And Cons
Workbook Event Macros Pros And Cons
MM0057 - 04/01/21 - The Power Of Loops In Excel VBA 3
The Power Of Loops In Excel VBA 3
MM0056 - 28/12/20 - The Power Of Loops In Excel VBA 2
The Power Of Loops In Excel VBA 2
MM0055 - 21/12/20 - The Power Of Loops In Excel VBA 1
The Power Of Loops In Excel VBA 1
MM0054 - 14/12/20 - Excel VBA Christmas Carol Challenge 2
Building A Custom Excel VBA Tool For Christmas 2
MM0053 - 07/12/20 - Excel VBA Christmas Carol Challenge 1
Excel VBA Christmas Carol Challenge 1
MM0052 - 30/11/20 - Catching Up With Craig And The New Website
Catching Up With Craig And The New Website
MM0051 - 23/11/20 - Separate Text Into Cells With Excel Formulae And VBA
Separate Text Into Separate Cells With Excel Formulae And VBA.mp4
MM0050 - 16/11/20 - How To Understand A Complicated Excel File
How To Understand A Complicated Excel File
MM0049 - 09/11/20 - Using A Userform For Quick Data Input 2
Using A Userform For Quick Data Input 2
MM0048 - 02/11/20 - Using A Userform For Quick Data Input 1
Using A Userform For Quick Data Input 1
MM0047 - 26/10/20 - Introduction To The Normal Distribution In Excel
Introduction To The Normal Distribution In Excel
MM0046 - 19/10/20 - Creating A Custom Probability Distribution
Creating A Custom Probability Distribution
MM0045 - 12/10/20 - Talking Through Andrew's Excel VBA Implementation For Nikki
Talking Through Andrew's Excel VBA Implementation For Nikki
MM0044 - 05/10/20 - Improving A Live Excel File With VBA
Improving A Live Excel File With VBA
MM0043 - 28/09/20 - Excel VBA Simulation For The Monty Hall Problem
Excel VBA Simulation For The Monty Hall Problem
MM0042 - 21/09/20 - How To Build A Career Around Excel
How To Build A Career Around Excel
MM0040 - 07/09/20 - How To Copy In 'Filtered' Rows Only (1)
How To Copy In 'Filtered' Rows Only (1)
MM0041 - 14/09/20 - How To Talk To Managers About Excel
How To Talk To Managers About Excel
MM0039 - 31/08/20 - Import Data From Other Files With Excel VBA
Import Data From Other Files With Excel VBA
MM0038 - 24/08/20 - How To Reference Other Files In Excel VBA
How To Reference Other Files In Excel VBA
MM0037 - 17/08/20 - Deleting Columns Using Excel VBA
Deleting Columns Using Excel VBA
MM0036 - 10/08/20 - Guided Blank Canvas Development 2
Guided Blank Canvas Development 2
MM0035 - 03/08/20 - Guided Blank Canvas Development
Guided Blank Canvas Development
MM0034 - 20/07/20 - Homework Reviews And Quick Walkthrough Of Tiger's Tombola
Homework Reviews And Quick Walkthrough Of Tiger's Tombola
MM0033 - 13/07/20 - First Meeting About Zahra's Project
First Meeting About Zahra's Project
MM0032 - 06/07/20 - Iain L Stars And More Development Of Bart's File
Iain L Stars And More Development Of Bart's File
MM0031 - 29/06/20 - Feedback From Bart And More Development
Feedback From Bart And More Development
MM0030 - 22/06/20 - Starting An Excel VBA Project With Bart!
Starting An Excel VBA Project With Bart!
MM0029 - 15/06/20 - Create A Work Schedule With Excel VBA 4
Create A Work Schedule With Excel VBA 4
MM0028 - 08/06/20 - Create A Work Schedule With Excel VBA 3
Create A Work Schedule With Excel VBA 3
MM0027 - 01/06/20 - The Power Of Excel INDIRECT 2
The Power Of Excel INDIRECT 2
MM0026 - 25/05/20 - The Power Of Excel INDIRECT 1
The Power Of Excel INDIRECT 1
MM0025 - 18/05/20 - 10 Ways My Excel VBA Has Improved In The Last 10 Years
10 Ways My Excel VBA Has Improved In The Last 10 Years
MM0024 - 11/05/20 - Automating Work Scheduling With Excel 2
Automating Work Scheduling With Excel 2
MM0023 - 04/05/20 - Automating Work Scheduling With Excel
Automating Work Scheduling With Excel
MM0022 - 27/04/20 - Speed Up A Typical Excel Task With Excel VBA
Speed Up A Typical Excel Task With Excel VBA
MM0021 - 20/04/20 - How To Make Money Out Of Excel
How To Make Money Out Of Excel
MM0020 - 13/04/20 - A Powerful Analysis Of Football Data With Excel VBA
A Powerful Analysis Of Football Data With Excel VBA
MM0019 - 06/04/20 - Chris's Data Analysis Secret Weapons
Chris's Data Analysis Secret Weapons
MM0018 - 30/03/20 - Creating Custom Lists In Excel VBA 2
Creating Custom Lists In Excel VBA 2
MM0017 - 23/03/20 - Creating Custom Lists Using VBA
Creating Custom Lists Using VBA
MM0016 - 16/03/20 - Trying Out New Excel Formulae
Trying Out New Excel Formulae
MM0015 - 09/03/20 - Create A Custom Report With Excel VBA
Create A Custom Report With Excel VBA
MM0014 - 02/03/20 - Automate Creation of Hyperlinks with Excel VBA 2
Automate Creation of Hyperlinks with Excel VBA 2
MM0013 - 24/02/20 - Automate Hyperlinks With Excel VBA
Automate Hyperlinks With Excel VBA
MM0012 - 17/02/20 - A Userform Combobox for Data Selection
A Userform Combobox for Data Selection
MM0011 - 10/02/20 - Using Module Level Variables
Using Module Level Variables
MM0010 - 03/02/20 - Two Examples of Application.WorksheetFunction
Two Examples of Application.WorksheetFunction
MM0009 - 27/01/20 - Find The 'Last Row' In A Dataset Using Excel VBA
Find The 'Last Row' In A Dataset Using Excel VBA
MM0008 - 20/01/20 - VBA To Move Input Data To A Database
VBA To Move Input Data To A Database
MM0007 - 13/01/20 - Supporting Data Input in Excel
Supporting Data Input in Excel
MM0006 - 06/01/20 - Planning Your Excel Project
Planning Your Excel Project
MM0004 - 23/12/19 - Working With Multiple Files In VBA 2
Working With Multiple Files in Excel VBA 2
MM0005 - 30/12/19 - Look Up Multiple Entries In Another File
Look Up Multiple Entries In Another File
MM0003 - 16/12/19 - Working With Another File In VBA
Working With Another File In VBA
MM0002 - 09/12/19 - Cool Workbook Event Macros
Cool Workbook Event Macros
MM0001 - 02/12/19 - How To Create Dynamic Dropdown Menus
How To Create Dynamic Dropdown Menus
Products
Course
Members Monday - Members Monday Video Library
Members Monday - Members Monday Video Library
Members Monday - Members Monday Video Library
Buy now
Learn more
MM Content Navigators
MM Content Navigator VOL 1 After MM52
MM Content Navigator VOL 2 After MM115 CM.xlsm
How To Use The Content Navigators - Video Walkthrough
MM Download Files Link
MM Download Files Link
MM0150
Link To Live Session
MM0149
Link To Live Session
MM0148
Link To Live Session
MM0147
Link To Live Session
MM0146
Link To Live Session
MM0145
Link To Live Session
MM0144
Link To Live Session
MM0143
Members_ Monday _143.mp4
MM0142
Link To Live Session
MM0141
Link To Live Session
MM0140
Link To Live Session
MM0139
Link To Live Session
MM0138
Link To Live Session
MM0137
Link To Live Session
MM0136
Link To Live Session
MM0135
Link To Live Session
MM0134
Link To Live Session
MM0133
Link To Live Session
MM0132 - A Career In Excel?
Link To Live Session
MM0131 - 23 Excel Keyboard Shortcuts For 2023!
Link To Live Session
MM0130 - Dependency Diagrams For Excel Models
Link To Live Session
MM0129 - A General Theory Of Data Analysis In Excel?
Link To Live Session
MM0128 - Getting To Know Power Query (Finally!)
Link To Live Session
MM0127 - Simple Dashboard Generation
Link To Live Session
MM0126 - Homework Reviews And VBA Task Continuation
Link To Live Session
MM0125 - Using A Matrix To Control A VBA Routine
Link To Live Session
MM0124 - Member Showcase 2023
Link To Live Session
MM0123
Link To Live Session
MM0122 - Homework Reviews And Conditional Formatting Question
Link To Live Session
MM0121
Link To Live Session
MM0120 - Have Dynamic Array Formulae 'Changed Everything'?
Link To Live Session
MM0119
Link To Live Session
MM0118
Link To Live Session
MM0117
Link To Live Session
MM0116
Link To Live Session
MM0115 - What To Do When You Are Stuck In Excel! (And How To Copy A Chart To Powerpoint)
Members Monday #115 - What To Do When You Are Stuck In Excel! (And How To Copy A Chart To Powerpoint)
MM0114 - How To Work With Complicated Logic In A Simple Way
Members Monday #114 - How To Work With Complicated Logic In A Simple Way
MM0113 - How to Improving An Inefficient Excel File And Monica's Learning Journey
Members Monday #113 - How to Improving An Inefficient Excel File And Monica's Learning Journey
MM0112 - Advanced Applications Of FILTER And How To Design A Professional Excel Solution
Members Monday #112 - Advanced Applications Of FILTER And How To Design A Professional Excel Solution
MM0111 - How To Present A Chart And The FILTER Formula
Members Monday #111 - How To Present A Chart And The FILTER Formula
MM0110 - Excel Data Transfer Options And Homework Reviews
Members_ Monday #110 - Excel Data Transfer Discussion and Homework Reviews
MM0109 - Creating A Betting Analysis In Excel With A Visualisation
Members_ Monday #109 - Building A Trading Model For Football Data
MM0108 - Secrets Of the Random Task Generator 2
Members_ Monday #108 - Secrets Of The Random Task Generator 2
MM0107 - Secrets Of The Random Task Generator
Members_ Monday #107 - Secrets Of The Random Task Generator 1
MM0106 - An Incomplete Guide To Pivot Tables
Members_ Monday #106 - An Incomplete Guide To Pivot Tables.mp4
MM105 - Excel VBA Vs. Excel Formulae
Members_ Monday #105 - Excel VBA vs. Excel Formulae
MM0104 - Fixing An Inefficient Excel File For Jakob
Members_ Monday #104 - Fixing An Inefficient Excel File For Jakob
MM0103 - Dynamic Chart Challenge Homework Reviews
Dynamic Chart Challenge Homework Reviews
MM0102 - How To Export Excel Reports To Powerpoint … And A Chart Challenge 1.
How To Export Excel Reports To Powerpoint … And A Chart Challenge 1
MM0101 - Excel 101!
Members Monday #101 - Excel 101!
This section is
delayed by 2 days.
MM0100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)
Members' Monday #100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)
This section is
delayed by 2 days.
MM0099 - Two-Hour Excel VBA Absolute Beginner Course (Part 2_2)
Members' Monday #99 - Two-Hour Excel VBA Absolute Beginner Course (Part 2_2)
MM0098 - Two-Hour Excel VBA Absolute Beginner Course (Part 1/2)
Members' Monday #98 - Two-Hour Excel VBA Absolute Beginner Course (Part 1_2)
MM0097 - Use Excel VBA To Create Powerpoint Presentations 3
Getting Started With Excel VBA For Powerpoint 3
MM0096 - Use Excel VBA To Create Powerpoint Presentations 2
Getting Started With Excel VBA For Powerpoint 2
MM0095 - Use Excel VBA To Create Powerpoint Presentations 1
Getting Started With Excel VBA For Powerpoint 1
MM0094 - Referencing Sheets And Workbook Events
Referencing Sheets And Workbook Events
MM0093 - Q&A With Chris And The MM Community
Q&A With Chris And The MM Community
MM0092 - How Many Worksheets Do You Need?
How Many Worksheets Do You Need
MM0091 - Chris's Data Cleansing Challenge
Chris's Data Cleansing Challenge
MM0090 - Position Control In Excel VBA With Jakob
Make Dynamic Range Definition EASY With Excel VBA
MM0089 - Exploring SUMPRODUCT
Exploring SUMPRODUCT
MM0088 - Your 2022 Excel Gameplan
Your Excel Gameplan For This Year
MM0087 - Christmas Q&A
Exploring The Langage Of VBA
MM0086 - De-duplicating Data Across Multiple Files 3
De-duplicate Data Across Multiple Files With Excel VBA 3
MM0085 - De-duplicating Data Across Multiple Files 2
De-Duplicating Data Across Multiple Files
MM0084 - De-duplicating Data Across Multiple Files 1
De-Duplicating Data Across Multiple Files
MM0083 - Excel's Text Formulae
Excel's Text Formulae
MM0081 - Excel's 20 Information Formulae
Excel's 20 Information Formulae
MM0080 - Mastering Excel's 25 Date & Time Formulae
Mastering Excel's 25 Date & Time Formulae
MM0079 - Mastering Excel's Logical Functions
Mastering Excel's 11 Logical Functions
MM0078 - How Many Of Excel's 500 Formulae Do You Know?
How Many Of Excel's '500' Formulae Do You Know
MM0077 - A Loop Within A Loop With Excel VBA
How To Create A Loop Within A Loop In Excel VBA
MM0076 - Solving A Real-World Excel VBA Problem For A Member
Solving A Real-World VBA Problem For A Member
MM0075 - Create A Report In Another File Using Excel VBA
Create A Report In Another File With Excel VBA
MM0074 - How To Create A Report In Another File
Options For Creating A Report In Another File
MM0073 - 3 Small Excel VBA Challenges
3 Small Excel VBA Challenges
MM0072 - The Perfect Excel Line Chart?
All About Line Charts
MM0071 - The Perfect Excel Bar Chart?
The Perfect Excel Bar Chart
MM0070 - All About Pie Charts
All About Pie Charts
MM0069 - More Data Input Tips And Tricks
More Data Input Tips And Tricks
MM0068 - Data Input Tips And Tricks
Data Input Tips And Tricks
MM0067 - Creating An Invoice Generator
Copy , Rename And Delete Sheets With Excel VBA 2
MM0066 - Copy, Rename And Delete Sheets With Excel VBA
Copy, Rename And Delete Sheets With Excel VBA
MM0065 - Building An Excel VBA Application For The World's Toughest Client ;-)
Building An Excel VBA Application For The World's Toughest Client
MM0064 - Two Way Lookups In Excel With XLOOKUP
Two Way Lookups In Excel With XLOOKUP
MM0063 - 5 Steps To A Successful Excel Project
5 Steps To A Successful Excel Project
MM0062 - How To Analyse Times And Dates In Excel
How To Analyse Times And Dates In Excel
MM0061 - VBA-Based Optimisation In Excel
Advanced Optimisation With Excel VBA
MM0060 - 25/01/21 - Excel Optimisation Basics
Excel Optimisation Basics
MM0059 - 18/01/21 - 5 Excel Data Management Principles
5 Excel Data Management Principles
MM0058 - 11/01/21 - Workbook Event Macros: Pros And Cons
Workbook Event Macros Pros And Cons
MM0057 - 04/01/21 - The Power Of Loops In Excel VBA 3
The Power Of Loops In Excel VBA 3
MM0056 - 28/12/20 - The Power Of Loops In Excel VBA 2
The Power Of Loops In Excel VBA 2
MM0055 - 21/12/20 - The Power Of Loops In Excel VBA 1
The Power Of Loops In Excel VBA 1
MM0054 - 14/12/20 - Excel VBA Christmas Carol Challenge 2
Building A Custom Excel VBA Tool For Christmas 2
MM0053 - 07/12/20 - Excel VBA Christmas Carol Challenge 1
Excel VBA Christmas Carol Challenge 1
MM0052 - 30/11/20 - Catching Up With Craig And The New Website
Catching Up With Craig And The New Website
MM0051 - 23/11/20 - Separate Text Into Cells With Excel Formulae And VBA
Separate Text Into Separate Cells With Excel Formulae And VBA.mp4
MM0050 - 16/11/20 - How To Understand A Complicated Excel File
How To Understand A Complicated Excel File
MM0049 - 09/11/20 - Using A Userform For Quick Data Input 2
Using A Userform For Quick Data Input 2
MM0048 - 02/11/20 - Using A Userform For Quick Data Input 1
Using A Userform For Quick Data Input 1
MM0047 - 26/10/20 - Introduction To The Normal Distribution In Excel
Introduction To The Normal Distribution In Excel
MM0046 - 19/10/20 - Creating A Custom Probability Distribution
Creating A Custom Probability Distribution
MM0045 - 12/10/20 - Talking Through Andrew's Excel VBA Implementation For Nikki
Talking Through Andrew's Excel VBA Implementation For Nikki
MM0044 - 05/10/20 - Improving A Live Excel File With VBA
Improving A Live Excel File With VBA
MM0043 - 28/09/20 - Excel VBA Simulation For The Monty Hall Problem
Excel VBA Simulation For The Monty Hall Problem
MM0042 - 21/09/20 - How To Build A Career Around Excel
How To Build A Career Around Excel
MM0040 - 07/09/20 - How To Copy In 'Filtered' Rows Only (1)
How To Copy In 'Filtered' Rows Only (1)
MM0041 - 14/09/20 - How To Talk To Managers About Excel
How To Talk To Managers About Excel
MM0039 - 31/08/20 - Import Data From Other Files With Excel VBA
Import Data From Other Files With Excel VBA
MM0038 - 24/08/20 - How To Reference Other Files In Excel VBA
How To Reference Other Files In Excel VBA
MM0037 - 17/08/20 - Deleting Columns Using Excel VBA
Deleting Columns Using Excel VBA
MM0036 - 10/08/20 - Guided Blank Canvas Development 2
Guided Blank Canvas Development 2
MM0035 - 03/08/20 - Guided Blank Canvas Development
Guided Blank Canvas Development
MM0034 - 20/07/20 - Homework Reviews And Quick Walkthrough Of Tiger's Tombola
Homework Reviews And Quick Walkthrough Of Tiger's Tombola
MM0033 - 13/07/20 - First Meeting About Zahra's Project
First Meeting About Zahra's Project
MM0032 - 06/07/20 - Iain L Stars And More Development Of Bart's File
Iain L Stars And More Development Of Bart's File
MM0031 - 29/06/20 - Feedback From Bart And More Development
Feedback From Bart And More Development
MM0030 - 22/06/20 - Starting An Excel VBA Project With Bart!
Starting An Excel VBA Project With Bart!
MM0029 - 15/06/20 - Create A Work Schedule With Excel VBA 4
Create A Work Schedule With Excel VBA 4
MM0028 - 08/06/20 - Create A Work Schedule With Excel VBA 3
Create A Work Schedule With Excel VBA 3
MM0027 - 01/06/20 - The Power Of Excel INDIRECT 2
The Power Of Excel INDIRECT 2
MM0026 - 25/05/20 - The Power Of Excel INDIRECT 1
The Power Of Excel INDIRECT 1
MM0025 - 18/05/20 - 10 Ways My Excel VBA Has Improved In The Last 10 Years
10 Ways My Excel VBA Has Improved In The Last 10 Years
MM0024 - 11/05/20 - Automating Work Scheduling With Excel 2
Automating Work Scheduling With Excel 2
MM0023 - 04/05/20 - Automating Work Scheduling With Excel
Automating Work Scheduling With Excel
MM0022 - 27/04/20 - Speed Up A Typical Excel Task With Excel VBA
Speed Up A Typical Excel Task With Excel VBA
MM0021 - 20/04/20 - How To Make Money Out Of Excel
How To Make Money Out Of Excel
MM0020 - 13/04/20 - A Powerful Analysis Of Football Data With Excel VBA
A Powerful Analysis Of Football Data With Excel VBA
MM0019 - 06/04/20 - Chris's Data Analysis Secret Weapons
Chris's Data Analysis Secret Weapons
MM0018 - 30/03/20 - Creating Custom Lists In Excel VBA 2
Creating Custom Lists In Excel VBA 2
MM0017 - 23/03/20 - Creating Custom Lists Using VBA
Creating Custom Lists Using VBA
MM0016 - 16/03/20 - Trying Out New Excel Formulae
Trying Out New Excel Formulae
MM0015 - 09/03/20 - Create A Custom Report With Excel VBA
Create A Custom Report With Excel VBA
MM0014 - 02/03/20 - Automate Creation of Hyperlinks with Excel VBA 2
Automate Creation of Hyperlinks with Excel VBA 2
MM0013 - 24/02/20 - Automate Hyperlinks With Excel VBA
Automate Hyperlinks With Excel VBA
MM0012 - 17/02/20 - A Userform Combobox for Data Selection
A Userform Combobox for Data Selection
MM0011 - 10/02/20 - Using Module Level Variables
Using Module Level Variables
MM0010 - 03/02/20 - Two Examples of Application.WorksheetFunction
Two Examples of Application.WorksheetFunction
MM0009 - 27/01/20 - Find The 'Last Row' In A Dataset Using Excel VBA
Find The 'Last Row' In A Dataset Using Excel VBA
MM0008 - 20/01/20 - VBA To Move Input Data To A Database
VBA To Move Input Data To A Database
MM0007 - 13/01/20 - Supporting Data Input in Excel
Supporting Data Input in Excel
MM0006 - 06/01/20 - Planning Your Excel Project
Planning Your Excel Project
MM0004 - 23/12/19 - Working With Multiple Files In VBA 2
Working With Multiple Files in Excel VBA 2
MM0005 - 30/12/19 - Look Up Multiple Entries In Another File
Look Up Multiple Entries In Another File
MM0003 - 16/12/19 - Working With Another File In VBA
Working With Another File In VBA
MM0002 - 09/12/19 - Cool Workbook Event Macros
Cool Workbook Event Macros
MM0001 - 02/12/19 - How To Create Dynamic Dropdown Menus
How To Create Dynamic Dropdown Menus
Learn more
Buy now
MM Content Navigators
3 Lessons
MM Content Navigator VOL 1 After MM52
MM Content Navigator VOL 2 After MM115 CM.xlsm
How To Use The Content Navigators - Video Walkthrough
MM Download Files Link
1 Lesson
MM Download Files Link
MM0150
1 Lesson
Link To Live Session
MM0149
1 Lesson
Link To Live Session
MM0148
1 Lesson
Link To Live Session
MM0147
1 Lesson
Link To Live Session
MM0146
1 Lesson
Link To Live Session
MM0145
1 Lesson
Link To Live Session
MM0144
1 Lesson
Link To Live Session
MM0143
1 Lesson
Members_ Monday _143.mp4
MM0142
1 Lesson
Link To Live Session
MM0141
1 Lesson
Link To Live Session
MM0140
1 Lesson
Link To Live Session
MM0139
1 Lesson
Link To Live Session
MM0138
1 Lesson
Link To Live Session
MM0137
1 Lesson
Link To Live Session
MM0136
1 Lesson
Link To Live Session
MM0135
1 Lesson
Link To Live Session
MM0134
1 Lesson
Link To Live Session
MM0133
1 Lesson
Link To Live Session
MM0132 - A Career In Excel?
1 Lesson
Link To Live Session
MM0131 - 23 Excel Keyboard Shortcuts For 2023!
1 Lesson
Link To Live Session
MM0130 - Dependency Diagrams For Excel Models
1 Lesson
Link To Live Session
MM0129 - A General Theory Of Data Analysis In Excel?
1 Lesson
Link To Live Session
MM0128 - Getting To Know Power Query (Finally!)
1 Lesson
Link To Live Session
MM0127 - Simple Dashboard Generation
1 Lesson
Link To Live Session
MM0126 - Homework Reviews And VBA Task Continuation
1 Lesson
Link To Live Session
MM0125 - Using A Matrix To Control A VBA Routine
1 Lesson
Link To Live Session
MM0124 - Member Showcase 2023
1 Lesson
Link To Live Session
MM0123
1 Lesson
Link To Live Session
MM0122 - Homework Reviews And Conditional Formatting Question
1 Lesson
Link To Live Session
MM0121
1 Lesson
Link To Live Session
MM0120 - Have Dynamic Array Formulae 'Changed Everything'?
1 Lesson
Link To Live Session
MM0119
1 Lesson
Link To Live Session
MM0118
1 Lesson
Link To Live Session
MM0117
1 Lesson
Link To Live Session
MM0116
1 Lesson
Link To Live Session
MM0115 - What To Do When You Are Stuck In Excel! (And How To Copy A Chart To Powerpoint)
1 Lesson
Members Monday #115 - What To Do When You Are Stuck In Excel! (And How To Copy A Chart To Powerpoint)
MM0114 - How To Work With Complicated Logic In A Simple Way
1 Lesson
Members Monday #114 - How To Work With Complicated Logic In A Simple Way
MM0113 - How to Improving An Inefficient Excel File And Monica's Learning Journey
1 Lesson
Members Monday #113 - How to Improving An Inefficient Excel File And Monica's Learning Journey
MM0112 - Advanced Applications Of FILTER And How To Design A Professional Excel Solution
1 Lesson
Members Monday #112 - Advanced Applications Of FILTER And How To Design A Professional Excel Solution
MM0111 - How To Present A Chart And The FILTER Formula
1 Lesson
Members Monday #111 - How To Present A Chart And The FILTER Formula
MM0110 - Excel Data Transfer Options And Homework Reviews
1 Lesson
Members_ Monday #110 - Excel Data Transfer Discussion and Homework Reviews
MM0109 - Creating A Betting Analysis In Excel With A Visualisation
1 Lesson
Members_ Monday #109 - Building A Trading Model For Football Data
MM0108 - Secrets Of the Random Task Generator 2
1 Lesson
Members_ Monday #108 - Secrets Of The Random Task Generator 2
MM0107 - Secrets Of The Random Task Generator
1 Lesson
Members_ Monday #107 - Secrets Of The Random Task Generator 1
MM0106 - An Incomplete Guide To Pivot Tables
1 Lesson
Members_ Monday #106 - An Incomplete Guide To Pivot Tables.mp4
MM105 - Excel VBA Vs. Excel Formulae
1 Lesson
Members_ Monday #105 - Excel VBA vs. Excel Formulae
MM0104 - Fixing An Inefficient Excel File For Jakob
1 Lesson
Members_ Monday #104 - Fixing An Inefficient Excel File For Jakob
MM0103 - Dynamic Chart Challenge Homework Reviews
1 Lesson
Dynamic Chart Challenge Homework Reviews
MM0102 - How To Export Excel Reports To Powerpoint … And A Chart Challenge 1.
1 Lesson
How To Export Excel Reports To Powerpoint … And A Chart Challenge 1
MM0101 - Excel 101!
1 Lesson
Members Monday #101 - Excel 101!
This section is
delayed by 2 days.
MM0100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)
1 Lesson
Members' Monday #100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)
This section is
delayed by 2 days.
MM0099 - Two-Hour Excel VBA Absolute Beginner Course (Part 2_2)
1 Lesson
Members' Monday #99 - Two-Hour Excel VBA Absolute Beginner Course (Part 2_2)
MM0098 - Two-Hour Excel VBA Absolute Beginner Course (Part 1/2)
1 Lesson
Members' Monday #98 - Two-Hour Excel VBA Absolute Beginner Course (Part 1_2)
MM0097 - Use Excel VBA To Create Powerpoint Presentations 3
1 Lesson
Getting Started With Excel VBA For Powerpoint 3
MM0096 - Use Excel VBA To Create Powerpoint Presentations 2
1 Lesson
Getting Started With Excel VBA For Powerpoint 2
MM0095 - Use Excel VBA To Create Powerpoint Presentations 1
1 Lesson
Getting Started With Excel VBA For Powerpoint 1
MM0094 - Referencing Sheets And Workbook Events
1 Lesson
Referencing Sheets And Workbook Events
MM0093 - Q&A With Chris And The MM Community
1 Lesson
Q&A With Chris And The MM Community
MM0092 - How Many Worksheets Do You Need?
1 Lesson
How Many Worksheets Do You Need
MM0091 - Chris's Data Cleansing Challenge
1 Lesson
Chris's Data Cleansing Challenge
MM0090 - Position Control In Excel VBA With Jakob
1 Lesson
Make Dynamic Range Definition EASY With Excel VBA
MM0089 - Exploring SUMPRODUCT
1 Lesson
Exploring SUMPRODUCT
MM0088 - Your 2022 Excel Gameplan
1 Lesson
Your Excel Gameplan For This Year
MM0087 - Christmas Q&A
1 Lesson
Exploring The Langage Of VBA
MM0086 - De-duplicating Data Across Multiple Files 3
1 Lesson
De-duplicate Data Across Multiple Files With Excel VBA 3
MM0085 - De-duplicating Data Across Multiple Files 2
1 Lesson
De-Duplicating Data Across Multiple Files
MM0084 - De-duplicating Data Across Multiple Files 1
1 Lesson
De-Duplicating Data Across Multiple Files
MM0083 - Excel's Text Formulae
1 Lesson
Excel's Text Formulae
MM0081 - Excel's 20 Information Formulae
1 Lesson
Excel's 20 Information Formulae
MM0080 - Mastering Excel's 25 Date & Time Formulae
1 Lesson
Mastering Excel's 25 Date & Time Formulae
MM0079 - Mastering Excel's Logical Functions
1 Lesson
Mastering Excel's 11 Logical Functions
MM0078 - How Many Of Excel's 500 Formulae Do You Know?
1 Lesson
How Many Of Excel's '500' Formulae Do You Know
MM0077 - A Loop Within A Loop With Excel VBA
1 Lesson
How To Create A Loop Within A Loop In Excel VBA
MM0076 - Solving A Real-World Excel VBA Problem For A Member
1 Lesson
Solving A Real-World VBA Problem For A Member
MM0075 - Create A Report In Another File Using Excel VBA
1 Lesson
Create A Report In Another File With Excel VBA
MM0074 - How To Create A Report In Another File
1 Lesson
Options For Creating A Report In Another File
MM0073 - 3 Small Excel VBA Challenges
1 Lesson
3 Small Excel VBA Challenges
MM0072 - The Perfect Excel Line Chart?
1 Lesson
All About Line Charts
MM0071 - The Perfect Excel Bar Chart?
1 Lesson
The Perfect Excel Bar Chart
MM0070 - All About Pie Charts
1 Lesson
All About Pie Charts
MM0069 - More Data Input Tips And Tricks
1 Lesson
More Data Input Tips And Tricks
MM0068 - Data Input Tips And Tricks
1 Lesson
Data Input Tips And Tricks
MM0067 - Creating An Invoice Generator
1 Lesson
Copy , Rename And Delete Sheets With Excel VBA 2
MM0066 - Copy, Rename And Delete Sheets With Excel VBA
1 Lesson
Copy, Rename And Delete Sheets With Excel VBA
MM0065 - Building An Excel VBA Application For The World's Toughest Client ;-)
1 Lesson
Building An Excel VBA Application For The World's Toughest Client
MM0064 - Two Way Lookups In Excel With XLOOKUP
1 Lesson
Two Way Lookups In Excel With XLOOKUP
MM0063 - 5 Steps To A Successful Excel Project
1 Lesson
5 Steps To A Successful Excel Project
MM0062 - How To Analyse Times And Dates In Excel
1 Lesson
How To Analyse Times And Dates In Excel
MM0061 - VBA-Based Optimisation In Excel
1 Lesson
Advanced Optimisation With Excel VBA
MM0060 - 25/01/21 - Excel Optimisation Basics
1 Lesson
Excel Optimisation Basics
MM0059 - 18/01/21 - 5 Excel Data Management Principles
1 Lesson
5 Excel Data Management Principles
MM0058 - 11/01/21 - Workbook Event Macros: Pros And Cons
1 Lesson
Workbook Event Macros Pros And Cons
MM0057 - 04/01/21 - The Power Of Loops In Excel VBA 3
1 Lesson
The Power Of Loops In Excel VBA 3
MM0056 - 28/12/20 - The Power Of Loops In Excel VBA 2
1 Lesson
The Power Of Loops In Excel VBA 2
MM0055 - 21/12/20 - The Power Of Loops In Excel VBA 1
1 Lesson
The Power Of Loops In Excel VBA 1
MM0054 - 14/12/20 - Excel VBA Christmas Carol Challenge 2
1 Lesson
Building A Custom Excel VBA Tool For Christmas 2
MM0053 - 07/12/20 - Excel VBA Christmas Carol Challenge 1
1 Lesson
Excel VBA Christmas Carol Challenge 1
MM0052 - 30/11/20 - Catching Up With Craig And The New Website
1 Lesson
Catching Up With Craig And The New Website
MM0051 - 23/11/20 - Separate Text Into Cells With Excel Formulae And VBA
1 Lesson
Separate Text Into Separate Cells With Excel Formulae And VBA.mp4
MM0050 - 16/11/20 - How To Understand A Complicated Excel File
1 Lesson
How To Understand A Complicated Excel File
MM0049 - 09/11/20 - Using A Userform For Quick Data Input 2
1 Lesson
Using A Userform For Quick Data Input 2
MM0048 - 02/11/20 - Using A Userform For Quick Data Input 1
1 Lesson
Using A Userform For Quick Data Input 1
MM0047 - 26/10/20 - Introduction To The Normal Distribution In Excel
1 Lesson
Introduction To The Normal Distribution In Excel
MM0046 - 19/10/20 - Creating A Custom Probability Distribution
1 Lesson
Creating A Custom Probability Distribution
MM0045 - 12/10/20 - Talking Through Andrew's Excel VBA Implementation For Nikki
1 Lesson
Talking Through Andrew's Excel VBA Implementation For Nikki
MM0044 - 05/10/20 - Improving A Live Excel File With VBA
1 Lesson
Improving A Live Excel File With VBA
MM0043 - 28/09/20 - Excel VBA Simulation For The Monty Hall Problem
1 Lesson
Excel VBA Simulation For The Monty Hall Problem
MM0042 - 21/09/20 - How To Build A Career Around Excel
1 Lesson
How To Build A Career Around Excel
MM0040 - 07/09/20 - How To Copy In 'Filtered' Rows Only (1)
1 Lesson
How To Copy In 'Filtered' Rows Only (1)
MM0041 - 14/09/20 - How To Talk To Managers About Excel
1 Lesson
How To Talk To Managers About Excel
MM0039 - 31/08/20 - Import Data From Other Files With Excel VBA
1 Lesson
Import Data From Other Files With Excel VBA
MM0038 - 24/08/20 - How To Reference Other Files In Excel VBA
1 Lesson
How To Reference Other Files In Excel VBA
MM0037 - 17/08/20 - Deleting Columns Using Excel VBA
1 Lesson
Deleting Columns Using Excel VBA
MM0036 - 10/08/20 - Guided Blank Canvas Development 2
1 Lesson
Guided Blank Canvas Development 2
MM0035 - 03/08/20 - Guided Blank Canvas Development
1 Lesson
Guided Blank Canvas Development
MM0034 - 20/07/20 - Homework Reviews And Quick Walkthrough Of Tiger's Tombola
1 Lesson
Homework Reviews And Quick Walkthrough Of Tiger's Tombola
MM0033 - 13/07/20 - First Meeting About Zahra's Project
1 Lesson
First Meeting About Zahra's Project
MM0032 - 06/07/20 - Iain L Stars And More Development Of Bart's File
1 Lesson
Iain L Stars And More Development Of Bart's File
MM0031 - 29/06/20 - Feedback From Bart And More Development
1 Lesson
Feedback From Bart And More Development
MM0030 - 22/06/20 - Starting An Excel VBA Project With Bart!
1 Lesson
Starting An Excel VBA Project With Bart!
MM0029 - 15/06/20 - Create A Work Schedule With Excel VBA 4
1 Lesson
Create A Work Schedule With Excel VBA 4
MM0028 - 08/06/20 - Create A Work Schedule With Excel VBA 3
1 Lesson
Create A Work Schedule With Excel VBA 3
MM0027 - 01/06/20 - The Power Of Excel INDIRECT 2
1 Lesson
The Power Of Excel INDIRECT 2
MM0026 - 25/05/20 - The Power Of Excel INDIRECT 1
1 Lesson
The Power Of Excel INDIRECT 1
MM0025 - 18/05/20 - 10 Ways My Excel VBA Has Improved In The Last 10 Years
1 Lesson
10 Ways My Excel VBA Has Improved In The Last 10 Years
MM0024 - 11/05/20 - Automating Work Scheduling With Excel 2
1 Lesson
Automating Work Scheduling With Excel 2
MM0023 - 04/05/20 - Automating Work Scheduling With Excel
1 Lesson
Automating Work Scheduling With Excel
MM0022 - 27/04/20 - Speed Up A Typical Excel Task With Excel VBA
1 Lesson
Speed Up A Typical Excel Task With Excel VBA
MM0021 - 20/04/20 - How To Make Money Out Of Excel
1 Lesson
How To Make Money Out Of Excel
MM0020 - 13/04/20 - A Powerful Analysis Of Football Data With Excel VBA
1 Lesson
A Powerful Analysis Of Football Data With Excel VBA
MM0019 - 06/04/20 - Chris's Data Analysis Secret Weapons
1 Lesson
Chris's Data Analysis Secret Weapons
MM0018 - 30/03/20 - Creating Custom Lists In Excel VBA 2
1 Lesson
Creating Custom Lists In Excel VBA 2
MM0017 - 23/03/20 - Creating Custom Lists Using VBA
1 Lesson
Creating Custom Lists Using VBA
MM0016 - 16/03/20 - Trying Out New Excel Formulae
1 Lesson
Trying Out New Excel Formulae
MM0015 - 09/03/20 - Create A Custom Report With Excel VBA
1 Lesson
Create A Custom Report With Excel VBA
MM0014 - 02/03/20 - Automate Creation of Hyperlinks with Excel VBA 2
1 Lesson
Automate Creation of Hyperlinks with Excel VBA 2
MM0013 - 24/02/20 - Automate Hyperlinks With Excel VBA
1 Lesson
Automate Hyperlinks With Excel VBA
MM0012 - 17/02/20 - A Userform Combobox for Data Selection
1 Lesson
A Userform Combobox for Data Selection
MM0011 - 10/02/20 - Using Module Level Variables
1 Lesson
Using Module Level Variables
MM0010 - 03/02/20 - Two Examples of Application.WorksheetFunction
1 Lesson
Two Examples of Application.WorksheetFunction
MM0009 - 27/01/20 - Find The 'Last Row' In A Dataset Using Excel VBA
1 Lesson
Find The 'Last Row' In A Dataset Using Excel VBA
MM0008 - 20/01/20 - VBA To Move Input Data To A Database
1 Lesson
VBA To Move Input Data To A Database
MM0007 - 13/01/20 - Supporting Data Input in Excel
1 Lesson
Supporting Data Input in Excel
MM0006 - 06/01/20 - Planning Your Excel Project
1 Lesson
Planning Your Excel Project
MM0004 - 23/12/19 - Working With Multiple Files In VBA 2
1 Lesson
Working With Multiple Files in Excel VBA 2
MM0005 - 30/12/19 - Look Up Multiple Entries In Another File
1 Lesson
Look Up Multiple Entries In Another File
MM0003 - 16/12/19 - Working With Another File In VBA
1 Lesson
Working With Another File In VBA
MM0002 - 09/12/19 - Cool Workbook Event Macros
1 Lesson
Cool Workbook Event Macros
MM0001 - 02/12/19 - How To Create Dynamic Dropdown Menus
1 Lesson
How To Create Dynamic Dropdown Menus