Skip to the content
Advanced Excel
Files
Advanced Excel
0%
Completed
Basic Of Excel
Understanding Cell References
Video - 00:00:00 mins
wildcard characters in Excel
Video - 00:00:00 mins
Text Formulas
Text Formula
Reading
Date & Time Functions
Introduction
Reading
Today & Now
Reading
DATE()
Reading
DAY()
Reading
DAYS()
Reading
DAYS360()
Reading
EDATE()
Reading
EOMONTH()
Reading
MONTH()
Reading
NETWORKDAYS()
Reading
NETWORKDAYS.INTL()
Reading
NOW()
Reading
WORKDAY and WORKDAY.INTL Function
Reading
TIME()
Reading
TIMEVALUE()
Reading
HOUR()
Reading
SECOND()
Reading
MINUTE()
Reading
TODAY()
Reading
WEEKDAY()
Reading
WEEKNUM()
Reading
ISOWEEKNUM()
Reading
WORKDAY()
Reading
WORKDAY.INTL()
Reading
YEAR()
Reading
YEARFRAC()
Reading
DATEVALUE()
Reading
Mathematical Functions
SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
Excel SUMIFS Function
Reading
Wildcard Characters in Excel
Reading
SUMIF Function
Reading
Lookup & Reference Functions
LOOKUP()Â
Reading
VLOOKUP()
Reading
HLOOKUP()
Reading
XLOOKUP()
Reading
Choose, Index, Match
CHOOSE()
Reading
Index()
Reading
Downloadable files
Files
Reading
More
Announcements
Reviews
Course Info
Navigation file –
Download File
Data Analysis File with Pivot Table –
Download File
Â
DGET File-
Download File
Â
Power Query file –
Download File
Â
Login
Sign Up
Remember me
Forgot Password?
Sign in
I accept the
Terms of Service and Privacy Policy
Sign Up
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
Email Reset Link
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway