
Create a dynamic, parameter-based interactive sales dashboard in Excel using dropdowns, slicers, timelines, and charts to visualize data on one screen for clear presentations.
Select a storage location, create and rename a new excel file named sales dash v2, and understand excel formats and VBA use while setting up the sales dashboard project.
Copy the data sheet into the dashboard file using the data tab to create a copy, then extract unique years, products, and regions for product-wise, region-wise, and yearly charts.
Identify required calculations by dividing data region wise to analyze sales by year and product. Set up regional datasets and prepare formulas for the dashboard.
Learn to build a dynamic Excel dashboard by using a dynamic parameter and the sumifs function to aggregate sales across product and region data sets.
Create a dynamic dashboard by using a separate data table with base data and region filters, applying if, match, and index lookups to highlight a selected product.
Insert and format charts in the dashboard, select a chart type for financial year data, and make visuals dynamic and embedded, paving the way for VBA automation in part two.
Learn to build a dynamic Excel sales dashboard by creating named ranges with the name manager, saving as a macro-enabled workbook, and applying a VBA selection-change event.
Format the dashboard charts in Excel, removing borders, grid lines, and legends for a clean, embedded view. Apply conditional formatting and dynamic controls to highlight selected products and brands.
Explore an interactive sales dashboard in Excel and learn the next steps to build and expand Excel skills through future videos.
Are you a professional using Excel on a daily basis in your tasks, If yes, then this is the course for you!
This course is going to transform the way you are using Excel by giving you an understanding of the Microsoft Excel - Interactive Sales Dashboard in Excel, by which you will be able to analyze complex data in Excel very easily.
Why this course is worth joining??
This course is worth your attention because in this course we are going to make those things possible in Excel which seems nearly impossible to you till now, also we will be solving complex problems live in this course by using Excel so that your vision of using excel will be changed, after that we will see how experts work in Excel to reduce their hours of working using Excel features.
By the completion of the course you'll be able to:
1. An Interactive Excel Dashboard for your data using advanced excel tricks
Course Delivery:-
The delivery of the course will be via the online dashboard of Udemy. All the videos, resources, PDFs, PPTs, Excel Workbooks, and case studies will be uploaded there for quick access of participants.
Eligibility:-
Although there are no fixed eligibility criteria but deep desire to learn Excel is required. With this, anyone with the basic knowledge of using Excel can join.
Duration:-
The course continues with 1.5 hours of videos and Excel Exercise Workbooks
Salient features of Interactive Sales Dashboard in Excel:-
1. Completely online, no bar on access. You can access it anytime and from anywhere
2. Everything is discussed with an example & detailed cases so that practical situations. Issues in its applicability faced by the industries and businesses are covered and discussed with a solution
3. Working Files are shared so that it will be easy for the students to perform their practice
4. Every aspect is discussed with practical files & real-life problems
5. A lot of tricks & cases are discussed so that way of using Excel can be changed