MS Excel 2007 - Level 3

s This course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft Office Excel, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

After completing this course, students will be able to:

Find Optimal Solutions by Using Solver Analyze Data by Using Descriptive Statistics Analyze Data Dynamically by Using PivotTables Filter, Show, and Hide PivotTable Data Create Dynamic Charts by Using PivotCharts Create and Modifying Macros Run Macros When a Button Is Clicked Store Workbooks as Parts of Other Office Documents Paste Charts into Other Documents Manage Comments Track and Manage Colleagues Changes Authenticate Workbooks Save Workbooks for the Web

Mode of delivery: Fully instructor-led classroom training
Duration:  8 hours

For more information click Course Details