Excel Charting Basics - Produce Professional-Looking Excel Charts - Part 1

Speaker

Instructor: Joe Weil
Product ID: 704604

Location
  • Duration: 90 Min
This training program will help attendees learn Excel charting techniques including using the ribbon to create the chart, creating charts instantly with shortcuts, moving and resizing a chart, adding title headings, axis titles and gridlines to a chart, and more.
RECORDED TRAINING
Last Recorded Date: Jun-2016

 

$129.00
1 Person Unlimited viewing for 6 month info Recorded Link and Ref. material will be available in My CO Section
(For multiple locations contact Customer Care)

$249.00
Downloadable file is for usage in one location only. info Downloadable link along with the materials will be emailed within 2 business days
(For multiple locations contact Customer Care)

 

 

Customer Care

Fax: +1-650-362-2367

Email: [email protected]

Read Frequently Asked Questions

Why Should You Attend:

In this webinar, the instructor will illustrate how best to display data with charts using Excel. This webinar will begin with the basics: how to select your data, use the ribbon, the special chart toolbar and which three charts work best for 90% of your data. The course then shows attendees how to use editing tools to create professional-level charts and how to format and fine-tune your charts for effective data presentation. A picture is worth a thousand words when you learn professional charting techniques in just one hour.

A few Excel essentials that this session will cover:

  • Pie charts using a budgeting example
  • Bar charts using a revenue analysis by product line and city example
  • XY Scatter Chart for easy, rapid linear regression analysis (line chart)

Other training programs in this Excel series:

Learning Objectives:

  • Using the ribbon to create the chart
  • Selecting the proper type of chart from the chart pallet
  • Creating charts instantly with shortcuts
  • Choosing a layout
  • Moving and resizing a chart
  • Adding title headings, axis titles and gridlines to a chart
  • Analyzing existing and future data with trend lines

Areas Covered in the Webinar:

  • Charting Basic Concepts
    • Ribbon, Plot Area, Chart Area and Special Ribbon for Charts
    • Selecting Your Data and Chart - Three Most Basic Types - Purposes
    • Menu Commands, Shortcuts and Placement of Your Chart
  • Two Basic Examples Made Beautiful in Minutes
    • Pie Chart Example - Municipal Revenues
    • Column Chart Example - Revenue, Product Line and Location
    • Using the Page Layout Galley
  • Spark Lines
    • Line, Column, Win/Loss
    • Using the Design Tab Effectively - Manipulating Column Height and Width for Effect
  • Fine Tuning Your Chart
    • Editing Your Chart - Titles, Labels, Legends, Grid Lines, Formatting, and More
    • Using the Design Tab Effectively
  • Using the XY Scatter Graph for Easy, Rapid Linear Regression Analysis
    • Organizing Data - Dependent and Independent Variables - X, Y
    • Using Trend Lines, Options Menu, Equation and Rho Coefficient
    • Display Features

Who Will Benefit:

Managers, supervisors, financial professionals, administrative assistants, sales professionals, marketers — anyone who uses Microsoft Excel and wants to save hours, avoid using cumbersome tables and analyze data in the most proficient manner possible.

  • Banking
  • Finance
  • Marketing
  • Sales
  • Investments
  • Pharmacy
  • Accounts
  • Audit

Instructor Profile:

A former corporate controller and director of auditing, Joe Weil, CPA, has 25+ years of Excel instruction/presentation experience. He holds a Master of Accounting degree and is a college Excel and auditing professor. Mr. Weil has led over 400 Excel presentations.

Follow us :

 

 

Refund Policy

Our refund policy is governed by individual products and services refund policy mentioned against each of offerings. However in absence of specific refund policy of an offering below refund policy will be effective.
Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange. Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time. On-Demand Recording purchases will not be refunded as it is available for immediate streaming. However if you are not able to view the webinar or you have any concern about the content of the webinar please contact us at below email or by call mentioning your feedback for resolution of the matter. We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email [email protected] call +1-888-717-2436 (Toll Free).

 

 

+1-888-717-2436

6201 America Center Drive Suite 240, San Jose, CA 95002, USA

Follow Us

facebook twitter linkedin youtube

 

Copyright © 2023 ComplianceOnline.com MetricStream
Our Policies: Terms of use | Privacy

PAYMENT METHOD: 100% Secure Transaction

payment method