25 Must-Know formulas and functions in Excel
25 Must-Know formulas and functions in Excel
Duration: 1h 13m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 433 MB
Genre: eLearning | Language: English
Duration: 1h 13m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 433 MB
Genre: eLearning | Language: English
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 .