Name: Excel: Mastering Charts
Overall Rating: 5.0 out of 5 (7 ratings)
Category: All Learners
Duration: 1.25 hour(s)
Individual Fee: $20.00

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.



This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Know and Explain: Information you will know, be able to explain, or be able to find.

  • 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.

Topics

  • 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

SkillPrerequisiteExpected Outcome
Excel1 - BeginnerNot specified
Excel Advanced1 - BeginnerNot specified
Excel Intermediate1 - BeginnerNot specified

Cathy Horwitz

Years of Experience: 44+ years

Areas of Expertise: Microsoft Office


Class Costs
Class ValueNo Charge
Individual Fee$20.00
Private Class Fee$0.00
5.0 out of 5 (7 ratings)

Extremely Helpful Mon, Dec 11, 2023
The course layout and the instructor made this course beneficial. I would recommend this course to others!
Excel: Mastering Charts Mon, Feb 13, 2023
good illustration
Good material, Instructor very knowledgeable. Fri, Dec 10, 2021
I took this course to learn more about Excel Charts. Cathy Horwitz is very knowledgeable and was able to demonstrate the material well. I took a lot away that I will begin to implement in my daily work. I would recommend this course to anyone looking to gain more knowledge with charts and graphs in Excel.
[See all User Reviews…]