엑셀 대시보드, 초보자를 위한 90분 총정리 가이드 - 보고서의 품격이 달라집니다!

✅ Download Example File & Self-Check Quiz https://www.oppadu.com/%ec%97%91%ec%8... 👇 We have included almost everything you need for practical work with Excel! Purchase the textbook "Practical Excel for Real Use" Kyobo Book Centre https://bit.ly/excel_kyobo Yes24 https://bit.ly/excel_yes Aladin https://bit.ly/excel_aladin ⭐Join the Oppa Do Excel We Can Do Membership Channel    / @oppadu   Pro: Full live lecture replays provided Premium: Premium-exclusive workshops and replay videos provided #ExcelDashboard #ExcelHouseholdAccountBook #ExcelLecture #Excel #ExcelBasics #PracticalExcel #PracticalExcelForRealUse #OppaDoExcel 00:00 Start of Lecture ---- 1st Session ---- 01:16 XLS file format, please be careful! 02:21 Converting Transaction History into a Table 03:40 How to Troubleshoot Style Issues When Using Tables 04:51 Adding Necessary Items to the Dashboard 05:31 Why Is Managing an Excel Household Account Book Difficult? 07:06 How to Utilize Table Features to Their Fullest 200% 10:07 How to Use Dynamic Table Ranges! 11:27 Creating an Auto-Expanding List Box 12:29 Shortcuts for Convenient List Box Usage 13:11 Formula for Automatically Classifying Each Expense Item 16:57 How to Fix When Table Formulas Don't Autocomplete 17:43 Filling in Account Classifications for Other Expenses 22:16 Adding Items Other Than Major Categories and Time Zones ---- 2nd Session ---- 24:02 Creating Pivot Tables for Dashboards 25:19 Useful Tips for Moving Panel Positions in Practice 25:44 ① Pivot Table for Expenses by Major Category 28:07 ② Pivot Table of Top 10 Transactions 28:57 Precautions When Using Slicers + Filters (Important!) 30:25 ③-1 Pivot Table for Monthly Expense/Income Status 31:21 How to Change Text Dates All at Once 32:36 ③-2 Completing the Pivot Table for Monthly Expense/Income Status 33:34 Useful Pivot Tables in Practice Layout 36:33 ④ Pivot Table of Expense Status by Time 37:06 ⑤-1 Pivot Table of the Last 30 Transactions 37:52 Pivot Table Dates, Correct Aggregation Method (Important!) 41:10 Aggregating Deposits/Withdrawals with Calculated Fields 42:01 ⑤-2 Completing the Pivot Table of the Last 30 Transactions 43:28 Visualizing Reports with Cell Formatting ---- 3rd Session ---- 45:46 Core Excel Dashboard Feature, Slicer! 47:21 Filtering Multiple Pivot Tables Simultaneously 48:17 Precautions When Using Report Links (Important!) 49:19 Hiding Unnecessary Buttons in Slicers 50:40 Slicer Design, How to Do It Easily! 53:49 Setting the Number of Slicer Buttons 54:42 Changing Slicer Headers 56:04 Creating Subheadings for Each Dashboard Item 56:51 ①-1 Creating a Chart of Expense Details by Major Category 59:51 Visualizing the Chart of Expense Details by Major Category 1:02:20 Shortcut Tips for Conveniently Moving Shapes 1:04:08 ② Creating a Chart of the Top 10 Expense Items 1:06:09 ③ Creating a Chart of Monthly Expense/Income Status 1:10:00 Solving Label Overlapping Issues in Bar Charts 1:12:22 ④ Creating a Chart of Expense Status by Time 1:14:40 Useful Line Chart Tips for Practical Work 1:15:50 Pivot Tables: Always Display Empty Items (Important!) 1:18:25 How to Link Missing Items in a Chart ---- 4th Period ---- 1:20:30 ⑤ Table of Top 30 Transaction History Creating 1:22:51 Enhancing User Convenience - Slicer Connection Settings 1:25:42 Creating a Text Box That Links in Real-Time 1:28:54 The Principle of Formulas for Calculating Last Update Date and Balance 1:30:06 Tips for Solving Cell Merging Issues When Using Functions 1:31:30 Calculating Last Update Date 1:33:37 Calculating Bank Account Balance 1:36:07 Completing the Household Account Dashboard and Final Testing