Excel TEXTBEFORE TEXTAFTER Functions
Learn to properly use the Excel TEXTBEFORE and TEXTAFTER functions. There is a cool trick you can use with these functions to get the outcome you want. Check out the post for more.
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 tips & tricks – stop doing these 7 things in Excel
Don't merge cells in Excel - Don't Copy Excel sheets without updating links - Don't hide rows and columns! There are better ways of doing these things. Find out 7 things you're doing wrong in Excel and how to do it correctly.
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.
DAX CALCULATE Function
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.