YoVDO

Excel: PivotTables for Beginners

Offered By: LinkedIn Learning

Tags

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

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 simple: Analyze data with ease
  • Using the exercise files and Excel versions
1. Basic PivotTable Concepts
  • What is a PivotTable?
  • Prepare your data
  • A word about fields
2. Building Your First PivotTable
  • Start building a PivotTable
  • Create the value field first
  • Create row fields
  • Create column fields
  • Create filters
  • Updating a PivotTable
  • Create a PivotTable with AI
Conclusion
  • Where to learn more about PivotTables

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