Mail us:
info@thestrategist.co.in
Caus:
+91 9961813730, 0484-4059310
Home
About
Data Analytics
Consulting
Training
Tutorials
Student Login MOS
Home Tab
Insert Tab
Page Layout Tab
Formulas Tab
Data
Top Topics
Excel VBA
Excel Functions
Date and Time
Math
Info
Logical
Statistics
Financial
Lookup & Reference
Text Functions
VBA Functions
MOS Certifications
excel tutorials
Formulas Tab >> Topics
Date/Time Functions
DAY (WS, VBA)
DAYS360 (WS)
DAYS (WS)
EDATE (WS)
EOMONTH (WS)
HOUR (WS, VBA)
ISOWEEKNUM (WS)
MINUTE (WS, VBA)
MONTH (WS, VBA)
NETWORKDAYS (WS)
NETWORKDAYS.INTL (WS)
NOW (WS, VBA)
SECOND (WS)
TIME (WS)
TODAY (WS)
WEEKDAY (WS, VBA)
WEEKNUM (WS)
WORKDAY (WS)
WORKDAY.INTL (WS)
YEAR (WS, VBA)
Math/Trig Functions
ABS (WS, VBA)
ACOS (WS)
ACOSH (WS)
ACOT
ACOTH
ASIN (WS)
ASINH (WS)
ATAN (WS)
ATANH (WS)
CEILING MATH(WS)
COMBIN (WS)
COS (WS, VBA)
COSH (WS)
COT
COTH
CSC
CSCH
DEGREES (WS)
EVEN (WS)
EXP (WS, VBA)
FACT (WS)
FACTDOUBLE
FLOOR.MATH
GCD
INT (WS, VBA)
LCM
LN (WS)
LOG (WS)
LOG10 (WS)
MDETERM (WS)
MINVERSE (WS)
MMULT (WS)
MOD (WS)
MROUND
MULTINOMINAL
ODD (WS)
PI (WS)
POWER (WS)
PRODUCT (WS
QUOTIENT
RADIANS (WS)
RAND (WS)
RANDBETWEEN (WS)
ROMAN (WS)
ROUND (WS)
ROUNDDOWN (WS)
ROUNDUP (WS)
SEC
SECH
SERIESSUM
SIGN (WS)
SIN (WS, VBA)
SINH (WS)
SQRT (WS)
SQRTPI
SUM (WS)
SUMIF (WS)
SUMIFS (WS)
SUMPRODUCT (WS)
SUMSQ (WS)
SUMX2MY2 (WS)
SUMX2PY2 (WS)
SUMXMY2 (WS)
TAN (WS, VBA)
TANH (WS)
TRUNC (WS)
Information Formulas
CELL (WS)
ERROR.TYPE (WS)
INFO (WS)
ISBLANK (WS)
ISERROR (WS, VBA)
ISFORMULA
ISLOGICAL (WS)
ISNA (WS)
ISNONTEXT (WS)
ISNUMBER (WS)
ISREF (WS)
ISTEXT (WS)
SHEET
Text Formulas
BAHTTEXT (WS)
CHAR (WS)
CLEAN (WS)
CODE (WS)
CONCAT (WS)
DOLLAR (WS)
EXACT (WS)
FIND (WS)
FIXED (WS)
INSTR (VBA)
LEFT (WS, VBA)
LEN (WS, VBA)
LOWER (WS)
MID (WS, VBA)
NUMBERVALUE (WS)
PROPER (WS)
REPLACE (WS)
REPT (WS)
RIGHT (WS, VBA)
SEARCH (WS)
T (WS)
TEXT (WS)
TEXTJOIN (WS)
TRIM (WS, VBA)
UNICHAR (WS)
UNICODE (WS)
UPPER (WS)
VALUE (WS)
Lookup and reference
Index and match
Vlookup Application 1
Vlookup Application 2
Vlookup Application 3
Defined Names (Name Manager section)
Manually
Defining Names Automatically
Deleting Name in Name Manager
Editing Name in Name Manager
