Excel 2016
Advanced Formulas and Functions
Improve Your Microsoft Excel Skills,
Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula cells and accelerate working with Excel formulas—even on multiple sheets. He then covers how to find and retrieve data with the VLOOKUP and INDEX functions, calculate totals with counting and statistical functions, extract data with text functions, and work with date, time, array, math and information functions. The course focuses on practical examples that will help viewers easily transition to using Excel's most powerful formulas and functions in real-world scenarios.
Contents:
- Introduction
- 1. Formula and Function Tips and Shortcuts
- 2. Formula and Function Tools
- 3. IF and Related Functions
- 4. Lookup and Reference Functions
- 5. Power Functions
- 6. Statistical Functions
- 7. Math Functions
- 8. Date and Time Functions
- 9. Array Formulas and Functions
- 10. Reference Functions
- 11. Text Functions
- 12. Information Functions
- Conclusion
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 6h 18m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Dennis Taylor |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Business |
Tags | Business Spreadsheets Microsoft Excel |
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
Rating | Not enough ratings |
---|---|
Length | 6h 18m |
Starts | On Demand (Start anytime) |
Cost | $29/month (Access to entire library- free trial available) |
From | LinkedIn Learning |
Instructor | Dennis Taylor |
Download Videos | Only via the LinkedIn Learning mobile app |
Language | English |
Subjects | Business |
Tags | Business Spreadsheets Microsoft Excel |
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