Excel 2016: Advanced

Become your organization’s Excel 2016 expert by mastering the program’s advanced features and tools to deliver reliable data quickly and professionally. In this course, we’ll build on your existing knowledge of Excel 2016 to teach you high-level formulas, including advanced IF statements and complex lookup, logical and text functions, as well as formula auditing and error checking techniques. You’ll discover how to save time by automating with macros, using advanced PivotTable and PowerPivot features, and importing and exporting data. The course also covers how to use What-If Analysis tools, form controls and collaboration features to get more out of the Excel 2016 program.

This course is the third and final part in our 3-part series on Microsoft Excel 2016.
This course aligns with the CAP Body of Knowledge and should be approved for 2.25 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.