This course was 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 including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites

Basic knowledge of Microsoft Excel is essential with the follow pre-requisites: Have attended Microsoft Excel – Foundation Level; OR Able to switch between task applications

Able to perform basic calculation

The Outlines:-

Module 1: Calculating Data with Advance Formulas

Module 2: Organizing Worksheet and Table Data

Module 3: Presenting Data Using Charts

Module 4: Graphic Objects

Module 5: Enhancing and Customizing Workbook

Module 6: Streamlining Workflow

Module 7: Collaborating with others - Protect files

Module 8: Auditing worksheets

Module 9: Working with Multiple Workbooks

Module 10: Import Data

Module 11: Analysing Data

Module 12: Sorting and Filtering Data

Module 13: Analyzing Data Using Pivot

Module 14: Macro

Module 15: Linking and Embedding