Excel 365: 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