Mastering a few high-impact tools like formatting and tables is the best way to get started in Excel.

This post explains what is IFERROR function and how to use the function in Microsoft Excel. The IFERROR function was introduced in Excel as a logical function to handle errors that may occur within ...

The LAMBDA function in Excel is transforming how users handle formulas by enabling the creation of custom, reusable functions. This capability simplifies complex calculations, reduces errors, and ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

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, ...

Dynamic arrays change the rules for formula output in Excel. When I write a formula that returns a list by default, I need to decide whether I want the result to spill across a range of cells or ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Comments in Excel come in handy for documenting your spreadsheet so you can remember what all the formulas are for or to provide instructions for other spreadsheet users. The How-To Geek points out a ...

DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.