Preparing an Advanced Sales Dashboard using MS Excel

Deal Score0
$6 $115
Deal Score0
$6 $115

Learn Data Formulas and Formatting, Macro, Sigma Analysis, Pivot, Trend Analysis, Montecarlo Simulation and Null Matrix

Preparing an Advanced Sales Dashboard using MS Excel
Preparing an Advanced Sales Dashboard using MS Excel

What you’ll learn

  • Learn Data Formulas and Formatting
  • Gain deep understanding in Macro
  • Learn Sigma Analysis, Budget, Pivot Table and Chart, Consolidation and Trend Analysis
  • We will be learning about Montecarlo Simulation, Null Matrix, Active Visavis and Inactive Analysis, Histogram And Regression Analysis
  • Learn Rank and Percentile and Descriptive Statistics

Requirements

  • Basic knowledge of excel tools and functions
  • Passion to learn and apply
  • MS Excel 2016 in your PC

Description

The main objective of this online training is to deliver the knowledge of advanced excel that a user can apply to create a sales dashboard without using any coding or intense programming. It being one of the most interesting usage of excel you might be excited to learn to create excel dashboards. We will begin with Data Formulas and Formatting. We will move further to learn more on Macro. This course will use advanced level of excel usage to form dashboard. We will use Sigma Analysis, Budget, Pivot Table and Chart, Consolidation and Trend Analysis. We will be learning about Montecarlo Simulation, Null Matrix, Active Visavis and Inactive Analysis, Histogram And Regression Analysis. We will touch upon critical topics like Rank and Percentile and Descriptive Statistics.

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

How can learn this Course?

1.Create Account / Login on Udemy.com
2. Learn Course by Enroll in this Course

Hurry Up! 

Enroll Here

We will be happy to hear your thoughts

      Leave a reply

      AllCouponFree
      Logo
      Enable registration in settings - general