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 Chart: Change Bar Colour Automatically
Automatically change the colour of the largest bar in a bar chart (No VBA)
Getting Started with Excel Formulas & Functions
YouTube live stream aimed at users who struggle with or who have never used formulas in Excel (or who want a refresher)
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!
Sort Slicer Months & Days Correctly
By default Slicers display month and day names in A-Z order. Learn how to display them as Jan, Feb etc