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.

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.

Percentile and Percentile Rank Calculation in Excel

Learn the meaning of percentile in introductory statistics and how to calculate Percentile in Excel. There are two functions: one is PERCENTILE.INC and the other PERCENTILE.EXC. I'll explain the difference and also how you can calculate PERCENTRANK in Excel.

Office 2021 new Features

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

Excel BYROW and BYCOL Functions

Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.

Excel Add Text to Values

You can easily add text to your cell values in Excel. You don't have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.

SUMIFS Multiple Criteria in a Single Column

Learn how to sum values based on multiple criteria in a single columns. You probably know that you can use SUMIFS to sum values based on criteria from multiple columns. But there is also an easy way you can sum values if your criteria is in the same column.