Preparing a Beginners Sales Dashboard using Excel

Preparing a Beginners Sales Dashboard using Excel

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

Requirements

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

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
Tutorial Bar
Logo