Excel for Beginners: Pivot Tables

Overview

This 1-hour, project-based course introduces learners to the powerful pivot table feature of most spreadsheet applications. We’ll be using Excel on the Web in this project, which is the free spreadsheet application offered by Microsoft. However, many of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets. We will cover the following concepts in a hands-on manner: - Introduction to the functionality of pivot tables. - Application of pivot tables to quickly summarize large amounts of raw data in detail. - Visualize generated data from pivot tables for accessible information at a glance using charts. Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.

Syllabus

Project Overview

In this module, you'll learn how to use pivot tables to quickly organize, summarize, and analyze large datasets in Excel on the Web. Through hands-on practice, you'll explore the core functionality of pivot tables, generate meaningful insights from raw data, and create charts to visualize your results. By the end of the project, you'll be able to use pivot tables to transform data into clear, actionable information that supports decision-making.