Excel Reports and Dashboards using Pivot Table - Part 1 | Malayalam
00:00 Introduction
01:14 Prepare data
02:03 Insert a pivot table
03:02 Configure pivot table
06:20 Format and Customize
12:00 Outro
Correction: At 00:10, Quantity Sold is shown as currency. Ignore the $ sign.
In this video, we will go through the process of creating a pivot table to analyze sales data, focusing on total revenue by category and product. We'll start with the basic steps to set up and configure the pivot table, including selecting the data range, choosing the appropriate fields, and applying formatting and customization. In the second part of the video, we'll learn how to generate monthly sales reports and identify the top 3 products. Finally, we'll see how to create interactive dashboards using pivot tables and pivot charts.
Worksheet available at https://github.com/rani-media/excel-b...
Excel Reports and Dashboards using Pivot Table - Part 2 | 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 ...
Excel beginner: Different methods to remove duplicates | Malayalam • Excel beginner: Different methods to remov...
Excel beginner: Excel tables | Malayalam • Excel beginner: Excel tables | Malayalam