Instructor Led Sumif Training - Training Resources
Sumif Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From Navigator Project Finance
Project Finance Modelling A
...round recommended 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
more...
...round recommended 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
more...
From NetLearn
Excel 2007 basic - advanced
...on
Topic B: Math 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
more...
...on
Topic B: Math 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
more...
From Applied Office
Microsoft Excel 2003 - Formulas and Functions 2
...iate class that introduces functions such as VLOOKUP, IF, SUMIF, and more. Learn how to work with dates and times. Build more complex worksheets that automate your work and save you and your employees considerable time.
~~~~~~~~~~~~~~~~~~
About the Location
Classes are located at the beautiful University of the Pacific
campus in a state-of-the-art hands-on computer lab and include:
more...
...iate class that introduces functions such as VLOOKUP, IF, SUMIF, and more. Learn how to work with dates and times. Build more complex worksheets that automate your work and save you and your employees considerable time.
~~~~~~~~~~~~~~~~~~
About the Location
Classes are located at the beautiful University of the Pacific
campus in a state-of-the-art hands-on computer lab and include:
more...
