by Ben Thompson
August 19, 2020
We regularly receive questions around how to calculate percents in Microsoft Excel so decided to dedicate a video to answering these questions.
by Ben Thompson
June 26, 2020
In this video we look at two quick methods for removing Numbers from an Alphanumeric string including Flash Fill and Power Query.
by Ben Thompson
June 12, 2020
In this video we demonstrate how to incorporate formulas into your conditional formatting logic.
by Ben Thompson
June 5, 2020
In this video we look at the importance of using Data Relationships when working with multiple data sets in Excel.
by Ben Thompson
May 22, 2020
In this tutorial we take at possibly the easiest solution for gathering information into Excel allowing people to submit results from ANY device!
by Ben Thompson
May 15, 2020
In this video we take a look at FIVE new formulas available in Office 365 that you should know.
by Ben Thompson
May 8, 2020
In this video we use the FILTER function in Office 365 to return multiple columns of detail for the largest salaries.
by Ben Thompson
May 1, 2020
In this tutorial I demonstrate how we can use the NEW dynamic functions available in Office 365 to create searchable drop-down lists.
by Ben Thompson
April 23, 2020
In this video I look at the benefits of using tables in Microsoft Excel. I cover the topics of conditional formatting and data validation (dropdown lists).
by Ben Thompson
April 16, 2020
In this video we take a look at the BEST keyboard shortcuts we have available in Microsoft Excel to save us time simplify our Excel tasks.
by Ben Thompson
March 21, 2020
In this tutorial I work through the benefits of replacing VLOOKUP with the new XLOOKUP Function in Microsoft Excel.
by Ben Thompson
October 5, 2019
Learn Pivot Tables in under 10 Minutes... In this tutorial we will show you everything you need to get started with PIVOT tables in Microsoft Excel.
Use left/right arrows to navigate the slideshow or swipe left/right if using a mobile device