Excel LOOKUP Function

The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

Excel TEXTSPLIT Function

Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

New Excel Functions Vstack Textsplit tocol

Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

Excel Advanced Formula Editor Lambda

The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel. It's a "new" version of Name Manager and hopefully it could replace Name Manager in the future.

Common Excel formula Errors and how to fix them

How do you fix broken Excel formulas? What do you do when the formulas return errors? Find out what the most common Excel formula errors are and how you can fix them. It's easy! You just need the right approach. This post covers it all!

Excel Combine text and numbers

Learn practical and easy methods (including a hidden tip not many know about) to combine data from multiple cells into a single cell in Excel.

Excel for Engineers

If you're a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.


If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you what's happening behind the scenes: How the CALCULATE function works and delivers results.

Excel SCAN Function

Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.