Excel Online Refresher (O.R.) Toolkit

Post Training Videos is to allow participant to easily and quickly refresh what they have learnt. The videos are created using the same common layman language that was used by the trainer in the class.  This will helps to easily trigger the memory the participants had from the training and reconnect with their learning easily.  

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

 

  • 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
  • T
  • TEXT
  • TRIM
  • UPPER
  • VLOOKUP
  • WATCH WINDOW
  • WEEKDAY
  • WORKDAY
  • XIRR: SCHEDULED IRR
  • XNPV: SCHEDULED NPV
  • YEAR
WhatsApp chat WhatsApp us