Excel 2013
Advanced Formulas and Functions
Heads up! This course may be archived and/or unavailable.
Become an Excel 2013 Microsoft Office Specialist,
Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to 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 | 5h 26m |
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 | Data Science Business |
Tags | Data Analysis 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.
Jet magazine entertainment writer, copy editor, co-managing editor, features editor $47k
Assistant Staff Arts & Entertainment/Features writer $52k
Acting Features Editor $58k
Editor of Features Production $58k
Special Features Journalist $59k
Columnist/Features Writer $63k
Assistant Features Apprentice $63k
Features Department Coordinator $64k
Features Writer & Online Producer $73k
Senior Features Apprentice $74k
Senior consulting features editor $89k
Deputy features news editor $95k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 5h 26m |
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 | Data Science Business |
Tags | Data Analysis 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