Loading...
25 Must-Know Formulas and Functions in Excel
How to use the most popular formulas and functions in Excel.schedule1h
4.5(1448)
Tom Fragale
•
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
51 Courses
• 5917 Reviews
Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word...
About this course
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 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 in PDF format.
This course includes:
schedule1 hour on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Dec 9, 2021