How-To Geek on MSN

Excel's Custom Data Validation: A Trick You Didn't Know You Needed

If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the ...
MUO on MSN

I stopped consolidating sheets by hand because Excel’s INDIRECT function does all the work for me

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...
SlashGear

How To Separate Names In Microsoft Excel And Google Sheets

You might be familiar with using spreadsheets at work, but they're also a great tool for personal use. Whether you're tracking expenses or putting together a wedding guest list, a spreadsheet can make ...
JournalofAccountancy

In Excel, Cell Names Spell Speed, Safety

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. To help readers follow ...