Office Fundamentals PivotTables in Microsoft Excel
What you’ll learn
Properly structure raw data for analysis with Pivot
Insert and create PivotTables
Editing PivotTable fields
Analysis and organization of data
Sort, filter, and group pivot data
Working with values in PivotTables
Calculations with calculated fields
Create visual representations with PivotCharts & Dashboards
Requirements
A PC
Microsoft Excel
Description
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!
Overview
Section 1: Einführung
Lecture 1 Welcome to the course!
Lecture 2 Why PivotTables? What are they good for?
Section 2: PivotTable Fundamentals – Learning the basics
Lecture 3 Overview and download of the example data file
Lecture 4 Structuring the source data
Lecture 5 Creating and inserting PivotTables in Microsoft Excel
Lecture 6 The PivotTable fields explained
Lecture 7 PivotTable tabs in the Excel ribbon
Lecture 8 PivotTable actions and how we can use them
Lecture 9 Refreshing and Changing the data source for PivotTables
Lecture 10 Tips for working with growing source data
Lecture 11 The PivotTable Cache explained
Lecture 12 Pro tip for generating filtered subsets of data
Section 3: Formatting PivotTables
Lecture 13 Intro – Formatting PivotTables
Lecture 14 Number formatting with PivotTables
Lecture 15 Table layout and customizing the view
Lecture 16 Using tabular layout to create exportable data sets
Lecture 17 Creating custom PivotTable styles
Lecture 18 Changing labels inside of a PivotTable
Lecture 19 Conditional formatting to show the highest values
Lecture 20 Highlighting top and bottom values using conditional formatting
Lecture 21 Visualization with data bars
Lecture 22 Visualization with icon sets and color scales
Lecture 23 Conditional formatting specifically for PivotTables
Lecture 24 Preventing PivotTables from resizing on update
Section 4: Sorting, Filtering and Grouping with PivotTables
Lecture 25 Intro – Sorting, Filtering and Grouping
Lecture 26 Overview of the different sorting options
Lecture 27 Sorting by custom lists
Lecture 28 Filtering with manual selections and label filters
Lecture 29 Pro tip for faster manual selection filters
Lecture 30 Filtering with wildcards
Lecture 31 Using value filters
Lecture 32 Using multiple filters simultaneously
Lecture 33 Creating custom groups in a PivotTable
Lecture 34 Automatic date grouping and options
Lecture 35 Visual filtering using slicers
Lecture 36 Visual date filtering using timelines
Lecture 37 Creating and showing report filter pages
Section 5: Working with values in PivotTables
Lecture 38 Intro – Working with values
Lecture 39 Summarizing values by different methods
Lecture 40 “Show values as…” options
Lecture 41 Show values as % of parent total
Lecture 42 Show values as difference
Lecture 43 Show values as running totals
Lecture 44 Show values as rank
Lecture 45 Visual improvements for large PivotTables
Lecture 46 Show values as index with example
Section 6: Working with calculated fields in PivotTables
Lecture 47 Intro – Calculated Fields
Lecture 48 Using calculated fields in PivotTables
Lecture 49 Using count in calculated fields
Section 7: Visualizing data analysis with PivotCharts & Dashboards
Lecture 50 Intro – PivotCharts and Dashboards
Lecture 51 Creating PivotCharts
Lecture 52 Pie Charts and using multiple PivotCharts
Lecture 53 Visually improving PivotCharts
Lecture 54 Multiple dimensions in PivotCharts
Lecture 55 Filtering PivotCharts using timelines and slicers
Lecture 56 Creating a dashboard from PivotCharts
Lecture 57 Visually improving the dashboard
Lecture 58 Printing the dashboard
Excel beginners,Advanced Excel users
Course Information:
Udemy | English | 5h 43m | 4.28 GB
Created by: Johannes Ruof
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com