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

Introduction to Office 365 Development and APIs
Microsoft via edX Office 365: Managing Identities and Services with Hands-on Labs
Microsoft via edX Compliance in Office 365: eDiscovery
Microsoft via edX Compliance in Office 365: Data Governance
Microsoft via edX Microsoft Exchange Server 2016 - 5: Hybrid Topologies with Office 365
Microsoft via edX