BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

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

Learn to create a yield curve in Excel and understand its implications for interest rate forecasting. Follow our simple guide to plot your own financial data.

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.