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

MM0131 - 23 Excel Keyboard Shortcuts For 2023!

1 Lesson