Visualizing Excel Data with SmartArt and Charts

Use a SmartArt graphic if you want to do any of the following:

 » Create an organization chart or Excel sparkline charts

 » Show hierarchy, such as a decision tree

 » Illustrate steps or stages in a process or workflow

 » Show the flow of a process, procedure, or other event

 » List information

Use a chart if you want to do any of the following:

 » Create a bar chart or column chart

 » Create a line or XY scatter (data point) chart

 » Create a stock chart, used to graph various stock prices

 » Create a surface, donut, bubble, or radar chart

 » Create a combination chart, such as a bar and line chart

Why Should You Attend

They say that ‘a picture is worth a thousand words’. Using SmartArt and Charts to visually display complex Excel data helps in communicating the data’s message much more effectively to your target audience.

SmartArt graphics and Charts can be created not just in Excel, but also in PowerPoint, Word and Outlook. This makes learning these tools extremely useful.

In addition, you’ll get tips and tricks along the way to help you save time and make your job of data visualization with advanced Excel easier and more efficient.

Areas Covered in the Session:

Creating SmartArt Diagrams

 » Inserting diagrams

 » Modifying illustrations

 » Formatting shapes and SmartArt

 » Convert bulleted text into SmartArt

Creating Charts

 » Types of charts

 » Creating a chart

 » Parts of a chart

 » Changing the chart type

 » Switching data

 » Changing the chart style

 » Moving a chart to a chart sheet

 » Creating a combination chart

Who Will Benefit

 Anyone using MS Office in a business or educational setting to create reports and presentations