Excel training classes near me in San Diego

Excel Pivot Table Class in San Diego


This class is intended for:

PC/Windows Users: Excel 2016-2019-365
Certificate of Completion (optional): $5
Course Length: Half Day

san diego computer training classes

Excel Pivot Tables and Pivot Charts are powerful tools for analyzing large spreadsheets. They allow you to condense, sort, and filter data so you can see the "big picture."

excel dashboard

Pivot Tables:

  • 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 Table Dashboard

Pivot Charts:

  • Layout & Design
  • Chart Styles & Formatting
  • Change Chart Type
  • Filtering Options
  • Sorting Options
san diego computer training classes

Call 858-578-9476

We also offer classes on:

Beginning Excel | Intermediate Excel | Advanced Excel | Excel Formulas | Excel Charts |

Computers Etc. Software Training Center, Inc.
6920 Miramar Road - Suite 206
San Diego, CA 92121
858-578-9476