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 ...
Bloomberg L.P.

Investor Relations & Strategy: How to Use Bloomberg in Excel

We invite you to join our industry specialists for a virtual session on how to use Bloomberg functionality in Excel. This expert-led webinar will focus on equity-related functions relevant to a broad ...
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 ...