Click to search the Andrew Heiskell Braille and Talking Book Library Skip Navigation

TechConnect: Excel Genius Class 3: Charts and Sparklines

Share

February 12, 2018

Excel Genius is a new set of classes aimed at students who have taken the Beginner and Intermediate Excel courses, or who have good fundamental knowledge of Excel, and who would like to gain a deeper understanding of the world’s most popular spreadsheet application.  Each class will cover a topic in depth and then give students exercises that apply that knowledge to real world situations.

While we recommend that students take the classes in order, there are no attendance requirements, and students are welcome to repeat or skip classes as they choose.

Class 1: Logic Functions

Class 2: Conditional Stat Functions

Class 3: Charts and Sparklines

Class 4: Tables, Structured References, and Data Validation

Class 5: Pivot Tables

Class 6: Lookup Functions

Class 7: Importing Data, String Functions, and Goal Seek

 

Class Requirements:

Each Class will have its own set of specific requirements, but all classes will use the following skills:

  • Data Entry

  • Selecting Cells

  • Copy and Paste

  • Formatting Cells

 

Class 3 : Charts and Sparklines

This class will cover how to customize charts to better visualize informations, as well as the pros and cons of various chart types.  Topics include : Formatting charts, adding and customizing chart elements, creating mixed charts, chart analysis tools, and sparklines

Skills required:

  • How to insert a chart

  • How to navigate menu options in Excel

 

***Students will not be admitted to class more than 10 minutes after class begins.***

More Info

  • Class Format: Hands on
  • Skill prerequisites: MS Excel 2010 for Beginners, Intermediate MS Excel
  • Audience: Adults, 50+, Adults