1st class free
Vishwajeet's email address and phone number have been validated.
Vishwajeet
- Rate ₹3,088
- Response 12h
-
Students3
Number of students accompanied by Vishwajeet since their arrival at Superprof
Number of students accompanied by Vishwajeet since their arrival at Superprof
₹3,088/hr
Contact
1st class free
- Microsoft Excel
Tutoring in Intermediate to advanced Excel by a Data Analyst having over 6 years of experience with Australian pharmacy and beverages retail organisations. Simulations of real life data analytics proj
- Microsoft Excel
Class location
About Vishwajeet
I have got over 5 years of experience working Data Analyst in leading pharmacy and beverages retail companies of Australia. My role predominantly was to extract the complex and large datasets from various internal and external sources, cleanse them to make them analysis ready.
While working as Retail Operations Analyst in one of the beverages retail companies of Australia, my activities included analysing performance of various financial and basket measures like [Sales/Purchases/Cost/Gross Margin/Total Baskets/Average Basket value/Lines Per Basket/Price Per Line], recording their growth over LY, picking trends of key measures, benchmarking performances, creating and managing Performance Score cards, analysing distribution of high margin Private Label products amongst stores, analysing SLOB items, analysing promotional prices of our banners against the competition, creating SOPs etc.
While working as Pricing Analyst in one of the pharmacy retail companies of Australia, my activities included creating Excel templates for automating pricing algorithms, analysing performance of marketing activities like monthly catalogues/supplier trainings etc., analysing performance of Categories/ Subcategories/ Suppliers/ Brands, identifying underperforming products and giving ranging recommendations to Category Managers based on the analysis.
See more
About the class
- Classes 6 to 8
- Class 10
- Classes 11 & 12
- +13
levels :
Classes 6 to 8
Class 10
Classes 11 & 12
BTech
Adult Literacy
Undergraduate
Masters
PG Diploma
PhD
Beginner
Intermediate
Advanced
Professional
Others
Children
Class 12
- English
All languages in which the class is available :
English
Unlock Your Data Potential with Expert Guidance!
Are you ready to master the art of data analysis and elevate your skills to new heights? With my extensive experience in Advanced Excel, I offer a unique learning journey tailored for you.
Transform your data into insightful reports that would aid in making data-driven decisions. My hands-on approach ensures you grasp the intricacies of creating Excel based Reports, Dashboards and Templates using basic to advanced level functions, features & formulae including:
- Lookup Functions - VLOOKUP/XLOOKUP/INDEX MATCH)
- Conditional Aggregations - COUNTIFS/SUMIFS/AVERAGEIFS/MAXIFS/MINIFS)
- Data Summarisation using Pivot Tables/Charts
- Conditional Formatting
- Complex Nested Formulae
- Advance Features - Power Pivot, Power Query etc.
- Price Forecasting Using Data Analytics Tool pack - Regression Modelling and Excel Solver (for select users who are into retail pricing)
Will share some real life project experience such as:
- 360 Degree Category Performance Review
- Performance Score Card
- Distribution of High Margin/Desired products in Stores/Branches
- Can create new projects tailored to your business needs.
See more
Rates
Rate
- ₹3,088
Pack prices
- 5h: ₹15,442
- 10h: ₹30,884
free classes
This first free class with Vishwajeet will allow you to get to know each other and to specify the exact learning requirements for the upcoming classes.
- 1hr
online
- ₹3,088/hr
Similar Microsoft Excel teachers in Blacktown
Abhishek
Noida & Online
- ₹800/hr
- 1st class free
Sweta
Mumbai & Online
- ₹700/hr
Rupal
Gurugram & Online
- ₹1,400/hr
- 1st class free
Reet
Ghaziabad & Online
- ₹850/hr
- 1st class free
Neha
Gurugram & Online
- ₹1,000/hr
- 1st class free
Abhay
Bengaluru & Online
- ₹2,000/hr
- 1st class free
SHILPA
Faridabad & Online
- ₹700/hr
- 1st class free
Sharad
Ghaziabad & Online
- ₹1,999/hr
Ankit
New Delhi & Online
- ₹599/hr
- 1st class free
Mahendra
Hyderabad & Online
- ₹600/hr
- 1st class free
Shekku
Bengaluru & Online
- ₹1,600/hr
- 1st class free
Rajan
Thane & Online
- ₹1,500/hr
Aparajita
& Online
- ₹330/hr
- 1st class free
Yatendra
Noida & Online
- ₹500/hr
- 1st class free
Aniket
Bengaluru & Online
- ₹3,000/hr
- 1st class free
Pawan
Ghaziabad & Online
- ₹1,500/hr
Sandeep
& Online
- ₹2,000/hr
- 1st class free
Divya
Bengaluru & Online
- ₹1,200/hr
- 1st class free
Nikita
Solan & Online
- ₹350/hr
- 1st class free
Sajida
New Delhi & Online
- ₹999/hr
- 1st class free
-
More Microsoft Excel teachers
