Excel’s shiny new functions still can’t dethrone the PivotTable.

Extract partial data from an array in Excel.

Excel FILTER function mastery requires understanding TRUE/FALSE logic. Use the * multiplier for AND logic to easily handle multiple complex conditions.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find. LAMBDA functions are new to Microsoft ...

Microsoft Excel’s new text functions make working with strings a breeze. A common task is to parse or find characters within a delimited string in Microsoft Excel. Fortunately, Excel has several ...

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM, WORKDAY, ...

Q. How do I use the FILTER function in Excel, and how is this an improvement over the filter feature? A. The FILTER function was introduced five years ago as part of the Excel Dynamic Arrays rollout.

Q. Part of my job involves keeping track of all the departments’ budget status, which takes several hours each month. Is there a quicker way to do this? A. The task alluded to in the question involves ...

Excel might seem like a basic tool for many, but beneath its familiar rows and columns lies a powerful engine packed with underappreciated functions. While most people know how to sum columns or sort ...

When you dive into the world of Microsoft Excel spreadsheets, you quickly realize how powerful its functions can be. One such function that you will find incredibly useful is the RANK function. This ...

Caroline Banton has 6+ years of experience as a writer of business and finance articles. She also writes biographies for Story Terrace. Suzanne is a content marketer, writer, and fact-checker. She ...