Excel Data Analysis with Pivot Tables – Supported

$ 240.00

Module Duration: 3.5 Hours

Class Agenda

Resource Setup 30 Minutes
Training Session 3 Hours
Breaks Prescribed by Instructor

This course is designed for students who wish to summarize and organize data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Recommended Preparation: Excel 1 & 2

  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Data Sources
  • Create a PivotTable from an External Data Source
  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data
  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.

DETAILED COURSE OUTLINE

Getting Started with Access

Working with Table Data

Querying a Database

Using Forms

Generating Reports

“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”

Event Details

Phone: (602)252-3955

Email: registration@trainingtoyou.com

Scroll to Top