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
