Microsoft Excel: Charts, Dashboards and Reports

Course Overview

Microsoft Excel can be used to create quality presentation charts and graphs quickly and easily using the charting facility available in the application.

This course examines how basic charts can then be created and then customised using a variety of chart and graph styles and formatting effects to help communicate your data in an effective and interesting way.

CourseMonster has vetted every training supplier to ensure that you receive the best quality Microsoft training available.

Related Courses

• Microsoft Excel: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)
• Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)

Audience

Increasingly a working knowledge of ICT packages is becoming a core competence for every employee. This programme is therefore relevant to anyone within an organisation who may be required to prepare or present charts and graphs

Course Outline

The following topics will be covered:

• Introduction to creating charts
• Chart types
• Adding Objects
• User-defined custom charts
• Pivot Charts
• Multiple Axes
• Overlay charts
• Using Excel charts in other applications
• Charts and Functions