Join millions using the Alison App – faster, easier, and made for learning on the move... 📲 Learn On The Go With
The Alison App
Get App
Explore

Top Free Courses

    Most Popular Searches

    Your Recent Searches

      en
      For BusinessAffiliate coin
      Language icon en
      Advanced Pivot Tables in Excel

      Advanced Pivot Tables in Excel

      Enrolled1.5-3 Hours (Contains Video)
      Save This Course For Later
      Start Course NowCertify Now
      Certify Now

      Confident you have the skills to certify without completing the course content?

      1. Advanced Pivot Tables in Excel
      • Beginner Level

      Advanced Pivot Tables in Excel

      This free online course on Advanced Microsoft Excel PivotTables explains key functions and analysis in PivotTables.

      Save This Course For Later
      Start Course NowCertify Now
      Certify Now

      Confident you have the skills to certify without completing the course content?

      Advanced Pivot Tables in Excel
      Published by
      Saved For Later
      View Saved Courses
      Certificate Icon
      Confident you have the skills to certify without completing the course content?
      Certify Now

      Learning Outcomes

      In this free course, you will learn how to:

      • Describe how to put a Pivot together in Excel
      • Explain how to Import data from a text file
      • Discuss the process of Importing data from Access
      • Describe the cleaning of Data to use in a PivotTable
      • Discuss Tabular Data and setting up a Table
      • Explain the process of creating and Manipulating a PivotTable
      • Discuss the combination of Data from Multiple Worksheets
      • Explain Grouping and Ungrouping in a Pivot Table
      • Describe how to Report Layouts
      • Explains how to Format Error Values and Empty Cells
      • Differentiate PivotTable Styles and how to use them
      • Describe Custom Number Formatting in a Pivot Table

      Knowledge & skills you will learn

        Course Overview

        About This Course

        Course Description

        Read MoreRead Less

        Modules ()

        -

        -

        -

        -

        Published by
         Positive learner  ratings
        Learners Courses
        Learn More About The Publisher

        Showcase Skills With A Certificate!

        • Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
        • Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
        • Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.
        Claim Your Certificate

        Course Rating & Reviews

        -Positive Ratings

        Reviews

        Loading...
        Loading...
        Loading...
        Loading...
        Loading...
        Loading...
        View All Reviews
        Back to top
        Back to course information
        Trustpilot
        Download Courses And Learn Without Internet!
        Download Courses And Learn Without Internet!

        Use your iOS or Android devices to download Alison courses, and learn without internet on the Alison App.

        Upgrade your learning. <br>Ditch the ads.
        Upgrade your learning.
        Ditch the ads.

        Go ad-free, unlock exclusive perks, and learn without interruptions with Alison Premium.

        Advertisement

        Explore Related Careers

        Explore Related Courses

          Interested In This Course For Your Team?

          16,000 organisations use Alison for Business to upskill their teams