101 views
Link to the Awesome Hashtag Training Community: https://go.hotmart.com/G95796985Y?ap=... Link to the Data Analysis Intensive Course: https://go.hotmart.com/G95796985Y?ap=... Link to the Storytelling with Data Book: https://amzn.to/41PZ8ok Link to the Excel Spreadsheet: https://bit.ly/3Dt3PKo Learn how to create a pivot table in Excel from scratch and discover how to perform powerful analyses in a practical and efficient way! In this tutorial, you will see the step-by-step process for creating a simple Excel pivot table, perfect for beginners. We will explore the quantities sold by categories in a store and calculate the percentage that each one represents, both in general and filtering by gender, using data segmentation. In addition, I show you how to transform these analyses into pivot charts, making your data presentation even more visual and professional. In this video, you will learn: How to create a pivot table from scratch in Excel. Set up Excel pivot tables with charts for powerful analysis. Use the simple Excel pivot table with data segmentation to easily filter information. Perform advanced analysis intuitively, even if you are a beginner in Excel pivot tables.