
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: Prevent Excel Replacing Last Numbers with Zeros
Learn how to prevent Excel replacing the last 5 digits with zeros
Excel: Remove E+ From Numbers
How to change a number that displays E+ at the end so that it displays correctly
Copy Specific Table Columns
Create a dynamically-updating copy of specific columns from a Table
Excel: Case Conversion
Convert text from one case to another using formulas or Power Query
Excel: Insert Images into Cells (Non-365)
Embed an image inside a cell using a feature that is available to ALL Excel users
Excel: Track KPI’s with Traffic Lights
Show progress against actual using automatically-updating traffic lights
Excel: Create a Soccer Results Tracker
Build a simple Excel-based tracker to track match results and attendances
Excel: Link Shapes and Icons to Cell Values
How to add shapes and icons to a dashboard and link them to cells
Excel – Use IF with Wildcards
The IF function in Excel doesn’t support the use of wildcards. Here’s a workaround