Introduction to PivotTables in Excel
Work with PivotTables and databases in this career advancing course.
Created by John Bura
01
Skill level
All levels
02
Sections
6
03
Lectures
43
04
Instructor
John Bura
What's inside
This course includes.
✓
6
Sections
✓
43
Lectures
✓
43
Resources
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ 01. Introduction to the Course 4 lectures
1.1 Introduction To The Course New
Locked
1.2 Why Should You Learn Pivottables New
Locked
1.3 Introduction Of The Instructor New
Locked
1.4 Course Requirements (what Software, Experience) New
Locked
+ 02. PivotTables Fundamental Projects 7 lectures
2.1 What We Learn In This Section
Locked
2.2 What Is A Pivot Table
Locked
2.3 Pivottables Basics
Locked
2.4 Pivottable Compliant Data Sources
Locked
2.5 Build A Basic Pivottable
Locked
2.6 Section Summary
Locked
2.7 Challenge
Locked
+ 03. Format PivotTables 7 lectures
3.1 What Will We Learn In This Section
Locked
3.2 Introduction To Formatting Pivottables
Locked
3.3 Build An Expense Report
Locked
3.4 Format The Expense Report Pivottable
Locked
3.5 Finalize The Expense Report Pivottable
Locked
3.6 Section Summary
Locked
3.7 Challenge
Locked
+ 04. Excel Tables 8 lectures
4.1 What Will We Learn In This Section
Locked
4.2 What Are Excel Tables
Locked
4.3 Sales Report Analysis With Pivottables
Locked
4.4 Modify Source Data
Locked
4.5 Format The Sales Report
Locked
4.6 Complete The Sales Report Analysis
Locked
4.7 Section Summary
Locked
4.8 Challenge
Locked
+ 05. Slice and Dice Your Data 7 lectures
5.1 What Will We Learn In This Section
Locked
5.2 What Is Slicing Data
Locked
5.3 Slicing Data Project
Locked
5.4 Data Slicer Tools
Locked
5.5 Link Slicers To Multiple Pivottables
Locked
5.6 Section Summary
Locked
5.7 Challenge
Locked
+ 06. Connect to Databases 10 lectures
6.1 What Will We Learn In This Section
Locked
6.2 Connect To Databases
Locked
6.3 Import Data Sources
Locked
6.4 Use Pivottables To Refine Data
Locked
6.5 Consolidate Your Data Table
Locked
6.6 Format Large Data Sets
Locked
6.7 Slicer And Timeline In Large Data Sets
Locked
6.8 Refresh And Drill Down From Databases
Locked
6.9 Section Summary
Locked
6.10 Challenge
Locked
Description
About this course.
**Welcome to the Course: Introduction to PivotTables in Excel**
Unlock the power of PivotTables in Excel with this comprehensive introduction course. Whether you're a beginner looking to delve into the world of PivotTables or an intermediate user aiming to enhance your skills, this course covers fundamental concepts, formatting techniques, working with Excel Tables, and connecting to databases for a thorough understanding of PivotTable functionality.
**Who is this course for?**
- Beginners and intermediate Excel users looking to master PivotTable functionality.
- Data analysts and professionals aiming to leverage PivotTables for efficient data analysis.
- Anyone interested in enhancing their Excel skills for better data visualization and decision-making.
**Why Take this Course?**
- **Practical Learning:** Engage in hands-on projects and real-world applications of PivotTables.
- **Comprehensive Coverage:** Cover fundamental and advanced aspects of PivotTables for a well-rounded understanding.
- **Data Connectivity:** Learn how to seamlessly connect PivotTables to external databases for real-time analysis.
Elevate your Excel skills and become proficient in PivotTables with the "Introduction to PivotTables in Excel" course. Join us on this learning journey and discover the transformative capabilities of PivotTables for data analysis and reporting in Excel.
Instructors
Taught by people who ship.
John Bura
Founder and CEO of Mammoth Club and Course Pro, the #1 AI-powered Learning Management System for course and content development, training and evaluation.
Ready to start building?
Work with PivotTables and databases in this career advancing course.