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.

Learning objectives:

• Use advanced formulas and functions such as SUMIF, AVERAGEIF and COUNTIF
• Ensure data integrity by protecting worksheets and workbooks
• Save time and effort by automating using macros
• Apply advanced features to PivotTables and PowerPivot
• Make data entry on worksheets easier and improve readability using form controls
• Import and export data to a text file