Excel 2016 Essential Training provides in-depth training on Microsoft Excel, including the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek; and Solver.
Excel 2016 Essential Training provides insights into mastering Excel, including the powerful IF, VLOOKUP, and COUNTIF family of functions. The course is designed for anyone looking to get the hang of Excel or solidify their Excel skills.
In this course, you’ll learn how to enter and organize data, do calculations with simple functions, work with multiple worksheets, format data, build charts and PivotTables, and more. Apart from that, you’ll learn how to automate tasks with macros.
Dennis Taylor, a well-known LinkedIn Learning instructor and Excel expert, delivers the course. He has over 25 years of experience in spreadsheet authoring and training and has presented over 300 Excel seminars and classes throughout the U.S. and Canada.
The course spans eight hours and 53 minutes and includes 15 modules:
- Getting Started With Excel
- Entering Data
- Creating Formulas and Functions
- Adjusting Worksheet Layout and Data
- Adjusting Worksheet Views
- Multiple Worksheets and Workbooks
- IF, VLOOKUP, and Power Functions
- Security and Sharing
- Data Management Features
- Data Analysis Tools
- Pivot Tables
- Introduction to Macros
At the end of the course, you’ll get a certificate of completion. The pricing for this course is a one-time purchase of $44.99 with a 30-day money-back guarantee.
More than 750,000 people have viewed this course. The course was first launched in September 2015, and learners like the short and easy-to-digest videos as well as the in-depth training on the subject.