Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

Explore the power of Excel spreadsheet formulas for data analysis in this 30-minute video tutorial. Compare traditional formulas with new Office 365 Dynamic Array Formulas, focusing on SUMIFS, COUNTIFS, and AVERAGEIFS for creating data analysis summary reports. Learn to change default settings for table formula nomenclature, use cell references effectively, and apply Excel functions for calculations based on single and multiple conditions. Practice with provided start files, finished files, and PDF notes to master both old school and dynamic array approaches. Gain valuable skills in data analysis and business intelligence using Microsoft Excel Power Tools, including PivotTables, Power Query, Power Pivot, and Power BI Desktop.