Michael Rempel · Jan 22, 2026 · 5:11 PM UTC

XLOOKUP SUM And Intersection Tricks In Excel youtu.be/oXO186f8Rxg?si=whST… via @YouTube

XLOOKUP SUM And Intersection Tricks In Excel

In this tutorial we are going to look at two tricks using XLOOKUP: ...

Michael Rempel · Oct 27, 2025 · 3:43 PM UTC

How To Use The TRIMRANGE Function and the Dot Operator In Excel youtu.be/KbCs186bpWQ?si=aodo… via @YouTube

Michael Rempel · Oct 15, 2025 · 6:48 PM UTC

How To Use The LAMBDA Function In Excel

In this video we are going to explain the usage and benefits of the...

Michael Rempel · Feb 5, 2025 · 3:36 PM UTC

How To Use The REGEXEXTRACT Function In Excel youtu.be/dKyo6Rm7qAQ?si=4e0K… via @YouTube

In this tutorial we are going to review the REGEXEXTRACT function, ...

Michael Rempel · Jan 6, 2025 · 3:39 PM UTC

How To Use The FILTER Function Based On A List With Multiple Criteria In... youtu.be/C3In8L5Pxq8?si=yVKZ… via @YouTube

Michael Rempel · Oct 29, 2024 · 2:06 PM UTC

How To SUM Alpha Numeric Values In Excel youtu.be/_pkMITRXxVU?si=Uq13… via @YouTube

In this tutorial we are going to see how we can sum alpha numeric t...

105

Michael Rempel · Sep 18, 2024 · 2:14 PM UTC

How To Dynamically Set Multiple Print Areas On The Same Worksheet In Excel youtu.be/iV5YTJ9veZQ?si=HbjA… via @YouTube

In this tutorial we are going to look at how we can create dynamic ...

Michael Rempel · Sep 4, 2024 · 1:51 PM UTC

In this tutorial we are going to look at the Navigation option in E...

Michael Rempel · Aug 7, 2024 · 3:00 PM UTC

In this tutorial we are going to look at a very useful option in Mi...

Michael Rempel · Jul 29, 2024 · 7:03 PM UTC

Three Very Useful Paste Special Options In Excel youtu.be/lOKOZtc4Ug8?si=qeRj… via @YouTube

In this tutorial we are going to look at three options from the Pas...