Advanced Excel 2019 Techniques & Tools
Excel 2019 - Advanced
Overview
This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.
Course Playlist
For Business
Give your team access to award-winning training content on the most popular software & business skills. We have options for every budget, with tiered pricing available on user count and multi-year discounts automatically applied.
Intellezy Select 50
Build a custom 50-course library from the Intellezy complete library.
Intellezy Full Library
Access to full library of courses, including 11,000+ video lessons.
Your subscription includes:
The Most-Up-to-Date Contentt
Content Available in 20+ Languages
Course Assessments & Downloadable Files
Deliverability via Your SCORM-Compliant LMS or Our Easy-to-Navigate Platform
And More!
Billed Monthly
$15/month
$180 total annually
Billed Annually
$12.50/month
$150 total annually
Your subscription includes:
11,000+ Video Lessons
Content Available in 20+ Languages
The Most-Up-to-Date Content
Content Available in 20+ Languages
Course Assessments & Downloadable Files
And More!