Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories

Excel – Data Analysis with PivotTables

$148

Upgrade your tech skills with this , training course. Launch your career to the stars with AstraTech IT Certification Training!

Please select a Learning Method below to get started:

  • Microsoft Apps
  • Microsoft Excel

Course Highlights
ILT DURATION: 0.5 Day(s)
SKILL LEVEL: 
  • Intermediate
BRAND/TECHNOLOGY: 
TOPICS: 

Excel – Data Analysis with PivotTables Course Outline

Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others.

0

Excel – Part 1 & Part 2 or equivalent experience.

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables. Work with PivotCharts.

1 – Preparing Data & Creating PivotTables

  • 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 Source

2 – Analyzing Data Using PivotTables

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data

3 – Working with PivotCharts

  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

Related Training Courses

Related products

  • Data & Analytics

    Programming and Data Wrangling with VBA and Excel
    Microsoft Apps
    Intermediate
    VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft? Excel? and other applications in the Microsoft? Office application suite. You can use VBA to…
    3 Day(s)
    $885.00
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    Excel – Data Analysis with Power Pivot
    Microsoft Apps
    Intermediate
    Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In this course, students gain a solid understanding of Power Pivot…
    0.5 Day(s)
    $148.00
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    Data Analysis and Visualization with Microsoft Excel
    Microsoft Apps
    Intermediate
    Analyzing data to find issues, insights and opportunities, is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to…
    2 Day(s)
    $590.00
    Virtual Classroom
    Live, Instructor-Led (ILT)

Contact Info

Email address
info@ittrainingclasses.com
Phone number
(813) 425-3300

Our Company

AstraTech was established out of a passion for education and the core belief that knowledge is the ultimate super power. Our mission is to revolutionalize the IT education industry with our wide range of innovative & cost-effective IT certification training courses.