How-To Geek on MSN

The simple Excel function that decides if your formula spills or returns one value

For decades, Excel worked on a simple principle: you enter a formula into one cell, and it returns a single result into that ...
Geeky Gadgets

Use Excel Like a Pro : Fill Blank Cells in Seconds with This Genius Hack

Have you ever found yourself staring at a sea of blank cells in Excel, wondering how to fill them without hours of manual effort? For years, this has been a frustrating bottleneck for professionals ...
How-To Geek on MSN

How to fix the #SPILL! error in Microsoft Excel

There are two ways to fix this cause of the #SPILL! error. First, select the entire spill range (or at least the cell or cells causing the blockage), and drag it to another area in the worksheet. On ...
JournalofAccountancy

Exploring Excel’s dynamic FILTER function

Q. How do I use the FILTER function in Excel, and how is this an improvement over the filter feature? A. The FILTER function was introduced five years ago as part of the Excel Dynamic Arrays rollout.
Geeky Gadgets

Create Dynamic Reports in Excel with Just One Formula

Excel can feel like a maze of endless rows, columns, and formulas, especially when you’re trying to create something as detailed as a loan repayment report. If you’ve ever found yourself overwhelmed ...
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 ...