Mastering Excel® Charts and Graphical Features

  • Business Enhancement Skills
  • Course Code: 62071
Quickly Craft Effective Presentations and Reports from Your Spreadsheets
 
This interactive, 90-minute webinar explores the visual and graphical Excel features you can use to add functionality and pizzazz to your worksheets and charts. 
 
You’ll gain quick methods for creating charts, how (and why) to use different chart types and how to alter the look of a chart with layout, color, and content changes.
 
One often overlooked benefit of this course: depicting your 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 power and flair to enliven all of your presentations and reports.
 
For example, you’ll hear how to quickly add gridlines, change background colors, adjust scaling, insert titles, re-configure 3-D charts, and add trendlines.
 
In a nutshell, you’ll get simple and powerful tips for making your data more readable and understandable. In addition to a myriad of Charting tips, you’ll also learn how to use:
  • Themes (for consistent colors and fonts)
  • Tables (to organize lists and set up dynamic charts)
  • Conditional Formatting (to accentuate your data with color bars and icons)
  • Form Controls (including Check Boxes, Spin Buttons, and Scroll Bars) to enter data without typing
 

How You Will Benefit

After completing this course, you will be able to:

Apply formatting techniques and presentation styles to Excel spreadsheets

Demonstrate working knowledge of using graphics and charts to enhance ideas and information in Excel worksheets

 

Who Should Attend

 

Related Courses

Stay Connected

Copyright © 2017 CANADIAN MANAGEMENT CENTRE - PROFESSIONAL DEVELOPMENT, MANAGEMENT & CAREER TRAINING | 33 Yonge Street, Suite 320, Toronto, Ontario M5E 1G4, Canada | cmcinfo@cmcoutperform.com