Discover Classes. Earn Rewards.
Excel - Pivot Tables / Pivot Charts is unfortunately unavailable

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

Excel - Pivot Tables / Pivot Charts

at Computers Etc Software Training Center - Miramar

(4)
Course Details
Price:
$125
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:
Miramar
6920 Miramar Road Suite 206
Production Ave
San Diego, California 92121
(Map)
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 6

What you'll learn in this excel class:

Use Pivot Tables to summarize large spreadsheets.

  • Create a Pivot Table
  • Layout & Design
  • Move a PivotTable
  • Filter a Pivot Table
  • Sort a Pivot Table
  • Expand & Collapse Columns
  • Grand Totals and Subtotals
  • Functions (Sum, Average, Min, Max)
  • Change Data Source (change range of cells, use Access as data source, etc.)
  • Append (Add) Data to a Pivot Table
  • Convert Underlying Data Into a Table
  • Combine Multiple Data Sources
  • Use GetPivotData Function
  • Refresh Data
  • Group by Dates (Week, Month, Year)
  • Calculated Fields (Create, Edit, Delete, List Formulas, Change Solve Order)
  • Slicers

PIVOT CHARTS:

  • Layout & Design
  • Chart Styles & Formatting
  • Change Chart Type
  • Filtering Options
  • Sorting Options

Still have questions? Ask the community.

Refund Policy

Transfer Policy: You can transfer free-of-charge to another class provided that you give us at least 24 hours advance notice by phone or e-mail. You can also send someone else in your place. Please inform us who will attend the class.

Refund Policy: If you feel a class isn't right for you, just let the instructor know during the first break. We will issue a full-refund, transfer you to another class, or issue a full credit for the class - Your choice. You must inform the instructor during the first break!

Map

Google Map

Computers Etc Software Training Center

All classes at this location

From 805: Go east on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn left at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces. From 15: Go west on Miramar Road. Look for Jack in the Box, Flooring Wholesalers, and Starbucks. Turn right at stoplight onto Production Ave and continue just past railroads tracks. Turn left into parking lot. Do not park in reserved spaces.

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 1250 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 Computers Etc Software Training Center (4)

School: Computers Etc Software Training Center

Computers Etc Software Training Center

Computers Etc. was founded in 1992. We teach popular computer programs such as Access, Excel, Outlook, PowerPoint, Word, and QuickBooks. Over 25,000 students have attended our computer classes over the years. Our mission is to offer the finest computer classes at the lowest possible prices. From the...

Read more about Computers Etc Software Training Center

CourseHorse Approved

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

Want to take this class?

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

3 Top Choices

Excel Intermediate

at Computers Etc Software Training Center - Miramar 6920 Miramar Road Suite 206, San Diego, California 92121

Take your Excel skills to the next level and create formulas using parentheses, combine information from different sheets or files, use Validation to create look-up lists and limit what users can input, password protect all or part of a sheet, use Conditional Formatting to make important values stand out, and analyze large spreadsheets with PivotTables. ...

Thursday Feb 16th, 9am - 4pm Pacific Time

Excel Beginning

at Computers Etc Software Training Center - Miramar 6920 Miramar Road Suite 206, San Diego, California 92121

Recommended for anyone who hasn't worked with formulas or charts before or those with little or no experience with Excel. Great refresher course for students who haven't used Excel in a long time. Learn how to navigate the Excel user interface. Customize the Quick Access Toolbar to include your favorite commands. Learn many keyboard shortcuts that...

Thursday Feb 9th, 9am - 4pm Pacific Time

Excel Advanced

at Computers Etc Software Training Center - Miramar 6920 Miramar Road Suite 206, San Diego, California 92121

This class is intended for: PC/Windows Users: Excel 2010-2013-2016-2019-365 Course Materials: FREE Certificate of Completion (optional): $5 Course Length: 1 Day Basic Functions: Average (average a range of cells) Max (display highest number in a range cells) Min (display lowest number in a range of cells) Sum (sum or total of a range of...

Tuesday Jan 31st, 9am - 4pm Pacific Time

Loading...