Vishwajeet - Microsoft Excel tutor - Blacktown

1^st lesson free

Vishwajeet

Rate £46,820
Response 6h
Students
Number of students Vishwajeet has accompanied since arriving at Superprof
4
Number of students Vishwajeet has accompanied since arriving at Superprof

£46,820/hr

1^st 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

- Online

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.

About the lesson

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.

Rates

Rate

£46,820

Pack prices

5h: £234,102
10h: £468,203

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.

online

£46,820/h

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

Lesson location

About Vishwajeet

About the lesson

Rates

Rate

Pack prices

free lessons

online

Similar Microsoft Excel teachers in Blacktown

Excel | vba | power bi expert, engineer. flexible dates, week-end, invoice for enterprise

I am a cpa, have been using excel for over 20 years in the commercial world. whether you want to learn excel, set up a budget template, understand structure and formulas behind existing excel sheet .

Increase your productivity and efficiency by learning excel. want to impress at a job interview or prepare for an exam? make an appointment for a free consultation.

Master financial modeling in excel | expert tutor for hands-on, practical training for career and academic success

Unlock the power of excel: expert consulting for all skill levels! big4 accountant and financial analyst teaches you how to make custom tables, models, and sheets!

Course in excel vba (beginners, intermediate, advanced) for creation of automated documents

Microsoft office specialist certified expert tutor (excel, access, word, powerpoint & outlook) - virtual / remote only

Ms office programs (excel, powerpoint, word) training from industrial engineer to expert level.

Qualified accountant with over 10 years excel experience. patient and understanding teaching style for beginners, intermediate or experienced excel users.

Apprentice engineer at sorbonne utc, i help you with handling excel, formulas, tcd, validation... more info: iazz(.)fr

Are you looking for improving your ms office level: excel, powerpoint, word, etc.?

[milan] computer science and maths private lessons at home (bachelor degree in computer science)

Grande ecole graduate and founder of ijschool offers office automation courses (pack office) / cpf financing, pôle emploi accepted / invoice possible

A tutor with more than 15 years of experience using microsoft office

It engineer with 110 cum laude. it lessons of excel and databases. even for homogeneous groups.

Business intelligence analyst, excel teacher and consultant. i can teach you excel, from basic to advanced!

Learn excel from basic to advanced in an efficient and practical way

Excel and ms office help for work tasks, reports, and productivity | certified tutor with 20+ years of experience!

Expert in microsoft excel and computer beginners ramp-up. adapt course from the basics to the advanced.

Industrial engineer with experience in operations control for excel classes and consultancies (formulas, logical functions, report generation, pivot tables, vba (macros) and dashboards)

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

Lesson location

About Vishwajeet

About the lesson

Rates

Rate

Pack prices

free lessons

online

Similar Microsoft Excel teachers in Blacktown

Excel | vba | power bi expert, engineer. flexible dates, week-end, invoice for enterprise

I am a cpa, have been using excel for over 20 years in the commercial world. whether you want to learn excel, set up a budget template, understand structure and formulas behind existing excel sheet .

Increase your productivity and efficiency by learning excel. want to impress at a job interview or prepare for an exam? make an appointment for a free consultation.

Master financial modeling in excel | expert tutor for hands-on, practical training for career and academic success

Unlock the power of excel: expert consulting for all skill levels! big4 accountant and financial analyst teaches you how to make custom tables, models, and sheets!

Course in excel vba (beginners, intermediate, advanced) for creation of automated documents

Microsoft office specialist certified expert tutor (excel, access, word, powerpoint & outlook) - virtual / remote only

Ms office programs (excel, powerpoint, word) training from industrial engineer to expert level.

Qualified accountant with over 10 years excel experience. patient and understanding teaching style for beginners, intermediate or experienced excel users.

Apprentice engineer at sorbonne utc, i help you with handling excel, formulas, tcd, validation... more info: iazz(.)fr

Are you looking for improving your ms office level: excel, powerpoint, word, etc.?

[milan] computer science and maths private lessons at home (bachelor degree in computer science)

Grande ecole graduate and founder of ijschool offers office automation courses (pack office) / cpf financing, pôle emploi accepted / invoice possible

A tutor with more than 15 years of experience using microsoft office

It engineer with 110 cum laude. it lessons of excel and databases. even for homogeneous groups.

Business intelligence analyst, excel teacher and consultant. i can teach you excel, from basic to advanced!

Learn excel from basic to advanced in an efficient and practical way

Excel and ms office help for work tasks, reports, and productivity | certified tutor with 20+ years of experience!

Expert in microsoft excel and computer beginners ramp-up. adapt course from the basics to the advanced.

Industrial engineer with experience in operations control for excel classes and consultancies (formulas, logical functions, report generation, pivot tables, vba (macros) and dashboards)

Share

Tutor profile verified

levels

All languages in which the lesson is available

Review

Reviews

Recommendations

free lessons

Report this ad