Excel
Advanced Formulas and Functions
Follow along with Excel expert Dennis Taylor as he demystifies the hundreds of formulas and functions available in Excel. Dennis starts with a few critical formula shortcuts that will speed up your work, then covers a variety of functions, such as VLOOKUP, MATCH, and INDEX, statistical functions, text functions, and date and time, math, text, and information functions. Dennis provides practical examples to help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios. Note that this course is recorded in Excel for Office 365 but anyone using a recent version—including 2019, 2016, and 2013—will be able to follow along.
Contents:
- Introduction
- 1. Formula and Function Tips and Shortcuts
- 2. IF and Related Functions
- 3. Lookup and Reference Functions
- 4. Power Functions
- 5. Statistical Functions
- 6. Math Functions
- 7. Date and Time Functions
- 8. Reference Functions
- 9. Text Functions
- 10. Information Functions
- Conclusion
Get a Reminder
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Colorist Expert $34k
Negotiator Expert $38k
English Language Development, AVID & AVID Excel Teacher $53k
Transportation Expert $54k
Hairstylist Expert $59k
Excel Reporting Developer $68k
F/A Expert $70k
Excel/Access DTS Developers $78k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
MBB Expert $109k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course