Excel Spreadsheet Formulas - Old School or Dynamic Arrays?

This course compares traditional Excel formulas with dynamic arrays for data analysis. Learners build summary reports using SUMIFS, COUNTIFS, and AVERAGEIFS with one-condition and cross-tabulated examples.

Syllabus

) Introduction.
) Excel Spreadsheet Formulas Uses in Data Analysis.
) Change Default Settings for Table Formula Nomenclature (Structured References)..
) Cell References in Formulas..
) Excel Functions to Make Calculations Based on one Condition, four examples:.
) SUMIFS Function with One Condition shown on next page in cell H13.
) SUMIFS Function with One Condition & Dynamic Array shown on next page in cell K13.
) COUNTIFS Function with One Condition shown on next page in cell H24.
) COUNTIFS Function with One Condition & Dynamic Array shown on next page in cell K24.
) Excel Functions to Make Calculations Based on an AND Logical Text..
) SUMIFS for Summary Report Based on Adding, Old School Cell References and Dynamic Arrays..
)AVERAGEIFS for Summary Report Based on Averaging, Old School Cell References and Dynamic Arrays..
) COUNTIFS for Summary Report Based on Counting, Old School Cell References and Dynamic Arrays..
) Homework sheets..
) Summary.