Vishwajeet - Microsoft excel tutor - Blacktown

1^st lesson free

Vishwajeet

Rate €28
Response 6h
Students
Number of students Vishwajeet has accompanied since arriving at Superprof
4
Number of students Vishwajeet has accompanied since arriving at Superprof

€28/h

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

€28

Pack prices

5h: €139
10h: €277

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

€28/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 tutors in Blacktown

Business analytics and ai professional, teaching ms excel all levels. more than 10 years professional experience using excel

Patient excel tutor. i also tutor ms power bi and sql! i spent 20 years in analytics, and now i have spent four years as a full-time tutor!

I am a master's student who teaches computer. i provide personalized methodology to meet all your individual needs.

Aca qualified accountant with over 8 years experience using & developing my skills in microsoft excel

Learn ms excel with an experienced tutor: formulas, data analysis & advanced skills

Business graduate, comprehensive professional experience making spreadsheets, data treatments, pivot tables, formulas, dashboards and data analysis using the many tools microsoft excel provides.

Hi! i’m aaron — excel, power bi & power automate tutor i help professionals and students learn excel, power bi, and power automate from basics to advanced real-world skills.

10+ years experience in data science and analytics. master in artificial intelligence from nci. currently working as a professional data scientist.

A corporate finance manager using ms excel for over 7 years. i have been helping professionals and students beef up their excel skills from beginner to pro level.

Whether you’re a student, business professional, or simply eager to sharpen your skills, excel mastery is just a class away!

Master excel for projects, jobs & business – learn from a business analytics postgrad

Cima-qualified accountant and excel expert in management reporting, budgeting and forecasting, financial analysis and modelling, and finance transformation projects.

Excel mastery unleashed: msc business analyst offering expert tuition with 8 years of proven experience! #superprof #exceltutor

Learn excel quickly – personalized lessons available. formulas, data analysis using pivots and dashboards made easy.

Learn 20% of excel for 80% of your needs – practical and efficient lessons

Advance excel for everyone. i am research assistant. i always use excel. big data, functions, graphics everything is here

Computer science and business secondary school teacher offering essential computer skills/computer science, leadership and business/economics/accounting & maths lessons up to a professional level in i

Data analyst and ucd postgraduate student teaches microsoft excel from beginner to advanced levels in dublin and online.

I have worked professionally on ms excel for 15 years. i worked with audit firms like kpmg and converted messed up data to workable data. this would be fora beginners level. you could save a lot of t

Aprendé excel desde cero o mejorá tus skills con clases online claras y aplicadas.

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 tutors in Blacktown

Business analytics and ai professional, teaching ms excel all levels. more than 10 years professional experience using excel

Patient excel tutor. i also tutor ms power bi and sql! i spent 20 years in analytics, and now i have spent four years as a full-time tutor!

I am a master's student who teaches computer. i provide personalized methodology to meet all your individual needs.

Aca qualified accountant with over 8 years experience using & developing my skills in microsoft excel

Learn ms excel with an experienced tutor: formulas, data analysis & advanced skills

Business graduate, comprehensive professional experience making spreadsheets, data treatments, pivot tables, formulas, dashboards and data analysis using the many tools microsoft excel provides.

Hi! i’m aaron — excel, power bi & power automate tutor i help professionals and students learn excel, power bi, and power automate from basics to advanced real-world skills.

10+ years experience in data science and analytics. master in artificial intelligence from nci. currently working as a professional data scientist.

A corporate finance manager using ms excel for over 7 years. i have been helping professionals and students beef up their excel skills from beginner to pro level.

Whether you’re a student, business professional, or simply eager to sharpen your skills, excel mastery is just a class away!

Master excel for projects, jobs & business – learn from a business analytics postgrad

Cima-qualified accountant and excel expert in management reporting, budgeting and forecasting, financial analysis and modelling, and finance transformation projects.

Excel mastery unleashed: msc business analyst offering expert tuition with 8 years of proven experience! #superprof #exceltutor

Learn excel quickly – personalized lessons available. formulas, data analysis using pivots and dashboards made easy.

Learn 20% of excel for 80% of your needs – practical and efficient lessons

Advance excel for everyone. i am research assistant. i always use excel. big data, functions, graphics everything is here

Computer science and business secondary school teacher offering essential computer skills/computer science, leadership and business/economics/accounting & maths lessons up to a professional level in i

Data analyst and ucd postgraduate student teaches microsoft excel from beginner to advanced levels in dublin and online.

I have worked professionally on ms excel for 15 years. i worked with audit firms like kpmg and converted messed up data to workable data. this would be fora beginners level. you could save a lot of t

Aprendé excel desde cero o mejorá tus skills con clases online claras y aplicadas.

Share

Tutor profile verified

levels

All languages in which the lesson is available

Review

Reviews

Recommendations

free lessons

Report this ad