If you ever find yourself writing the same formula for multiple columns, BYCOL can save you time and effort. Instead of copying, adjusting references, and making sure nothing gets accidentally overwritten, BYCOL just takes the entire range and runs the calculation for each column automatically. Continue reading
When working with large datasets in Excel, you often hit the same question: "How do I apply this calculation to every row in a range without copying formulas down?". BYROW is made for exactly that. Continue reading
Finding a single match in Excel is easy with VLOOKUP or XLOOKUP. The challenge comes when you need to pull all matching values, not just the first one. To accomplish the task in pre-dynamic Excel, you had to rely on several nested functions working together, which was quite complex and far from beginner-friendly. Continue reading
Calculating how much each value contributes to a total is something many Excel users do every day. In older versions, this usually meant creating your own formula that divided a part by the whole. The PERCENTOF function gives you a quick and direct way to return that percentage without building a formula manually. Continue reading
If you've already used Excel checkboxes to track project milestones, a progress bar is the perfect next step. It gives you a clear visual snapshot of how close you are to reaching a goal. In Excel, you can easily create a progress bar using conditional formatting or charts, no coding required. Continue reading
Whenever you want to create a to-do list or project tracker, attendance sheet or review checklist, there is one small element you'll definitely need – a checkbox. In modern versions of Excel, adding checkboxes is much simpler than you might think, and you can set it up in under a minute. Continue reading
With Excel Copilot, creating VLOOKUP and XLOOKUP formulas is as easy as explaining your task in plain language. This guide walks you through using Copilot in both the desktop Excel app and in browser to perform quick, accurate lookups – no advanced formula skills needed! Continue reading
When you're using Excel to manage project deadlines, schedule appointments, or analyze data trends, it's often handy to know the day of the week for specific dates. Excel has a variety of tools to help you figure this out. Continue reading
Whether you are a student, researcher, or data analyst, understanding the standard error of the mean can help you draw more accurate conclusions from your data and make more informed decisions. This article will show you a few quick ways to calculate the standard error in Excel. Continue reading
Whether it's a simple formatting mistake or a more complex syntax issue, knowing how to fix the #VALUE error in Excel is essential for anyone who wants to create error-free spreadsheets and ensure the accuracy of their data. Continue reading
Even experienced Excel users may encounter errors while working with complex spreadsheets. One such error is #NAME, which can be frustrating to deal with but is usually easy to fix, especially when you know the reasons behind it. Continue reading
Whether you're an experienced user or just starting to learn about your favorite spreadsheet program, knowing how to quickly identify if a specific value is present or absent in a given range can save much time and effort in your data analysis. Continue reading
Sorting text and numbers separately in Excel is as easy as ABC or 123 :) But re-arranging values that have both letters and digits in them such as employee IDs, SKU's and the like may cause problems. If you want to have more control over how alphanumeric stings are sorted, read this tutorial. Continue reading
Microsoft Excel provides a variety of functions to calculate dates. When it comes to adding or subtracting months to/from a given date, EDATE is the function to use. Additionally, it can help you calculate expiration dates, anniversary dates, due dates, and a lot more. Continue reading
Imagine that you are working with a dataset of hundreds or thousands of columns. Obviously, some columns are more important than others, and naturally you may want to read their data first. Excel 365 offers a perfect function for the job, named CHOOSECOLS. Continue reading
Want to increase an array to a specified number of rows or columns so that all similar arrays in your worksheet have the same size? In Excel 365, that can be done with one simple formula. Meet the brand-new EXPAND function that can grow an array to any dimensions you set. Continue reading
To check if a given value is between two numbers, you can use the AND function with two logical tests. To return your own values when both expressions evaluate to TRUE, nest AND inside the IF function. Detailed examples follow below. Continue reading
When working with long strings, you may often want to extract a specific part of them for closer examination. In Microsoft Excel and Google Sheets, there are several ways to get text between two characters or substrings. In this article, we'll discuss the fastest and most effective ones. Continue reading
When working with complex datasets in Excel, you may often find yourself in a situation when you need to extract data to the right of a certain character or word. This tutorial will show you the fastest way by using the span-new TEXTAFTER function. Continue reading
In earlier Excel versions, extracting text before a space, comma or any other character was quite tricky. In Excel 365 and Excel for the web, we now have a brand-new TEXTBEFORE function that does the magic! Continue reading
For large datasets, you may often need to calculate a total amount for a given range between two numbers. This can be easily done with the SUMIFS function both in Excel and Google Sheets. Continue reading
The SUMIF and SUMIFS functions available in Microsoft Excel and Google Sheets are case-insensitive by nature. To conditionally sum cells treating lowercase and uppercase letters as different characters, you'll have to come up with something else. Continue reading
In some situations, you may need to sum specific numbers in a range, say top 3, 5, 10 or n. That might be a challenge because Excel has no inbuilt function for this. But as always, there is nothing that would prevent you from constructing your own formulas :) Continue reading
When building complex formulas in Excel, you may sometimes need to get a column letter of a specific cell or from a given number. This can be done in two ways: by using inbuilt functions or your own one. Continue reading
VLOOKUP is one of the most confusing Excel functions plagued with many issues. Using VLOOKUP with ISERROR can help you catch all possible errors and handle them in a way most appropriate to your situation. Continue reading
Getting a lot of #N/A errors in your worksheets and are curious to know if there is a way to replace them with a user-friendly message? IFNA formula is the solution you need. Continue reading
The tutorial talks about how to return a column number in Excel using formulas and how to number columns automatically. Continue reading
When Excel cannot find what it is asked for, a #N/A! error appears in a cell. To intercept and handle such errors, you can use the ISNA function. Continue reading
Traditionally, string concatenation in Excel is done with the help of the CONCATENATE function or the ampersand symbol. In modern Excel, these old-school methods give way to CONCAT - a newer and improved function to combine text from multiple cells into one cell. Continue reading
When working with text data in Excel, you may sometimes need to add the same text to existing cells to make things clearer. For example, you might want to put some prefix at the beginning of each cell, insert a special symbol at the end, or place certain text before a formula. Continue reading