logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel MegaBytes: Pivot Tables

SS Course: 3000649

Course Overview

TOP

During this two-hour live hands-on training, our top-rated instructor will teach how to summarize, analyze and present large amounts of data using Pivot Tables and Pivot Charts. Students are encouraged to ask questions during this hands-on session.                                                                  

Scheduled Classes

TOP
04/29/24 - HC1 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)
09/16/24 - HC2 - Virtual Instructor-Led - Virtual Instructor-Led (click to enroll)

What You'll Learn

TOP

During this hands-on training, you will learn to:

  • Create & Use Pivot Tables
  • Create & Use Pivot Charts
  • Format Pivot Tables & Charts
  • Filter data
  • Refresh data

Outline

TOP
Viewing outline for:
  • Pivot Tables
    • Creation
    • Utilization
  • Pivot Charts
    • Creation
    • Utilization
  • Formatting
    • Pivot Tables
    • Pivot Charts
  • Filtering data
    • By Sheets
    • Using Slicers
  • Refreshing data
  • Prerequisites

    TOP

      Who Should Attend

      TOP

      Students who wish to create pivot tables, pivot charts, and explore options for displaying data.

      Next Step Courses

      TOP

      Other Bits & Bytes sessions and Microsoft Office courses.