Course Content
Basic Of Excel
0/2
Understanding Cell References
00:00
wildcard characters in Excel
00:00
Text Formulas
0/1
Text Formula
Date & Time Functions
0/27
Introduction
Today & Now
DATE()
DAY()
DAYS()
DAYS360()
EDATE()
EOMONTH()
MONTH()
NETWORKDAYS()
NETWORKDAYS.INTL()
NOW()
WORKDAY and WORKDAY.INTL Function
TIME()
TIMEVALUE()
HOUR()
SECOND()
MINUTE()
TODAY()
WEEKDAY()
WEEKNUM()
ISOWEEKNUM()
WORKDAY()
WORKDAY.INTL()
YEAR()
YEARFRAC()
DATEVALUE()
Mathematical Functions
SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
0/3
Excel SUMIFS Function
Wildcard Characters in Excel
SUMIF Function
Lookup & Reference Functions
0/4
LOOKUP() 
VLOOKUP()
HLOOKUP()
XLOOKUP()
Choose, Index, Match
0/2
CHOOSE()
Index()
Downloadable files
0/1
Files
Advanced Excel

Navigation file –

Download File

Data Analysis File with Pivot Table –

Download File

 

DGET File-

Download File

 

Power Query file –

Download File

 

Previous
Next