Introduction to programming applications in VBA (Excel) - Namur

Translated by GoogleSee original

Introduction to programming applications in VBA (Excel)

From 31 £ /h

Microsoft Office applications contain a development environment which allows the operation of these applications to be adapted to the concrete needs of its users.
I offer you an introduction to programming in Visual Basic for Applications, in order to allow you to get started with macros and the interaction that you can bring to your Excel files.
On the menu :
* Editor interface
* Macro recording
* Analysis of the code generated by the macro recorder
* Programming basics: types of variables, execution flow control instructions and common functions
* Preview of the Excel object model

Extra information

You must have an official version of Microsoft Excel software (minimum version 2016)

Location

Online from Belgium

About Me

Computer scientist (more precisely: analyst-programmer) since the last century (it's been old, I know), I turned to teaching a few years ago now.

I am now an office automation trainer (Word, Excel, Access, Outlook, Powerpoint, VBA) and a programming teacher (all languages: it is the substantive core that is taken from it)

Education

Graduate in IT management - Business School of Namur
Certificate of Educational Aptitudes - Technical Institute of Namur (Social Promotion)

Experience / Qualifications

Computer scientist (analyst-programmer) since 1998:
* Family Allowance Fund (application management + XML exchanges with social security)
* UCM Social Secretariat: management of exchanges with the ONSS; Business Intelligence with SAS
Teacher since September 2020:
* ITN Promotion Sociale (technopedagogue - office automation)
* Business Administration School - SPW (office automation - programming)
* IEPSCF - Namur Cadets (office automation teacher)

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Duration

60 minutes

The class is taught in

French

English

Dutch

Skills

Visual basic

Computer programming

Microsoft excel

Availability of a typical week

(GMT -04:00)

New York

Online via webcam

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Personalized support for Microsoft Word software

26 £ /h

Starting from your needs (school work such as TFE, dissertations or institutional to hand in), I will accompany you, step by step, to allow you to take in hand and improve your use of the Microsoft Word software:
* Layout, character and paragraph formatting;
* Insertion of tables, images, SmartArt or other objects;
* Management of layouts, sections and table of contents;
* Management of styles, advanced editing elements;
* Direct mail;
* Creation of macros, text blocks, forms;
(non-exhaustive list)

Adam

4.43

(7)

doctoral student in engineering sciences provides support courses in analog and digital electronics at any DEUG level and engineering schools. having scientific and technical knowledge, three years of experience in the field of teaching, pedagogy and a sense of listening and analysis, I am able to help pupils and students and train them in the chapters of which they are having difficulty. for more info please contact me

Amin

4.43

(7)

Microsoft Office skills are expected in almost every professional environment — yet most people have never been properly taught how to use these tools efficiently.
This course covers Word, Excel, and PowerPoint at whatever level you need, from basic document formatting to advanced Excel functions and automation.
Excel (most popular):

Formulas and functions (VLOOKUP, INDEX/MATCH, IF, SUMIFS, and more)
PivotTables and data analysis
Charts and professional dashboards
Macros and VBA automation — eliminate repetitive tasks entirely

Word: Professional document formatting, styles, tables, mail merge
PowerPoint: Clean, professional presentation design and structure
This is a hands-on course — we work directly on your files and your real-world tasks, not generic exercises. You'll leave each session knowing exactly how to apply what you learned to your actual work.
Ideal for students, job seekers, administrative professionals, and anyone who wants to stop wasting time on manual work.

Gaëlle

4.43

(7)

While adults are still debating whether kids should use AI, they are already using it.
The question isn't "should they?" it's "how do we do it intelligently?"

In this course, your child will discover:
✓ What AI actually is: not magic, not mystery. How machines think, what they can do, what they can't
✓ How ChatGPT really works: not just "ask a question and get an answer," but why it responds that way, where it fails, when to trust it
✓ What LLMs are (Large Language Models): in language they understand, not tech jargon
✓ Create with AI: custom avatars, interactive stories, real projects using real tools
✓ Think critically about AI: Bias, privacy, creativity. What does AI do better than humans? What can't it do?
✓ Real-world applications: How AI transforms medicine, education, art, gaming, everyday life

Why this is different:
Most AI courses for kids teach "here's the tool, use it." I teach how to think about AI.
Your child will learn to see AI not as black magic or a solution to everything, but as a powerful tool with real limits.
And, more importantly: that they can control how they use it.

What they take home:
Real projects they created (custom avatar, interactive app, analysis of a real AI case study). A genuine understanding of how it works. And the ability to use AI responsibly and creatively.

Format: Online | 60–90 min sessions | Flexible, adapted to their age and pace

For curious kids asking "How does ChatGPT actually know things?"

Salah

4.43

(7)

Master Python with Personalized Courses

Discover the art of programming with Python courses tailor-made to meet your specific needs. Whether you are a beginner, intermediate or professional, my lessons are suitable for all levels.

Why Choose My Courses?

Personalized Teaching Approach: Each course is tailored to your skill level and individual goals.

Practical Experience: Learn by doing with real-world projects that build your understanding and skills.

Ongoing Support: Get unlimited email support for any questions you have between sessions.

As a Python expert, I have a passion for teaching and sharing my knowledge. My goal is to guide you effectively in your learning journey.

Book Your First Lesson:

Start your journey to Python mastery now by booking your first lesson. Whether you aspire to enter the development field or hone your existing skills, these courses are designed for you.

Kamal

4.43

(7)

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

4.43

(7)

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!

Nawfl

4.43

(7)

Online Private Classes in Microsoft Word, Excel, and PowerPoint

Boost your productivity and master essential office tools with personalized online training in:

Microsoft Word – Learn document creation, formatting, advanced editing, and professional layout design.

Microsoft Excel – Master formulas, data analysis, pivot tables, charts, and automation for business or personal use.

Microsoft PowerPoint – Create stunning presentations with animations, transitions, and effective storytelling techniques.

Why Choose Our Classes?
✔ One-on-one sessions tailored to your skill level
✔ Flexible scheduling to fit your availability
✔ Hands-on exercises & real-world examples
✔ Certification guidance (if needed)

Ideal for students, professionals, or anyone looking to enhance their Microsoft Office skills efficiently.

📩 Contact us today to book your session!

Mounir

4.43

(7)

Unlock Your Potential: Private Online Excel & Word Classes

Master Excel and Word from the comfort of your home! Our personalized one-on-one online classes are designed to help you gain confidence and proficiency. Whether you're a beginner needing basics, a student tackling projects, or a professional aiming to boost productivity, we tailor lessons to your specific goals.

Flexible Scheduling
Customized Curriculum
Experienced Instructor
Boost Your Skills, Boost Your Career!

Brent

4.43

(7)

Stuck in Excel? Want to finally understand how those formulas really work? Do you need to create a pie chart of your expense report for work or school, but feel completely lost? Don’t worry! I’m here to help... at your pace, with no jargon or complicated explanations.

Whether you:
- are starting completely from scratch,
- already have some basic knowledge,
- or want to solve a specific problem,
we’ll tailor the session to your needs. No one-size-fits-all course, just practical help that actually works for you.

👨‍🏫 About me
I’ve been using Excel since I was a teenager — for personal use (like budgeting tools or calorie trackers) and professionally as part of my work and studies in data analysis. Thanks to my experience and structured approach, I explain Excel in a clear and understandable way. I know how frustrating it can be when something technical doesn’t work... and how satisfying it feels when it finally clicks.

🎯 Topics we can cover
- Smart formulas (IF, VLOOKUP, INDEX, MATCH, etc.)
- Creating charts, pivot tables, and dashboards
- Using Excel for budgeting, planning, or managing projects
- Data analysis and basic programming in Excel
- Preparing for Excel tests or improving job-related Excel skills

💻 Practical info
- Having your own laptop/PC is helpful, but not required
- Online or in-person sessions possible
- Have specific questions or files you’d like to work on? Let me know! I also have my own practice materials.

Feel free to send me a message with your question or goal. I’ll gladly look at how I can help you out!

Sara

4.43

(7)

Do you dream of creating your own website but don't know where to start? 🙋‍♂️🙋‍♀️ This course is for you! This private tutoring program is designed for beginners, students, or professionals changing careers who want to master the essential basics of website creation. 📚

The Coaching Program includes:
HTML5: Structuring the content of a web page in a clean and semantic way.
CSS3: Style your pages, manage layout (Flexbox, Grid) and create responsive designs adapted to mobile devices.
JavaScript: Make your sites dynamic, manage user interactions (buttons, forms) and manipulate the DOM.
Practical Projects: Create your own projects from A to Z to build your portfolio.

💡 My 100% Personalized Methodology: The pace adapts completely to your strengths and difficulties.
Practical: 20% theory to 80% live coding and concrete exercises.
Continuous Monitoring: Sharing of resources, answer keys and mini-challenges between sessions.

See you soon to create your first website together! 😄👨‍🏫👩‍🏫

Farouk

4.43

(7)

These courses are part of a structured and progressive training in Object-Oriented Programming (OOP) with JavaScript, designed for beginner or intermediate developers who want to understand in depth how the language works, write clearer, more maintainable code and prepare themselves calmly for modern frameworks like React ⚛️.

Object-Oriented Programming is often perceived as complex or abstract.

My goal is simple: to make it logical, concrete, and immediately applicable.

🎯 Training Objectives

Upon completion of this training, you will be able to:

Understanding what Object-Oriented Programming really is (and when to use it)
Create and manipulate objects in JavaScript in a clean and efficient way
Use ES6 classes, constructors, and methods with confidence
Mastering this, the prototype, and the instantiation logic
Apply encapsulation, inheritance, and polymorphism without confusion
Avoiding common mistakes made by OOP beginners
Structure your JavaScript code like a professional developer

📖 Training Plan – Object-Oriented Programming in JavaScript
1. Introduction to Object-Oriented Programming 🧠
Understanding the concept, objectives and benefits of OOP.
2. Procedural Programming vs. OOP
Why unstructured code quickly becomes unmanageable.
3. Objects in JavaScript
Properties, methods and representation of the real world.
4. The keyword this
Understanding the execution context (often poorly understood).
5. Limitations of simple objects
Why duplicating code is a bad idea.
6. Constructive functions
Create multiple objects from the same model.
7. The keyword new
What it's actually doing under the hood.
8. The prototype
Sharing methods and memory optimization.
9. ES6 Classes
Modern syntax and best practices.
10. The builder
Proper initialization of objects.
11. Data Encapsulation
Protect the internal state of objects.
12. Inheritance between classes
Reusing code intelligently.
13. The keyword super
Communication between parent and child in the classroom.
14. Polymorphism
The same behavior, several forms.
15. Composition vs. Inheritance
Choosing the right architecture.
16. Best practices in OOP
Write readable, scalable, and maintainable code.
17. Common mistakes made by beginners
Pitfalls to absolutely avoid.
18. Guided practical exercise
Creation of a concrete class (product, user, etc.).
19. Assessment Quiz (Multiple Choice Questions)
To validate the actual understanding of the concepts.

🛠️ Teaching method: Understand before writing

This training program is based on a progressive and pragmatic approach:
Clear and illustrated explanations
Concrete examples from real projects
Simple but effective exercises
Constant questioning to avoid rote learning
Adaptation to the learner's level and pace
Here, we don't "recite OOP" — we understand it.

🚀 Learner's result

At the end of the training, you will not only know how to write a JavaScript class.
You will know:

1- Why does it exist?
2- When to use it
3- and when not to use it

You will leave with:
a solid understanding of OOP
a cleaner and more professional code
an ideal foundation for learning React, Node.js or any other modern framework

Ali

4.43

(7)

I offer one-to-one Programming tuition in Python, C, and C++, for GCSE Computer Science, A-Level Computing, and university students studying engineering, computer science, or related subjects. Lessons are available online or in person around Birmingham.

What I cover:

Python for beginners and intermediate learners
C and C++ programming
GCSE and A-Level Computer Science (all exam boards)
University coursework support, debugging help, and project guidance
Core concepts: variables, loops, functions, data structures, object-oriented programming, file handling, basic algorithms

How I teach:
I start by understanding exactly where you are — whether that's "I've never coded before" or "I'm stuck on a specific assignment." Then I build lessons around small, practical examples you can actually run and modify yourself. I'm patient with errors (everyone gets them), and I make sure you understand the why behind the code, not just how to copy it. For university students, I can also help with debugging, code reviews, and explaining tricky concepts in plain English.
If you or your child is preparing for exams, working on coursework, or just wants to finally feel comfortable with coding, I'd love to help.

Omar

4.43

(7)

Master Microsoft Office from the comfort of your home with personalized online private classes in Excel, Word, and PowerPoint. Learn essential skills for school, university, business, and everyday professional tasks through interactive and practical lessons tailored to your level and goals.

With over 16 years of teaching experience, lessons focus on building confidence, improving productivity, and helping students achieve real results. Whether you are a beginner or looking to advance your skills, each session is designed to make learning simple, engaging, and effective.

Topics include:

Microsoft Excel (formulas, charts, spreadsheets, data analysis)
Microsoft Word (document formatting, reports, CVs, professional writing)
Microsoft PowerPoint (presentations, animations, design techniques)

Flexible schedules, one-to-one support, and step-by-step guidance available for students, professionals, and job seekers of all ages.

Ammar

4.43

(7)

A- SUJETS QUE VOUS POUVEZ EXPLORER ET MAÎTRISER :

1- FONDEMENTS DE PYTHON
• Variables, types de données, opérateurs, structures conditionnelles, boucles, fonctions, modules, fichiers, exceptions et programmation orientée objet
• Listes, tuples, dictionnaires, ensembles, compréhensions, débogage et écriture d’un code clair, réutilisable et bien structuré
• Jupyter Notebook, Anaconda, Visual Studio Code, environnements virtuels et gestion des packages

2- PRÉPARATION ET EXPLORATION DES DONNÉES
• NumPy et pandas pour importer, nettoyer, transformer, filtrer, regrouper, restructurer et fusionner les données
• Valeurs manquantes, doublons, valeurs aberrantes, formats incohérents, fuite de données (data leakage) et validation de la qualité des données
• Analyse exploratoire des données à l’aide de statistiques descriptives, Matplotlib, Seaborn et interprétation graphique

3- FONDEMENTS MATHÉMATIQUES
• Algèbre linéaire, vecteurs, matrices, dérivées, optimisation, probabilités et statistiques
• Fonctions de perte, gradients, mesures de distance, régularisation, vraisemblance et complexité des modèles
• Les concepts mathématiques sont expliqués en fonction du niveau de l’apprenant et des exigences des algorithmes sélectionnés

4- APPRENTISSAGE AUTOMATIQUE SUPERVISÉ
• Régression linéaire et polynomiale, régression logistique et modèles régularisés
• k plus proches voisins (k-nearest neighbours), arbres de décision, forêts aléatoires, gradient boosting, machines à vecteurs de support et classificateur naïf de Bayes
• Classification, régression, hypothèses des modèles, frontières de décision, importance des variables et interprétation des résultats

5- APPRENTISSAGE NON SUPERVISÉ
• Regroupement (clustering) par k-means, classification hiérarchique et méthodes fondées sur la densité
• Analyse en composantes principales, réduction de dimensionnalité, détection d’anomalies et découverte de structures ou de motifs
• Sélection des méthodes, évaluation de la structure des données et interprétation des résultats sans étiquettes prédéfinies

6- ÉVALUATION ET AMÉLIORATION DES MODÈLES
• Jeux d’entraînement, de validation et de test ; validation croisée ; optimisation des hyperparamètres
• Exactitude (accuracy), précision, rappel (recall), spécificité, score F1, ROC–AUC, matrices de confusion, MAE, MSE, RMSE et R2
• Sous-apprentissage, surapprentissage, compromis biais–variance, déséquilibre des classes, ingénierie des variables, sélection des variables, mise à l’échelle et régularisation

7- APPRENTISSAGE PROFOND
• Fondements des réseaux de neurones, fonctions d’activation, propagation avant, rétropropagation et descente de gradient
• Perceptrons multicouches, réseaux de neurones convolutifs, réseaux récurrents et fondements des Transformers
• TensorFlow, Keras ou PyTorch selon le projet et l’environnement de travail de l’apprenant

8- APPLICATIONS DE L’INTELLIGENCE ARTIFICIELLE
• Traitement automatique du langage naturel, classification de textes, plongements vectoriels (embeddings), analyse de sentiments et fondements des modèles de langage
• Vision par ordinateur, classification d’images, principes fondamentaux de la détection d’objets et prétraitement des images
• Systèmes de recommandation, prévision, détection d’anomalies, automatisation intelligente et applications d’aide à la décision

9- IA GÉNÉRATIVE ET GRANDS MODÈLES DE LANGAGE
• Architecture Transformer, tokens, embeddings, mécanismes d’attention, ingénierie des prompts, génération augmentée par récupération (Retrieval-Augmented Generation – RAG) et évaluation des modèles
• Utilisation d’API d’intelligence artificielle, de bases de données vectorielles, de systèmes de recherche documentaire et de flux de travail structurés utilisant l’IA lorsque cela est pertinent
• Fiabilité, hallucinations, biais, confidentialité, utilisation responsable et validation humaine appropriée

10- OUTILS ET BIBLIOTHÈQUES
• Python, NumPy, pandas, Matplotlib, Seaborn, scikit-learn, SciPy, Statsmodels, TensorFlow, Keras et PyTorch
• Jupyter Notebook, Anaconda, Visual Studio Code, Git, GitHub, SQL, Excel et Power BI lorsqu’ils sont utiles au projet
• Des bibliothèques supplémentaires peuvent être introduites en fonction de la spécialisation choisie et du jeu de données utilisé

11- PROJETS, RECHERCHE ET PRÉPARATION AUX ENTRETIENS
• Projets complets couvrant la préparation des données, le développement des modèles, leur évaluation, leur interprétation et la présentation des résultats
• Travaux universitaires, mémoires, thèses, projets de recherche, projets de portfolio, entretiens techniques et applications professionnelles
• Revue de code, débogage, documentation, reproductibilité, comparaison de modèles et communication des résultats

B- TUTORAT PERSONNALISÉ : APPRENDRE À RAISONNER
L’apprentissage automatique et l’intelligence artificielle deviennent beaucoup plus accessibles lorsque les mathématiques, les algorithmes, le code Python, les données et les applications concrètes sont clairement reliés entre eux.

Mes cours vous aident à aller au-delà de la simple copie de code ou de l’utilisation de modèles comme des « boîtes noires ». Vous apprendrez à définir correctement le problème, préparer les données, sélectionner un algorithme approprié, comprendre son fonctionnement, entraîner et évaluer le modèle, diagnostiquer les erreurs, améliorer ses performances et interpréter les résultats de manière rigoureuse et responsable.

Chaque cours est personnalisé en fonction de votre niveau actuel, de vos connaissances mathématiques, de votre expérience en programmation, de votre jeu de données, de votre travail universitaire, de votre projet de recherche, de votre préparation à un entretien ou de votre objectif professionnel. Nous commençons par identifier vos connaissances existantes, votre environnement logiciel, les résultats attendus ainsi que vos principales difficultés conceptuelles ou techniques. Nous établissons ensuite un plan d’apprentissage structuré.

Le premier cours gratuit combine une discussion portant sur votre parcours, vos objectifs et vos besoins en tutorat, une première évaluation de vos connaissances actuelles, une planification et une organisation personnalisées des séances, ainsi qu’un court cours d’essai afin de déterminer la méthode de travail la plus efficace.

Une séance type peut comprendre une explication conceptuelle, le développement de l’intuition mathématique, de la programmation en direct, une mise en œuvre guidée, l’évaluation des modèles, la résolution de problèmes techniques et une synthèse concise des prochaines étapes.

Vous pouvez travailler avec votre propre jeu de données, travail universitaire, projet de recherche ou problématique professionnelle, à condition que les informations confidentielles soient traitées de manière appropriée. Je peux également fournir des exemples structurés et des jeux de données adaptés à votre niveau.

Mon objectif n’est pas simplement de vous aider à exécuter un algorithme. Il est de vous permettre de comprendre pourquoi il est approprié, comment il apprend à partir des données, comment l’évaluer correctement, pourquoi il peut échouer et comment construire une solution fiable, interprétable et scientifiquement rigoureuse.

Baia

4.43

(7)

I'm a working MEP engineer, currently building Python automation for Revit workflows daily - plan checks, model coordination, and repetitive drafting tasks. I teach other engineers, architects, and BIM professionals how to do the same, using pyRevit and real project workflows, not toy examples.

Topics include:
pyRevit fundamentals and setup
Automating repetitive Revit tasks (model checks, plan generation, data extraction)
Writing custom scripts for your firm's specific workflows
Applying Python automation to real MEP/BIM projects