How-To Geek on MSN

Forget INDIRECT: The modern way to create cascading drop-down lists in Excel

Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.
TechRepublic

How to use the UNIQUE() function to return a count of unique values in Excel

How to use the UNIQUE() function to return a count of unique values in Excel Your email has been sent The TechRepublic article How to create a sorted unique list in an Excel spreadsheet shows you how ...
How-To Geek on MSN

When not to use tables in Excel: 5 scenarios where regular ranges are better

Skip tables when you need spilled results, presentation-ready layouts, one-off modeling logic, or stable protected data-entry templates.
TechRepublic

How to return the top or bottom n records without a filter or PivotTable in Excel

How to return the top or bottom n records without a filter or PivotTable in Excel Your email has been sent Returning the top or bottom n records of a data set in Excel isn’t difficult, and there are ...
Geeky Gadgets

Easily Create Excel Self-Updating Filters That Save Hours of Work

Whether you’re tracking sales, managing inventory, or analyzing employee records, keeping up with dynamic datasets can feel like a never-ending chore. But what if there was a way to make Excel do the ...
JournalofAccountancy

Create a dynamic to-do list with Excel’s checkboxes

Q. I currently keep a static to-do list, and I would like to update it to be more dynamic. Do you have any advice? A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool ...