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

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:

• "Step-By-Step Excel Tables - Part 2
• "Harness the Incredible Power of Excel Pivot Tables in 90 Minutes: Learn To Slice, Dice and Crunch Numbers with Expert Ability - Part 3

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 :