COURSEUS$131
25 Must-Know Formulas and Functions in Excel
How to use the most popular formulas and functions in Excel.
schedule 1 hour4.5(372 ratings)
starstar
starstar
starstar
starstar
star_halfstar
Created By Tom Fragale
-54%
US$60
auto_storiesINSTRUCTOR(S)
Tom Fragale
Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
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 hours on-demand video
signal_cellular_altIntermediate level
task_altNo preparation required
calendar_todayPublished At Dec 9, 2021
workspace_premiumCertificate of completion
errorNo prerequisites
lock1 year access
calendar_todayUpdated At Aug 8, 2024
HomepageBecome an InstructorLearnFormula PodcastsLatest IntelligenceLearnFormula BusinessTerms of useContact usPrivacy policyReport AbuseHelp Center
Copyright @ 2024 CPE QAS LearnFormula | Professional Development Course Marketplace