YoVDO

Excel: PivotTables for Beginners

Offered By: LinkedIn Learning

Tags

PivotTables Courses Data Analysis Courses Data Visualization Courses Microsoft Office 365 Courses Spreadsheets Courses

Course Description

Overview

Get a short and simple beginner's guide to Excel PivotTables. Follow along and learn how to create a basic PivotTable to analyze and present spreadsheet data.

Syllabus

Introduction
  • Excel PivotTables made easy
  • Excel versions and exercise files
1. Basic PivotTable Concepts
  • What is a PivotTable?
  • Prepare your data
  • A word about fields
2. Building a Basic PivotTable
  • Start building a PivotTable
  • Create the value field first
  • Create row fields
  • Create column fields
  • Create filters
  • Updating a PivotTable
Conclusion
  • Next steps

Taught by

Dave Ludwig

Related Courses

Intro to Statistics
Stanford University via Udacity Introduction to Data Science
University of Washington via Coursera Passion Driven Statistics
Wesleyan University via Coursera Information Visualization
Indiana University via Independent DCO042 - Python For Informatics
University of Michigan via Independent