TechRepublic

How to use the FILTER() dynamic array function in Excel

Microsoft Excel’s new FILTER() function is a great tool for reporting and dashboards. We’ll show you how to use it to get more done. Filtering is a huge part of many Microsoft Excel sheets, and ...
JournalofAccountancy

Microsoft Excel: A dynamic new way to SORT data arrays

Q. Is it possible to sort a column in Excel using formulas rather than the Data tab’s Sort tool, so the sort process is performed automatically as I update my data? A. Excel has announced a new ...
Geeky Gadgets

Create Dynamic Excel Data Validation Lists Using Table Spill Ranges

Traditional methods for creating dynamic drop-down lists in Excel, such as using INDIRECT or named ranges, often come with significant limitations. These approaches can break when tables are renamed, ...
TechRepublic

How to create a sorted unique list in an Excel spreadsheet

Microsoft 365’s UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula. Lists are a fundamental part in almost any Microsoft Excel ...
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 ...