Training

 


Learning
 back      
 

Excel 2007: New Charting Features, Graphs and Diagrams (133024)

REGISTRATION STATUS: OPEN

Date: Monday, November 30, 2009
Time: 8:30am - 12:00pm (Registration at 8:00am )
Facility: MACPA Columbia Center, Columbia
CPE Credit: 4 Technology
Course Type: Computers
Provider: SCG Training & Consulting
Instructor: Judith E. Borsher, CPA, MBA
Field of Study: Technology, Computer Science
Level of Knowledge: Intermediate
Fees: $240 MACPA Members, $290 Non-Members
Referral Discount: ($50)
Student Discount: ($50)
Reciprocal Discount ($50)

Click here to add this event to your electronic calendar (then click OPEN when prompted).

Bookmark and Share


Description:

Excel 2007 includes many new graph templates, diagram types and accessible tools to create a professional presentation of data in a visual format. In this full-day hands-on course, you will learn the Excel features to present data using enhanced charts styles, graphs and diagrams. Drawing tools for adding annotation features will also be covered. Participants will learn many time-saving tips in this course for presenting business information. Highlights

  • Master the variety of chart type choices for presenting data trends and results
  • Learn to enhance the appearance of charts, graphs and diagrams using new features
  • Learn how to add data values and explanations to charts, graphs and diagrams
  • Learn to customize graphs and add a graph as a user-defined template
  • Learn when to use the multiple axis feature for presenting various types of data
  • Learn when to use a primary pie chart and a secondary pie connected to the chart
  • Learn data selection techniques to populate the graphic elements
  • Learn how to present Pivot Table results in graphic form

    Objectives:

    • Learn data selecting techniques and tips to populate the graphic elements
    • Create varieties of bar charts, pie charts, and trendlines using new styles and graphics
    • Use a variety of accessible formatting features to emphasize and customize parts of the data presentation
    • Add SmartArt as well as drawn objects including text boxes and callout shapes to add descriptions and other information not included in other chart elements.
    • Add multiple axes to present comparisons of data in bar charts
    • Add a secondary pie chart to present a breakout of one element of the primary pie chart
    • Add your customized charts to the chart templates as a user-defined entry for quick application to future charts
    • Add data tables to charts to quickly present the numeric values in the chart
    • Use flow chart symbols and connectors to create work flow diagrams
    • Compare the benefits and disadvantages of using embedded charts and chart sheets
    • Use the time-saving contextual ribbon tools and customize the quick access toolbar (2007)
    • Learn how to copy and paste charts between Excel and Word or Excel and PowerPoint
    • Use the diagram features included in Excel to show workflow, overlapping functions and staff organization
    • Use features for printing charts, graphs and diagrams
    • Learn how to present Pivot Table results in graphic form

    Who Should Attend:

    CPA practitioners and industry professionals needing to present Excel 2007 data in a visual format with the new time-saving charting and diagramming features. This class will be taught using Excel 2007.

    Prerequisite:

    Excel worksheet experience


    •  back