Lubbock - Excel Dashboard & Reports using PivotTables 2/11/2018

Class time: 8:30am - 4:30pm

Length: 7 hours (1 day)

Location:

Lubbock Classroom
Melonie Park Meeting Space
3502 74th Street
Lubbock, TX 79423

Prerequisites

Students must have an Intermediate to Advanced understanding of Microsoft Excel.

Course Description

In the course, you will learn how to create and modify charts. Once you have modified the charts we will create chart templates to make creating future charts faster. We will also look at the new Sparkline feature in Excel.

In this class, you will also learn PivotTables and Pivot Charts. Learn how using the Table feature can help make PivotTables and charts more dynamic.

Detailed Course Outline

Understanding Charting

  • Create Excel Charts
  • Understanding the different types of Charts
  • Using the Chart Ribbon
  • Use the new Recommended Charts
  • Changing the Chart Type and Moving the Chart
  • Modifying charts
  • Work with Chart Elements
  • Create and use Chart Templates
  • Look at the Excel’s new Sparkline feature

Understanding Tables and PivotTables

  • Learn how to design your spreadsheet to make it easier to create Tables and PivotTables
  • Learn various ways to Filter data
  • Understand the difference between Filtering data and using Tables
  • Create Tables and Understand their benefits
  • Create and Modify PivotTables
  • Create and Modify Pivot Charts
  • Work with Slicers
  • Understand how Slicers can help with Dashboards
  • Work with PivotTable Timelines
  • Work with Recommended PivotTables

Conditional Formatting

  • Understand how to apply and modify Conditional Formatting
  • Understand how to use new features like Data Bars and Icon Sets

Combine Your Knowledge and Create a Dashboard

  • Use your knowledge of PivotTables, Charts. Slicers, Timelines, and Conditional Formatting to create a simple dashboard.
  • Learn Basic Drawing options and Excel Options to help with dashboards.

Who Should Attend

Intermediate to Advanced Excel users that would like to expand their knowledge of Excel

The class must be canceled 10 days before start date

Class Information

Class date: 02/11/19
Class end date: 02/11/19
Seats Remaining: 6
Cut off date: 02/11/19
Individual Price: $169.00
Location: Lubbock Classroom

Group Rate

No Number registrants Rate/Person($)
1 3 149.00
Share this class: