Pavan
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from30.56USD/ 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 (8)

Nice and useful explanations. It helped a lot to understand the matter
Very experienced and helpful
Pavan is a very pleasant and knowledgeable person.
Great teacher, inspiring and he knows his stuff
Pavan was excellent. A very patient teacher, knew exactly what was needed and we will certainly use him again!
...

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 $30.56At teacher's location
from $30.56Online via webcam
from $30.56At 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 $30.56At teacher's location
from $30.56Online via webcam
from $30.56At 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

You are here


Zen
VBA training (Excel, Word, Access, Outlook) with practical remote sessions
VBA is a tool that is easily accessible to people and can take productivity, accuracy to levels beyond imagination. When the data and the complexity of the projects are not very big to fit into fancy computer applications, VBA comes into the picture to get things done efficiently with satisfying results. Some of the (VBA-based) projects that I have personally undertaken in the past include building financial and business models to simulate best / worst case scenarios, generating automated legal contracts with appropriate wordings and clauses based on inputs. specific. data by attachments or in the body of the 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 being taught there will be a few practice sessions with a problem statement or sample data / files.

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.

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

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint)
Office, in particular Excel and Access, are programs widely used both in industry and in the personal field. It is worth learning. I am used to working with people of different ages. I believe in segmentation, visualization of progress, objective results and practice. Beyond these general lines, there is no rule or magic method. Some things work with some students and not with others. Adapting to needs is really the goal of private lessons. So I will do my best to find what motivates and helps my student.

Ilias
Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (adults)
Whether you are asked to create a spreadsheet for statistical analysis, a database of customers, or an engaging presentation of a new product, Microsoft Office is usually your choice. Many users know the basics of what Office can do, but being aware of the more advanced capabilities of Office programs gives you many opportunities for impressive results. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Presentations with PowerPoint - Communication with Teams - Databases with Access If learners are advanced or not interested in any of the above modules, I could happily exclude those modules from the course.

Hajar
Computer courses in Office automation (Beginner, Intermediate, Advanced): "Word", "Excel", "PowerPoint"
Throughout my engineering student studies, I worked on multiple projects which require mastery of office automation tools ("Word", "Excel", "PowerPoint", ...). I would therefore like to share my knowledge with you, whether you are a student or not, in order to introduce you to office automation, to train you, and to guide you in your projects.

Boris
Microsoft Excel, Finance, Investments, Economics 🔥 🔥 🔥
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.

Youness
Formation À Distance en Sphinx : Création et analyse Des Données Avec Sphinx
Formation À Distance en Sphinx : Création et analyse Des Données Avec Sphinx - Je donne des cours en Sphinx. ( Logiciel Sphinx ). - Grace à cette formation, vous pourrez facilement créer des questionnaires, enquêtes et sondages selon les besoins de votre marché. - Cette formation est accompagneé avec des exemples Pratiques, réels et Concrets. - J'attends votre réservation!!! *** Pour plus d'informations, Contactez moi.

Enrico
Microsoft Excel for any application [ITA/ENG] 100% Practical
Finance professional with 6 years working experience offering courses in Italian/English on Microsoft Excel for financial application & database management. I enjoy teaching, students of any level are welcome. If you're looking at anything ranging from basic formulas, graphs, pivots up to a complete automation of spreadsheets via complex formulas or VBA macros, hit me up. The course can also be helpful in preparation for internships at top tier investment banking / consulting firms. 100% practical session with extensive examples. Google Meet / Skype or any other software is fine.

Agata
Excel and PowerPoint - your business analysis toolpack!
Do you want to improve your skills in Excel and Powerpoint and become more efficient in your work? Wanting to get a job in Business Analytics or need these programs for your studies? Look no further. I offer 15+ years real work experience in the field and passion for teaching others! Up-skill your business analytics toolset in no time and future-proof your career.

Valentin
Applied Excel Analytics (One on one coaching session)
If I have the privilige of working with you, I will help you to develop your Analytic skills so that you can define the business problem, design the analysis, extract an insight from the analysis and are able to communicate your findings clearly while using Excel. We will assess your level, define you goals and create a custom training plan to reach your goals. You can expect that on each lesson you will learn by working on the business problem you want to solve. You will become a better problem solver while you learn, improve and master your Excel skills.

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

Abderrahmane
Understanding the Secrets of Microsoft Excel: Practical Course with Excel (Beginners and Intermediate)
Excel remains one of the most used tools today. If you are a beginner and looking to improve yourself in Excel, I am a teacher to accompany you and help you improve by using several practical cases in Excel.

Dr S Iyer
Highly experienced tutor : One-on-one online tutoring in Financial modeling with Microsoft Excel, Financial applications in Python
I am Dr S Iyer- a tutor with over 17 years of teaching experience as of 2021 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.

Imane
Office automation courses (Word, Excel, Powerpoint) for beginners and intermediates.
Technology accompanies us everywhere on a daily basis, and the use of computers is becoming more and more essential in all areas. Being lucky to be among this generation who grew up in this technology I would like to share all that I was able to acquire during my school studies and help people who do not know anything about it to develop their skills and take advantage of these tools to facilitate their personal and professional life.