Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 2 Minute(s)
Language
English
Taught by
Yoda Learning
Rating
Course Overview
This course is NOT for Beginners.
You can improve ONLY if you can measure. This course uses multiple mini-projects to teach you how to work with multiple Excel techniques to prepare your sales reports and perform analytics.
Sales Visualization techniques WITHOUT using Charts
Find correct sales by extracting Bank Account Codes from unclean data dumps
Analysis Sales by Bucket sizes 0-1000, 1001-2000, and so on
Combine Sales Ledgers of multiple months & Automate the process for next months
Analyze 3-years' sales using Pivot Table
Commission Calculation using different incentive periods
Allocating sales to different agents
Consolidating Sales of multiple products, multiple agents from different sheets
After Sales Service Tracking - Contract Expiry Date, TAT & Response Times
Course Content
- 1 section(s)
- 10 lecture(s)
- Section 1 Section 1
What You’ll Learn
- Multiple Excel techniques to prepare your sales reports and perform analytics
- Pivot Table
- SUMIFS and VLOOKUP for Slabs
- Date Formulas for After Sales Service
- Data Preparation for Analysis
- Data Consolidation
- Visualization without Charts
Skills covered in this course
Reviews
-
PPrince Gupta
Nice Course
-
FFadi ghassan Sami Mahmoud
amazing info
-
PPallavi Nimodia
yes it was good course
-
UUnni Krishnan K G
Mr Rishab is an amazing instructor and is very passionate in explaining the key points . Although the Module is short for 1 hr , it is still having lot of tools & techniques to save time and improve Automated results . Watching & Practicing will defientely improve the productivity
