
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: Select Random Rows (No Duplicates)
Select random rows from a table with a neat trick to ensure no duplicates
Create a Checkbox-Style Filter
Use the new Insert > Checkbox feature to create a filter for a Dashboard
Exclude Columns From a Pivot Chart
Choose which columns from a Pivot Table to include in a chart
Excel: Create a Dinner Seating Plan
Quickly create a seating plan for a dinner using a combination of Excel and PowerPoint
Excel: Filter a Pivot Table on a Date Range
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
Excel: Lock a Checkbox on Protected Sheet
Sheet Protection on its own doesn’t prevent users changing a checkbox. Lean about the additional steps needed.
Excel: Automatically Generate Sequential ID’s – In Reverse
Automatically generate sequential ID numbers when a row is added at the top of a Table
Excel: Automatically Generate Sequential ID’s
Automatically generate sequential ID numbers such as TET-0001, TET-0002 etc when a new row is added
Excel: Import Content from XML
Use Power Query to load and clean data from an XML file into Excel