Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

MS Excel - Preparing a Beginners Sales Dashboard

via Udemy

This course may be unavailable.

Overview

Learn Database creation, extraction, Hyperlinks, Location Analysis, Statistical Analysis, Predictive and Exit Analysis

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

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 understandSingular 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.

Taught by

Institute of Investment Banking

Reviews

4.6 rating at Udemy based on 41 ratings

Start your review of MS Excel - Preparing a Beginners Sales Dashboard

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.