49,329 views
Do you want to create a dashboard in Excel? Here you will learn how it works using the example of a household budget! Of course you can also use the procedure for all other types of dashboards. Timestamps: 00:00 Introduction 00:10 Data table 04:22 Worksheets 05:30 Creating a pivot table 06:08 Bar charts 12:11 Line chart 15:29 Donut chart 18:00 Tree map 22:09 Savings icon 24:08 Data slices 26:00 Design - formatting 28:44 Design - finish 29:16 Outro