How-To Geek on MSN

How to use formula by example in Excel to generate complex formulas

I traded the static results of Flash Fill for dynamic formulas that update automatically.

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 easier to refresh and reuse frequently updated data inside a worksheet.