Microsoft Excel users, here’s a quick tip on adding a condition to a drop down list. You can use a Microsoft Excel drop down list to display a simple list, though sometimes you need a bit more control ...

Many Excel tools are optional extras, but these six are essentials I rely on in every workbook.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...

Track your invoices, keep on top of your job search, and get the best value for money with these three easy-to-follow Excel projects.

Have you ever spent hours perfecting your Excel spreadsheet, only to watch your carefully crafted formatting fall apart the moment you insert a new row? It’s a maddeningly common issue for Excel users ...

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how. An expression to return a simple ...