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).
- 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
- 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:
- Basic Excel skills
- Opening & closing files
- Moving around the spreadsheet
- Inserting & deleting rows and columns
- Inserting text & formulas
- Deleting cells
- Copying formulas
- Basic formulas (+-*/) e.g. =C5+C7+sum(C9:C12), and =D5*D6/12 3. 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