Chart Like a Pro


Who Should Attend

Experienced users of Excel who now wish to increase their efficiency and effectiveness to develop more complex spreadsheet models. Participants are expected to be proficient with building simple financial models without the use of macro.

Class limit:
16 participants

Facilitators
Mr. Paul Toh
Duration
1 Day
Intakes & Registrations
Click on your preferred date below to register. Only online registrations will be accepted.

Intake 01

2 May 13

Intake 02

Fee
S$500 (Inclusive of GST)
Venue
10 Kent Ridge Crescent Block ADM, Level 6

Course Objectives

By the end of the course, participants should be able to understand the concepts of charting and demonstrate the ability to create and use charts in-depth; accomplish operations associated with developing, formatting and using charts in Microsoft Excel.

Course Outline

  • Chart Plotting Tricks
    -     Plot it once, use it many times
    - Not plotting empty cells
    - Changing data range quickly
  • Chart Formatting Techniques and Tricks
    -     Charting with conditions
    - Fixing font auto-scaling manually
    - Squeezing out blank columns in series
    - Displaying variable column widths in a column chart
    - Displaying a column chart with two Y axes
    - Jazz up your data markers
  • Handling Combination Charts
    -     Row out your own combination charts
    - Adding a horizontal or vertical line to a chart
    - Vertical categories axis
  • Dynamic and Interactive Charts
    -     Expanding your chart on the fly to include new data
    - Charting the last twelve months’ data dynamically
    - Interactive charting using combo box or check box
  • Chart Axes and Axis Tricks
    -     Tertiary Y axis
    - Arbitrary axis scale
    - Arbitrary gridlines
    - Staggered axis labels
    - Broken Y axis

 

Who Should Attend
This course is useful for all persons who need to use Microsoft Excel to produce charts.