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