
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
Flash Fill in Excel
Flash Fill is a real time saver for entering or manipulating list-based data in Excel. And it can all be done from a single shortcut key
Choose Columns v Remove Columns (Query Editor)
Which is the better tool for removing columns? Which will make your life easier in the long run?
Counting Values in a Pivot Table
Choose the wrong counting method and you could end up with inaccurate information!
Video Editing: Behind the Scenes
A behind the scenes look at editing my weekly YouTube video
5 Pivot Table Productivity Tricks
5 tricks to help you be more productive with Pivot Tables whilst working around annoyances
Excel – Distinct Count in a Pivot Table – Mac & Online
How to create a distinct count in a Pivot Table created in Excel Online or Excel for Mac (no Data Model support)
Dynamic Array Functions: 1 Hour Tutorial
Dynamic Array Functions Will Change Your Life!
Fix for 2 Pivot Table Filter By Value Issues
A trick to fix 2 filtering issues in Pivot Tables – one on Mac and one on both Windows and Mac
Excel for Mac: Pivot Tables
Recording go a live training session streamed on YouTube. How to create Pivot Tables in Excel for Mac