Excel Pivot Tables for Beginners [FULL COURSE]
Knowing how to create Pivot Tables is a must-have skill for Excel users who need to analyse data and build reports.
Whether you're a Data Analyst building an Excel-based dashboard, a small business owner who has to make some serious decisions or a home user who needs to summarize data for a personal project, Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) toolkit.
This training will provide you with a solid foundation that you can use to build your own pivot tables and reports.
With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarize, analyze, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on which you base your key decisions.
Pivot Tables have a reputation for being complicated and scary but by attending this training, you’ll be pleasantly surprised at how easy it is to use and create them.
Topics Covered:
Use cases: Why and when you should use a Pivot Table
Your raw data - do’s and don’ts
Create a simple Pivot Table with a few mouse clicks
Different ways to summarize your data - total, count and percent
Produce time-based reports (monthly, quarterly etc)
Apply formatting to a Pivot Table to make it easy to read and understand
Display Pivot Table data in alphabetical or numerical order
Represent the Pivot Table data as a chart/graph
How to update a Pivot Table when the source data changes
⏱ Timestamps
00:00:00 Introduction
00:00:37 What is a Pivot Table (and Why Do You Need to Know?)
00:04:56 Create a Basic Pivot Table
00:17:23 Prevent Column Widths Changing on Refresh
00:22:13 Calculating Percentages
00:26:17 Sort a Pivot Table
00:32:07 Filtering a Pivot Table
00:44:55 Slicers
00:54:58 Create a Chart from a Pivot Table
01:02:49 Refresh the Pivot Table and How to Change the Data Source
01:14:45 Introduction to The Data Model
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #pivottables #reports
Watch video Excel Pivot Tables for Beginners [FULL COURSE] online without registration, duration hours minute second in high quality. This video was added by user Mike Thomas 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,95 once and liked it 13 people.