Search
0 Log In
Search Results
    View all results
    Popular Searches
    Popular Brand and Topics
    image

    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.
    Virtual Instructor-Led Training 4 hours

    Upcoming Schedules

    Date Time Enroll
    Sep 18 - Sep 18, 2026 9:00 AM - 12:30 PM America/New_York Add To Cart
    Oct 26 - Oct 26, 2026 9:00 AM - 12:30 PM America/New_York Add To Cart
    Nov 23 - Nov 23, 2026 9:00 AM - 12:30 PM America/New_York Add To Cart
    Dec 28 - Dec 28, 2026 9:00 AM - 12:30 PM America/New_York Add To Cart

    Prerequisites for Excel – Data Analysis with PivotTables Course

    Excel - Part 1 & Part 2 or equivalent experience.

    Excel – Data Analysis with PivotTables Course Outline

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

    Resources

    pexels pavel danilyuk 7658240
    1 min Read

    The Power of Workplace Relationships: Influence, Inclusion, and Impact

    Success in today’s workplace is not just about technical skills—it’s about relationships. Strong interpersonal connections enable teams to collaborate, innovate, and adapt to constant change. The Work Relationships: Influence Inclusion and Impact course focuses on building these essential skills. Why Workplace Relationships Matter Human collaboration is one of our greatest strengths. In a rapidly changing […]
    Read More
    pexels kampus 6248961
    1 min Read

    Building Strong Teams with Positive Assertiveness & Inclusive Leadership

    In modern workplaces, communication is everything. Yet many professionals struggle to express themselves effectively—either becoming too passive or overly aggressive. The solution lies in positive assertiveness. The Positive Assertiveness & Inclusive Leadership course helps individuals develop a communication style that is confident, respectful, and impactful. What is Positive Assertiveness? Positive assertiveness is the ability to: […]
    Read More
    man meeting
    2 mins Read

    Why Critical Thinking & Decision Making is a Must-Have Skill for Leaders

    In today’s fast-paced world, decision-making is constant. From the moment we wake up, we make dozens of choices—many without even realizing it. But when it comes to leadership, decisions carry weight. This is where critical thinking becomes essential. The Critical Thinking & Decision Making course is designed to help professionals strengthen their ability to analyze […]
    Read More
    Visit Learning Blog

    FAQs on Excel – Data Analysis with PivotTables

    You will learn to prepare raw data for reporting, create PivotTables from local and external data sources, analyze data using PivotTables, and build and format PivotCharts.

    You should have completed Excel – Part 1 & Part 2, or have equivalent working experience with Excel.

    This course is designed for Excel users who need to analyze large datasets and create dynamic reports using PivotTables and PivotCharts.

    The course covers three main areas: preparing data and creating PivotTables, analyzing data using PivotTables, and working with PivotCharts, including formatting and refreshing data.

    Yes, the course teaches you how to create PivotTables from local data sources, multiple local data sources, and external data sources.

    Related Courses

    Microsoft Excel

    Programming and Data Wrangling with VBA and Excel

    VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in...
    Microsoft Excel

    Excel – Data Analysis with Power Pivot

    Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In...
    Microsoft Excel

    Excel – Part 1

    Ready to start building your Excel skills from the ground up? This beginner Excel training course provides the foundation you...
    Microsoft Excel

    Excel – Part 2

    Ready to go beyond the basics? Our Intermediate Excel Training course is perfect for professionals who want to turn raw...
    Microsoft Excel

    Excel – Part 3

    Ready to take your spreadsheet skills to the next level? This Advanced Excel Training course is designed for professionals who...
    Microsoft Excel

    Excel – Pivot Tables and Conditional Formatting

    In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.

    Maximize Your Learning. Unlock Your Potential

    Discover career-focused courses designed to build the skills employers demand. Explore our catalog, choose
    your path, and start learning with expert-led training today.

    Explore Our Catalog