Excel: Creating Charts
and Using Excel as a Database

Time: 1.5 Hours
Course Description:
Learn just how easy it is to create meaningful and professional looking charts and graphs in Excel. As an added bonus, you will learn incredible ways to use Excel as a mini database to help you keep up with your records.
Course Material:
A customized step-by-step Quick Reference Card with screenshots is included in this class which covers each topic you will learn.
Course Outline:
-
Data Visualization Rules
-
Selecting the Right Chart
-
Chart Basics
-
Inserting a Chart
-
Moving the Chart on the Worksheet
-
Moving the Chart to Another Worksheet
-
Deleting a Chart
-
Identifying Chart Elements
-
Customizing and Formatting a Chart
-
Chart Elements, Layouts, Colors
-
Design Menu
-
Format Menu
-
Choosing Chart Types
-
Quick Analysis
-
Ideas Feature
-
Ideas - Creating a Pivot Table and Chart
-
Using Excel as a Mini Database
-
Create a Table with Filters
-
Create a Data Form