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

From 25.01 £ /h

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

Use Ctrl + wheel to zoom!

At student's location :

Around Brussels, Belgium

At teacher's location :

Meilaan, 1200 Sint-Lambrechts-Woluwe, Belgium

Online from Belgium

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

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

Skills

Microsoft excel

Visual basic

Reviews

Availability of a typical week

(GMT -05:00)

New York

At teacher's location and via webcam

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Lionel

5.0

(1)

I help you master the practice of Excel which will make your life easier.
And I help you achieve your concrete projects.

Michal

5.0

(1)

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.

Veronique

5.0

(1)

I can adapt to your request or your needs.
I can also show you all the inexhaustible resources that Excel offers.
Whether you are a novice or need to deepen a particular aspect (graph, formula, database management, pivot tables ....), you want to prepare for interview or a new job? Can I help you.
You want to prepare for interview?
Excel is first and foremost a practice, so after a little introduction, it's time for exercises

Joanna

5.0

(1)

Excel is a basic tool for almost every smaller company and huge corporation. It serves as a tool for analysis or optimization of daily work, environment for databases or creating templates.

The purpose of tutoring with me is not a series of lessons in which you look as I write formulas, but to achieve some understanding of how Excel works. I would like to become superfluous after a few lessons - I would like you to be able to discover Excel yourself.

About me:
Biotechnology and Industrial Management graduate at Technical University of Lodz. My big passion is Data Science and Business Intelligence. I was working for Philips, currently I am intern for NATO.

Suranjit

5.0

(1)

Specialized in English Language, Grammar and Computer and teaching for 15 years
Experienced as English Teacher for all classes of students and TOEFL, IELTS GRE etc.
specialized for University Admission Test
Learn with pleasure and new technique that i have invented and one can easily learn reading, writing, speaking, listening English.
I like to prefer computer application program, just try one class and feel.

Anas

5.0

(1)

>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.

>>> What about pedagogy?
I favor the learning by doing method

>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.

>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)

>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.

**** Excel Training (Beginner and Intermediate) ****

Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.

Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.

Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination

Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously

Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.

Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.

Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.

**** Excel Training (Advanced) ****

Part I: Configure Excel Options
Set up Excel options.
Customize the interface.

Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.

Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.

Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.

Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.

Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.

Edgar

5.0

(1)

I give private lessons in this extraordinary tool that is MS Excel for all levels (beginner, advanced, expert).

You will learn among others:
• The basics (save, print, basic options, the ribbon, etc.)
• Formatting (fonts, colors, formats, borders, etc.)
• Tables and Charts (data model, pivot tables, chart types, filters, slicers, etc.)
• Illustrations (geometric objects, images, smart art
• Functions (Mathematics and Trigonometrics, Research, Logic, Financial, Text, ...)
• External data
• Data connections
• Data analysis (Scenarios, Goal seek, etc.)
• Database
• Macros with VBA

...and much more.

Learning always takes place through concrete examples.
Also, if you are facing a particular problem, I help you find a solution with Excel.

For your information, I am a Management Engineer, specialized in Finance, graduated from the Solvay Brussels School of Economics and Management, with professional experience in the financial and data analysis fields.

Edgar

Ilias

5.0

(1)

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.

Serge

5.0

(1)

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 project on Excel, I guide you in setting up your spreadsheet, organizing the data, integrating the formulas and the layout so that you have created a tool that suits you, whether you understood and are proud of.

Sebastian

5.0

(1)

📊 Unlock the Power of Excel with Personalized (Online) Courses! 📊

Are you ready to conquer the world of spreadsheets and harness the true potential of Microsoft Excel? Look no further – I'm here to guide you on an Excel journey that's tailored precisely to your needs.

🔹 Who am I?
Hello, I'm Sebastian, and I'm not just an Excel enthusiast – I'm a part-time Excel aficionado who's passionate about helping others unravel the magic of Excel. From newcomers seeking an introduction to seasoned users aiming to master advanced functionalities, I'm here to be your Excel companion.

🔹 What I Offer:
📌 A Custom Learning Experience: No two learners are the same, and that's why I craft a learning path that aligns with your unique goals and pace.
📌 Mastering Formulas: From the foundational to the complex – whether it's VLOOKUP, HLOOKUP, INDEX, MATCH, or even their intricate combinations, I've got you covered.
📌 Visualize Data Like a Pro: Graphs, charts, and interconnected dashboards – I'll equip you with the skills to present data in compelling and visually appealing ways.
📌 Multilingual Learning: Fluent in English, French, and German, I ensure language isn't a barrier to your Excel success.
📌 For All Ages and Roles: Whether you're a student or a seasoned professional, age is just a number when it comes to Excel mastery.
📌 Flexibility in Learning: Choose between in-person sessions at your location or the convenience of online lessons.

🔹 Excel Made Easy:
Navigating spreadsheets, deciphering formulas, and conducting insightful data analysis can be overwhelming – but not with my expert guidance. Whether you're taking your first steps or aiming for advanced proficiency, together, we'll demystify Excel and empower you to create dynamic spreadsheets with confidence.

Ready to transform your Excel skills? Let's dive in and explore the boundless possibilities that Excel offers. Your Excel journey starts now!

Connect with me today to embark on a learning experience that will forever change how you interact with data.

Salah

5.0

(1)

Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level!

If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office.

Why Choose Microsoft Office?

Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features.

Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential.

Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Salomé

5.0

(1)

A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services.

Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location
Educational and organized teacher with excellent revision and organizational techniques
Microsoft Office - Excel/Word/PowerPoint - email - typing - ...

Educational and patient with a good methodology adapted to each student

97% success rate with regular monitoring

Feel free to contact me for more information!
See you soon

Kamal

5.0

(1)

The purpose of this session is to allow the learner to understand the usefulness of Excel, to understand its principle and how it can be used at the school and professional level. It is also about Excel formulas, application exercise.
contact me

Morad

5.0

(1)

You want to boost your Excel skills and unlock the full power of spreadsheets? Our online Excel classes are designed for everyone, from beginners to advanced users. Learn how to organize data, create powerful formulas, generate charts, and streamline your workflow with ease.

Led by expert instructors, our interactive lessons offer hands-on practice, covering everything from basic functions to advanced Excel techniques. Whether you're looking to improve your job performance, manage data more efficiently, or learn new skills, our flexible online classes allow you to learn at your own pace, from anywhere.

Take control of your data—sign up for our online Excel classes today and become an Excel pro!

Gwendoline

5.0

(1)

I teach interactive courses on Excel, Word, and PowerPoint for all levels, whether for high school, college, or the workplace. I also offer introductions to information and office automation.

My approach is practice-based: I guide students step by step, using concrete examples and exercises tailored to their needs. I also teach methods to help them become more organized, more efficient, and more independent in using these tools. Each session is personalized to target the skills they need to develop, while building a climate of trust and motivation.

I always suggest discussing and defining the learner's needs before starting classes so that you can effectively prepare the course materials and support. It is crucial for me to respond correctly to the student's request.

I am a mathematician by training, with over 10 years of experience in private tutoring and assisted coaching. I currently work as a biostatistician and also provide training in this field. I am very patient and passionate about what I teach. I adapt to each student or learner to provide personalized support and I share my methods and tips for progressing quickly and effectively.

I invite you to contact me to best determine the support you need!