catraining

 

Microsoft Partner
Microsoft Excel Charts

Audience: Anyone needing to be able to communicate quantative information visually using Excel charts. This course includes a discussion of the standard chart types and how they should be best used.

Course Duration: Half day module to be combined with any other half day module in the Microsoft Office suite.

Course Types: Group bookings, public courses , 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Excel Charts training course is delivered at our training centre in London situated close to London Liverpool street station, training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Create basic Charts
    • Fine-Tune your Chart
    • Change Chart Options
    • Add Graphics
    • Change a Chart's Source Data
    • Print and Share Charts

  • Course Outline
    print this page
    Module 1: Creating Basic Charts
    • Selecting data to display as a chart
    • Creating in-cell charts with Sparklines
    Module 2: Fine-Tuning your Chart
    • Adding a chart element
    • Choosing a chart style from the gallery
    • Switching data rows and columns
    • Changing the chart's source data
    • Dealing with empty and hidden cells
    • Changing a chart's type
    • Changing the default chart type and creating a template
    Module 3: Changing Chart Options
    • Modifying axes
    • Adding, editing, and removing chart titles
    • Linking titles to content
    • Analysing data with trendlines
     
    Module 4: Adding Graphics
    • Using pictures as chart elements
    • Adding shapes and arrows
    • Adding floating text and text boxes
    • Understanding Specific Chart Types
    • Using column and bar charts
    • Using line charts
    • Using pie charts
    • Using area, stock, and XY charts
    • Using doughnut, bubble and radar charts
    Module 5: Changing a Chart's Source Data
    • Creating charts from multiple data sources
    • Creating dynamic charts that always show specific periods of data
    Module 6: Printing and Sharing Charts
    • Printing charts
    • Linking charts with Word and PowerPoint
     
      Microsoft

Call us now for further information Tel:08001601666