Pavan
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from27.00EUR/ 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 27€At teacher's location
from 27€Online via webcam
from 27€At 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
  • 3 repeat students
  • 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 27€At teacher's location
from 27€Online via webcam
from 27€At 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.

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.

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
- 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.

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.

Stephan
Office applications for seniors such as word processing and spreadsheets!
Especially for seniors I teach the office applications WORD, EXCEL and POWER POINT (as an ECDL advanced trainer experience in adult education) other computer applications can also be addressed as - Outlook - Internet and research - Telephoning over the Internet - Etc.

Boutaina
Office automation courses (Word, Excel, PowerPoint) for beginners (Basics of computer use)
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 make their lives easier.

Ilias
Microsoft Office: Excel, Word, PowerPoint, Outlook, Teams and Access (children and teenagers)
Whether you are asked to create a spreadsheet for maths or science assessments, a database of pupils, or an engaging presentation for a school project, Microsoft Office is usually your choice. The more you know about advanced capabilities of Office programs the more impressive your work can be. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Communication with Teams - Presentations with PowerPoint - 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.

Sara
Je donne des cours particuliers en matière de l'informatique pour tous les niveaux
Je suis suis lauréate en école de commerce et je travaille en finance. Passionné par l'informatique, je propose des cours et des formations pour les différents niveaux: seniors, étudiants ou curieux: -Informatique de base: MS office(bureautique), systèmes d'informatique.... - Design des présentations sur les différentes plateformes. Contactez moi. A bientôt ! Cours informatique

Clément
Private lesson in Maths - Physics with simulation and discovery of Excel
Science is an incredible discipline, without limits, to the point where it is possible to get lost in it. This course therefore proposes to work on the bases and knowledge of Maths - Physics - Chemistry and to make the link with the use of these in the real world. Understanding where and how science is used is essential to be able to learn and move forward. Being an engineering student of Arts et Métiers, I worked with sciences since small and I always had a certain facility which allowed me very quickly to explain how to advance to other people. This course also offers a rise in competence in the use of Excel which is essential for a lot of work in analysis and it is a real added value to know how to handle a minimum of 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.

Serge
Excel course to organize your budget and personal finances.
Did you know that in Excel you can create a smartphone application that manages your personal budget? Or that you can program reminders so you don't forget to pay your bills? You can even play chess remotely using Excel! Starting from your Excel project, I will guide you through setting up your spreadsheet, organizing data, integrating formulas and layout so that you yourself have created a tool that looks like you, that you understand and are proud of.

Virginie
Word, Excel and PowerPoint lessons, to create professional documents for work or for school
You don't understand anything when using Word, Excel or Powerpoint? However, these 3 programs are now in great demand by an employer or even to make a project for the school. I help you start a learning process to understand the basics of these 3 programs and create professional documents of an advanced level in a very short time. Do you have a special need? Do not hesitate to tell me about it in order to adapt the lessons directly! Many exercises and assured support.