Excel Reports and Dashboards using Pivot Table - Part 2 | Malayalam
00:00 Introduction
00:42 Finding Monthly Sales
01:20 Finding Top 3 Products
02:10 Creating Dashboard
03:05 Adding Charts
04:41 Adding Metrics
05:00 Adding Slicer and Timeline
06:57 Themes and Styling
07:07 Outro
In the first part of our video, we covered the basics of setting up and configuring a pivot table to analyze sales data, focusing on total revenue by category and product. In this video, we'll generate monthly sales reports and identify the top 3 products. Then, we'll create interactive dashboards using pivot tables and pivot charts, combining multiple tables and charts, adding slicers and timelines for dynamic filtering, and customizing the layout for a professional presentation.
Worksheet available at https://github.com/rani-media/excel-b...
Excel Reports and Dashboards using Pivot Table - Part 1 | Malayalam • Excel Reports and Dashboards using Pivot T...
Excel Data Cleaning Ideas | Malayalam • Excel Data Cleaning Ideas | Malayalam
Excel data validation for error-free data entry | Malayalam • Excel data validation for error-free data ...