
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
How to Crack Password Protection in Excel
Disable protection when you don’t know the password – without using 3rd party apps
Power Query FINALLY Comes to The Mac
The Power Query Editor is now available to Beta Channel users in Excel for Mac
Combine Text From Multiple Cells in Excel
Four ways to combine text stored in separate cells into a single cell
Lock Cells and Protect Data in Excel
How to prevent accidental changes ruining your carefully crafted spreadsheet
How to Use SUMIF and SUMIFS in Excel
Add up numbers that match one or more criteria. Includes between (dates/numbers) and wildcards (partial matches)
How to Use COUNTIF and COUNTIFS in Excel
Count the number of items in a range. Tutorial includes between (dates/numbers) and wildcards (partial matches)
Extract Text Between Characters in Excel
Using Power Query makes extracting text from between a set of parentheses in Excel a simple job.
Use Power Query to Create a Currency Converter
A robust and reliable way to load web-based exchange rate data into Excel and automatically keep it up-to-date
Use Data Types to Create a Currency Converter
Use the Currency Data Type to create a currency converter that automatically updates