Introduction to programming applications in VBA (Excel) - Namur

Translated by GoogleSee original

Introduction to programming applications in VBA (Excel)

From 58 C$ /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

48 C$ /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)

4.85

(13)

Hello, I am a doctoral student in electrical engineering and associate professor in engineering sciences, experienced in the field of electrical engineering, I offer support courses in the subjects of engineering sciences (Electronics, automatics, electrical engineering, automation, programming).

Digital electronics
Analog electronic
electromagnetism (propagation of high frequency waves)
Automatic (continuous, sampled)
electrical engineering (transformers, electrical machines, switching power supply)
C / c ++ programming, Assembler, ARM, STM32
renewable energy (wind, PV)
engineering Sciences
RDM
Python,VHDL
PIC Microprocessor and Microcontroller
Signal processing and data acquisition
Engineering Sciences

These courses allow the student to get up to speed and regain confidence in all scientific subjects, just as they prepare him effectively for the Baccalaureate, the Preparatory Classes or various examinations of the engineering classes.

COURSE OBJECTIVES AND PEDAGOGICAL APPROACH

Resumption and deepening of fundamental concepts through exercises with course reminders.

Put the student in a situation of questioning and research.

Respond to individual issues and questions

Exercise training in order to achieve real mastery of the content.

Learn to build theoretical reasoning from observable facts or hypotheses.

Specific preparation for higher education requirements (in-depth content, increase in work capacity, enrichment of scientific background)

This educational approach is effective since it has often led me to interesting results with my students.

Associate professor provides support courses in electrical engineering

Matías

4.85

(13)

Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations.

Why choose Microsoft Office?

Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation.

Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters.

Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management.

Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master.

Available Everywhere: 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 everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential.

Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Adam

4.85

(13)

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

(13)

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.

Enrique

4.85

(13)

Don't settle for anything less than excellence.
I am an Aerospace Engineer with a Master's degree in Quantum Physics and have completed Ph.D. work at the University of Cambridge in Computational Physics. Additionally, I have 4 years of experience developing MATLAB and possess deep programming skills in MATLAB/Simulink family, C/C++, Fortran, and Python.

With over 12 years of tutoring experience, I have successfully guided more than 50 students worldwide to achieve distinction in various fields. Consistent results are my priority, and I strive for excellence in all aspects of my teaching.

My lessons are customized to meet each student's unique needs and are designed to be engaging and insightful.

Whether you are at a school level or require advanced or professional-level instruction, I offer support in the following areas:
- Preparation for IB/IA, A-Levels, GCSE, University Entry, or equivalent.
- Experience in preparing students to access world-class schools and universities, including Cambridge University, Oxford, Ivy League and other top institutions in the UK and US.
- University levels (undergraduate and postgraduate).
- High school studies and diploma programs.
- Assistance with specific projects at a professional level, including job interview preparation.
- Extensive experience working with children.

Every lesson is meticulously planned in advance to ensure that it aligns with your goals and targets areas for improvement.
I prioritize a dynamic and interactive learning experience, with one-on-one sessions tailored to your individual requirements. Lessons will be conducted via webcam, enabling you to connect from anywhere.

I have a highly flexible schedule and can adapt to accommodate your needs.
If you have any questions about my teaching method, availability, or pricing, please don't hesitate to reach out. I am here to assist you and provide the support you need.

Salah

4.85

(13)

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.

Yassine

4.85

(13)

Unlock Your Microsoft Office Potential! Private online classes available in Microsoft Word, Excel, and PowerPoint. Struggling with Microsoft Office? Get personalized help with private online classes in Word, Excel, and PowerPoint. Boost your productivity, create professional documents, analyze data effectively, and design engaging presentations. Learn from the comfort of your home! Inquire today.

Brent

4.85

(13)

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!

Amr

4.85

(13)

# **Master C/C++: Build the Foundation of Modern Software Development**

Unlock the power of one of the most influential programming languages in computing history! Whether you're an absolute beginner or looking to deepen your expertise, this comprehensive C/C++ course delivers structured learning from fundamentals to advanced concepts that power operating systems, game engines, and high-performance applications.

## **Why Choose This C/C++ Program?**

**Industry-Relevant Curriculum:** Learn expert guidance on the design of effective classes, functions, templates, and inheritance patterns that form the backbone of professional C++ development. Move beyond basic syntax to understand how to write clean, efficient, and maintainable code that stands the test of time.

**Templates & Generic Programming Mastery:** Go beyond introductory material with in-depth coverage of templates—the cornerstone of modern C++—enabling you to create robust, reusable code components that work across multiple data types. Discover how function templates, class templates, and variadic templates work to maximize your coding efficiency.

**Practical, Hands-On Approach:** This isn't just theory! You'll build real-world projects that demonstrate memory management, object-oriented programming, and system-level programming techniques used in today's technology landscape.

## **Your Learning Journey**

Our structured path takes you from writing your first "Hello World" program through advanced template metaprogramming, with special attention to modern C++ standards (up to C++20). You'll gain the confidence to tackle complex programming challenges and understand the "why" behind effective C++ practices—not just the "how."

## **Transform Your Career Today**

C/C++ skills remain in high demand across industries from finance to gaming to IoT. By mastering these foundational languages, you'll develop problem-solving abilities that translate to any programming environment.

Issam

4.85

(13)

Our private classes move beyond the basics, transforming you from a casual user into a confident and efficient power user of Microsoft Word, Excel, and PowerPoint. Whether you're a student, a professional, a job seeker, or simply looking to upgrade your skills, we provide a flexible and focused learning experience that delivers real results.

Ioannis

4.85

(13)

PhD Candidate in Informatics – Private Lessons & Pancyprian Exams

I am a PhD Candidate in Informatics and I offer private lessons in Informatics to High School students (Pancyprian Exams) as well as to University students, with an emphasis on correct understanding and methodical thinking.

Pancyprian Exams – Informatics

Systematic preparation with an emphasis on:
• understanding of the material
• correct algorithmic thinking
• methodology for solving problems
• analysis of old Pancyprian exam questions

We cover, for example: pseudocode, tables, repetitions, control structures and common exam errors.

Students & General Computing

Support in:
• Programming (C / C++ / Python)
• Operating Systems
• Computer Architecture
• Code Understanding & Debugging

In-person or online courses, with emphasis on understanding and proper study organization.

English text below

PhD Candidate in Computer Science – Private Tutoring & Pancyprian Exams

I am a PhD candidate in Computer Science offering private tutoring for high school students (Pancyprian Exams – Computer Science) and university students.

Pancyprian Exams – Computer Science

Structured exam preparation focusing on:
• understanding the syllabus
• correct algorithmic thinking
• exam-oriented problem-solving
• analysis of past Pancyprian exams

Topics include pseudocode, arrays, loops, control structures, and common exam mistakes.

University & General Computer Science

Support in:
Programming (C/C++/Python)
• Operating Systems
• Computer Architecture
• Code understanding and debugging

Lessons are available in person or online, with emphasis on understanding concepts rather than memorization.

Farouk

4.85

(13)

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

Ammar

4.85

(13)

A- TOPICS YOU CAN EXPLORE AND MASTER:
1- PYTHON FOUNDATIONS
• Variables, data types, operators, conditional structures, loops, functions, modules, files, exceptions, and object-oriented programming
• Lists, tuples, dictionaries, sets, comprehensions, debugging, and writing clear, reusable, well-structured code
• Jupyter Notebook, Anaconda, Visual Studio Code, virtual environments, and package management

2 — PROGRAMMING, ALGORITHMS, AND COMPUTER SCIENCE FOUNDATIONS
• Algorithmic thinking, problem decomposition, pseudocode, flowcharts, procedural programming, object-oriented programming, recursion, and modular program design
• Fundamental data structures including arrays, lists, stacks, queues, dictionaries/hash tables, sets, trees, graphs, and their appropriate use
• Searching, sorting, traversal, algorithm efficiency, computational complexity, Big-O notation, debugging, testing, code organization, and problem-solving strategies
• Practical programming exercises ranging from beginner problems to university-level algorithmic and computational challenges

3- DATA PREPARATION AND EXPLORATION
• NumPy and pandas for importing, cleaning, transforming, filtering, grouping, reshaping, and merging data
• Missing values, duplicates, outliers, inconsistent formats, data leakage, and data-quality validation
• Exploratory data analysis using descriptive statistics, Matplotlib, Seaborn, and graphical interpretation

4- MATHEMATICAL FOUNDATIONS
• Linear algebra, vectors, matrices, derivatives, optimization, probability, and statistics
• Loss functions, gradients, distance measures, regularization, likelihood, and model complexity
• Mathematical concepts are explained according to the learner’s level and the requirements of the selected algorithms

5- SUPERVISED MACHINE LEARNING
• Linear and polynomial regression, logistic regression, and regularized models
• k-nearest neighbours, decision trees, random forests, gradient boosting, support vector machines, and Naive Bayes classifiers
• Classification, regression, model assumptions, decision boundaries, feature importance, and interpretation of results

6- UNSUPERVISED LEARNING
• Clustering using k-means, hierarchical clustering, and density-based methods
• Principal component analysis, dimensionality reduction, anomaly detection, and pattern or structure discovery
• Method selection, evaluation of data structure, and interpretation of results without predefined labels

7- MODEL EVALUATION AND IMPROVEMENT
• Training, validation, and test sets; cross-validation; hyperparameter optimization
• Accuracy, precision, recall, specificity, F1 score, ROC–AUC, confusion matrices, MAE, MSE, RMSE, and R2
• Underfitting, overfitting, bias–variance trade-off, class imbalance, feature engineering, feature selection, scaling, and regularization

8- DEEP LEARNING
• Neural-network foundations, activation functions, forward propagation, backpropagation, and gradient descent
• Multilayer perceptrons, convolutional neural networks, recurrent neural networks, and Transformer foundations
• TensorFlow, Keras, or PyTorch depending on the learner’s project and working environment

9- ARTIFICIAL INTELLIGENCE APPLICATIONS
• Natural language processing, text classification, embeddings, sentiment analysis, and foundations of language models
• Computer vision, image classification, fundamental principles of object detection, and image preprocessing
• Recommendation systems, forecasting, anomaly detection, intelligent automation, and decision-support applications

10- GENERATIVE AI AND LARGE LANGUAGE MODELS
• Transformer architecture, tokens, embeddings, attention mechanisms, prompt engineering, Retrieval-Augmented Generation (RAG), and model evaluation
• Use of artificial-intelligence APIs, vector databases, document-retrieval systems, and structured AI-enabled workflows when relevant
• Reliability, hallucinations, bias, privacy, responsible use, and appropriate human validation

11- TOOLS AND LIBRARIES
• Python, NumPy, pandas, Matplotlib, Seaborn, scikit-learn, SciPy, Statsmodels, TensorFlow, Keras, and PyTorch
• Jupyter Notebook, Anaconda, Visual Studio Code, Git, GitHub, SQL, Excel, and Power BI when useful to the project
• Additional libraries may be introduced depending on the selected specialization and dataset

12- PROJECTS, RESEARCH, AND INTERVIEW PREPARATION
• Complete projects covering data preparation, model development, evaluation, interpretation, and presentation of results
• University assignments, dissertations, theses, research projects, portfolio projects, technical interviews, and professional applications
• Code review, debugging, documentation, reproducibility, model comparison, and communication of results

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
B- PERSONALIZED TUTORING: LEARNING HOW TO REASON
Machine learning and artificial intelligence become much more accessible when mathematics, algorithms, Python code, data, and real-world applications are clearly connected.

My lessons help you move beyond simply copying code or using models as “black boxes.” You will learn how to define the problem correctly, prepare the data, select an appropriate algorithm, understand how it works, train and evaluate the model, diagnose errors, improve performance, and interpret results rigorously and responsibly.

Each lesson is personalized according to your current level, mathematical background, programming experience, dataset, university work, research project, interview preparation, or professional objective. We begin by identifying your existing knowledge, software environment, expected outcomes, and main conceptual or technical difficulties. We then establish a structured learning plan.

The first lesson combines a discussion of your background, objectives, and tutoring needs; an initial assessment of your current knowledge; personalized planning and organization of future sessions; and a short trial lesson to determine the most effective learning approach.

A typical session may include conceptual explanation, development of mathematical intuition, live coding, guided implementation, model evaluation, technical problem solving, and a concise summary of the next steps.

You may work with your own dataset, university assignment, research project, or professional problem, provided that confidential information is handled appropriately. I can also provide structured examples and datasets suited to your level.

My goal is not simply to help you run an algorithm. It is to help you understand why it is appropriate, how it learns from data, how to evaluate it correctly, why it may fail, and how to build a reliable, interpretable, and scientifically rigorous solution.

Baia

4.85

(13)

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

Yassine

4.85

(13)

Professeur agrégé de informatique, j’aide élèves et étudiants à réussir examens et concours. J’interviens aux classes préparatoires (MPSI, MP, PSI, ECS...) et jusqu’à l’université (Licence & Master en sciences ou économie). Ma méthode : comprendre le cours, pratiquer avec rigueur, structurer le raisonnement et ha des exercices et problèmes bien choisis. Chaque séance inclut exercices ciblés, conseils méthodologiques, et suivi personnalisé. Vous recevez un enregistrement vidéo plus un PDF annoté après chaque cours. Cours en ligne via Google Meet, 5 jours sur 7, avec flexibilité horaire. Je reste joignable entre les séances pour répondre aux questions. Contactez-moi pour un premier échange.