Instructor Led Sumif Training
Sumif Training Provider? - Tell us about your Training!
Please select the location nearest to you:
United Kingdom
United States
India
Australia
South Africa
 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 IT's Easy Software Training
Advanced Excel
...Using Solver
a IF Statements
a Advanced VlookUp and SUMIF
a IF And
a Logical Tests, Error Trapping
a Using Form Tools
a Data Validation
a Advanced Pivot Tables Formulae
a Recording Basic Macros
a Importing External Data
a Using Named Ranges in a Formula
a Advanced Database Filters and functions
a Advanced Scenarios
a Investment Rate of Return Functions
more...
...Using Solver
a IF Statements
a Advanced VlookUp and SUMIF
a IF And
a Logical Tests, Error Trapping
a Using Form Tools
a Data Validation
a Advanced Pivot Tables Formulae
a Recording Basic Macros
a Importing External Data
a Using Named Ranges in a Formula
a Advanced Database Filters and functions
a Advanced Scenarios
a Investment Rate of Return Functions
more...
From Learn Excel Class
Advanced Excel Class
Advanced Microsoft Excel Training covers advanced formulas and functions (Vlookup, If/ Then, Index/ Match, DSum, arrays, formula auditing techniques), what-if data-analysis techniques (pivot tables, scenarios, forecasting), database features (validations, extract unique values), advanced macros (with light VBA programming) and collaboration techniques.
Advanced Excel Training Objectives:
*
more...
From Mohd Arsalan
ADVANCED EXCEL
This program intends to impart the advance excel benefits to an individual. After the successful completion of the program, an individual will be able to use advanced filters, advanced pivots, array formulas, multi-dimensional lookup, more advanced formulas combining sumif, if, index, date functions and text functions. The program is offered online as well as as a live workshop.
more...
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...
