Excel’s Options dialog is where you stop fighting your workbook and start shaping Excel to suit the way you work. Two tabs you’ll open many times as a power user or teacher are General (personalisation and defaults) and Formulas (how Excel calculates). Below you’ll find an easy-to-follow walkthrough, practical examples, step-by-step how-tos, VBA snippets you can drop into a

When working with functions like VLOOKUP, XLOOKUP, or MATCH, Excel often returns a #N/A error if it can't find a match. These errors are expected in many workflows, but they can be confusing to users or disrupt downstream calculations. Enter: the IFNA function—purpose-built to handle #N/A errors only while allowing other types of errors to pass through untouched.

Excel uses various symbolic operators to perform calculations, define references, combine values, and control logic. Understanding these symbols is essential for writing effective formulas and debugging spreadsheet issues.

The IFERROR function is a built-in Excel tool designed to catch errors in formulas and replace them with a custom result — often a blank cell, a message, or a calculated alternative. It helps you control what your audience sees, maintaining a clean presentation even when underlying formulas produce errors.