Introduction to programming applications in VBA (Excel) - Namur

Translated by GoogleSee original

Introduction to programming applications in VBA (Excel)

From 56 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

47 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)

Youssef

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

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

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)

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.

Baia

4.85

(13)

I teach Python specifically for finance and data applications - the kind used in economics, business analytics, and quantitative programs. This isn't a general "learn to code" course; it's built around real financial data, benchmarking, and the workflows you'll actually use in coursework or early career work.

Topics include:
Python fundamentals through a finance lens (data structures, functions, control flow).
Working with financial data and datasets.
Performance benchmarking and writing efficient code.
Applying concepts from Hilpisch's Python for Finance.

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!

Amine

4.85

(13)

Online Private Classes in Microsoft Office

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

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

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

Microsoft PowerPoint – Design engaging presentations with animations, transitions, and multimedia integration.

Why Choose Our Classes?
✅ One-on-One Sessions – Tailored to your skill level and goals.
✅ Flexible Scheduling – Learn at your convenience.
✅ Hands-On Practice – Real-world exercises for better retention.
✅ Certified Instructors – Experienced professionals guiding you step-by-step.

Perfect for students, professionals, or anyone looking to enhance their Microsoft Office skills efficiently!

📩 Contact us today to book your session!

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.

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

Laroussi

4.85

(13)

Who should attend ?
This course is specifically designed for seniors, young retirees, or anyone wishing to update their computer skills at their own pace. No prior technical knowledge is required. Patience, clarity, and a supportive approach are at the heart of this training.

Why take this course?
Information technology should no longer be a barrier, but a tool to simplify your daily life and keep you connected with loved ones. This program has two objectives: to make you completely proficient with standard software (Word, Excel) and to introduce you, in a simple and engaging way, to the new Artificial Intelligence (AI) technologies that everyone is talking about.

Educational goals :
At the end of this learning cycle, you will be able to:

Drafting and formatting administrative or personal documents.

Managing a family budget or creating simple organizational lists.

Understand what Artificial Intelligence is (like ChatGPT or Gemini) and use it as a personal assistant on a daily basis.

Detailed program (Syllabus)
The program is adaptable to your initial level. Each session includes simplified theory and plenty of practice.

Module 1: The basics of office software (Microsoft Word)

Exploring the interface: the keyboard, the mouse, and the word processing screen.

Enter, correct and format text (bold, italics, colours, alignment).

Write an official letter or a letter to loved ones.

Save, find your document on the computer, and print it.

Module 2: Daily Organization (Microsoft Excel)

Understanding the principle of tables and cells.

Create simple lists (address book, shopping list).

Create a tracking table for the monthly budget (expenses, income).

Use basic formulas (automatic sum) to have the computer calculate for you.

Module 3: The Arrival of Artificial Intelligence (Chatbots)

What is Artificial Intelligence (AI)? A simple explanation and demystification.

Discover virtual assistants (ChatGPT or Gemini): how to access them for free and securely.

The art of the "Prompt" (the query): how to ask the right questions to the machine to get the best answers.

Practical workshops with AI:

Ask him to draft a complex email.

Looking for recipe ideas using leftovers from the fridge.

Have him summarize a long newspaper article.

Organize a travel itinerary from A to Z.

Module 4: Safety and Best Practices

Recognizing reliable information in the face of AI "hallucinations" (errors).

The golden rules for protecting your personal data on the internet and in Office documents.

My Pedagogical Methodology
The approach is entirely personalized. I adapt to your learning pace. Each new concept is immediately followed by a practical, concrete exercise directly related to your everyday needs (writing to an administration, planning your vacation, etc.). Simplified course materials can be provided at the end of each session to help you review on your own.

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.

منال

4.85

(13)

📊Microsoft Office: To establish your office skills, manage data via Excel, write professional reports with Word, and prepare impressive presentations with PowerPoint.

📐 AutoCAD: To learn engineering drawing and design two-dimensional and three-dimensional plans with high accuracy and speed.

🛣️ Civil 3D: To learn road design, network design, surveying, and quantity surveying in a scientific and practical way

Azhar

4.85

(13)

Are you interested in learning Python but don't know where to start? This course is designed to help you understand the fundamentals of Python programming in a simple, practical, and enjoyable way.

Python is one of the most popular programming languages in the world. It is widely used in software development, automation, data analysis, artificial intelligence, and web development.

Whether you are a complete beginner, a student, or someone looking to develop new technical skills, these lessons will help you build a strong foundation in programming.

You will learn
1. Introduction to Python
2. Python Fundamentals
3. Conditional Statements and Loops
4. Working with Data
5. Functions and Practical Programming
6. Mini Projects