Microsoft Excel Data Analysis with PivotTables and PowerTools

Excel® PivotTables

We live in the age of big data. Information is being collected all the time for increasingly detailed transactions. Without the proper tools and training this can lead to an overwhelming amount of data and missed opportunities. Therefore, the need to analyze that data and gain actionable insight is also greater than ever before.

Harness the power of advanced PivotTable and PivotCharts features to summarize, organize, and analyze data to gain actionable insights and a competitive advantage. Excel Power Tools helps organize, manipulate, data model, and report on your data in the best way possible. Gain a solid understanding of Power Tools to maximize your speed and effectiveness when analyzing data.

Note: This course does not include Power BI. Watch for additional classes coming soon.

Objectives

Upon successful completion of this course, you will be able to use Excel advanced PivotTable and Power Pivot to functionality to analyze raw data from a variety of sources.

You will:

  • Prepare data for PivotTable reporting and create PivotTables from various data sources
  • Analyze Data Using PivotTables
  • Work with PivotCharts
  • Get started with Power Pivot
  • Visualize Power Pivot data
  • Work with advanced functionality in Power Pivot

$199

8:30 am - 4:30 pm

10% discount for University of Arkansas Faculty, Staff and Current Students. To receive the discount, you must register with your uark email address and enter coupon code 'UA10' at checkout. Status will be verified and correct rate will be applied. Additional discounts do not apply.​


Schedule


Register 11/9/17
Location:
Global Campus Rogers
Suite 402


Register 12/8/17
Location:
Global Campus Rogers
Suite 402


Prerequisites

To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

Course Content

  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Sources
  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data
  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart
  • Enable and Navigate Power Pivot
  • Manage Data Relationships
  • Create a Power Pivot Report
  • Create Calculations in Power Pivot
  • Create a Key Performance Indicator
  • Work with Dates and Time in Power Pivot