Excel Charts and Graphs

You will learn on how to present information through the various types of Excel charts and graphs.

This training is offered Nairobi Kenya.

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

Conditional Formatting Graphs

Creating flexible graphs

Slicers and Timelines

Training Requirements

Microsoft Excel 2016 Professional Pro

Windows based Laptop – Minimum RAM (2GB)

Minimum 1GHz clock speed

Internet connection

Screen Resolution 1280x800

Training Methodology

Every delegate will be required to have a laptop with Microsoft 2016 professional pro (Activated) installed. There are some training aspects not available in Excel 2010 and the lower versions.

The training is practical and everyone shall be expected to practically participate.

Soft and hard copy training materials shall be provided.

Feedback & 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.

Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an exercise will be discussed prior to tackling the exercise).