How to Use the Subtotal Function in Excel: Step-By-Step We all have used the contemporary functions of Excel – the SUM Function, the AVERAGE function, the COUNT function, and so on 📝 But today, we are going to introduce you to such a versatile function of Excel that will knock your socks off. [...]
Full List of ALL Excel Errors and How to Fix Them (2024) Hashtags are a trend – yes, but only until they are on Instagram or maybe Twitter. As soon as you see your Excel sheet throwing hashtags your way, you know there’s something wrong 🛑 Excel errors come with a hashtag before [...]
How to Compare Two Columns in Excel: Step-by-Step Comparing two columns in Excel is something you’d need to do very often. Sometimes to see if both the columns tally. And the other times, to see if both the columns are unique to each other 👀 In both cases, Excel fails to offer any [...]
How to Use the MATCH Function in Excel (Formula) The MATCH function belongs to the list of Excel’s reference/lookup functions. It looks for a value in a lookup array like all the lookup functions do 👀 However, once found, it doesn’t return the corresponding value. But the relative position of the lookup value [...]
How to Concatenate in Excel: CONCAT, Ampersand, and more Excel data is not always available in the format that we need when working with it. There are situations when we want to combine the data from several cells into one cell. But if you concatenate columns manually row-by-row, it can take hours ⏳ [...]
How to Get Week Number in Excel: Quick Tutorial (2024) Microsoft Excel has a wide variety of functions dealing with dates, weeks, months, and years. And one of these functions is the WEEKNUM function. You might not have heard of it before, and that's alright. Precisely speaking, it returns the week number for [...]
How to Use the PMT Function in Excel (With Examples) Are you up for borrowing? Before you do, make sure you know loan payments are worked out 💰 And Excel financial functions are here to help you with that. One of these, the PMT function will help you calculate periodic loan payments at [...]
How to Find the Median in Excel: Step-by-Step (2024 Guide) "When Bill Gates walks into a bar, everyone becomes a millionaire on average". Outliers (like Mr. Bill) can skew data so much that simple statistical indicators (like averages) become misguiding. In some of those cases, finding the median is more insightful 💡 Let [...]
Full Guide to Solver in Excel: How to Use + Install (2024) We make many assumptions when creating financial models in Microsoft Excel. These assumptions also have limitations 🚧 If you want to find optimal solutions from a model, you must change these assumptions. It will take hours to get the answer if [...]
How to Use TEXTJOIN in Excel: Concatenate Cells (2024) You must have heard of the CONCATENATE function and the concatenation operator (&). Haven't you? Both of these are used to merge cell contents in Excel 🤝 But now, we have a third addition to this league too – the TEXTJOIN function. The TEXTJOIN [...]