Office Fundamentals - PivotTables in Microsoft Excel

Overview

Learn everything about creating and using PivotTables in Excel to analyze data and plot with PivotCharts & dashboards What you'll learn:

Properly structure raw data for analysis with PivotInsert and create PivotTablesEditing PivotTable fieldsAnalysis and organization of dataSort, filter, and group pivot dataWorking with values in PivotTablesCalculations with calculated fieldsCreate visual representations with PivotCharts & Dashboards Pivot tables are a quick and easy way to organize, summarize, and analyze raw data. In this course, you'll learn everything you need to know about pivot tables to work with them confidently in everyday life.

We start with the absolute basics and then build on that to learn more advanced and complex topics.We'll talk about formatting, sorting, filtering, grouping, working with values, calculated fields, and pivot charts, and even build our own dashboard to visualize our data and manipulate and customize these charts live.The course is designed to be hands-on.We will work with an extensive and practical example that will help you follow and understand the subject matter well.Our goal with this course is to make your daily work with Excel easier, and pivot tables are ideal for this.Since pivot tables are a special sub-topic of Microsoft Excel, it is, of course, helpful if you are already familiar with the program.Ideally, you should already know the basics of Excel if you want to work with pivot tables. We have already helped thousands of people to become office professionals in our courses, and I would be more than happy to welcome you to the course!

Syllabus

• Introduction to PivotTables
Understanding the Purpose and Benefits of PivotTables
Use Cases for PivotTables in Data Analysis
• Getting Started with PivotTables
Navigating the Excel Interface for PivotTables
Creating Your First PivotTable
• Organizing Data with PivotTables
Structuring Data Before Pivoting
Selecting and Arranging Fields: Rows, Columns, and Values
• Summarizing Data with PivotTables
Different Types of Aggregation: Sum, Average, Count, etc.
Customizing Aggregation Settings
• Analyzing Data with PivotTables
Sorting and Filtering Data within PivotTables
Grouping Data and Managing Subtotals
• Enhancing PivotTables
Adding Calculated Fields and Items
Inserting Slicers for Interactive Filtering
• Visualizing Data
Creating PivotCharts from PivotTables
Customizing Chart Types and Styles
• Advanced PivotTable Techniques
Utilizing Multiple Data Sources
Understanding and Using Power Pivot
• Best Practices for Efficient Data Analysis
Common PivotTable Mistakes to Avoid
Tips for Maintaining Accurate and Updated Data
• Practical Exercise and Case Studies
Real-world Scenarios for Hands-on Practice
Collaborative Group Exercise
• Conclusion and Resources
Recap of Key Concepts
Additional Resources and Further Learning Opportunities

---

Taught by

Johannes Ruof and Timothy Meixner

---

Subjects

Data Science