Excel O.R Toolkits

Excel in Excel !



                                   


Post Training Videos allows participant to easily and quickly refresh what they have learnt. The videos are created using the same common layman language as what was used by the trainer in the class. This will easily trigger the memory and reconnect with what the participants have learnt easily.

We have as many as 77 Online Refresher videos for easy reference. Refresh your learning anytime! Anywhere! Your style! Your pace!

You will receive the link to download the videos once you have signed up as member and have attended any of our Excel training program:





Below is the list of videos for the Excel O.R Toolkits:

AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BUBBLE CHART
CLEAN
COLUMN
COLUMN CHART
COLUMNS
CONDITIONAL FORMATTING
CONTROL KEY - CORE
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DATA TABLE
DATA VALIDATION
DATEDIF
DAY
EDATE
EOMONTH
FIND
FREEZE PANE
FUTURE VALUE
HLOOKUP
IFERROR


HYPERLINK
IF
INDEX
INDIRECT
IRR: INTERNAL RATE OF RETURN
LARGE
LEFT
LEN
LINE CHART
LOWER
MACRO
MATCH
MAX
MID
MIN
MIRR: MODIFIED IRR
NETWORKDAYS
NPV: NET PRESENT VALUE
OFFSET
PIE CHART
PMT
PROPER
PROTECT FILE
PROTECT SHEET
REPT
RIGHT
ROUND


ROW
ROWS
SIGN
SLN: STRAIGHT LINE DEPRECIATION
SMALL
SPARKLINE
SPIN BUTTON
SPLIT WINDOW
SUBSTITUTE
SUMIF
SUMIFS
SUMPRODUCT
TEXT
TRIM
UPPER
VLOOKUP
WATCH WINDOW
WEEKDAY
WORKDAY
XIRR: SCHEDULED IRR
XNPV: SCHEDULED NPV
YEAR