Microsoft Excel Tables and PivotTables

Hours: 3.00 | Estimated Cost: $99.00

It can be difficult to see the big picture when you have a lot of data listed in an Excel table. Creating PivotTables and/or PivotCharts can help you make sense of this data and gives you a quick visual analysis. In this seminar, create Tables, PivotTables and PivotCharts and learn how they can be an effective visual communication tool as well.

    Additional Information

  • Learn About
    • Creating an Excel table
    • Creating a PivotTable and PivotChart Sorting and filtering a table or list range
    • Manipulating PivotTable Data
    • Easy Filtering Using Timelines and Slicers
  • Benefits & Outcomes
    • Present, analyze and summarize data in a meaningful way
    • View common trends and/or themes within a data table
  • Training Outline

    **Excel Tables**

    • Range vs. Table
    • Creating a Table
    • Adding/Deleting Table Rows & Columns
    • Adding a Total Row
    • Removing Duplicates
    • Adding Formulas
    • Using Table Specifiers
    • Converting a Table to a List Range

    **Sorting & Filtering a Table or List Range**

    • Basic & Complex Sorting
    • Filtering
    • Clearing Filtering
    • Showing/Hiding AutoFilter
    • Grouping
    • Subtotaling

    **PivotTables & PivotCharts**

    • Creating a PivotTable/PivotChart from Worksheet Data
    • Transactional Data
    • Show/Hide the PivotTable Fields Pane
    • Adding/Removing a PivotTable Field
    • Refreshing a PivotTable
    • Rearranging a PivotTable
    • Adding a PivotChart to a PivotTable
    • Formatting
    • Sorting & Filtering a PivotTable
    • Filtering with Timelines & Slicers
    • Changing the Summary Function
    • Changing How Values are Shown
    • Using a PivotTable to Analyze Multiple Data Sources using the Data Model

Share Your Needs

Information Request (check all that apply - your information is private)
Areas of Interest (check all that apply)

(e.g., MS Excel on-site)

Business & Industry Services (BIS)
5 N. Systems Drive
Appleton, WI 54914-1655

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771