New Excel Features: Dynamic Array Formulas & Spill Ranges

Bottom Line: Learn about the new Dynamic Array functions and formulas that will eventually replace the Ctrl+Shift+Enter¬†array formulas. Skill Level: Beginner Download the Excel File Here’s the file I use in the video. Unfortunately, these functions are only available to a portion of users on Microsoft’s Office Insiders Program.¬† So you might not have access … Continue reading New Excel Features: Dynamic Array Formulas & Spill Ranges