Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per course

£495 for any two half day courses +VAT
Client site, max 10 individuals

Duration

Half day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

Contact us for the latest course dates.

Book course

This course is intended for users of Microsoft Excel who need to interpret values in graphical format to show highs, lows and data trends.

Objectives: 

By the end of the course users will be able to create charts in a variety of layouts to interpret single or multiple data values. Users will be able to manipulate the layout of charts and include detailed options such as trend lines and values.

Prerequisites: 

Delegates attending this course should be able to navigate efficiently within spreadsheets and perform common commands such as sorting, filtering, selecting and formatting data.

Download Outline (PDF)

Chart Basics
  • Understanding Chart Types
  • Creating Charts
    • On an Existing Worksheet
    • On a New Worksheet
  • Creating Charts with the Quick Analysis Tools
  • Moving & Resizing Charts
  • Understanding Chart Elements
  • Changing Chart Data
  • Applying Styles & Chart Layouts
Designing Charts
  • Manipulating Chart Elements
    • Titles
    • Legends
    • Data Tables
    • Data Labels
  • Formatting Individual Chart Elements
  • Manipulating 3-D Charts
  • Adding Trend Lines
  • Creating a Custom Chart Template

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.