Welcome From Mike
Are you looking to learn more about Excel or Power BI? Are you trying to solve a specific problem? Google “Excel Help” and you’ll get back almost 4 billion results! Hopefully you’ll find what you are looking for here. If not, please feel free to browse the tutorials anyway. You never know what you might find!
I’m Mike Thomas. a UK-based IT Trainer with over 30 years experience and my passion is for all-things-Excel-related although I must admit that Power BI is coming a close second!
Through my training courses, Youtube videos, written tutorials and application development skills, I hope that I can help to make a difference to you and your business.
Below you’ll find my latest tutorials. For older ones, please click the Tutorials link on the menu
Latest Videos and Tutorials
Excel – Use UNIQUE to Remove Duplicates
Learn how to master the UNIQUE function in Excel! Remove duplicates the easy way
Getting Started with Excel Formulas & Functions
Recording of a YouTube live stream covering creating basic formulas and functions in Excel
Excel Chart: Change Bar Colour Automatically
Automatically change the colour of the largest bar in a bar chart (No VBA)
Getting Started with DAX in Excel
A recording of a YouTube live streamed training session aimed at users who are new to the DAX formula language
Excel Charts: Create an Effective Title and Subtitle
Don’t underestimate the importance of a meaningful title and subtitle for your Excel chart.
Getting Started with Power Pivot in Excel
A recording of a training session delivered live on YouTube in June 2022 aimed at users who are new to Power Pivot.
What’s a Waffle Chart and How to Create One
Impress your Audience! With a few simple steps you can create a cool and easy-to-understand visual
Calculate Age From Date of Birth in Excel
Learn how to calculate age from the date of birth using the hidden DATEDIF function
Excel Pivot Tables for Beginners
If you’re a Pivot Table Newbie or just need to brush up on your skills this is the training for you!