Tutorials
Examples
Exercises
Excel Introduction
Excel Basics
Excel Operations
CH-1 : Excel Version
HOW TO FREEZE A ROW
ADDING COMMENTS
ROW HEIGHT
COLUMN HEIGHT
HOTKEYS TO INSERT ROW
INSERT COLUMN
HIDING ROWS & COLUMN​
Test page
Maths Functions
Age Calculation
ABS
SUM Shortcut Key
COMBIN
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
FLOOR
INT
LCM
MAX
MIN
ODD
RAND
RANDBETWEEN
SUM
SUM as Running Total
SUM using names
SUM with OFFSET
SUMIF
SUMPRODUCT
LOGICAL FUNCTIONS
AND
NOT
OR
HLOOKUP
VLOOKUP
MATCH
INDEX
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
DATE & TIME FUNCTIONS
DATE
FORMATTING DATES
DATE FUNCTION
DATE TO TEXT
DATEDIF
DATE VALUE
DAY
EDATE
FORMATTING TIME
TIME VALUE
TIME CALCULATION
TIME
DAY
DAYS 360
TODAY
WEEK DAY
WORK DAY
EOMONTH
YEAR
YEAR FRAC
EXCEL
Welcome
EXCEL
NEXT