Please visit our YouTube channel for tutorial videos on Microsoft Access and Microsoft Excel and join the close to 1,000,000 people who have already watched them at Software-Matters YouTube
To play a video, click on the play symbol in the centre of the video window.
You can watch the videos on this page but if you would prefer to view a video full screen you can click through to Software-Matters YouTube. Or below each video there is a link that will take you to the video on YouTube. To watch a video full screen on YouTube click on the full screen symbol in the lower right corner of the video .
NB: You will need sound when you watch the video.
How to Create a Stock Management Database in MS Access
We'll walk you through creating a Microsoft Access Stock Control or Inventory Management Database.
Watch the HHow to Create a Stock Management Database video on YouTube: How to Create a Stock Management Database in MS Access
How to Create a Contact Management (CRM) Database in MS Access
We'll walk you through creating a Microsoft Access Contact Management Database.
Watch the How to Create a Contact Management (CRM) Database video on YouTube: How to Create a Contact Management (CRM) Database in MS Access
How to Create an Autokeys Closing Macro
We'll walk you through creating a custom hotkey for Microsoft Access 2010 using an autokeys macro. The macro we'll show you is designed to avoid a problem where incorrectly closing an object can save filters and sorts into their properties and alter their behaviour in the future.
Watch the Autokeys Closing Macro video on YouTube: Access - Autokeys Closing Macro
VLOOKUP and HLOOKUP can turn Excel from a spreadsheet into a database, allowing your sheets to retrieve information relevant to what you are entering from data tables. Watch the video to see how they work and some examples of where they can be very useful.
Watch the VLOOKUP video on YouTube: Excel - VLOOKUP
Download VLOOKUP example spreadsheet as used in the video.
When you want to do a conditional sum, that is a sum where you only add entries for which a certain criteria is true, you need to use the SUMIF function. Combined with its sister function SUMIFS, which lets you have many conditions, you can extract very specific information from a dataset of any size. In this video we'll give you a quick tutorial on how to use it and why it's worthy of the number 2 place in our top 5 best Excel features list.
Watch the SUMIF video on YouTube: Excel - SUMIF
Download SUMIF example spreadsheet as used in the video.
Tables and Filters
Excel makes managing big blocks of data easy through two key features: Tables and Filters. In this video we'll demonstrate how to set both up and show some examples of how to use them, hopefully convincing you that they deserve this number 3 spot on our top 5 list.
Watch the Tables and Filters video on YouTube: Excel - Tables and Filters
Download Tables and Filters example spreadsheet as used in the video.
Sparklines, a feature first added in Excel 2010 used for spotting and tracking trends in data without resorting to large / complicated charts.
Watch the Sparklines video on YouTube: Excel - Sparklines
Download Sparklines example spreadsheet as used in the video.
Left, Right, Mid and Trim
Left, Right, Mid and Trim are basic text manipulation functions for cutting up and re-serving text data.
Watch the Left, Right, Mid and Trim video on YouTube: Excel - Left, Right, Mid and Trim
Download Left Right Mid Trim example spreadsheet as used in the video.
Download Files as used in other Videos2 Way Lookup Example Spreadsheet
Creating Pie Charts Example Spreadsheet
Comparative Pie Charts Example Spreadsheet
Multiple Item Lookup Example Spreadsheet
Don't just take our word for it...
"I would like to say thanks to yourself and your team for all your hard work.
We are very happy with the quoting system; for the first time ever we are looking at a system in which we have confidence."
Steve Ringsell, CFN Packaging