Course Outline
- Create and Design customer and product database
- Import data from multiple resources
- Pareto Analysis on products, customers, and sale revenues
- Sales snapshots without any visualization techniques
- Automate customer follow up database using advanced conditional formatting
- Contemporary Excel techniques to prepare sales reports and sales analytics
- Find best market segment and target through multiple statistical techniques
- Advanced visualization on sales reports.
- Estimate future sales forecasts and budgets using regression and predictive modeling techniques
- Find the correlation between quantitative variables for effective decision making
- Combine sales data of multiple salespersons/ regions for the master database
- Sent automatic emails to customers on overdue invoices, deadlines dates etc
- Contemporary Excel techniques to Clean and analyze past sales data
- Apply what-if analysis on multiple controlled and uncontrolled variables
- Automatic append sales data collected from different resources