MS Excel - Preparing a Beginners Sales Dashboard
What you'll learn
- Learn Database creation, Database extraction, Index designing, Process flow, Hyperlinks
- Explore concepts like Cluster analysis, Graphs, Macro filters, Target vs achievement analysis
- Learn Zone comparison, State comparison, Data consolidation
- Learn CAGR, Correlation analysis, Moving average, Standard deviation
Requirements
- Basic knowledge of excel tools and functions
- Passion to learn and apply
- MS Excel 2016 in your PC
Description
These dashboards help to maintain huge chunks of data and also to convert dashboard data into user friendly visuals. These online tutorials are indeed self-paced and one can easily make way and learn to create out dashboards and business intelligence and understand the importance of data trending and create valuable data visualizations. In this training and the beginners training on the same topic, we shall learn Database creation, Database extraction, Index designing, Process flow, Hyperlinks. We will also have a deep understanding on business analysis. We will explore concepts like Cluster analysis, Graphs, Macro filters, Target vs achievement analysis. We will understand Location Analysis through Zone comparison, State comparison, Data consolidation. For doing statistical modeling, we will learn CAGR, Correlation analysis, Moving average, Standard deviation. For doing Predictive analysis, we will look at Trendline, Michael t. Robinson generation analysis, Advanced filters, Excel solver. As a part of Exit Analysis, we will concentrate on %loss reports, growth ratios, scenario manager. We shall also understand Singular view, Data validations, Performance linked growth and CTC.
These dashboards help to maintain huge chunks of data and also to convert dashboard data into user friendly visuals. These online tutorials are indeed self-paced and one can easily make way and learn to create out dashboards and business intelligence and understand the importance of data trending and create valuable data visualizations. The training includes the following information;
INTRODUCTION – We shall learn Database creation, Database extraction, Index designing, Process flow, Hyperlinks.
BUSINESS ANALYSIS – Here we will explore concepts like Cluster analysis, Graphs, Macro filters, Target vs achievement analysis.
LOCATION ANALYSIS – In this sections we are considering Zone comparison, State comparison, Data consolidation.
STATISTICAL MODELLING – Let’s learn CAGR, Correlation analysis, Moving average, Standard deviation.
PREDICTIVE ANALYSIS – Lets look at Trendline, Michael t. Robinson generation analysis, Advanced filters, Excel solver.
EXIT ANALYSIS – Here we shall concentrate on %loss reports, growth ratios, scenario manager.
SALE EMPLOYEE PROFILE – Lets understand Singular view, Data validations, Performance linked growth and CTC vis-à-vis target.
CONCLUSION – In the concluding lecture we will see Full screen macro, Protect sheet, Protect file, Presentation view macro, Page layout.
Who this course is for:
- Commerce students
- Sales professional
- Students from the business administration
- Working professionals who go through the hectic working schedule of same repetitive work every day
Instructor
![Banking and Finance School](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 3.7 Instructor Rating
- 3,670 Reviews
- 100,637 Students
- 31 Courses
Banking and Finance School (BFS) offers a comprehensive range of professional Online Courses and Classroom Programs in Finance and Investment Banking. BFS is the Premier Finance Training Provider around the world. BFS has built a strong online platform and caters to self-paced learning, online learning and classroom mode of learning. Our courses are taught by industry experts. Our courses are driven by a constant need to be job relevant and stimulating, taking into consideration the dynamic nature of the Financial Services and Analytics market. We empower you with practical knowledge through our courses. With us, you get the intensive experience that will expose you to new challenges, and innovative ideas to perform better in your career. We've been offering our courses for more than a decade and our alumni are already doing a remarkable job across the globe. Our academic excellence goes beyond theoretical knowledge or setting you up to memorize things, our courses are built around applied Finance. We're proud of people who give us their time and commitment. We're looking for people who are ready to level up, who care to up-skill and re-skill with changing time and work demand. One thing we preach is that any learning needs focus, commitment, and consistency. Come and Join our courses and take a leap.