1st lesson free
The profile of Vishwajeet and their contact details have been verified by our experts
Vishwajeet
- Rate 351 GHS
- Response 6h
-
Students2
Number of students Vishwajeet has accompanied since arriving at Superprof
Number of students Vishwajeet has accompanied since arriving at Superprof
351 GHS/hr
Contact
1st lesson 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
Lesson 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 lesson
- Junior high school
- SHS 1
- SHS 2
- +13
levels :
Junior high school
SHS 1
SHS 2
BTS
Adult Education
Facultate (Licență)
Master's degree
Higher national diploma
Doctor of philosophy
Beginner
Intermediate
Advanced
Professionel
Others
Child
SHS 3
- English
All languages in which the lesson 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
- 351 GHS
Pack prices
- 5h: 1,755 GHS
- 10h: 3,510 GHS
online
- GHS351/h
free lessons
The first free lesson with Vishwajeet will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
Similar Microsoft Excel teachers in Blacktown
N'rele Ferdinand
Accra & Online
- 30 GHS/hr
- 1st lesson free
James
Accra & Online
- 50 GHS/hr
- 1st lesson free
Adjoa
Accra & Online
- 200 GHS/hr
- 1st lesson free
Mourad
Paris 12e, France & Online
- 581 GHS/hr
- 1st lesson free
Erica
Fairfield, Australia & Online
- 468 GHS/hr
Ireneusz
Gdańsk, Poland & Online
- 270 GHS/hr
- 1st lesson free
Billy
Bullhead City, United States & Online
- 566 GHS/hr
- 1st lesson free
Arbaz
New York, United States & Online
- 453 GHS/hr
- 1st lesson free
Matthieu
Tigery, France & Online
- 387 GHS/hr
- 1st lesson free
Adi
Toronto, Canada & Online
- 398 GHS/hr
- 1st lesson free
Zammad
New York, United States & Online
- 566 GHS/hr
- 1st lesson free
Ben
Southampton, United Kingdom & Online
- 674 GHS/hr
- 1st lesson free
Ilian
Paris 8e, France & Online
- 323 GHS/hr
- 1st lesson free
Marc
New York, United States & Online
- 1,416 GHS/hr
Patricia
Madrid, Spain & Online
- 323 GHS/hr
Inès
Paris 1er, France & Online
- 581 GHS/hr
Abhishek
Noida, India & Online
- 108 GHS/hr
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & Online
- 194 GHS/hr
Moreno
Monza, Italy & Online
- 645 GHS/hr
- 1st lesson free
Matthew
London, United Kingdom & Online
- 584 GHS/hr
- 1st lesson free
-
See Microsoft Excel tutors
