Excel 2016 Essential Training provides in-depth training in Microsoft Excel, including the powerful IF, VLOOKUP, and COUNTIF family of functions; the search for a goal; and Solver.
Excel 2016 Essential Training provides information on mastering Excel, including the powerful family of IF, VLOOKUP, and COUNTIF functions. The course is designed for anyone looking to master Excel or consolidate their Excel skills.
In this course, you will learn how to enter and organize data, perform calculations with simple functions, use multiple worksheets, format data, create charts and pivot tables, and more. Apart from that, you will learn how to automate tasks with macros.
Dennis Taylor, a well-known LinkedIn Learning instructor and Excel expert, teaches the course. He has over 25 years of experience creating and training spreadsheets and has presented over 300 Excel seminars and courses in the United States and Canada.
The course lasts eight hours and 53 minutes and includes 15 modules:
- Getting started with Excel
- Data entry
- Creating formulas and functions
- Adjusting the layout and data of the worksheet
- Adjusting worksheet views
- Multiple worksheets and workbooks
- IF, VLOOKUP and power functions
- Security and sharing
- Data management features
- Data analysis tools
- Introduction to macros
At the end of the course, you will get a certificate of completion. The price for this course is a one-time purchase of $ 44.99 with a 30-day money-back guarantee.
Over 750,000 people have viewed this course. The course was first launched in September 2015, and learners love the short, easy-to-digest videos and in-depth training on the topic.