Microsoft Excel’s new import functions make handling numbers easier

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...
How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
MrExcel on MSN

Excel WE LOOKUP 101: Finding Data Made Easy

This video explains the WE LOOKUP function in Excel and how it can be used to quickly find and return data from tables. It ...
JournalofAccountancy

How CPAs can use exponential smoothing in Excel for better forecasts

Q. I use Excel to do traditional linear forecasting, but I would like to upgrade to exponential smoothing for more accurate forecasts. Is there a way to do this in Excel? A. Accurate forecasting is ...
PC World

Use Microsoft Excel data types to save unnecessary typing

If you’ve ever doing an assignment for work or study that requires you to display information about a country, you could manually search for it and type it out in Microsoft Excel, but that would be ...