starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Courses
  2. >
  3. Excel Pivot Tables

Excel Pivot Tables

Excel Pivot Tables are powerful tools to help understand and analyze data. This course covers the power of Pivot Tables and how they can be used to create sums, averages, or other statistical analysis of grouped values.

John Bura
John Bura
Business | core | 4 hours |   Published: Jan 2021
In partnership with:  Coursera

    Discussions

Overview

15KSTUDENTS*
94%RECOMMEND*

This course includes:

  • 4+ hours of on-demand video
  • 6 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
Excel Pivot Tables are powerful tools to help understand and analyze data.  Pivot Tables help you to group values that aggregates the individual items of a more extensive table within one or more discrete categories.  This course covers the power of Pivot Tables and how they can be used to create sums, averages, or other statistical analysis of grouped values.

Skills You Will Gain

Excel
Formatting Pivot tables
Pivot table basics
Pivot tables

Learning Outcomes (At the end of this program you will be able to)

Prerequisites

None other than a basic understanding of computers

Who Should Attend

Anyone interested in learning the core features and functions of Excel, and applying these skills in practical settings.

Curriculum

Instructors

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
1Welcome to the course!
2Module 01: Introduction to the Course
3Module 02: PivotTables Fundamental Projects
4Module 03: Format Pivot Tables
5Module 04: Excel Tables
6Module 05: Slice and Dice Your Data
7Module 06: Connect to Databases

Instructor bio - John Bura

Segment - 01 - Introduction to the Course

Segment - 02 - Why should you learn Pivot Tables

Segment - 03 - Introduction of the Instructor

Segment - 04 - Course Requirements (what software, experience)

Source File

Segment - 05 - What will we learn in this section

Segment - 06 - What is a Pivot Table

Segment - 07 - Pivot Table Basics

Segment - 08 - Pivot Table Compilant Data Sources

Segment - 09 - Build a Basic Pivot Table

Segment - 10 - Section Summary

Segment - 11 - Challenge

Source File

John Bura

John Bura

John Bura is a seasoned game developer, eLearning innovator, and AI coach with over 15 years of experience in the tech industry. Based in Vancouver, Canada, he serves as the CEO of Mammoth Interactive, where he leads the development of top-ranking games and applications across multiple platforms. His leadership also extends to Devonian Apps, a SaaS company known for delivering high-quality, fast-to-market digital products.

John is deeply passionate about education through technology. As a celebrated Udemy instructor, he has empowered over 300,000 students worldwide through practical courses on HTML5, Xcode, and game design, with his teaching style widely recognized for its clarity and real-world applicability. His dedication to curriculum excellence was further reflected in his role as a Program Advisor at Centennial College, where he shaped game design education to match industry demands.

With a rich background in both creative and technical disciplines, John has had his work featured by major industry players like Nickelodeon. As a forward-thinking AI expert, he now coaches businesses on building intelligent, automated infrastructures to increase efficiency and scalability. He's currently developing a cutting-edge tool that automates podcast and video production for content creators, furthering his mission to make innovation accessible.

Whether building games, coaching teams, or designing AI-powered tools, John blends creativity with technical mastery to drive productivity, foster innovation, and inspire learners around the world.

VIEW MY CHANNEL

Segment - 12 - What will we learn in this section

Segment - 13 - Introduction to Formatting Pivot Tables

Segment - 14 - Build an Expense Report

Segment - 15 - Format the Expense Report Pivot Table

Segment - 16 - Finalize the Expense Report Pivot Table

Segment - 17 - Section Summary

Segment - 18 - Challenge

Source File

Segment - 19 - What will we learn in this section

Segment - 20 - What are Excel Tables

Segment - 21 - Sales Report Analysis

Segment - 22 - Complete the Sales Report Analysis

Segment - 23 - Format the Sales Report

Segment - 24 - Modify Source Data

Segment - 25 - Section Summary

Segment - 26 - Challenge

Source File

Segment - 27 - What will we learn in this section

Segment - 28 - What is Slicing Data

Segment - 29 - Slicing Data Project

Segment - 30 - Data Slicer Tools

Segment - 31 - Links Slicer to Multiple Pivot Tables

Segment - 32 - Section Summary

Segment - 33 - Challenge

Source File

Segment - 34 - What will we learn in this section

Segment - 35 - Connect to Databases

Segment - 36 - Import Data Sources

Segment - 37 - Use Pivot Tables to Refine Data

Segment - 38 - Consolidate your Data Table

Segment - 39 - Format Large Data Sets

Segment - 40 - Slicer and Timeline in Large Data Sets

Segment - 41 - Refresh and Drill Down from Databases

Segment - 42 - Section Summary

Segment - 43 - Challenge

Source File