Home / Business & Management / Big Data & Analytics / Excel for Data Analysis / How to Create Pivot Tables in Excel
How to Create Pivot Tables in Excel
This video explains that pivot tables are powerful tools to calculate, summarise and analyse data that lets you see comparisons, patterns and trends.
This video on the basics of creating pivot tables will include:
- Creating and selecting the correct cells
- Using pivot tables in an existing or new worksheet
- How to add fields
- How to edit filters, columns and rows
- How you can group data in a pivot table in order to analyse it
- How to create and edit slicers to focus analysis
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
