Professional Course

Utilizing Graphs and Charts in Microsoft® Excel®

1.5 hours
1.5 hours
This provider usually responds within 48 hours 👍

Course description

Utilizing Graphs and Charts in Microsoft® Excel®

Utilizing Graphs and Charts in Microsoft® Excel®

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, 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. 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.

Learning Objectives

  • You will be able to review chart terminology.
  • You will be able to discuss chart formatting options.
  • You will be able to recognize special features for 3-D charts.
  • You will be able to explain how to annotate a chart.

  • Do you work at this company and want to update this page?

    Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

    Who should attend?

    This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, bookkeepers and accountants.

    Training content

    • Selecting Data to Be Used in a ChartCreate Charts Instantly – Either on the Same Worksheet as the Data or on a Separate SheetChange the Chart Type: Column, Bar, Line, Pie, etc. – Selecting the Best Chart for the OccasionSetting up Charts Based on Noncontiguous Data or Based on Data From Different WorksheetsChange the Location of a Chart – From/To Current Worksheet, to/From a Separate SheetChart Terminology – Legends, Gridlines, Axes, Chart Area, Plot Area, Walls, Floors, etc.Moving, Copying, Resizing and Deleting Charts on a WorksheetQuick Entire-Chart Formatting OptionsReformatting Legends, Gridlines, Axes and BackgroundsAdding Labels, Error Bars and Trend Lines to ChartsSpecial Features for 3-D ChartsCombination Charts – Using Lines and Columns Together on the Same ChartAnnotating Charts – Adding Lines, Arrows, Boxes, Special Comments and Titles


    The cost of this Utilizing Graphs and Charts in Microsoft® Excel® live webinar is $99 per participant.

    Contact this provider

    Contact course provider

    Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
    If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
    Country *

    reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
    Lorman Education Services
    Lorman Education Services
    2510 Alpine Road
    54702 Eau Claire Wisconsin

    Lorman Education Services - Live and On-Demand Courses

    Lorman Education Services is a leading provider of online professional development and corporate training for organizations and individual professionals. For more than 30 years, Lorman has delivered relevant, high-quality, professional-level courses that cover a broad range of business and technical...

    Read more and show all training delivered by this supplier