Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.

Cascading drop-down lists—where choosing a category like "Fruit" narrows the next list to "Apple" or "Pear"—are a staple of high-level data entry in Excel. The old INDIRECT method works, but it's ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

Many people working in the corporate world need at least a passing familiarity with Microsoft Excel. Maybe you only indicated that you're skilled with Excel on your resume because it feels like one of ...

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.