YoVDO

Excel for Beginners: Pivot Tables

Offered By: Coursera Project Network via Coursera

Tags

Microsoft Excel Courses Data Visualization Courses Data Summarization Courses Pivot Tables Courses

Course Description

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
    • Here you will describe what the project is about...give an overview of what the learner will achieve by completing this project. 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.

Taught by

Edward Falzon

Related Courses

Introduction to Statistics: Descriptive Statistics
University of California, Berkeley via edX
Statistical Reasoning for Public Health 1: Estimation, Inference, & Interpretation
Johns Hopkins University via Coursera
Excel Skills for Business: Intermediate I
Macquarie University via Coursera
Introduction to Statistics for Data Science
SAP Learning
Complex Retrieval Queries in MySQL Workbench
Coursera Project Network via Coursera