Estado de Resultados | Dashboard en Excel

In this video, we'll create a basic dashboard focused on analyzing the Income Statement data of a fictitious company. The dashboard will allow us to track metrics such as net income, remaining debt, fixed expenses, etc. We'll also create the basic structure of the income statement. To create this dashboard, we'll use visualizations such as: cards, progress charts, line and column charts. All of this will help us design a great dashboard in Excel. 🎞️Chapters 00:00 Introduction 01:34 Prerequisite 01:49 Database 03:58 Income Statement Structure 23:08 Metrics - Remaining Debt, Fixed Expenses, and Depreciation 29:13 Line Chart - Net Income Change and Variation 33:48 Line Chart - Net Sales Change and Variation 37:20 Progress Chart - Gross Profit Margin and Operating Profit Margin 39:53 Column Chart - Cost Change and Variation 43:58 Treemap Chart 49:01 Data Slicers 📌Download the worksheet. https://drive.google.com/file/d/1f4B3... --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- If you'd like the full Dashboard, you can get it here: https://go.hotmart.com/L96718171L?dp=1 Song: Fwends Author: Reed Mathis