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

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