25 Must-Know formulas and functions in Excel

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:

AutosumRelativeAbsoluteLinking sheetsIfAndOrNested ifCountifSumifAverageifSumifsCountifsAverageifsiferrorVlookupHlookupXlookupMatchIndexSubtracting datesNetworkdaysAdding days to a dateWorkdayWeekday/Weeknum

The course also includes the Excel file that is used in the video. It has the file before the changes, and then another copy of the file with all of the formulas and functions.

It also includes the presentation used .