Cómo Hacer un DASHBOARD INFORME DE VENTAS en Excel -Indicadores de Ventas- Cuadro de Mando de VENTAS
Summary
The video showcases how to create a dynamic sales dashboard in Excel that updates based on selected year or month. It covers creating various types of charts such as sales cost by category and linear sales graphs by month for each year. Additionally, the tutorial demonstrates how to customize the charts for better visual representation, add slicers for easy filtering, and organize the dashboard layout for a professional look. This comprehensive sales analysis tool allows for synchronized filtering and updates across different charts, providing a clear overview of sales data.
Introduction to Dynamic Sales Dashboard
Demonstration of creating a dynamic sales dashboard that updates based on selected year or month. Includes sales cost graph by category, linear sales graph by month for each year, and filters for category selection.
Setting up Data for Dashboard
Copying data from a base sales sheet to a new file, ensuring table formatting, and inserting a dynamic chart. Customizing the chart by changing chart type to bar graph, adjusting layout, and removing unnecessary elements like gridlines and labels.
Customizing Charts
Further customization of the chart by changing colors, adding data labels, adjusting style, and formatting chart elements for better visual representation of sales data.
Creating Additional Charts
Adding more charts for cost of sales, profit, and category wise sales. Customizing these charts and connecting them for synchronized filtering by year and month.
Final Dashboard Customization
Inserting slicers for easy data filtering, connecting charts for synchronized updates, and organizing the dashboard layout for a professional look. Adding a title and final touches for a comprehensive sales analysis tool.
Get your own AI Agent Today
Thousands of businesses worldwide are using Chaindesk Generative
AI platform.
Don't get left behind - start building your
own custom AI chatbot now!