Core-CT - Home
Advanced Excel II for EPM Users
FRP312 Class Agenda
|Introduction |Introduction to INDEX/MATCH |
| | |
|SUMIFS |Introduction to Excel tables. Use SUMIFS, INDEX, and MATCH to summarize vendor information |
|SUMIFS2 |Use SUMIFS to keep track of continuous type information. |
| | |
|Dashboard |Using the information from SUMIFS, create a rudimentary dashboard employing the OFFSET function that displays |
| |the most recent averages. |
|INDEX-MATCH |Create a drop down menu to look up employee information. INDEX and MATCH also allow you to create a lookup |
| |that looks left. VLOOKUP is limited in that it only allows a rightward lookup. |
|SUMIF |Create a per period sum and then hide all but the last value for each period. Create a running total that adds|
| |up a period and resets to zero for the next period. The exercise uses dynamic tables but the formulas can be |
| |used with any table. |
|Array |Use and array formula or SUMPRODUCT to create a subtotal of all like items in a data array. |
|On Your Own |This repeats the exercise in SUMIFS without the use of dynamic tables. |
| | |
Course Details
Schedule: Half day of training
Number of Participants: 12
Class Format: Excel Spreadsheet Exercises
On your own exercises
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.