DESCRIPTION
Put Excel’s Advanced Charting Tools and Options to Use to Create Excel Charts and Graphs
Creating charts in Excel has long been one of its most popular features. Numerical information can be boring and some of us just don’t read and absorb the meaning of such data until we see the information depicted in a chart. Charting is a powerful and easy-to-use Excel feature that lets users quickly display numerical information in an appealing and concise way. You can create an Excel chart with just a few keystrokes or mouse clicks and can easily alter a chart’s appearance by changing its type into a line, bar, pie, or column chart as well as numerous other types.
Despite the overwhelming number of charting tools and options, you can quickly learn more about the tools you need to create charts with ease and confidence. Join this webinar with expert speaker Dennis Taylor and 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 also learn the best ways to adjust chart elements, add gridlines, change background colors, adjust scaling, insert titles, insert ClipArt images, insert trendlines, and add functionality, and pizzazz to your charts with simple formatting techniques.
Learning Objective:
- 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; select the best chart for the occasion
- Set up charts based on noncontiguous data or based on data from different worksheets
- Move, Copy, Resize, or Delete charts on a worksheet
- Reformat legends, gridlines, axes, backgrounds
- Add labels, error bars, and trendlines to charts
- Use special features for 3-D charts
- Create Combination charts—use lines and column together on the same chart
- Set up dynamic charts (those that grow daily, weekly, or monthly) with Excel’s new Table feature
- Adjust Themes to quickly apply multiple formatting features
- Use Conditional Formatting to add color data bars and icons based on values
- Use Form controls to simplify data entry/editing with visual tools like spinner arrows and scroll bars
Session Highlights:
- How to select source data for a chart from non-adjacent ranges or from multiple sheets
- Learn the fastest ways to create a chart – one keystroke shortcut to create a chart on the same sheet as the source data, another keystroke shortcut to create a chart on a separate sheet
- Learn which chart types are best for the data being depicted and how to change types quickly
- Learn how to insert trendlines and adjust gridlines and axes
- Learn how to annotate charts with data labels, arrows, and boxes
- Set up dynamic charts (those that grow daily, weekly,monthly or yearly) with Excel’s Table feature
- Create in-cell charts with Sparklines
Who should attend:
- C-Level Executives
- Executive Assistants
- Accountants
- Administrators
- Office Managers
- Attorneys
- CPAs
- Finance Professionals
- Business Analysts
- Bookkeepers
- HR Professionals
