Pivot Tables Excel - Detailed Beginners Pivot Table Tutorial
Offered By: Simon Sez IT via YouTube
Course Description
Overview
Syllabus
- What Are Pivot Tables
- Cleaning Excel Data
- Removing Blank Rows
- Removing Duplicate Rows
- Clearing Formatting
- Applying Number Formatting
- Changing the Case
- Removing Spaces and Non-printing Characters
- Merging and Splitting Columns
- Converting Numbers Stored as Text
- Find and Replace
- Spell Checking
- Excel Tables vs. Pivot Tables
- Formatting Data as an Excel Table
- Using Recommended Pivot Tables
- Creating a Pivot Table from Scratch
- Pivot Table Ribbons and Fields
- Pivoting Fields
- Adding Multiple Dimensions
- Deleting Fields and Locking the Report Layout
- Methods of Aggregation
- Combining Methods of Aggregation
- Grouping and Ungrouping Data in Excel
- Applying Number Formatting
- Handling Cells with No Data
- Subtotals and Grand Totals
- Choosing a Report Layout
- Inserting Blank Rows
Taught by
Simon Sez IT
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard