One of the best LinkedIn studying programs in 2021
Excel 2016 Essential Training provides comprehensive training on Microsoft Excel, including the powerful IF, VLOOKUP, and COUNTIF family of functions; the target search; and solver.
Excel 2016 Essential Training provides insights into mastering Excel, including the powerful IF, VLOOKUP, and COUNTIF family of functions. The course is aimed at anyone who is familiar with Excel or who wants to consolidate their knowledge of Excel.
In this course, you will learn how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format data, create charts and PivotTables, and much more. You will also learn how to automate tasks with macros.
Dennis Taylor, a well-known LinkedIn Learning teacher and Excel expert, leads the course. He has over 25 years of spreadsheet creation and training and has given over 300 Excel seminars and courses in the United States and Canada.
The course is eight hours and 53 minutes and includes 15 modules:
- Getting started with Excel
- Enter data
- Create formulas and functions
- Customize the worksheet layout and data
- To press
- Customizing worksheet views
- Multiple worksheets and workbooks
- IF, VLOOKUP, and performance functions
- Security and Sharing
- Data management functions
- Data analysis tools
- Pivot tables
- Introduction to macros
At the end of the course you will receive a certificate of completion. The price 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 started in September 2015 and learners like the short and easy-to-understand videos as well as the in-depth training on the subject.