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. I’m an 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
What is GETPIVOTDATA? When should you use and avoid it? What are the gotchas?
LIVE training session on YouTube: Monday 16th May 7PM UK time
Excel’s OFFSET function is used to retrieve values from a cell or range
Three methods to replace part of a text string including SUBSTITUTE and REPLACE
On-demand recording of a live 60 minute training session covering Excel’s Lookup functions
The DROP function displays the contents of a specified range but excludes the first or last X number of rows or columns.
The TAKE function displays the contents of the first or last X rows or columns of a range
How to hide one or more rows in the Data Table that appears below a Chart
On-demand recording of a live 90 minute training session covering Power Query on a Mac