👇🏻 Download example files
https://www.oppadu.com/엑셀-매출분석-대시보드/
⭐We have opened a membership channel for Brother Do Excel's We Can Do.
https://www.youtube.com/channel/UCZ6UHYBQFBe14WUgxlgmYfg/join
Pro: Live lecture full video replay provided
Premium: Participation in on-site workshops and exclusive posts for premium members
00:00 Excel Dashboard Lecture Start
00:32 Analyzing seasonal factors
02:35 Notes on monthly data analysis
03:42 Creating a seasonal factor analysis chart
06:12 Analyzing sales by day of the week
07:02 Change sort order with custom list
08:09 Create a sales analysis chart by day of the week
09:53 Weekday/holiday sales analysis
12:17 Analyzing Sales Trends
13:37 Creating a smooth line graph
15:51 Adding a slicer
17:25 Notes on connecting the slicer report
19:02 Decorating the Slicer
21:41 How to easily edit multiple shapes