Pavan
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from31.53USD/ h

VBA (Excel, Word, Outlook) training with Practical Sessions

VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results.

Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc...

Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.

Extra information

A discussion would be needed before beginning the session to understand the level and to adapt the training. A hands on session is absolutely recommended to test the learning and reinforce what is learnt

Location

At teacher's location: Meilaan, 1200 Sint-Lambrechts-Woluwe, Belgium
At student's location: Around Brussels, Belgium
Online via webcam

|
Use ⊞+wheel to zoom!
+

General info

Skills:

Age:

Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)

Student level:

Beginner
Intermediate
Advanced

Duration:

60 minutes

The class is taught in:

English, French

About Me

Enterprising, tech savvy person, with proven experience in Financial Modelling and who is also a motivated & fast learner; Open to opportunities which present immense potential to learn, grow and make an impact with people and processes.

I am undertaking involves tasks such as automating workflows to save time, improve processes by building custom Windows applications with VBA on Microsoft Office platform. I would like to offer training to share my knowledge and reach more people.

Education

EDHEC Business School
Master of Science, Strategy and Organization Consultancy
2014 – 2015

EDHEC Business School
Masters in Management, Business Administration and Management, General
2012 – 2013

National Institute of Engineering, Mysore
Bachelor of Engineering (BE), Electrical and Electronics Engineering
2007 – 2011

Experience / Qualifications

DS Smith
Financial Business Analyst
September 2017 – Present (11 months)Brussels Area, Belgium
☛ Coordination of KPI Data Collection, Consolidation, Understanding Key business drivers and Challenge where relevant, trend analysis
☛ Analysis and Support the presentation of Sales and Business Development reports to Sales Organisation and Management
☛ Support Process/Methodology enhancement, tool maintenance and data testing
☛ Dashboard and Report building including profitability reports for Market Segmentation project

MasterCard
Analyst, Deal Management (Business Development, Finance)
September 2015 – September 2017 (2 years 1 month)Belgium
☛ Assisting with analysis to support Customer Account Managers
☛ Supporting operational functions and recommending solutions for problem resolution & process improvement
☛ Identification of opportunities to improve the quality and success rate of proposals
☛ Building and maintaining financial models and business cases - Part of implementation of standard models across Europe and Asia Pacific regions
☛ Addition of features to the financial models and business case based on Regulatory and/or business requirements
☛ Building and maintaining custom made tools for internal control process involved with contract review and signature process
☛ Management and executive reporting

Undertook various initiatives in areas related to Internal controls, compliance, legal/contract management and process improvements.

Entrepreneurs That SOAR!
Business Development Coordinator
December 2014 – August 2015 (9 months)
Virtual Internship - New Media marketing

☛ Collaborated with the president of the group to Create Products and Service Plans to leverage on Video Capabilities for Marketing efforts. (B2B Solutions)
☛ Creation of Online Community offering learning materials on subjects such as benefiting from the tools of new media marketing and use of Webcasts, Webinars and Virtual events to boost business

Toyota Motor Europe
Pricing, Sales & Marketing
June 2013 – July 2014 (1 year 2 months)Brussels Area, Belgium
Principle responsibility was to support the Lexus pricing team to handle pricing process in the Pan-European market, and Price Lexus models expected to be launched in 2014.
Key assignments or Projects included

☛ Price scheduling - A monthly process involving finalizing the pricing structure throughout the value chain and its impact on either side of the chain.
☛ Net price positioning - A quarterly process involving selection of competitor basket, comparing the prices in a normalized platform and providing all the necessary information for taking a pricing decision.
☛ Value table revision - A price table used for net price positing in order to compare Similar cars. The values are used to evaluate the advantages and disadvantages among the models chosen based on standard equipment on each of those models.
☛ New model pricing - Analysis and price structure for the introduction of the Lexus RC and the RC F in 13 countries of Europe.
☛ Assisting the Product division in creating a new safety strategy across all models of Toyota and Lexus in Europe.
☛ On demand / on request study of taxation, products and specifications offered in various countries under jurisdiction.

ABB India Ltd.
Engineer/Management trainee, Sales and Marketing, Low Voltage Systems & Process Automation
June 2011 – July 2012 (1 year 2 months)Bengaluru Area, India
☛ Participated and drove the definition and preparation of marketing tools customized for local needs: Technical clarifications, Solution description, technical consulting.
☛Assisted in planning for production with feeder listing and standard specification
☛ Interfacing with the front-end office for understanding the requirements and assembling them for further processing as every product was custom made.
☛ Involved in costing
☛ Trained in general commercial aspects and Project Management
☛ Worked for standardizing the offers made for stackers-reclaimers in process Automation Division as an individual project

Reviews (6)

Great teacher, inspiring and he knows his stuff
Pavan is a very pleasant and knowledgeable person.
Pavan was excellent. A very patient teacher, knew exactly what was needed and we will certainly use him again!
Pavan is a great teacher and straight forward.
Very competent and very clear! It was an extremely useful lesson
...

Ask a question

Send a message explaining your needs and Pavan will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

MonTueWedThuFriSatSun
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12            Saturday at 12:00  Sunday at 12:00
13              
14              
15              
16              
17              
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00    
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00    
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00    
21              
22              
23              
from $31.53At teacher's location
from $31.53Online via webcam
from $31.53At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Online reputation

  • Instructor since July 2018
  • Phone number verified
  • Linkedin connected
    418 connections

Availability of a typical week

MonTueWedThuFriSatSun
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00  Friday at 8:00  Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12            Saturday at 12:00  Sunday at 12:00
13              
14              
15              
16              
17              
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00    
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00    
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00    
21              
22              
23              
from $31.53At teacher's location
from $31.53Online via webcam
from $31.53At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Share

   LinkedIn   

Edgar
Microsoft Excel niveaux débutant, intermédiaire, expert
Je donne des cours particuliers de cet outil extraordinaire qu'est MS Excel pour tous les niveaux (débutant, avancé, expert). Vous apprendrez entre autres: • Les bases (sauver, imprimer, options de base, le ruban, …) • Mise en forme (polices, couleurs, formats, bordures, …) • Tableaux et Graphiques (modèle de données, tableaux pivot, types de graphiques, filtres, slicers, …) • Illustrations (objets géométriques, images, smart art • Fonctions (Mathématiques et Trigonométriques, Recherches, Logiques, Financières, Texte, …) • Données externes • Connections de données • Analyse de données (Scénarios, Goal seek, …) • Base de données • Macros avec VBA … et bien plus encore. L’apprentissage se fait toujours à travers des exemples concrets. De plus, si vous êtes confronté à un problème particulier, je vous aide à trouver une solution avec Excel. Pour votre information, je suis Ingénieur de gestion, spécialisé en Finance, diplômé de la Solvay Brussels School of Economics and Management, avec une expérience professionnelle dans les domaines financiers et d’analyse de données. Edgar

Michal
Microsoft Excel and VBA. From beginner to advanced level with experienced corporate trainer.
Excel is one of the most desirable skills by employers. If you want to increase your Excel of knowledge or you are going to begin your adventure with this software I can offer you a lessons. Your are going to go trough most basic comads in excel to advanced programming. As a corporate Excel trainer I can train you to pass Excel tests during recruitment process for job. Welcome to my class.

Khaoula
computer course (Word, Excel, Powerpoint, Publisher, Winbooks)
As a private tutor, my goal is to help students master Microsofts software. I can give the basics but also the more in-depth notions. My method of work is to give the theory (showing examples) and to give exercises so that the student can practice.

Suranjit
English Language and Grammar for all classes of students and for TOEFL IELTS GMAT GRE and Computer Progam (Word, Excel, Powerpoint Internet.
Teaching English Language in India and Bangladesh for 15 Years, Specialized in English Language and English Grammar Teaching for all classes of students and for the students who wants to sit for the exam of TOEFL, IELTS, SAT, GRE, GMAT etc. I will show some techniques and some rules by which a student can easily excel in Reading, writing, speaking and listening. I can teach from primarily levels to tertiary levels so that any weak student can easily learn English Language as a Native speaker can. I have invented some rules of English Grammar after completing B.A Honors and Masters in English Language from Rajshahi University, Bangladesh, India. I will give homework but you can learn all at the time of teaching with pleasure, The technique which you have never got in your life i will teach you and will never forget in your life. I can teach in Computer Basics, and Program Microsoft Word, Excel, Access, Power point, Operating System, Visual Basics, Internet Browsing.

Muhammad
Learn Micosoft Excel, VBA, Word, Powerpoint. Lectures can be delivered online (e.g. Skype)
I am specialized in accounting and finance. I am currently completing my PhD degree in the field of Finance from University Clermont Auvergne, France. I also have two master's degree in Business Administration (MBA) and Accounting and Finance. Furthermore, I have a two years experience in Audit in a bank. My goal is to keep students challenged, but not overwhelmed. I assign homework after lesson and provide periodic progress reports. Please note that I will teach in English.

Syed Abdul
Tutoring (Math, CAD, Excel, Primavera), Experience Pakistani and Indian foods
I have an experience in teaching maths and other subjects for about 10 years. I have professional experience of 5 years also in Production Manufacturing and Project Management sector. I know how to cook Indian and Pakistani dishes. I can give you a company also.

John
Excel functions for both the classroom and business
The class involves my demonstrating how to execute many Excel special functions. Such as linking information from one spreadsheet tab to another tab; creating V-Look ups, H-Look ups, Pivot Tables, Pivot Charts, Nested If's, Sumif's, "If/Then", “If/And” scenarios among many others. Included in the lesson is an interactive spreadsheet which contains actual working formulas with step-by-step instructions for easy implementation. You will see working, functioning examples of all the Excel functions I teach & explain during the lecture. Excel is one of my specialties. As an experienced CPA who has had both individual and corporate clients, I have constructed both simple to very complex spreadsheets – plus I was always ready to explain how they functioned to my employer, my co-workers, my tax clients, and even auditors!

Boris
Microsoft Excel, Finance, Investments, Economics, Math
Lessons from an experienced tutor (8 years of tutoring privately and in groups). I have a B.Sc. and an MBA, specializing in Finance and international Business. If you are a student, a professional or just building up your business, then Excel is a MUST tool for you. I can also help you with financial planning, investment portfolios, sensitivity and feasibility analysis for your projects, and much more. Tutoring is either online (Zoom/Skype) or at my place.

Felipe
Marketing, Projects,
In my classes you will learn all about marketing strategy, controlling projects and advanced excell

Onur
Learn to master Excel and VBA, and gain value in the market.
Microsoft Excel is one of the most used software in business, so it must be mastered. Whether you are a beginner or intermediate, the courses that I propose you will improve your profile and thus sell you more expensive in the job market. With two years of experience during which I trained the employees of a company to the optimal use of this software, I propose you a pedagogy focused on the game in order to master all the facets of this software. Finished with galley crosstalk capricious, error messages coming out of nowhere, # N / A whose provenance is unknown. Become a master, and increase your value!

Tarik
Excel pour tous les niveau, avec des méthodes simple et faciles
Quelque soit votre niveau, débutant ou avec des notions, étudiant ou salarié. Excel n'est pas destiné aux programmeurs ou les mathématiciens, plutôt un MUST LEARN outil pour toute personne qui se prépare pour intégrer le monde professionnel ou qui y est déjà. Il suffit juste la volonté et la rigueur. Je mets a votre disposition des méthodes simple pour apprendre Excel et l'utiliser au quotidien. Structure Excel Formule et fonctions. Tableau croisé dynamique Connexion avec MS ACCESS la mise en forme Les graph(Dynamique et static) les tableau de board. Macro VBA

Dr S
One-on-one online tutoring in Financial modeling with Microsoft Excel, Financial applications in Python by an experienced tutor
I am Dr S Iyer- a tutor with over 16 years of teaching experience as of 2020 and students from across the globe. I teach one-on-one online (over Skype/ Google Hangout and other media) using a pen tablet and the screen-share feature. I teach from Bachelor's level to Masters level and professional certifications. I have helped several students from various parts of the world do remarkably well in several subjects like Financial modelling, Corporate Finance, Investments, Accounting, Microeconomics, CFA, FRM. But more than that, I trust that if I can replace fear of a subject with love for it, then I would have truly made a difference to the student.

Ashington
STATISTICS AND STATISTICAL METHODS FOR STUDENTS AND PROFESSIONALS
This class covers statistics and statistical methods for data analysis which cuts across all industry and disciplines. Sample topics, Statistical calculations Statistical methods Statistical analysis Quantitative analysis Quantitative analysis techniques Non Quantitative data analysis Research methods Research methods paper section Mathematical analysis Statistical software and spreadsheets like Rsutdio, Excel, SPSS, and many others. and any statistical topic requests by students

Sarah
Office tools (Excel, Word, Power Point, Access)
do you need to improve on Word, Excel or PowerPoint? I am here to give you the concepts and techniques of Microsoft office (Excel, Word, Power-point or Access) adapted to your professional needs. private, professional and complete private lessons in OFFICE: Word (course, practice), Excel (course, practice), Power Point (course, practice), Access (course, practice) ... etc For more information please contact me.

Gauthier
EXCEL, WORD, POWERPOINT etc - ALL LEVELS: they will have no secrets for you!
Modulables, my courses adapt entirely to your level and especially to your profile. After having discussed with you and understanding your needs and objectives as well as the environment in which you operate and the knowledge you wish to acquire, I set up targeted exercises as well as short theoretical presentations. Guaranteed results in no time, you will not be disappointed! Do not hesitate to call me to have a first contact and at the same time get an answer to all your questions!