Instructor Led Countif Training
Countif Training Provider? - Tell us about your Training!
From Navigator Project Finance
Project Finance Modelling A



...ecommended functions and their applications
* SUMIF/ COUNTIF/ SUMPRODUCT/ DATE FUNCTIONS
* + takeaway file of demonstrations
* Array Functions {Average()}, {Min()},{Transpose()}
Sensitivities /Scenarios
* Using Flex Cells to ensure the base case remains intact
* Building a scenario manager a the structured approach to sensitivities/ scenarios
* 1D Data
more...
From NetLearn
Excel 2007 basic - advanced




... and statistical functions
B-1: Using SUMIF
B-2: Using COUNTIF
B-3: Using AVERAGEIF
B-4: Using SUMIFS, COUNTIFS, and AVERAGEIFS
B-5: Using ROUND
Topic C: Financial functions
C-1: Using the PMT function
Topic D: Displaying and printing formula
Unit 2: Lookups and data tables
Topic A: Using lookup functions
A-1: Examining VLOOKUP
A-2: Using VLOOKUP to find an exact match
more...
