Discover Classes. Earn Rewards.
Microsoft Excel PivotTables is unfortunately unavailable

Thankfully we have 11 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Course Details
Price:
$349
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Interactive Online Classroom
Description
Class Level: Advanced
Age Requirements: 16 and older
Average Class Size: 6
System Requirements:

You will need an Internet connection and administrator access on your computer or laptop.

Class Delivery:

Additional information on how to log into the online environment will be provided after purchasing the class.

What you'll learn in this excel class:

In Microsoft Excel PivotTables classes, you will learn the right ways to easily analyze large amounts of data in just a few clicks.  Instead of wasting valuable time with standard Excel look-up features, PivotTables allow you to do quick, easy grouping, summarizing, and filtering of data.  If you are looking to add high demand career skills to your resume or to improve your Excel productivity, this Excel PivotTables training is right for you.

In this Microsoft Excel PivotTables class, you will master both PivotTables and PivotCharts, starting with the basics. You will leave this excel class confident in creating an advanced PivotTable and performing advanced data analysis in a short amount of time. Extend your Excel training to be more productive at work and save time today.

As you work through the sessions of Microsoft Excel PivotTables, each class will be a hands-on and intensive workshop, designed to help make difficult topics easier to understand. Your instructor, a Microsoft expert, will work with you closely to make sure that you avoid common mistakes in Excel PivotTables and apply best practices when possible.

Class Objectives

Upon successful completion of the Microsoft Excel PivotTables class, students will be able to:

  • Analyze large amounts of data using PivotTables and PivotCharts
  • Create a basic Excel PivotTable
  • Group and summarize your data in creative ways
  • Filter and sort your PivotTable
  • Apply Slicers for visual filtering
  • Use advanced features of PivotTables
  • Format PivotTables easily
  • Use conditional formatting within PivotTables

Pre-requisites

  • Basic digital literacy including file management is required.
  • Microsoft Excel Beginners (Level 1) or equivalent knowledge is required.
  • It is required you install the latest Microsoft Office software before starting class.

Talk to a student advisor to ensure you have the right pre-requisites for each class or program.


Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Refund Policy

  • Students not accepted to the school are entitled to all monies paid. 
  • Students who cancel this contract by notifying us within three (3) business days are entitled to a full refund of all tuition and fees paid. 
  • Students, who withdraw after three (3) business days, but before the commencement of classes, are entitled to a full refund of all tuition paid except the maximum cancellation charge of $150.00 or 25% of the contract price, whichever is less. In the case of students withdrawing after the commencement of classes, the school will retain a cancellation charge plus a percentage of tuition and fees, which is based on the percentage of contact hours attended. 
  • The refund is based on the official date of termination or withdrawal.


If you would like to cancel or transfer a class, please write to [email protected]


Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 3490 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Digital Workshop Center (1)

School: Digital Workshop Center

Digital Workshop Center

Empowering you with Skills, not degrees.

Established in 2006, the Digital Workshop Center is a community center for education, coworking, and professional development. A premier independent provider of higher education and certificate credential programs, DWC has become a vital training option for nontraditional...

Read more about Digital Workshop Center

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

11 Top Choices

Online Excel for Beginners

at The New York Public Library (Tech) -

Learn the basics of working with spreadsheets using Microsoft Excel. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...

Thursday Feb 9th, 1:30pm - 3pm Eastern Time

Free

Excel Introduction (Online)

at Computer Training Source, Inc. -

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Monday Feb 6th, 9am - 4pm Central Time

Excel Intermediate (Online)

at Computer Training Source, Inc. -

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Tuesday Feb 7th, 9am - 4pm Central Time

Excel Dashboard Reporting: Intro to Dashboards ..

at Accelerate Computer Training -

Excel Dashboard Reporting: Intro to Dashboards Using Excel A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and...

Tuesday Feb 7th, 12pm - 3pm Pacific Time

Excel Advanced (Online)

at Computer Training Source, Inc. -

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Wednesday Feb 8th, 9am - 4pm Central Time

Excel Intermediate 2: Queries, Subtotals and Tables

at Accelerate Computer Training -

In this three-hour session for Windows users only, you will import external data and create queries using Power Query to bring in data from external sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting...

Wednesday Feb 15th, 8am - 11am Pacific Time

Excel Advanced 1: Automating Tasks

at Accelerate Computer Training -

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have...

Wednesday Feb 15th, 12pm - 3pm Pacific Time

Excel Beginning 1: Your First Worksheets

at Accelerate Computer Training -

This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...

Thursday Feb 16th, 8am - 11am Pacific Time

Excel Beginning 2: Cell Formatting and Charting

at Accelerate Computer Training -

In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart...

Thursday Feb 23rd, 8am - 11am Pacific Time

Excel Intermediate 1: Simple Formulas

at Accelerate Computer Training -

This three-hour session for Windows and Mac users teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, write arithmetic formulas by hand, parse text strings with the LEFT, MID, RIGHT and SEARCH functions, and perform calculations on dates. You will use HLOOKUP and VLOOKUP to retrieve data based...

Tuesday Feb 7th, 8am - 11am Pacific Time

Excel Advanced 2: Advanced Formulas

at Accelerate Computer Training -

In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, database summarization functions, and dynamic array functions. You will also become expert at using mixed...

Thursday Mar 2nd, 12pm - 3pm Pacific Time

Loading...