The DATE function is a financial analyst's best pal and categorized as a Date/Time function in Excel. The criticality of the DATE function's role is sourced from Excel's reluctance to keep the day, month, and year as a date. Instead, Excel stores them as a serial number.Directly handing over dates as a text string may not work well for all … [Read more...]
Excel FILTER Function – How To Use
The FILTER function is an Excel function that lets you fetch or "filter" a data set based on the criteria supplied via an argument. The FILTER function was introduced in Office 365 and will not be accessible in Office 2019 or earlier versions.FILTER is an in-built worksheet function and belongs to Excel's new Dynamic Arrays function category. The … [Read more...]
Excel IFERROR Function – How To Use
IFERROR function provides a great way to handle errors in Excel formulas. Excel IFERROR function returns a custom result (which can be a text, cell reference, or another formula) when the expression enclosed inside it returns an error.IFERROR helps you catch and address problems with your formulas so you can have clean and orderly spreadsheets. … [Read more...]
How to Find and Fix Circular References in Excel
A circular reference occurs when you end up having a formula in a cell – which in itself uses the cell reference (in which it’s been entered) for the calculation. If this statement seems a bit confusing, don’t worry by the end of this tutorial it will start to make sense.In simple terms, a circular reference happens when a formula references … [Read more...]
Excel SUBSTITUTE Function – How to Use
The SUBSTITUTE function in Microsoft Excel is a handy tool that enables users to replace single or multiple instances of a specific character or text string with a different character or text string. To see how this works on a spreadsheet, we will discuss the syntax and four arguments of the Excel SUBSTITUTE function.Next, we will try our hand at … [Read more...]
Excel OFFSET Function – How to Use
The OFFSET function is one of the most enigmatic Excel functions that may take a while to wrap your head around. But I will ensure that by the end of this tutorial, you would not just be able to understand what the Excel OFFSET function does, but also learn how you can use it in your own worksheets.OFFSET is an in-built worksheet function … [Read more...]
Excel Flash Fill – How To Use
What is Excel Flash Fill, and more importantly, what is so special about it?Flash Fill is a special tool in Excel that can automatically fill in values for you once it recognizes a pattern in the data.Have you ever wondered if Machine Learning exists in Excel? And if it does, where does it exist? Flash Fill is one of those tools that use … [Read more...]
Excel Find Function – How to Use
The FIND function is a built-in Worksheet Function (WS) in Microsoft Excel, which you can use to locate a sub-string or a specific character's position within a text string. It is categorized as a TEXT function in Excel.If the FIND function fails to find the text, it will return a #VALUE error. Note that the Excel FIND function will perform a … [Read more...]
