How to find errors in a complex formula, step by step, using Excel’s EVALUATE FORMULA function. Where to find the command, method, worked example, and related topics.
Excel General Tips
How to search a range of cells for specific text, and then sum another range of cells based on the search results. Worked examples using a combination of ISNUMBER, SEARCH, SUMPRODUCT, SUMIF.
How to fix Excel when formulas are not automatically calculating and flash fill doesn’t fill the formula down the column.
Using Tables in Excel has many benefits (we’ve listed our 10 favourite reasons), and this topic page shows you how to create, format, resize, rename, add totals and summarize data, and use data entry forms with Excel Tables.
How to create and use a data entry form in Excel
How to customize the ribbon in Excel – add commands, create a new tab and group of commands in the ribbon
It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.
How to add, move, group and copy worksheets within and between Excel workbooks, and how to navigate between sheets in large multi-worksheet file, and how to hide and unhide worksheets.
How to add a data label to just one data point on a chart in Excel.
How to remove blank cells from a set of data so that a plotted line is continuous. Example shows blank cells being replaced by ‘N/A’ values using an IF statement.