In today’s world, it’s an absolute must that you know Microsoft Excel for most office jobs. There’s some formulas and functions that will make your use of Excel more productive . This course shows you how to use 25 “Must-Know” formulas and functions.
Topics:
Autosum
Relative
Absolute
Linking sheets
If
And
Or
Nested if
Countif
Sumif
Averageif
Sumifs
Countifs
Averageifs
iferror
Vlookup
Hlookup
Xlookup
Match
Index
Subtracting dates
Networkdays
Adding days to a date
Workday
Weekday/Weeknum
The course also includes the Excel file that is used in the video.
It also includes the presentation used in PDF format.
StudentFileNew - This file has all of the sheets mentioned used in the course.