https://www.skillshare.com/classes/25-Must-Know-formulas-and-functions-in-Excel/1548357693
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 .
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.