Overview
Learn advanced Excel techniques for calculating average GPA with one condition across a one-to-many relationship between two tables. Explore multiple solutions using Excel array formulas, DAX measures in Excel 2016 Data Model, Power Query, and SQL coding in Access. Master the use of functions like AVERAGE, IF, COUNTIFS, AVERAGEX, CALCULATE, and FILTER to solve complex data analysis problems efficiently.
Syllabus
) Problem Introduction.
) Excel Array Formula Solution using AVERAGE, IF and COUNTIFS function with a Function Argument Array Operation.
) Excel 2016 Data Model DAX formula (DAX Measure) solution using AVERAGE, AVERAGEX, CALCULATE and FILTER functions, without Power Pivot.
) Power Query (Get & Transform).
) SQL coding in Access.
) Summary.
Taught by
ExcelIsFun