Mike ‘ExcelIsFun’ Girvin – Control+Shift+Enter: Mastering Excel Array Formulas

2013 | ISBN: 1615470085 | ISO | 11+ hours | 4.5 GBGenre: eLearning/Excel

Command The Power of the ‘Array Formula’ in Microsoft Excel with “Control+Shift+Enter”

Array Formulas are a powerful tool in Excel. An Array Formula works with a series of Data Values instead of a single Value. Excel Array Formulas are mysterious, even to people who use Excel 40 hours a week. Start with the secret keystroke that must be used to finish an Array Formula: Ctrl+Shift+Enter. Then, you have to know which functions will work with Arrays and which will not. Once you get a grasp on Array Formulas, you will find they solve problems that regular Excel Formulas can not solve, or would require hundreds of thousands of regular Formulas.

Although elusive, Array Formulas can be used to solve everyday Excel problems. If you need to figure out how many times your birthday fell on a Friday, an Array Formula can solve that. If you need to return a unique list of sales reps from a Database, an Array Formula can solve that.