Mike Thomas

Excel: How to Prevent Excel Replacing Last Numbers with Zeros

Excel: How to Filter a Pivot Table on Date Range (4 Methods)

How to Easily Replicate Power BI's Card Functionality in Excel

Excel: Get Data From a File Stored in a SharePoint Folder

Excel: How to Share and Backup Your Macros and VBA UserForms

Extract Text Between Characters in Excel (NO Formulas Needed!)

Excel: How To Quickly Convert Text Dates to Real Dates Without Using Formulas (Text-to-Columns)

Excel for Mac: How to Import Data From a Web Page

Excel: Create a Visual Interactive Map-Based Tracker for your Dashboards and Reports

Remove Duplicate Values From a List Using the UNIQUE Function in Excel

Excel: How to Calculate the Date of the Last Friday (Or Any Other Day) of Every Month

Excel: How to Calculate the First and Last Working Day of a Month

Excel: How to use Power Query to Combine Data from Multiple Excel Files with Different Sheet Names

Excel: What is a

Excel How to Create Clickable Hyperlinks in Power Query

Calculate Age From a Date of Birth in Excel (DATEDIF Function)

Excel for Beginners: Managing Sheets (Insert, Delete, Rename, Move, Duplicate, Hide/Unhide)

Excel - Quickly Find Highest/Lowest/Nth Highest/Nth Lowest Value in a List

Excel for iPad: Conditional Formatting: A First Look at a Brand New Feature

How to Count Unique Values (Distinct Count) in a Pivot Table in Excel Online and Excel for Mac

How to Add an Effective Title and Subtitle to an Excel Chart

Excel: How to Concatenate a Range (without using VBA)

Excel: Insert an Image into a Cell (the Non 365 Way)

Power Query Editor (Excel and Power BI): Choose Columns v Remove Columns. Which is Better?

Power Query and the Secrets of the LOAD To Option

Excel: Remove Unwanted Spaces with TRIM (the Cause of Many Common VLOOKUP/XLOOKUP/FILTER Problems)

Excel: 5 Essential Must-Know Slicer Tricks

Excel: How to Exclude Specific Columns From a Pivot Chart

Excel: Conditional Formatting Directional Icon Sets (Compare This Week’s Position to Last Week)

Excel: When Should You Use the Hash Sign (#) in a Formula?

Excel: VLOOKUP - How to Find the Next Largest Value

Excel: How to Prevent Excel Replacing Last Numbers with Zeros

Excel: Create Calculated Fields in a Pivot Table

Excel for Mac: How to Combine Files Stored in SharePoint or Teams

Excel for Mac: Enhance Your Dashboards with Automatically Updating Symbols and Emojis

Excel Tricks: Creating Markdown Links from Multiple Columns Using Power Query on a Mac

How to Fix “Variable uses an Automation type not supported" Error in VBA Editor in Excel for Mac

How to Combine Text in Excel (4 Methods: CONCATENATE, CONCAT, TEXTJOIN and Ampersand)

Excel: Two Ways to Change the Case of Text: Functions and Power Query

Excel - Apply Conditional Formatting to a Text Box

Excel - How to Display Selected Slicer Value(s) in a Cell

Excel: How to Count the Number of Rows in a Table or Range using the ROWS Function

Exporting Part of a SharePoint List to Excel

Dependent Filters in an Excel Pivot Table: The Secret to Getting Them to Work

Excel: How to Count the Number of Items in a List

Excel for Mac: Colour Matching from an Image or Screen Element (Plus Bonus Tip)

Excel: How to Use the IF Function with Wildcards (so it Works!)

Excel: Use the VSTACK Function to Quickly, Easily and Dynamically Combine Lists (No Power Query)

Excel: Learn the Secrets of the Frequency Function: How to Easily Group Numerical Values

LAMBDA for Beginners in Excel

Build an Infographic Style Bar Chart in Excel