

Data Analysis with Pivot Tables
Data Analysis with Pivot Tables (3 Hours)
Service Description
Data Analysis with Pivot Tables Introduction Overview of Pivot Tables What is a Pivot Table? Benefits and use cases in data analysis Part 1: Creating Pivot Tables Preparing Data Formatting data for Pivot Table analysis Ensuring data cleanliness and structure Creating a Basic Pivot Table Selecting data and inserting a Pivot Table Understanding the Pivot Table field list Adding fields to Rows, Columns, and Values Basic Pivot Table Operations Sorting and filtering data Grouping data (e.g., dates, numbers) Calculating totals and subtotals Hands-On Exercise Building Your Own Pivot Table Guided exercise with sample data Practice creating and customizing a Pivot Table Part 2: Advanced Pivot Table Features Using Calculated Fields and Items Creating calculated fields Adding calculated items Pivot Table Design and Layout Customizing Pivot Table styles and layout Conditional formatting within Pivot Tables Slicers and Timelines Adding and configuring Slicers for interactive filtering Using Timelines to filter data by dates
Upcoming Sessions
Contact Details
4313388726
BenninkTraining@shaw.ca
Winnipeg, MB, Canada