Login
Tiger Solutions/Members Monday - Members Monday Video Library
Buy now

  • £500

Members Monday - Members Monday Video Library

Buy now

Contents

MM Content Navigators

Find the MM content navigators in this section.  

You can use these files to find the Excel topics, techniques and training sessions that you need.  You can also simply browse the library of MM sessions, and even generate your own training plan about a particular topic.

Each volume contains summaries of 52 MM streams - in other words, one year of content.  Volume 1 covers December 2019 - December 2020, for example.

Any questions?  Just ask Chris in the live sessions, or put a query on the Facebook page.

Enjoy the 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)

Members' Monday #100 - Two-Hour Excel VBA Absolute Beginner Course (Part 3_2)

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?

A line chart is another great visualisation option but can be mis-used.  Let's learn some dos and don'ts in this session.

Topics




All About Line Charts

MM0071 - The Perfect Excel Bar Chart?

A bar (or column) chart is one of Excel's most popular chart options - but what should you bear in mind when creating a bar chart? Let's find out in this stream ...

Topics


The Perfect Excel Bar Chart

MM0070 - All About Pie Charts

The humble pie chart is somewhat underrated and misunderstood in Excel usage.  Let's change that today by creating the perfect pie chart …

Topics


All About Pie Charts

MM0069 - More Data Input Tips And Tricks

Data input - it's the most basic of Excel tasks, so why don't people focus on it more?  In this stream, we look at some cool ways to do data input properly in Excel.

Topics


More Data Input Tips And Tricks

MM0068 - Data Input Tips And Tricks

Data input - it's the most basic of Excel tasks, so why don't people focus on it more?  In this stream, we look at some cool ways to do data input properly in Excel.

Topics


Data Input Tips And Tricks

MM0067 - Creating An Invoice Generator

Creating and sending invoices is a common task for any contractor or small business owner.  How can we make it easy with Excel, and do we need Excel VBA?  Let's find out …

Topics


Copy , Rename And Delete Sheets With Excel VBA 2

MM0066 - Copy, Rename And Delete Sheets With Excel VBA

Creating new sheets, naming them and deleting them is something people are doing in Excel all the time - how can we automate this time-consuming task with Excel VBA?  Let's go through the basics in this stream.

Topics



"Printing? What About The Trees?"

Copy, Rename And Delete Sheets With Excel VBA

MM0065 - Building An Excel VBA Application For The World's Toughest Client ;-)

We're in at the deep end this week!  Can you handle and Excel VBA development project for the world's toughest client?  Get the briefing and get started in this session, then it's over to you for the implementation …

Topics


Building An Excel VBA Application For The World's Toughest Client

MM0064 - Two Way Lookups In Excel With XLOOKUP

The XLOOKUP formula is a relatively new addition to Excel.  Is it worth the hype?  Let's find out in this session.

Topics

Two Way Lookups In Excel With XLOOKUP

MM0063 - 5 Steps To A Successful Excel Project

We all love formulae, code and all the other good stuff that comes with Excel.  But, whether your project is successful or not has little to do with the technical stuff!  In this stream, we look at 5 things you should consider in the planning stage to make your Excel project a success.

Topics


5 Steps To A Successful Excel Project

MM0062 - How To Analyse Times And Dates In Excel

Working with dates and times in Excel can be a nightmare!  But, things can get a lot easier when you understand how Excel expresses time and learn some basic formulae for working with time and dates.  In this stream, we undertake a real-world task involving analysis of shift lengths, and aim to produce a helpful visualisation for our 'customer'.  We almost get there!

Topics


How To Analyse Times And Dates In Excel

MM0061 - VBA-Based Optimisation In Excel

We've looked at some of the 'built-in' options that Excel offers for optimisation in the past few weeks.  Nothing beats the power and flexibility of VBA, however.  Let's feel that power just a bit in this session …

Topics

Advanced Optimisation With Excel VBA

MM0060 - 25/01/21 - Excel Optimisation Basics

If you are working with a 'model' that consists of input, process and output, optimisation is something you might be interested in, and Excel is great at it!  Let's explore the basics in this stream.

Topics

Excel Optimisation Basics

MM0059 - 18/01/21 - 5 Excel Data Management Principles

VBA, Formulae, Pivot Tables … there is so much to think about in Excel!  But, things get a lot easier if overall data structure is logical and understandable.  Let's look at 5 Excel data management principles.

Topics

5 Excel Data Management Principles

MM0058 - 11/01/21 - Workbook Event Macros: Pros And Cons

Did you know you can trigger macros using what are called workbook 'events'?  Sounds interesting, right?  But, there can be unwanted side effects that might confuse and / or infuriate you or your customer!  So in this session, let's understand the pros and cons of workbook event macros.

Topics





Workbook Event Macros Pros And Cons

MM0057 - 04/01/21 - The Power Of Loops In Excel VBA 3

In the third of three sessions on loops we explore the potential (and the risks!) of Do Until loops in Excel VBA.

Topics


The Power Of Loops In Excel VBA 3

MM0056 - 28/12/20 - The Power Of Loops In Excel VBA 2

In this session, we continue our exploration of loops in Excel VBA.  We look at the unique options For / Next loops offers us and try some simple examples.

Topics

The Power Of Loops In Excel VBA 2

MM0055 - 21/12/20 - The Power Of Loops In Excel VBA 1

Is a loop the most powerful concept in computer programming?  We think so!  So, understanding the different loop options in Excel VBA is a great way to boost your coding skills.  Let's look at the options and some easy examples to get you thinking about what might be possible ...

Topics


The Power Of Loops In Excel VBA 1

MM0054 - 14/12/20 - Excel VBA Christmas Carol Challenge 2

It's coming up to Christmas and that can only mean one thing - customised Excel VBA solutions!  In this fun stream, we try to create a Christmas carol display tool for a local vicar.  Can you implement the tool yourself, and can you do it in time for the Christmas carol service?  The clock is ticking!

All download files can be found here:
https://tinyurl.com/y63wlhfa

Topics


Building A Custom Excel VBA Tool For Christmas 2

MM0053 - 07/12/20 - Excel VBA Christmas Carol Challenge 1

Welcome back to Members Monday!

All download files can be found here:
https://tinyurl.com/y63wlhfa

It's coming up to Christmas and that can only mean one thing - customised Excel VBA solutions!  In this fun stream, we try to create a Christmas carol display tool for a local vicar.  Can you implement the tool yourself, and can you do it in time for the Christmas carol service?  The clock is ticking!

Though the application is fun, we apply a number of essential Excel VBA techniques in the implementation.  Make sure you follow along and build it yourself ...

Topics

Excel VBA Christmas Carol Challenge 1

MM0052 - 30/11/20 - Catching Up With Craig And The New Website

In this non-technical stream, we catch up with new MM member Craig and look at how to transfer membership from YouTube to the new website

Topics

Catching Up With Craig And The New Website

MM0051 - 23/11/20 - Separate Text Into Cells With Excel Formulae And VBA

Being able to work with text in Excel is an essential skill.  In this stream, we use Excel formulae to separate a sentence into words in cells.
*APOLOGIES FOR INITIAL AUDIO - IMPROVES AFTER 12 MINUTES*

Topics

Separate Text Into Separate Cells With Excel Formulae And VBA.mp4

MM0050 - 16/11/20 - How To Understand A Complicated Excel File

How many times have you been handed a 'legacy' Excel file consisting of multiple sheets, formulae and even VBA?  It's difficult! But, it happens a lot so we need an approach to help us understand what is going on.

Topics

How To Understand A Complicated Excel File

MM0049 - 09/11/20 - Using A Userform For Quick Data Input 2

Last week, we learned how to set up a userform and simple listbox.  This week, we explore how to implement more advanced functions such as selecting multiple entries in the listbox.

Topics 

Using A Userform For Quick Data Input 2

MM0048 - 02/11/20 - Using A Userform For Quick Data Input 1

Userforms offer a world a possibilities, and can be a complete nightmare to code!  In this stream, we explore how to implement a cool data input mechanism in a userform whilst working through the code steadily and systematically.

Topics 


Using A Userform For Quick Data Input 1

MM0047 - 26/10/20 - Introduction To The Normal Distribution In Excel

Ah, statistics!  A difficult topic no doubt.  In this stream we discuss the practical value of the normal distribution, and learn how to 'sample' it to get a job done.  Look out for some cool dancing charts, among other things …

Topics


Introduction To The Normal Distribution In Excel

MM0046 - 19/10/20 - Creating A Custom Probability Distribution

If you want to create a simulation model, or simply generate a random dataset for a training session, you'll need to create a custom probability distribution. Let's see how in this MM!

Topics

Creating A Custom Probability Distribution

MM0045 - 12/10/20 - Talking Through Andrew's Excel VBA Implementation For Nikki

Andrew did a great job of improving Nikki's file on the basis of MM44.  In this stream, he talks through the developments with Chris and Nikki.

Topics

Talking Through Andrew's Excel VBA Implementation For Nikki

MM0044 - 05/10/20 - Improving A Live Excel File With VBA

In this session, we focus on a real-life application of Excel sent in by Nikki.  We talk through the file and begin to implement some VBA to speed things up.

Topics

Improving A Live Excel File With VBA

MM0043 - 28/09/20 - Excel VBA Simulation For The Monty Hall Problem

The Monty Hall problem is a real mind-bender! With the help of an Excel simulation, we can prove the best course of action …

Topics

Excel VBA Simulation For The Monty Hall Problem

MM0042 - 21/09/20 - How To Build A Career Around Excel

In this special edition of MM, we talk to experienced Excel consultant and project manager Sohail Anwar about how to build a career around your Excel skills

Topics

How To Build A Career Around Excel

MM0040 - 07/09/20 - How To Copy In 'Filtered' Rows Only (1)

In the 4th stream on Tim's task, we begin to explore how to copy in 'filtered' data - data that conforms to a certain criteria such as 'the value in this column equals x'

Topics

How To Copy In 'Filtered' Rows Only (1)

MM0041 - 14/09/20 - How To Talk To Managers About Excel

We love the technical stuff in Excel!  But, without the right salesmanship at the right times, our projects cannot have impact.  How can we engage effectively with people who might commission Excel projects?

Topics

How To Talk To Managers About Excel

MM0039 - 31/08/20 - Import Data From Other Files With Excel VBA

In the third stream on Tim's task, we look at moving data from other open files into a 'master' file, at the click of a button

Topics

  •  | Formulae For Generating Random Data
  •  | ROW / COLUMN
  •  | Assumptions List - Example
  •  | Importance Of Noting Assumptions
  •  | Give Customer Control With Input
  •  | Pick Out The Bits You Know First
  •  | Where Is Tim?
  •  | Conceptualising A Task - Example
  •  | Establish The File Format (Eg. .xlsm)
  •  | Good Example Of Using Worksheet Input
  •  | Importance Of ThisWorkbook
  •  | Loop Through User Inputs In A Table
  •  | How To Build Powerful Code
Import Data From Other Files With Excel VBA

MM0038 - 24/08/20 - How To Reference Other Files In Excel VBA

In this stream, we continue with topics relevant to Tim's real-world task.  How can we reference other open files using Excel VBA?

Topics

  •  | Jazfin - Homework Review
  •  | Your Client Is Probably Wrong
  •  | Copy / Paste With A Single Line Of Code
  •  | Should You Include User Instructions?
  •  | Software For Screen Recording
  •  | Iain L - Homework Review
  •  | VBA Arrays - Pros And Cons
  •  | Tony H - Homework Review
  •  | General Thoughts On Taking Feedback
  •  | Charles Join Us Live! Charles' Project
  •  | How Charles Started Excel VBA
  •  | Function To Identify Files To Work With
  •  | Loop Through Open Workbooks
  •  | Promo Video For Members Monday!
How To Reference Other Files In Excel VBA

MM0037 - 17/08/20 - Deleting Columns Using Excel VBA

In this stream, we begin another member task for new member Tim.  Our first job is to delete certain columns from a worksheet using Excel VBA …

Topics

  •  | Iain L - Homework Review
  •  | Is A Different Way Better?
  •  | Importance Of Horizontal Borders
  •  | Conditional Statement Toolkit
  •  | Tony H - Homework Review
  •  | Combine FREQUENCY And INDIRECT
  •  | Shortcut To Unlock A Sheet
  •  | Fit The Interface On One Screen
  •  | Jazfin - Homework Review
  •  | White Text To Hide Entries?
  •  | Background To Tim's VBA Project
  •  | Would You Recommend Power Query?
  •  | The Portability Of Excel VBA
  •  | Setup For Controlling Column Deletion
  •  | ADDRESS
  •  | MID
  •  | Interview About Nikki's Project
Deleting Columns Using Excel VBA

MM0036 - 10/08/20 - Guided Blank Canvas Development 2

In this stream we build additional functions into last week's Excel VBA implementation, including a cool data analysis technique

Topics

  •  | Andrew B - Homework Review
  •  | Features Of Well-Organised Code
  •  | Module Level Variable Example
  •  | Tony H - Homework Review
  •  | Why You Should Use The Basic Stuff!
  •  | Thoughts On 'On Error Resume Next'
  •  | Discussion Of Use Of Icons
  •  | Advantage Of Copy Pasting Formatting
  •  | How To Count Data In 'Bins' In Excel
  •  | FREQUENCY - Full Explanation
  •  | FREQUENCY - How To Input
  •  | FREQUENCY - How To Test
  •  | SUM Formula Keyboard Shortcut
  •  | Chris's Easy Way To Create Charts
  •  | Discussion Of Data Capacity Issues
  •  | How To Achieve FREQUENCY In VBA
Guided Blank Canvas Development 2

MM0035 - 03/08/20 - Guided Blank Canvas Development

In this stream, we take a recent briefing from Chris's work and look at how to implement a solution with Excel VBA

Topics

  •  | Sample Client Briefing
  •  | Simple Excel VBA Project Example
  •  | Format Cell For Time
  •  | NOW To Show Current Time
  •  | Named Range - 'Shorthand' Way
  •  | NOW Function in VBA
  •  | FORMAT Function In VBA
  •  | Chris' Preferred Table Formatting
  •  | AND
  •  | COUNTA
  •  | IF - ELSE - END IF
  •  | Live With Bart! Bart's VBA Projects
  •  | The No.1 Thing Bart Has Learned
Guided Blank Canvas Development

MM0034 - 20/07/20 - Homework Reviews And Quick Walkthrough Of Tiger's Tombola

In this stream, we look through member files created in response to the MM33 briefing.  We also look at how to combine random numbers, VLOOKUP and a probability table to create a simulation in Excel.

Topics

  •  | Welcome To Nikki
  •  | Content Navigator Walkthrough
  •  | Andrew B - Homework Review
  •  | Run A Macro When Workbook Opens
  •  | Different Symbols On Message Boxes
  •  | Discussion: Functions vs. Subs
  •  | Loop Through Files In A Folder
  •  | Iain L - Homework Review
  •  | Iain L's Cool Formatting Style
  •  | Manipulate The Status Bar
  •  | Live With Bart! Bart's VBA Projects
  •  | Walkthrough Of Tiger's Tombola!
  •  | Formula Setup For Excel Simulation
Homework Reviews And Quick Walkthrough Of Tiger's Tombola

MM0033 - 13/07/20 - First Meeting About Zahra's Project

Recorded conversation between Chris and Zahra about this typical Excel VBA development project

Topics

  •  | Background To Zahra's Project
  •  | How To Discuss A File With A Client
  •  | Get It Working ONCE
  •  | How To Create A Structural Diagram
  •  | Pseudo Code For Real World Project
  •  | Module Level Variable - Concept
  •  | Process For Validating File Setup
  •  | The Problem With Just Talking
First Meeting About Zahra's Project

MM0032 - 06/07/20 - Iain L Stars And More Development Of Bart's File

Iain dials into the stream to tell us about his Excel VBA learning journey

Topics

  •  | Interview With Iain L
  •  | How Iain L Started VBA
  •  | Accessibility Of Excel VBA
  •  | How Iain L Learned Excel VBA
  •  | People Don't Know What They Don't Know
  •  | Iain L - Homework Review
  •  | Discussion Of Optimisation Approaches
  •  | Building The 'Demand' Side Of Optimisation
  •  | VLOOKUP
  •  | IF To Avoid #N/A Errors
  •  | Formula To Pull Value From Other Sheet
  •  | A Typical Excel VBA Project?
Iain L Stars And More Development Of Bart's File

MM0031 - 29/06/20 - Feedback From Bart And More Development

Bart joins the stream to give feedback on Member developments in the shift scheduling project

Topics

  •  | Underrated Skills In Excel Development
  •  | Iain L - Homework Review
  •  | Why You Need To Plan
  •  | Show Your Client You Understand!
  •  | Paul T - Homework Review
  •  | Jazfin - Homework Review
  •  | The Concept Car!
  •  | Building A Proof Of Concept
  •  | IF
  •  | What Are Heuristics?
  •  | How To Manage An Optimisation
  •  | Pseudo Code For Optimisation Macro
  •  | Generate A Random Number In VBA
  •  | Should You Use 'GoTo'?
  •  | Bring The Client With You
Feedback From Bart And More Development

MM0030 - 22/06/20 - Starting An Excel VBA Project With Bart!

Let's go right back to the start with the shift scheduling task - how would we structure the file if we could start again?  Bart dials into the stream live!

Topics

  •  | Iain L - Homework Review
  •  | Checkbox In Worksheet Example
  •  | Link A Checkbox To A Cell
  •  | How To Get To Professional Level
  •  | How To Name An Excel Consultancy
  •  | What You Want From The First Meeting
  •  | Make It Iterative!
  •  | A 'Client' Describes The Situation
  •  | Roleplay - First Client Meeting
  •  | The Right Meeting Dynamic
  •  | Visually Communicate File Structure
  •  | Consultancy Is The Glory Job
  •  | Managing Complexity
Starting An Excel VBA Project With Bart!

MM0029 - 15/06/20 - Create A Work Schedule With Excel VBA 4

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

  •  | Iain L - Homework Review
  •  | Dynamic Chart Using INDIRECT
  •  | Dynamic Message Box Example
  •  | Role Of Message Boxes In VBA
  •  | Importance Of Indentation
  •  | 3 Ways Of Referencing Sheets
  •  | Empathetic Programming?
  •  | Does Your File Need A Re-Structure?
  •  | Role Of Constructive Challenge
Create A Work Schedule With Excel VBA 4

MM0028 - 08/06/20 - Create A Work Schedule With Excel VBA 3

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

 | Iain L - Homework Review
 | Spacer Column / Row Example
 | How To Link Checkbox To Cell
 | How To Improve Code Execution Time
 | How To Stop Code Execution
 | Firming Up Requirements With A Client
 | Copy A Sheet To Another File
 | How To Plan A Complex VBA Task
 | The Question To Ask Before You Start
 | Thoughts On Interacting With Clients
 | Examples Of Project Assumptions
 | Talk About The Limitations Of VBA
 | Constructive Challenge With Client
Create A Work Schedule With Excel VBA 3

MM0027 - 01/06/20 - The Power Of Excel INDIRECT 2

INDIRECT is an Excel formula with special powers; in this livestream, I show you how I have been harnessing INDIRECT to create cool dynamic functions in Excel files

Topics

  •  | INDIRECT - Dynamic Explanation
  •  | Dropdown Menu Setup
  •  | Discussion: INDIRECT vs. Pivot Tables
  •  | Insert A Chart
  •  | Delete A Series From A Chart
  •  | Dynamic Chart Using INDIRECT
  •  | Create A Named Range
  •  | Check A Dynamic Named Range
  •  | Dynamically Define A Data Range
  •  | MATCH
  •  | COUNTIF
  •  | & To Create A Text String
The Power Of Excel INDIRECT 2

MM0026 - 25/05/20 - The Power Of Excel INDIRECT 1

INDIRECT is an Excel formula with special powers; in this livestream, I show you how I have been harnessing INDIRECT to create cool dynamic functions in Excel files

Topics

  •  | INDIRECT - Concept
  •  | RANDBETWEEN
  •  | Create A Dropdown Menu
  •  | INDIRECT - Worksheet Setup
  •  | INDIRECT - Formula Setup
  •  | INDIRECT For Dynamic Sum
  •  | Chris's Favourite Windows Shortcut
  •  | SUBSTITUTE
  •  | OFFSET - Drawbacks
  •  | Best Screen Recorder
  •  | Dynamic Dropdown Using INDIRECT
  •  | COUNTA
The Power Of Excel INDIRECT 1

MM0025 - 18/05/20 - 10 Ways My Excel VBA Has Improved In The Last 10 Years

Looking back at your old work can be a great way to understand how you have got better - and how you can get even better from now!  In this stream, Chris reviews a file from 10 years ago and identifies 10 key improvements in his VBA coding.

Topics

  •  | Iain L - Homework Review
  •  | Common Mistake with Range(Range,Range)
  •  | VBA To Create Dropdown List
  •  | When To Use Copy / Paste Code
  •  | Jazfin
  •  | The One Mistake You Should Never Make
  •  | How To Use With … End With
  •  | Remote vs. Direct Referencing Example
  •  | Make Excel Not Look Like Excel
  •  | Should You Protect Your File?
  •  | How To Organise VBA Modules
  •  | The Leanest Way To Move Data
  •  | Should You Be Using Userforms?
10 Ways My Excel VBA Has Improved In The Last 10 Years

MM0024 - 11/05/20 - Automating Work Scheduling With Excel 2

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

  •  | Iain L - Homework Review
  •  | How To Access Formulae In VBA
  •  | Use Of Underscore In VBA
  •  | Discussion: VBA vs. Formulae
  •  | Role Of Constructive Challenge
  •  | Problem With Events To Trigger VBA
  •  | Macro Recorder Example
  •  | PasteSpecial Method Of Range Class
  •  | Example Of Full VBA Debug
  •  | Test In A Safe Space
Automating Work Scheduling With Excel 2

MM0023 - 04/05/20 - Automating Work Scheduling With Excel

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

  •  | Chris' Extreme Haircut
  •  | Jazfin - Homework Review
  •  | Iain L - Homework Review
  •  | Briefing For VBA Task
  •  | How To Do A Screen Recording
  •  | Create A Safe Space For Practice
  •  | TODAY
  •  | Get All Dates In A Year
  •  | TEXT
  •  | WEEKDAY
  •  | List All The Sundays In A Year
  •  | MOD
  •  | VALUE
  •  | RIGHT
  •  | Full vs. Partial Absolute Referencing
  •  | IF
  •  | Conditional Formatting Example
Automating Work Scheduling With Excel

MM0022 - 27/04/20 - Speed Up A Typical Excel Task With Excel VBA

Scheduling shifts is a great example of a task that could take some time, but could be automated with Excel VBA - let's give it a try!

Topics

  •  | Conceptualise A VBA Task
  •  | Create A Report Template Using VBA
  •  | Integer Variable Example
  •  | With … End With Example
  •  | For / Next Loop Example
  •  | Control A Loop With A Variable
  •  | Always List Assumptions
  •  | Range(Range,Range) Example
  •  | Breakpoint Example
  •  | COUNTA
  •  | Convey Extent of Ranges
  •  | Use The Macro Recorder
  •  | Code To Transpose Data
  •  | Combine Offset With Variable
  •  | Breakpoint Example
  •  | The Likely Source Of An Error
Speed Up A Typical Excel Task With Excel VBA

MM0021 - 20/04/20 - How To Make Money Out Of Excel

In this stream, Chris shares 7 tips for exploiting your Excel skill to create additional income; it should be relevant to anybody looking to 'freelance' as an Excel develop or other consultant

Topics

  •  | Iain L - Homework Review
  •  | How To Understand Things In MM
  •  | Tip For Understand Complicated VBA
  •  | Iain R - Homework Review
  •  | Make Money From Excel - 7 Topics
  •  | What Excel Do I Need To Know?
  •  | Excel Specialisation Options
  •  | What Is Excel Problem Structuring?
  •  | How To Market My Excel Skills?
  •  | How To Manage A Client Meeting?
  •  | How To Manage An Excel Project?
  •  | How To Grow An Excel Business?
  •  | Business Book Recommendation
  •  | Hobbyist - Part Time - Full Time
  •  | Who Should You Not Work With?
  •  | Can You Be Too Old?
How To Make Money Out Of Excel

MM0020 - 13/04/20 - A Powerful Analysis Of Football Data With Excel VBA

Let's apply Excel VBA to create a powerful 'click-of-a-button' analysis for football betting data

Topics

  •  | The Builder With No Plans!
  •  | Planning A VBA Routine
  •  | Coding Multiple Embedded Loops
  •  | How To Test Loops
  •  | New Line In A Msgbox
  •  | Subscript Out Of Range
  •  | VBA Is (Just) Another Language
  •  | Multiple Conditions Statement
  •  | Why Use With … End With?
  •  | Double Variable Example
  •  | A = A + 1
  •  | Punch The Air Moment
  •  | The Power Of VBA
  •  | Pros And Cons Of VBA
A Powerful Analysis Of Football Data With Excel VBA

MM0019 - 06/04/20 - Chris's Data Analysis Secret Weapons

There is no doubt, VBA is great!  But, Excel has a number of excellent data analysis tools that few people use, and avoid the need to deploy VBA at all.  Chris calls them his secret weapons.  Let's check out a few in this stream.

Topics

  •  | Quickly Delete Columns
  •  | Discussion: VBA vs. Formulae
  •  | Formula To Calculate Bet Returns
  •  | IF
  •  | Name A Range - Shorthand
  •  | SUMIF
  •  | SUMIFS
  •  | COUNTIFS
  •  | DSUM
  •  | Workbook Structure For Data Analysis
  •  | Data Table Example
  •  | Testing A Data Table
  •  | Discussion: VBA vs. Worksheet Techniques
  •  | Dealing With Additional Data Rows
  •  | Typical VBA Learning Journey
Chris's Data Analysis Secret Weapons

MM0018 - 30/03/20 - Creating Custom Lists In Excel VBA 2

In this stream, we complete the task we started in MM17: how to manipulate data into a layout that supports dynamic dropdown menus

Topics

  •  | MM Content Navigator Walkthrough
  •  | Iain - Homework Review
  •  | Sort Code - Concise
  •  | Jazfin - Homework Review
  •  | Module-Level Variable Example
  •  | Interaction Between Routines
  •  | Good Practice Naming Variables
  •  | For Next Loop Example
  •  | Named Range - Naming Convention
  •  | Range(Range,Range) Example
  •  | Write Down Assumptions
  •  | Call Another Routine
  •  | Module-Level Variable Example
  •  | Application.WorksheetFunction.COUNTIF
Creating Custom Lists In Excel VBA 2

MM0017 - 23/03/20 - Creating Custom Lists Using VBA

Dynamic dropdown menus are just cool!  In this stream, we begin to explore a dropdown menu that is dependent on an entry from a previous dropdown menu.

Topics

  •  | Darko - Homework Review
  •  | Discussion: Use of .Select
  •  | Iain - Homework Review
  •  | VBA To Scroll To Top Of Sheet
  •  | IF - Simple IF Statement
  •  | Jazfin - Homework Review
  •  | Typical VBA Task - Description
  •  | Recycling An Existing Macro
Creating Custom Lists Using VBA

MM0016 - 16/03/20 - Trying Out New Excel Formulae

Let's look at some of the new Excel 'array' formulae and consider their pros and cons compared to Excel VBA

Topics

  •  | Bart - Homework Review
  •  | 1004 - Application-defined Error
  •  | Variables - Error Caused By Wrong Type
  •  | Breakpoint Example
  •  | Jazfin - Homework Review
  •  | Discussion Of Direct Vs. Remote Referencing
  •  | IF Statement - IF - END IF
  •  | Discussion Of Array Formulae New In 2020
  •  | Remove Duplicates From Dataset
  •  | UNIQUE
  •  | SORT
  •  | Macro To List Unique Values
  •  | Application.WorksheetFunction.COUNTIF
  •  | Discussion: VBA Vs. UNIQUE Formula
Trying Out New Excel Formulae

MM0015 - 09/03/20 - Create A Custom Report With Excel VBA

How can we use Excel VBA to create a cool custom report for the user and help them extract exactly what they need from a dataset?

Topics

  •  | Bart - Homework Review
  •  | FORMAT
  •  | Get Unique Values
  •  | Role Of Engine And Lists Sheets
  •  | Named Range Example
  •  | With … End With
  •  | Range(Range,Range) Example
  •  | For Each Loop
  •  | Discussion Of Interaction Between Routines
  •  | Variables - String Variable Example

Create A Custom Report With Excel VBA

MM0014 - 02/03/20 - Automate Creation of Hyperlinks with Excel VBA 2

Learn how to integrate hundreds of hyperlinks into an Excel VBA application at the click of a button. Let's use loops and position control to scale up last week's code to create a powerful and flexible solution to this real-world problem.

Topics

  •  | Jazfin - Homework Review
  •  | Bart - Homework Review
  •  | Overflow Error
  •  | Named Range Example
  •  | Long Variable Example
  •  | Discussion: Integer Vs. Long Variables
  •  | .Cells
  •  | .End(xlup)
  •  | Assumptions Example
  •  | .Count
  •  | For Each Loop
  •  | LEFT
  •  | Range(Range,Range) Example
  •  | .Address
  •  | If Statement - IF - END IF
Automate Creation of Hyperlinks with Excel VBA 2

MM0013 - 24/02/20 - Automate Hyperlinks With Excel VBA

In this stream, we use Excel VBA to automate the creation of hyperlinks for the Members' Monday techniques file.  This is a good example of using Excel VBA in a practical way to solve a business problem.

Topics

  •  | Bart - Homework Review
  •  | Jazfin - Homework Review
  •  | HYPERLINK
  •  | Discussion: Pros And Cons vs. Formulae
  •  | What To Do When You Don't Know The Code
  •  | Do I Need A Textbook?
  •  | How To Use The Macro Recorder
  •  | Insert A Hyperlink
  •  | Keep The Stress Levels Down
  •  | Example of VBA And Formulae Working Together
  •  | SECOND
  •  | MINUTE
  •  | HOUR
  •  | Concatenation Using &
  •  | Importance of Assumptions
  •  | Use Video On Excel VBA Projects
Automate Hyperlinks With Excel VBA

MM0012 - 17/02/20 - A Userform Combobox for Data Selection

A combobox is like a dropdown menu for a userform; but, how to populate it? Let's look at two possibly approaches, and let's do it dynamically!

Topics

  •  | Jazfin - Homework Review
  •  | Description Of Typical Userform Job In Excel
  •  | How To Create A Userform
  •  | Insert A Label
  •  | How To Display A Userform In Excel
  •  | How To Insert A Combobox
  •  | Example Of Userform Display Issue
  •  | Make Values Appear In A Combobox
  •  | Problems Configuring Rowsource Property
  •  | Use .AddItem To Configure Combobox
  •  | For Each Loop Example
  •  | Call Another Routine
A Userform Combobox for Data Selection

MM0011 - 10/02/20 - Using Module Level Variables

Module level variables allow us to pass information between macros - they could take your Excel VBA coding to the next level

Topics

  •  | Bart - Homework Review
  •  | Dynamic Referencing
  •  | COLUMN
  •  | Conceptual Understanding Comes First
  •  | Discussion: Pros and Cons
  •  | .Cells Referencing Technique
  •  | Range(Range,Range)
  •  | Conceptual Understanding Comes First
  •  | With … End With
  •  | Variables - Module Level - Concept
  •  | Range(Range,Range)
  •  | Dynamic Referencing with .end
  •  | Variables - Module Level - Creation
  •  | IF Statement - IF - ELSE - END IF
  •  | Variables - General Discussion
Using Module Level Variables

MM0010 - 03/02/20 - Two Examples of Application.WorksheetFunction

This powerful VBA technique allows you to access worksheet formulae from the VBA editor.  Let's understand its unique power by working through an example related to our current project.

Topics

  •  | Dawid - Homework Review
  •  | Bart - Homework Review
  •  | Discussion Of Module Names
  •  | .end(xldown)
  •  | Sources Of Code
  •  | Nigel - Homework Review
  •  | Importance Of Metacognition
  •  | MATCH
  •  | Subscript Out Of Range Error
  •  | Application.WorksheetFunction.Match
  •  | Application.WorksheetFunction Explanation
  •  | Application.WorksheetFunction Advantages
  •  | COUNTIF
  •  | Application.WorksheetFunction.Countif
  •  | Unable To Get The Match Property Error
Two Examples of Application.WorksheetFunction

MM0009 - 27/01/20 - Find The 'Last Row' In A Dataset Using Excel VBA

VBA is great - but routines that do not cater for additional (or fewer) rows of data are not useful for long.  Let's look at how to build in a crucial piece of dynamic quality by finding the 'last row', regardless of the size of the dataset.

Topics

  •  | Bart - Homework Review
  •  | Overflow Error
  •  | Named Range Example
  •  | IF Statement - IF - ELSE - END IF
  •  | .Offset
  •  | Discusion Of Advantages Of Named Ranges
  •  | .Row
  •  | Type Mismatch Error
  •  | .end(xldown)
  •  | Subscript Out Of Range Error
  •  | Enjoy The Power!
  •  | Learning Is Not Linear
Find The 'Last Row' In A Dataset Using Excel VBA

MM0008 - 20/01/20 - VBA To Move Input Data To A Database

This is a common task in Excel VBA - transferring data from a 'form' (a userform or a sheet in the file) to a database.  Chris demonstrates the cool technique he uses on real-world projects.

Topics

  •  | Basic Setup For Moving Data Around
  •  | Basic Setup For Moving Data Around
  •  | Transpose Data
  •  | Importance Of Consistent Layout Across Sheets
  •  | Make Things Clear … For Yourself!
  •  | ROW
  •  | COLUMN
  •  | Discussion Of .Cells vs. Offset Pros And Cons
  •  | Range(Range,Range)
  •  | .end(xldown)
  •  | Why We Love Dynamic Solutions
  •  | For Each Loop Example
  •  | .Address
  •  | .Cells
  •  | Discussion Of Direct vs. Remote Coding 
  •  | .Offset
VBA To Move Input Data To A Database

MM0007 - 13/01/20 - Supporting Data Input in Excel

Something people are doing in Excel all the time?  Inputting data!  Let's look at some cool techniques for making the user experience as smooth as possible, including some cool VBA.

Topics

  •  | What Is Data Validation?
  •  | Create A Dropdown Menu
  •  | Format Dropdown Menus
  •  | Create An Input Message
  •  | How To Support The User
  •  | Create A Custom Input Error Alert
  •  | Cell-based Input Guidance
  •  | Cell Indentation For A Classy Look
  •  | IF
  •  | Avoid Hard Coding In Formulae
  •  | Named Range Naming Conventions
  •  | Conditional Formatting Rules Manager
  •  | Create A Conditional Formatting Rule
  •  | Cell And Sheet Protection
  •  | Validate Cell Inputs Using VBA
  •  | ADDRESS
  •  | ROW
Supporting Data Input in Excel

MM0006 - 06/01/20 - Planning Your Excel Project

In this stream, we explore five things to think about at the beginning of an Excel project.  I apply these things to a member file, live, to show you my thought process.  Hopefully it will save you time, frustration, and allow you to build more powerful Excel applications.

Topics

  •  | Why You Need To Plan Your Excel Project
  •  | Define The Purpose Of An Excel Application
  •  | The Different Types Of Excel Application
  •  | Discussion Of Different Data Input Approaches
  •  | Different Sheet Roles In Excel
  •  | How To Create A Structural Diagram
  •  | Discussion Of Pros And Cons Of VBA
  •  | Should You Use Excel For This Project?
  •  | Do I Need a Welcome Sheet?
  •  | Spreadsheet Real Estate!
  •  | Formatting For Data Input
  •  | Assumptions About User Excel Level
  •  | Quickly Format A Worksheet
  •  | Use Of Spacer Rows
  •  | Worksheet Setup For Custom Navigation System
  •  | How To Establish Data Quality
Planning Your Excel Project

MM0004 - 23/12/19 - Working With Multiple Files In VBA 2

In this stream, we combine together multiple techniques to dynamically define a data range in another file, which should means our macros will work for some time to come.  The approach is very closely based on what Chris uses in real-world projects - enjoy!

Topics

  •  | Description Of A Typical Task
  •  | Discussion: Any Approach Has Pros And Cons
  •  | Range(Range,Range) - Concept
  •  | .End(xldown)
  •  | .Row Property
  •  | .End(xldown) - Weakness And Alternative
  •  | .End(xlup)
  •  | .Rows.Count
  •  | Find And Replace
  •  | LEFT
Working With Multiple Files in Excel VBA 2

MM0005 - 30/12/19 - Look Up Multiple Entries In Another File

In this stream, we apply advanced coding techniques to create a powerful routine to collate data from another file according to a set of conditions.  Welcome to professional-level VBA coding!

Topics

  •  | Multiple VBA Routines vs. Single Long Routine
  •  | Switch Off But Retain Code By 'Commenting Out'
  •  | Variables - Range Variable
  •  | For Each Loop To Loop Through Cells
  •  | IF Statement - Single Line
  •  | COUNTIF
  •  | Named Range - Shorthand
  •  | Insert Breakpoint To Test Code
  •  | .Offset
  •  | Variables - Integer Variable
  •  | x = x + 1
  •  | .Offset And Variable For Position Control
  •  | Feel The Power!
Look Up Multiple Entries In Another File

MM0003 - 16/12/19 - Working With Another File In VBA

Perhaps you've created some macros that do cool stuff within a file.  But, many time-consuming tasks in Excel involve multiple files, and opening / closing them repeatedly causes frustration.  Let's explore how to do it at the 'click of a button' using Excel VBA

Topics

  •  | VBA To Open Another File
  •  | Variables - String Variable Example
  •  | Work With Multiple Files - File Setup
  •  | Workbook.Path Property
  •  | Discussion: Dataset Size Management
  •  | With … End With
  •  | .End(xldown)
  •  | Application.WorksheetFunction.COUNTIF
  •  | COUNTIF
  •  | How To Do Testing
  •  | Application.WorksheetFunction.MATCH
  •  | MATCH
  •  | Inserting Symbols
  •  | Message Box - Dynamic
  •  | VBA Can Change Your Life!
  •  | IF Statement - IF - ELSE - END IF
Working With Another File In VBA

MM0002 - 09/12/19 - Cool Workbook Event Macros

You probably know how to trigger a macro using a button.  Did you know that's just one of many ways to trigger a macro.  Excel 'events' - such as opening a file, changing sheets or editing a cell offer us opportunities to trigger macros that create value for the user.  Warning: appreciate the pros AND cons and handle with care!

Topics

  •  | Worbook Event Macros - Concept
  •  | Worbook Event Macros - Warning
  •  | Worbook Event Macros - Set Up In VBA Editor
  •  | Worbook Event Macros - Worksheet Change
  •  | Worbook Event Macros - Target A Cell
  •  | IF Statement - Single Line
  •  | Message Box - Simple
  •  | IF Statement - IF - ELSE - END IF
  •  | Worbook Event Macros - Complete Example
  •  | Use The Right Tools
  •  | Worbook Event Macros - Worksheet Activate
  •  | VBA To Scroll To Top Left

Cool Workbook Event Macros

MM0001 - 02/12/19 - How To Create Dynamic Dropdown Menus

Excel Dropdown menus are cool - but how to maintain them properly?  In this stream, we show how to create 'dynamic' dropdown menus that update when you add new entries to the list.  So, no more dropdowns with a list of empty spaces at the bottom!

Download the files here.

Topics
  •  | Dynamic Dropdown Menus - Setup
  •  | RIGHT
  •  | Basic Dropdown Menu
  •  | Time Formatting
  •  | Dynamic Dropdown Menus - Concept
  •  | Dynamic Dropdown Menus With OFFSET
  •  | Named Range Naming Conventions
  •  | MATCH
  •  | COUNTA
  •  | IF
  •  | OFFSET
  •  | Write Down Assumptions
  •  | TEXT
How To Create Dynamic Dropdown Menus