Introduction to programming applications in VBA (Excel) - Namur

Translated by GoogleSee original

Introduction to programming applications in VBA (Excel)

From 30 £ /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 -05: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

25 £ /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)

Youssef

4.85

(13)

Engineer and senior professor of engineering sciences provides support courses in analog and digital electronics at all levels, engineering schools. having a scientific and technical knowledge, five years of experience in the field of teaching, teaching and a sense of listening and analysis, I am able to help pupils and students and train them in the chapters of which they have difficulties. for more info please contact me

Matías

4.85

(13)

Python is one of the best, if not the best, language to start learning programming. It is also one of the most widely used languages today, especially in cutting-edge areas such as machine learning.

This popularity means that Python is constantly evolving. It offers a wide range of tools and libraries, which are free and very varied.

As an aeronautical engineer, I like to share my knowledge and derive satisfaction from it by teaching and motivating others.

I'm used to working with people of different ages. I believe in the importance of segmenting learning, visualizing progress, setting concrete goals and practicing regularly.

Beyond these general principles, there is no magic rule or method. Some approaches work with some students but not with others. Adaptation to individual needs is therefore the main objective of private lessons. So I will do my best to find what motivates and helps my student.

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

Gaëlle

4.85

(13)

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?"

Roger

4.85

(13)

Are you looking for personalized academic support to succeed in mathematics, physics or computer science? Do you want to understand your courses in depth, fill in your gaps or simply boost your performance? You've come to the right place!

💡 Why Choose this Program?
This program offers much more than traditional courses. You will benefit from tailor-made support for:

🔍 Understand theoretical concepts in depth.
🧠 Develop thinking and problem-solving methods.
📈 Progress at your own pace with exercises adapted to your level.
🎯 Prepare effectively for your exams (Brevet, Bac, competitive exams) by covering typical topics and revising key concepts.
💻 Acquire computer skills useful for studies, work or your personal projects.
👨‍🏫 Personalized and Pedagogical Teaching
Interactive online courses: Thanks to audio and screen sharing, enjoy comfortable learning from home, with complete peace of mind.
Clear and effective teaching: The explanations are adapted to your level to facilitate understanding.
Regular and motivating monitoring: Each progress is closely monitored to encourage and guide you throughout your journey.
Positive and caring method: Learn without stress and gain confidence thanks to caring support.
📘 Mathematics – Understand, Apply, Succeed
Mathematics can sometimes seem complicated, but with the right explanations, it becomes logical and accessible.
This module covers:

Middle School Level: Arithmetic, fractions, basic geometry, statistics.
High school level: Algebra, functions, equations, analytical geometry, probabilities.
Preparation for exams: Brevet, Bac, entrance exams for grandes écoles.
Advanced Mathematics: Differential and integral calculus, matrices, sequences and series for university level.
Practical and Corrected Exercises: To apply theoretical concepts and train effectively.
🔬 Physics – Learn by Understanding the World
Physics helps us understand the world around us, from gravity to electromagnetic phenomena.
This module covers:

Middle and high school level: Mechanics, electricity, optics, thermodynamics.
University Level: Analytical mechanics, advanced electromagnetism, quantum physics, statistical thermodynamics.
Scientific Methodology: Knowing how to analyze a problem, apply physical laws and interpret the results.
Practical Applications: Interactive simulations and corrected exercises to visualize and apply theoretical concepts.
💻 Computer Science – Learn to Code and Innovate
Mastering IT means developing essential skills in a constantly evolving digital world.
This module adapts to your level:

Introduction to Computers: Understand how a computer works, master office software.
Programming Beginner: Learn to code in Python, JavaScript or C/C++ with clear explanations and practical exercises.
Advanced Programming: Complex algorithms, advanced data structures, object-oriented programming.
Project Development: Creation of web applications, automated scripts, simple video games.
Preparation for NSI Exams: Complete support to pass the Digital and Computer Science tests.
🎯 Interactive and Motivating Teaching
Dynamic Online Course: Learn from home with an interactive format using audio and screen sharing.
Method Adapted to Your Pace: Each course is designed according to your level and your objectives.
Practical Exercises and Concrete Projects: To apply theoretical concepts and learn while having fun.
Personalized Monitoring: Regular support to monitor your progress and adapt the program to your needs.
Encouragement and Motivation: A positive approach to building your confidence in your abilities.
🔔 For Who?
This program is aimed at:

Middle school and high school students wishing to strengthen their foundations or aim for excellence.
University students in science or computer science looking to deepen their knowledge.
Candidates for exams and competitions preparing for the Brevet, the Bac, or entrance exams to the grandes écoles.
Passionate self-taught people who want to learn to program or better understand the scientific world.
Adults in professional retraining wishing to acquire IT skills.
🚀 Ready to Succeed?
Join the "🎯 Tailor-made Success – 📘 Private Lessons in Maths, 🔬 Physics & 💻 Computer Science!" and benefit from personalized support to achieve your goals. Whether you want to improve your grades, pass your exams or develop programming skills, this program will give you knowledge, confidence and motivation.

Register today and take the first step towards success!

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!

Mariem

4.85

(13)

Understanding algorithms is essential for anyone pursuing computer science or programming. In this course, I provide a structured approach to learning algorithms—from fundamental concepts like sorting and searching to advanced techniques such as dynamic programming and graph theory. Whether you're preparing for exams, coding interviews, or aiming to improve your problem-solving skills, this course is designed to build strong algorithmic thinking. Through practical examples and step-by-step explanations, I help students master the logic and techniques needed to write efficient and elegant code.

Yassine

4.85

(13)

Unlock your full potential with personalized online private classes in Microsoft Excel, Word, and PowerPoint! Whether you are a beginner eager to learn the basics or an advanced user aiming to enhance your skills, these one-on-one sessions are tailored just for you.

Learn to create professional documents in Word, analyze data and automate tasks in Excel, and design stunning presentations in PowerPoint—all from the comfort of your home. Our expert instructors provide live demonstrations, hands-on practice, and real-world projects to ensure you gain practical knowledge quickly.

Flexible scheduling, customized lessons, and continuous teacher support make mastering Microsoft Office easy and convenient. Perfect for students, professionals, and anyone looking to boost productivity and confidence with essential office tools.

Book your private class today and start your journey to Microsoft Office mastery!

Amin

4.85

(13)

Data skills can change your career, and you don't need to be a "math person" or have a technical background to learn them. If you can use a computer and you're curious, you can do this. In just 10 hours of one-to-one lessons, you'll go from "I don't know where to start" to analyzing real data on your own.

Maybe you're a student who needs to analyze data for a course or a thesis. Maybe you're looking for your first job in data, finance or business and want a skill that employers ask for. Maybe you already use Excel every day, but your reports take hours and you suspect there's a faster way. Or maybe you've never written a line of code and the idea feels intimidating. This class is built for all of you, and every lesson starts from where you are today.

I'm an engineer, and I work with data, statistics and programming (SQL, Python, R, Excel) every day. I don't teach theory for its own sake. I teach the way I use these tools in real work: you get a real question, a real dataset, and a clear method for turning one into the other.

In 10 hours, you will be able to:

Write SQL queries on your own. Select, filter, sort and group data, combine several tables with JOINs, and answer real questions such as "which product sold the most each month?"
Clean and analyze data in Excel. Use lookup formulas, conditional calculations and PivotTables, and build clear charts, instead of spending hours on manual work.
Build your first Power BI dashboard. Import data, clean it with Power Query, create interactive visuals, and share a report that looks professional.
Explain your results. Turn a business question into a query or a dashboard, check that your results make sense, and present them to someone who doesn't know the data.
Show a finished project. Leave with a portfolio-ready analysis you can use in an interview or in your thesis.

How the 10 hours are organized (we adapt this to your level and goal)

Hours 1-2: Foundations. We define your goal, check your level, and cover your first SQL queries (SELECT, WHERE, ORDER BY).
Hours 3-4: SQL in depth. Grouping and summarizing data, JOINs across tables, and cleaning messy data.
Hours 5-6: Excel for analysis. Advanced formulas, PivotTables, and charts.
Hours 7-8: Power BI. Importing and cleaning data, building visuals, and creating an interactive dashboard.
Hours 9-10: Your project. We put everything together on a realistic dataset (sales, finance, HR or your own data), and I give you feedback and a plan for what to practice next.

If you already know some Excel or SQL, we skip what you know and spend more time on what you need. If you want to go deeper later (for example advanced DAX, Python or statistics), we can continue from the same foundation.

How the lessons work

Every lesson is one-to-one and tailored to you. You practice on your own screen with my guidance, so you learn by doing rather than by watching. Between sessions I can give you short exercises if you want extra practice, and you can send me questions anytime. If you have your own files or work data (anonymized, of course), we can use them, which makes the learning much more relevant. Otherwise I provide practice datasets.

I explain in English or French (or Arabic if that's easier for you), and I'm patient. There are no silly questions. If something doesn't click, I'll explain it another way until it does.

Who this class is for

Students in business, economics, engineering, science or social sciences
Job seekers and career changers who want a first step into data analysis
Professionals who want to automate reports and work faster
Complete beginners. No previous experience with SQL or Power BI is needed.

Omar

4.85

(13)

Discover the full capabilities of Microsoft Word, Excel, and PowerPoint with personalized online private lessons designed to match your specific goals and skill level. Whether you're just starting out or looking to refine advanced techniques, these classes are tailored to help you succeed.

What You'll Master:

Word: Develop professional-quality documents, reports, and resumes with expert use of formatting, styles, tables, and mail merge.
Excel: Harness the power of spreadsheets by mastering formulas, functions, charts, and advanced data analysis.
PowerPoint: Create captivating presentations using animations, transitions, and striking visuals.

Why Opt for Private Lessons?

- Personalized one-on-one instruction tailored to your pace and objectives
- Flexible scheduling to fit your lifestyle—learn from anywhere at any time
- Immediate feedback and practical, hands-on experience
- Enhance productivity, tackle school projects with confidence, or elevate your career prospects

Ideal for students, professionals, job seekers, or anyone aiming to develop essential digital skills!

Wissem

4.85

(13)

I teach coding to beginners and intermediate students.
Lessons focus on logic, basic programming, and practical exercises.
Classes are adapted to the student’s pace.
Students can choose between website or mobile app development.Hands on dev

Verónica

4.85

(13)

Primary School Teacher. I offer personalized guidance in developing lesson plans and learning activities adapted to current educational regulations. During our sessions, you will learn to structure and write a complete lesson plan, including specific competencies, assessment criteria, core knowledge, methodology, addressing diversity, evaluation, and learning situations. My goal is to help you understand each section so you can independently develop a coherent, rigorous, and high-quality lesson plan.

You will learn to design practical, creative proposals, developing the necessary skills to apply them in the classroom or in competitive examination processes.

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

Abdul

4.85

(13)

Spending hours every month cleaning the same Excel reports? Or preparing for the PL-300 (Microsoft Power BI Data Analyst) exam and not sure where to start? I teach working professionals and career changers how to use Power BI and Excel the way they're used at work, step by step and in plain language.

What you'll learn (tailored to your goal):
• Power Query: clean messy data (extra spaces, wrong data types, duplicates, text numbers) and set it up so next month is just "Refresh"
• Data modelling: star schema, relationships and a proper Date table
• DAX: measures, CALCULATE and time intelligence, explained so you understand why, not just copy formulas
• Dashboards: clear visuals, slicers, drill-down and Actual vs Target reports
• Power BI Service: publishing, refresh and sharing
• PL-300 exam practice: exam-style questions with explanations

How I teach:
I explain each idea before we click, then we build it together on a realistic dataset, and then you try it yourself. You get clear notes after each lesson. If you bring your own work file (with sensitive data removed), we can use it so you solve your real problem.

About me: Data Science Master's student and BI analyst. I built Power BI and Excel reporting for companies, and recently automated a finance team's monthly SAP report with Power Query so it now updates with one click.