Welcome From Mike
Whether you’re trying to solve a specific problem or just eager to learn more, welcome to your one-stop destination for mastering Excel and Power BI.
Hi, I’m Mike Thomas, a Microsoft MVP in Excel since January 2024, and a UK-based IT Trainer with a rich experience spanning over 30 years. My zeal for Excel and its powerful companion, Power BI, fuels my commitment to sharing knowledge through comprehensive training courses, insightful YouTube videos, and engaging written tutorials. Whether you’re looking to streamline your business processes or simply elevate your analytical capabilities, my resources are designed to make a tangible difference in your journey.
The Microsoft MVP award stands testament to my dedication to the Excel community, acknowledging my technical proficiency, leadership, and unwavering commitment to addressing real-world challenges. It’s a recognition given to those who lead with excellence and inspire others to achieve more.
Dive into my latest tutorials below, and should you crave more, the ‘Tutorials’ menu is your gateway to a wealth of knowledge. Feel free to explore, learn, and transform the way you work with Excel and Power BI today!
Latest Videos and Tutorials
How to split text in a cell into multiple cells and how to deal with extra spaces and emojis in said text
A time-saver for applying often-used filter criteria to Excel lists
Select random rows from a table with a neat trick to ensure no duplicates
Use the new Insert > Checkbox feature to create a filter for a Dashboard
Choose which columns from a Pivot Table to include in a chart
Quickly create a seating plan for a dinner using a combination of Excel and PowerPoint
How to filter a pivot table based on a range of dates when the field containing the dates isn’t part of the pivot table
Sheet Protection on its own doesn’t prevent users changing a checkbox. Lean about the additional steps needed.
Automatically generate sequential ID numbers when a row is added at the top of a Table