Excel Data Analysis using Pivot Tables and Pivot Charts
Published 11/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 51 lectures (3h 53m) | Size: 2.5 GB
Utilize real-world case studies to master Excel pivot tables and pivot charts for data analysis
What you'll learn
Learn beginner to advance Excel Pivot Table Analysis Skills
Learn how to combine Pivot Tables and Pivot Charts for data analysis.
Master pivot table analysis step by step with homework and case study exercises at the end of each section
Test your skills with real world Pivot Table case studies
Requirements
Knowing your way around the excel environment
Microsoft Excel 2007-2019 or Office 365 (ideally for PC/Windows)
Description
Excel Pivot Tables are a must-have tool for anyone who works with data in Excel.
Pivot tables allow you to quickly summarize and analyze data, revealing trends and valuable insights into your data that you would not have discovered otherwise. Excel Pivot tables will provide quick, accurate, and intuitive answers to the most difficult analytics questions.
This course will provide a thorough understanding of Excel Pivot Tables through a hands-on approach with real-world simple but highly effective case studies, ensuring that skills learned can be immediately applied to any Excel data analysis tasks. To accomplish this, I will walk you through interactive, hands-on demos and Excel exercises along the way.
I will start by taking you through everything you need to know in Excel Pivot tables which will include
1) The data structure in Excel
2) Pivot Table layouts & styles
3) Design & formatting options
4) Sorting, filtering, & grouping tools
5) Calculated fields, items & values
6) Pivot Charts, slicers & timelines
7) Interactive Excel dashboards
We will then do some exercises to reinforce...
Read more
Continue reading...