Course Description
Learn the best and fastest ways to prepare data for charts, and create and modify them with a minimum of effort.
Any Excel user who needs quick methods to show numerical information in a visual way needs to know the basics of chart creation, how (and why) to use different chart types, and how to alter the look of a chart with layout, color and content changes. Depicting data in a chart may reveal a trend that was not so obvious in the numerical data, which often can be dry and boring. That elusive meaning, buried in the obscurity of a sea of numbers suddenly springs to life in a chart you get the big picture at a glance and Excel gives you a ton of formatting tools to add flair and pizzazz that enliven presentations and reports.
Learn quick ways to create charts, explore which chart types work best for different data, and get tips on when and how to add gridlines, change background colors, adjust scaling, insert titles, reconfigure 3D charts, insert clip art images and add trend lines. You can add both functionality and eyeappeal to your charts with simple formatting techniques.
You will also learn about the various chart types and which ones are most effective for the type of data being depicted. You will learn the best ways to adjust colors, gridlines, legend placement and scaling, and how to quickly change the overall appearance of a chart and add numerous eyeappealing features.
Audience
This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers and accountants.
Agenda
Selecting Data to Be Used in a Chart
Create Charts Instantly � Either on the Same Worksheet as the Data or on a Separate Sheet
Change the Chart Type: Column, Bar, Line, Pie, etc. � Selecting the Best Chart for the Occasion
Setting up Charts Based on Noncontiguous Data or Based on Data From Different Worksheets
Change the Location of a Chart � From/to Current Worksheet, to/From a Separate Sheet
Chart Terminology � Legends, Gridlines, Axes, Chart Area, Plot Area, Walls, Floors, etc.
Moving, Copying, Resizing and Deleting Charts on a Worksheet
Quick Entire-Chart Formatting Options
Reformatting Legends, Gridlines, Axes and Backgrounds
Adding Labels, Error Bars and Trend Lines to Charts
Special Features for 3-D Charts
Combination Charts � Using Lines and Columns Together on the Same Chart
Annotating Charts � Adding Lines, Arrows, Boxes, Special Comments and Titles