COURSE DESCRIPTION: This intermediate level course will expand on introductory Microsoft training to cover working with functions and lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.

Learning Objectives:

This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.

AVERAGE STUDY TIME: 4-5 HOURS

Completion of this course delivers a 4PRO+ CERTIFICATE OF PROFICIENCY and includes a BADGE/SEAL for the Certificate of Microsoft Office Excel Proficiency - Level II (4CMOEP2) course which has been reviewed and approved by the 4ProPlus Educational and Technical Advisory Boards.