## Dynamic Filter in Excel – Filter As You Type (with & without VBA)

https://youtube.com/watch?v=xBRkCv6RWcEIn this video, I will show you how to create a dynamic filter in Excel (where you can filter as you type in Excel). I cover two methods to create…

## 25 AWESOME Excel Keyboard Shortcuts (You Should Know)!

https://youtube.com/watch?v=TWYXcNm1I-QIn this video, I will share 25 Excel shortcuts that will help you save time and look like an Excel Pro. The following shortcuts are covered in this video: 1.…

## How to Compare Two Excel Sheets (and find the differences)

https://youtube.com/watch?v=8Ou_wfzcKKkIn this video, I will show you a couple of methods to compare two Excel sheets for differences or compare two Excel files. There are some in-built features in Excel,…

## How to Sort by Last Name in Excel (3 Easy Ways)

https://youtube.com/watch?v=8vpKwR0Fd7wIn this video, I will show you three easy ways to sort the names data based on the last name. The following three methods are covered in this video: 1.…

## Show Negative Numbers in Red Color (with a Bracket) in Excel

https://youtube.com/watch?v=9aokrf_tMRIIn this video, I will show you how to show negative numbers in red color and/or with brackets. This can be done using two methods: -- Conditional Formatting -- Custom…

## Unpivot Data in Excel Using Power Query (FASTEST way ever)

https://youtube.com/watch?v=2482wD1FmEsIn this video, I will show you how to quickly unpivot data in Excel using Power Query. Since the Pivot table needs a specific data format, in case you get…

## Show Numbers in Thousands or Millions in Excel (really easy way)

https://youtube.com/watch?v=6jLeD1YfWfYIn this video, I will show you a really easy way to show numbers in thousands in Excel (or in millions or billions). You can do this using the custom…

## Automatically Open Specific Excel Files When you Start Excel

https://youtube.com/watch?v=nGdkfbvqd5QIn this video, I will show you how to open specific Excel files when you start Excel. You can specify a folder so that whenever you start Excel, it will…

## Highlight Dates that are Past the Due Date in Excel (or about to be due)

https://youtube.com/watch?v=zqkINF31_nwIn this video, learn how to highlight cells with dates that are past the due date. This can easily be done using the TODAY function in conditional formatting. In this…

• 1
• 2