Monster formulas don't have to stay monstrous.

Overview Excel remains a core tool for data analysts, and a small set of functions can handle most tasks related to lookups, ...

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...

Excel formulas are getting scary good.

Have you ever found yourself staring at an Excel spreadsheet, trying to figure out how to make sense of all the numbers and data? Maybe you’ve spent hours manually calculating groups, splitting dates, ...

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work. Most Microsoft Excel functions are autonomous—one ...

Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic counterparts. It also has built-in functions for ...

Speak with confidence at your next financial meeting by calculating your gross profit with Microsoft Excel. Excel provides several built-in functions and operators to calculate total cost, revenue and ...

Here’s the thing, one must keep in mind that the SUBSTITUTE function is case sensitive, therefore, you must use it accordingly at all times. Furthermore, it is not possible to specify wildcard entries ...

Q. Could you explain how the UNIQUE function works in Excel? A. Excel’s UNIQUE is a dynamic array function that can be an essential tool for data analysts and accountants. This function allows users ...