Excel Workshop for Charts and Pivot Tables

Course Description

Extensively used in Excel Spreadsheets and Business Intelligence Software, Pivot table and charts are important data processing tools!

What does Pivot Table and Chart do?

• A pivot table generates and extracts meaningful information from a large table of information.
• A pivot chart is an interactive graphical representation of the data in a Pivot Table.

Benefits of using pivot tables and charts:

• Creates an interactive summary from many records
• Creates a quick summary of text entries
• Sums up large amount of info in less space
• Efficient use of data
• Organizes your data
• Interactive Data Analysis

Designed for effective time management, Pivot table and chart are used extensively by organizations and businesses around the world.

Excel Workshop For Charts and Pivot Tables contains comprehensive courseware : 3 PPTs+ 1 PDF + 8 training exercises files to make you familiar with charts and tables and their usage.

By the end of the course you will be able to:

• Prepare and produce a variation of Charts
• Adjust settings and customise Chart options
• Create and work with Pivot Tables
• Customise Quick Access Toolbar
• Create Hyperlinks and XML files

This online course also prepares you for the following examinations:

ICDL, MOS, SA MICTSETA!

What’s in the course:

• Courseware : 3 PPTs+ 1 PDF
• 8 documents covering training exercises