Mastering Excel Charts

Description

They say that a picture is worth a thousand words. Using Excel charting tools to visually display complex Excel data communicates the data’s message much more effectively to your target audience.

Chart and graphs are visual representations of your data. Viewing the data graphically makes the data less confusing and increases comprehension. It is easier to spot trends and patterns in your data sets.

Why Should You Attend:

You will learn how to create charts in Excel based on a variety of data sets. There are so many chart types to choose from, and you will understand which chart type presents the data from which perspectives.

We will start with very basic charts, modify the data being represented in the chart and advance into more complex combination charts. You will also learn how to format the charts to create the perfect emphasis of data.

Learn to embed Sparklines, mini charts, right inside of a cell.

Areas Covered in the Session:

• Creating charts in Excel
• 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 and advanced Excel charts
• Using sparkline chart, Excel
• How to make a graph in Excel

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