## 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
• Waterfall graphs
• Combination Charts
• Trendlines in models
• Goalseeking straight off the graph
• Conditional Formatting Graphs
• Creating flexible graphs
• Reporting – Methods to get your message across based on the results of the financial model

## Excel knowledge required:

1. Basic Excel skills
• Opening & closing files
• 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

## 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

## Excel 2010 new features

• 29:00
• Skill Level:
• What's my skill level

• 03:14
• Skill Level:
• What's my skill level