TOIT Training

Excel: Data Analysis with Pivot Tables

Overview
Curriculum

Pivot Tables are the perfect tool to analyze large amounts of data in Excel.  The ability to summarize, visualize, and tabulate your data makes PivotTables an important tool for Excel users who need to store and report on data.  Microsoft certified trainer Kathy Jones will show you how to create, format and manipulate PivotTables and PivotCharts so you can easily get the results you need from your data.

Curriculum

  • 15 Sections
  • 2h 5m Duration
Expand All
Preparing Data
    Create from Local Data Source
      Create from Multiple Local Sources
        Create from External Sources
          Summarize Table Data
            Organize Pivot Table Data
              Filter Data, Part 1
                Filter Data, Part 2
                  Format Pivot Table
                    Refresh and Change Data
                      Pivot Options, Part 1
                        Pivot Options, Part 2
                          Creating A Pivot Chart
                            Manipulate Pivot Chart Data
                              Formatting A Pivot Chart

                                Deleting Course Review

                                Are you sure? You can't restore this back

                                Course Access

                                This course is password protected. To access it please enter your password below:

                                Buy for group

                                Excel: Data Analysis with Pivot Tables
                                No groups Found

                                You don't have any groups yet

                                Create a group and add group members. Sync Group(s)