Workshop Excel 2013 Advanced Charting

Course details

In our day to day work environment we tend to use Excel’s great features of calculation, sorting and of storing information to create efficient, functional spread sheets. It’s easy and fairly straightforward. However, there are other elements within Excel that can transform spread sheets into powerful and efficient business tools. The data analysis features such as Charts can extract and summarise essential information from larger data sources – making the complex appear simple. That’s why SureSkills have developed this unique set of half-day courses allowing you to get even more from your investment in Microsoft Excel. Check out what you will learn in our new Advanced Charting course:

Objectives

• This workshop is designed to provide a focused and timeeffective approach to learning these features. Each session is intensive, concentrating on just one of these additional elements. This gives the student the chance to explore the topic thoroughly and to evaluate its potential for their own work and business situation.
• The duration of each workshop is deliberately short – to reduce the impact of time spent away from the office. In addition, the workshop can be tailored to meet your personal needs and business requirements addressing issues which are of particular concern in your business environment.

Content

• Creating charts – using the keyboard, the Quick Analysis Tool and Recommended Charts
• Selecting the right chart type
• Identifying chart elements
• Adding data to chart – changing the source of chart data
• Creating charts from multiple data sources
• Formatting elements in Chart
• Formatting text in titles & legends – using WordArt & special effects
• Adding drawing elements – arrows, call-out boxes etc
• Modifying Axes
• Using Sparklines, Trendlines and error bars
• Dual Axis Charts
• Adding Drop lines and up-down bars
• Creating dynamic charts that always show the most recent updates in the data
• Creating combination charts and specific need charts – waterfall charts, gnat charts
• Copying and embedding charts in Word or PowerPoint

Prerequisites

• The delegates should already be using Excel on a regular basis.
• They should be familiar with creating and editing spreadsheets and with the basics of calculation and formatting

Who should attend?

• Those who are familiar with the basics of Excel but who wish to learn more about the capabilities of Charting.
• Those who want to visually maximise the visual impact of their data.