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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX