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

How to use the MAP function in Microsoft Excel

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...
How-To Geek on MSN

How to pick a random name from a list in Excel

To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...
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 ...