Sales Productivity Dashboard using MS Excel - Beginners

Learn Database creation, extraction, Hyperlinks, Location Analysis, Statistical Analysis, Predictive and Exit Analysis
Instructed by: Institute of Investment Banking | Subject: Office Productivity, Microsoft

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. Who is the target audience? Commerce students Sales professional Students from the business administration Working professionals who go through the hectic working schedule of same repetitive work every day

@https%3A%2F%2Fwww.udemy.com%2Fsales-productivity-dashboard-using-ms-excel-beginners%2F%3Futm_medium=linkshare%26couponCode%3DIIBFREE

Course Info

• 49 Lectures
• 6.5 Hours
• Language: English
• Subject: Office Productivity, Microsoft
• Instructed by: Institute of Investment Banking
• Platform: Udemy