top of page

Excel 365: Creating and Using Charts in Depth Bonus! Includes Topic: Using Excel as a Database

Excel.png

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:

  • Inserting Charts

  • Using the Quick Analysis Tool

  • Using Keyboard Shortcuts or Menu

  • Data Visualization Rules

  • Selecting the Right Chart

  • Chart Styles and Layouts

  • Chart Styles

  • Quick Layouts

  • Changing Colors

  • Changing Themes in Whole Workbook

  • Switch Row/Column Data

  • Moving Charts

  • Moving the Chart on the Worksheet

  • Moving the Chart to Another Worksheet

  • Resizing a Chart

  • Deleting a Chart

  • Customizing and Formatting a Chart

  • Identifying Chart Elements

  • Adding a Chart Element

  • Working with Data Categories

  • Removing Categories of Data

  • Adding Categories of Data

  • Filtering Data

  • Change Chart Type

  • Recommended Charts

  • Saving a design as a Template

  • Applying a Template

  • Formatting and Deleting Chart Elements

  • Formatting Chart Elements

  • Deleting Chart Elements

  • Using the Format Menu

  • Changing All Fonts in the Chart at Once

  • Locating  Charts

  • Type of Charts

  • Column and Bar Charts

  • Line or Area Chart

  • Pie or Donut Chart

  • Hierarchy Charts

  • Statistic Chart

  • X,Y or Bubble Chart

  • Waterfall, Funnel, Stock, Surface or Radar Chart

  • Combo Charts

  • Map Chart

bottom of page