Next Live Training Date:

10- 14 June, 2013

Excel Charts and Graphs

This practical ½ – day Excel charts training course leads delegates through Excel’s charting and graphing tools.

In order to do this course we recommend a skill level of >3 (we offer a free Skills Assessment to make sure you get the correct level of training).

This is a very hands-on, non-intimidating, course – delegates work through various exercises under the supervision, and with the help, of the facilitator to get to grips with the nuances of Excel’s charting tools.

Ask for more details on price and venue by clicking here

Who Should Attend

  • All persons using Excel spreadsheets
  • All persons involved in the construction and use of financial models, including budgets, projections, evaluations, cash flows, projects, etc.
  • All delegates should have a score of above 4.5 on our Excel Skills Assessment
  • Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an excercise will be discussed prior to tackling the exercise).

Course Outline

  • Getting the Data right for Graphing
  • Understanding Excel graphs and incorporating them into your model
  • Adding another series to a graph
  • Creating a secondary axis in a chart
  • Changing default colouring to match corporate colours
  • Create a chart template for consistent use
  • Different Chart Types
    • Column Charts
    • Bar Charts
    • Pie Charts
    • Area Charts
    • Radar
    • Waterfall graphs
    • Combination Charts
  • Trendlines in models
  • Goalseeking straight off the graph
  • Linking your Word documents directly to the Excel graph
  • Conditional Formatting Graphs
  • Creating flexible graphs
  • Reporting – Methods to get your message across based on the results of the financial model

Pre Requisite (s)

Excel knowledge required:

  1. Basic Excel skills
  • Opening & closing files
  • Moving around the spreadsheet
  • Inserting & deleting rows and columns
  • Inserting text & formulas
  • Deleting cells
  • Copying formulas
  • Printing
  1. Basic formulas (+-*/) e.g. =C5+C7+sum(C9:C12), and =D5*D6/12 3. Formatting
  2. Formatting

Handy Tips & Tricks

Discounting cash flows with multiple discount rates

Discounting cash flows with multiple discount rates As financial models become more sophisticated users are starting to look at discounting the cash flows with multiple discount rates. However, we have noticed during our financial modelling training courses that this is … Continue reading →

Advanced Excel and Financial Modeling Training in July and August 2013

Advanced Excel and Financial Modeling Training in July and August 2013 Over the next 2 months we will be running a number of Excel related courses. In particular we will be covering Advanced Excel and Financial Modeling training. The dates … Continue reading →

I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.

– Melco Conveyor Equipment (Pty) Ltd

Video Library & Tutorials //

View Entire Video Gallery ››

Excel 2010 new features

Excel 2010 new features

Spreadsheet tests

Spreadsheet tests

Spreadsheet Change Control

Spreadsheet Change Control

Waterfall chart using stock charts

Waterfall chart using stock charts

Some of our Featured Clients