This live webinar will show you quick ways to create charts, explore which chart types work best for different data, and give you tips on when and how to add gridlines, change background colors, adjust scaling, insert titles, re-configure 3-D charts, insert clip art images and add trend lines. You can add both functionality and eye-appeal to your charts with simple formatting techniques.
This audio conference will allow the speaker to walk through examples in real time. This will be the best way to follow along with the program and a link will be provided for you prior to the program date.
Why should you Attend:
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.
You will learn the best and fastest ways to prepare data for charts, and create and modify them with a minimum of effort. 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 eye-appealing features.
Areas Covered in the Session:
Who Will Benefit:
- Selecting data to be used in a chart
- Create charts instantly - either on the same worksheet or on a separate sheet
- Setting up charts based on noncontiguous data or on data from different worksheets
- Change the chart type: column, bar, line, pie - selecting the best chart for the occasion
- 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, re-sizing and deleting charts on a worksheet
- Quick entire-chart formatting options
- Re-formatting legends, gridlines, axes and backgrounds
- Adding labels, error bars and trend lines to charts
- Special features for 3-D charts
- Combination charts - lines and columns together on the same chart
- Annotating charts - adding lines, arrows, boxes, special comments and titles
- Handling date labels in charts
- Using the Table tool for effectively creating dynamic charts
- Any Excel user who deals with large lists needs these tools and techniques to effectively manage the lists and become more productive. Nearly all Excel users, except for those just getting started, are candidates for this webinar
Dennis Taylor has worked extensively with Microsoft Excel since the mid-1990s. He's traveled the United States and Canada presenting seminars and classes to help attendees unlock the full potential of Excel.
Accomplishments: Dennis has authored and presented nearly 700 webinars on various Excel topics in the past 11 years. He has also produced numerous Excel courses on video, CD, and DVD and has taught more than 500 seminars and over 5,000 classes on the subject. Dennis is the author/presenter of over 200 hours of online Excel courses available at LinkedIn Learning. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field.
He's taught for numerous corporations, government agencies and colleges and universities, including: Northrop-Grumman, Raytheon, Levi Strauss, Chevron, BP, IBM, Apple, Driscoll's, Amgen, AT&T, Qwest, Anheuser-Busch, Starz-Encore, University of Phoenix, University of Colorado, US Department of Labor, Bureau of Land Management, Great-West Life Insurance, Texaco, Lexmark, Time-Warner, Environmental Protection Agency, National Seminars, and the Cities of Denver, Boulder, Longmont, and Westminster, CO.