Analysis by Function & Formula

Following is the list of all courses tagged as covering analysis by function and formula.  These courses will cover the use of the summarisation and aggregation functions, such as FILTER, FREQUENCY, SUMIF, SUMIFS, COUNTIF, COUNTIFS and the use of dynamic array formulas to calculate things such as weighted averages.  They may also demonstrate effective summarisation functions, such as BYCOL and BYROW.

Title Modified Date
A01 - Streamlining Performance Reporting in Excel 03 June 2023
A04 - Dashboarding in Excel, a Practical Example 03 June 2023
Financial Analysis Certificate 03 June 2023
T08 - Array Formulas Reinvented 03 June 2023
T09 - Using LET to Add Transparency to Complex Calculations 03 June 2023
T11 - Structuring and Accessing Data in Models 03 June 2023

Was the information in this article helpful?

Invalid Input
Thanks! Do you have any suggestions to make it better?
Let us know how you think we could improve...

0/255

Invalid Input

Would you like to suggest a topic?

Invalid Input

Invalid Input

0/255

Invalid Input

Clarkson ITT builds & delivers
expert training, in classrooms
& online, for professionals in
finance, funds management &
accounting - developing their
skills in modelling and analysis.

Contact

+61 2 9871 0399
PO Box 104
West Pennant Hills NSW 2125
Australia
Clarkson ITT Company page