To better understand your data, numbers can be represented visually in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same regardless of what type of chart you choose. As data changes, the chart will automatically update.

Different types of charts represent data in different ways.

• Column charts show comparisons
• Line charts show trends in the data
• Pie charts break out the individual values relative to their total

Learning Objectives:-

In this class, you will learn how charts can be used to represent data. You will create multiple charts including columns, lines, and pie. You will format the charts in order to present the data in an easy-to-understand layout.

Data can be further analyzed by creating timelines and forecasting data forward or backward. Data can be added, edited, and removed from a chart. Sparklines show a mini chart embedded in a cell to show trending without taking up a lot of screen space.

Areas Covered:-

Topics covered include:

• Creating Charts
• Defining the Components of a Chart
• Formatting a Chart
• Modifying a Chart
• Adding Chart Elements
• Adding, Editing, and Removing Data
• Annotating with Trendlines
• Creating a Combination Chart
• Using Sparklines

Why Should You Attend:-

Learn to present your data in a way that conveys the appropriate message. Charts can complement your data in a visual way. Creating charts brings everyone to the same understanding of the data.

Who Will Benefit:-

• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive