This is my new shopping mall.
https://excellatte.etsy.com
Practice file link: https://www.buymeacoffee.com/exceltutorial/e/189011
Completed file:
https://www.etsy.com/de-en/listing/1757842450/interactive-sale-dashboard-claim
For a Quick Start, go to 01:19 (Open an Excel File)
Contents:
00:00 Intro & Demonstration
01:19 Open an Excel File
01:33 Making a dashboard background
01:59 How to make a textbox
03:23 How to align objects
03:56 How to make a dashboard frame
07:18 Creating Pivot Tables
11:07 Tips for changing cell format
13:08 How to make slicers
16:00 Creating a monthly claim chart
18:43 Creating a Top5 claim product chart
21:54 Creating a claim reason chart
23:38 Creating a claim status chart
26:51 Creating a claim resolution chart
27:28 Creating a claim priority chart
28:21 Creating a claim reason by product chart
29:28 Creating a customer evaluation chart
32:05 Making a moving button
33:05 Adding updating function in VBA
34:02 Protecting chart shapes