VBA (Visual Basic for Application) - Excel, Access, SQL - Antony - Private lessons

Translated by GoogleSee original

VBA (Visual Basic for Application) - Excel, Access, SQL

From 26 € /h

First part, introduction to algorithms, up to a desired level for data management

Second part, application of algorithmic notions for vba applications and to acquire habits to face any situation and be autonomous in language without having to use objects. In this part, parallels can be made with other functional languages where programming languages are applied in a similar way (Python, PHP, Javascript ...)

Third part, introduction to the Excel data model (Collections, Objects, Methods). For this part, we forget the algos and we use the objects which reduce the number of lines of code. In this part, we will also discuss the macro recorder which can be very useful for this part.

Fourth part, approach an advanced level to manage files (create, modify, extract information), access databases ...

Location

|

Use Ctrl + wheel to zoom!

At student's location :

Around Antony, France

Online from France

About Me

Experience of more than 10 years in automation on Excel spreadsheet, in multinationals, SMEs in France and England
I also had to work remotely as a freelance for various interlocutors in various countries.

Education

DCG (Diploma in Accounting and Management) obtained at CNAM-INTEC between 2003 and 2008
License and Masters in business management at the University of Paris 12 in 2002.
BTS in international trade

Experience / Qualifications

Accounting and accounting management (good notions in business accounting and transversal matters (logistics, payroll ...)

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Duration

60 minutes

90 minutes

The class is taught in

French

English

Skills

Computer programming

Availability of a typical week

(GMT -05:00)

New York

Online via webcam

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Hello dear programmer,

HTML and CSS go hand in hand when it comes to creating websites programmatically.

I propose courses in detail of beginner level - intermediate or advanced. With existing site analysis and gradual explanation.

I myself was a beginner and I made sure to keep the vision that we can have when we start programming. This allows me to often answer questions to which some experts will provide a thorough and theoretical explanation and will remain misunderstood for some.

Answers to your questions!
Objective: YOU "Accompany and make you effective!"

I offer introductory courses in computer science and computer programming.

Computer introductory courses are courses that I give to beginners to better master the use of the computer and carry out common tasks (eg: online shopping, checking accounts, watching replay videos of TV shows, etc.). ), as well as tools such as the office pack with Word, PowerPoint, Excel...

In a second time, I also give computer programming courses, these are courses that are intended primarily for people with a basic knowledge of a computer, if it is not the case there will be no problem to start all over again.

I teach web programming with HTML, CSS, JavaScript, PHP, as well as object-oriented programming with JAVA and C ++. In addition I also do event programming with Visual Basic. Finally, I can give courses for the manipulation of databases with SQL and Access.

Hi,

This course is for anyone who wants to know more about the net (what the Net does not tell you (its languages: HTML, these, JavaScript and others).

Classes will take place in Massy.
I am available Mondays and Thursdays from 10h to 12h.

See you soon, I hope ! :)

Python is a programming language that combines high-level tools and syntax simplicity.

Working in the field of astrophysics, I develop scientific software in Python for several years.

I propose a course adapted to the level of each one: that it is the bases of Python and the programming or possibly an assistance to realize a defined project.

I base much more on the understanding of theoretical concepts before starting the examples since by understanding the concept we will be able to manage all types of questions that may arise.
Make several demonstrations with the whole class before asking the students to make comparisons on their own.
Keep in touch with the students after the sessions to give him help with his homework and do the maximum possible so that he will be able to improve in the way of thinking

As a beginner in computer science and to get acquainted with the world of programming, learn
c language and c ++ is paramount.
This course will help you learn the basics of these two languages which are among the best known and most used programming languages in the world.
Having knowledge of C and C ++ will help you to better understand other programming languages later on.

Student in the research course in Computer Science Linguistics at the University of Paris, I have a background in literature through a license and in mathematics with a CPGE. My goal during private lessons is to explain the lessons with a different vision of a traditional teacher and to train the student not only for his homework and exams but also for the rest of his course.

If you are looking for user-friendly and rewarding courses in computer science and Microsoft Excel, you will find the courses suitable and impactful.

My experience is also multiple as an entrepreneur, employee? Temporary teacher and company manager.
I do both Microsoft Excel initiation and very advanced courses (see price)

I organize your course according to your needs, your requests and your level, the number of hours required is often 2 hours.
I adapt to your needs and personalize your course for you either on your work support or on my already developed supports.

The people I train are: active looking for a job, student or retired. More than 300 people trained since 2016.

Initiation levels: Learning tabs, cell format, Creation of simple pivot tables, graphics on Microsoft Excel.
Getting started with your computer recording and filing your files, voice tools.

If you want to go to the advanced level, I suggest:
On EXCEL: (VBA, Macro, complex formulas index equiv, creation of QRCODE and the principle of $, the 5 SI).

◾ Tools

RStudio • SQL • SPSS • SAS • Jamovi • JASP

◾ Statistical Methods & Tests

Student's t-test • ANOVA • MANOVA • ANCOVA • Regression (linear & logistic) • Correlation • Chi-square • Nonparametric tests • PCA • MCA • Exploratory factor analysis • Classification / Clustering • Mediation • Moderation • Interpretation

◾ Data analysis & decision support

- Data preparation, structuring and validation using SAS, R and SQL
- Descriptive, exploratory and multivariate statistical analyses on business data
- Production of performance indicators and actionable analyses to support decision-making

◾ Selection and implementation of methods

- Preparation and structuring of databases
- Hypothesis testing and univariate, bivariate and multivariate analyses (ANOVA / ANCOVA)
- Linear and logistic regressions
- Factor analyses (PCA / MCA)
- Mediation and moderation models
- Classification / clustering

1) Academic support

- Lectures, tutorials, projects and assignments in statistics
- Help in understanding and interpreting the results
- Preparation for exams and academic presentations

2) Statistical analysis

- Descriptive statistics (univariate and bivariate)
- Multivariate analyses
- Data exploration and outlier detection

3) Statistical tests

- Correlations (Pearson, Spearman, Cohen's Kappa)
- t-tests (one and two samples, independent or paired)
- Chi-square, binomial tests
- z-scores and associated indicators

4) Statistical modeling

- Linear regressions (simple and multiple)
- Logistic regression
- Interpretation of coefficients, diagnostics and validation of models

5) ANOVA & ANCOVA

- One- or multi-factor ANOVA
- Repeated measures ANOVA
- Fixed and random effects
- Post-hoc tests and effect sizes

6) Factor analyses

- ACP / PCA (scree plot, factor scores, matrices)
- Exploratory factor analysis
- Factorial rotations
- Validation and interpretation of structures and clusters

◾ Reporting & communication

- Clear, structured and concise reporting of results
- Visualizations tailored to decision-makers
- Support for strategic and operational decision-making

I am a young teacher who will help you learn programming and algorithms with a very effective methodology.
I am also here to guide you and show you the tricks of this field and how to become a quality software engineer, not just a developer or a programmer.
I prefer to have students who are really interested than to have students who are just looking to find someone to help them with their homework.

Welcome to the exciting world of web development! As a seasoned full-stack developer with 5 years of experience, I contributed to the success of Veepee and a startup that achieved a remarkable exit to the tune of $100 million.

Today, my passion drives me to share my knowledge through teaching web development, focusing on cutting-edge technologies such as React, Node.js, JavaScript, and many other computer languages. Join me on an exciting journey into the world of coding, where innovation and skill mastery are at the heart of every line of code! 🚀

I follow more or less closely the famous book entitled Introduction to Algorithms authored by CLRS on the subject. The coverage is exhaustive as we go through various concepts related to data structures and algorithms, study standard algorithms such as for sorting, searching, finding max/min, handling trees and graphs, and then pursue in detail their application to real world problems.

I work upwards from first principles so the understanding is solid and transferrable to other domains. We work through problems together in a step by step manner before I encourage the student to tackle a problem autonomously so they get an idea of the problem solving process whilst also building their own framework to approach each problem.

With more than 10 years of experience, I offer support courses in mathematics, physics and programming adapted to all levels.

I regularly assisted students through private lessons. In addition, during my doctoral studies, I had the opportunity to teach theoretical physics at the university.

Doctor in particle physics, my training allows me to teach various subjects and prepare effectively for exams. Since mathematics is an essential component of theoretical physics, I am also able to provide in-depth support in this discipline.

In addition, the practice of fundamental research in particle physics involves daily work in programming. I am comfortable in C++, Fortran, Python, Matlab, Bash/Unix, FORM, Mathematica among others.

I teach both in French and in English.

Do you want to learn computer science, programming or deepen your knowledge in information technology? I offer courses adapted to all levels, from beginner to advanced.

👉 Introduction to Computer Science and Operating Systems
👉 Introduction and improvement in object programming (solid experience in the Java language)
👉 Web development and databases (HTML, CSS, Javascript, SQL)
👉 Cybersecurity and information systems management
👉 Support for your projects and help with homework

Personalized courses, interactive teaching and guaranteed progress! Available online or in person. Contact me to discuss your goals and start your learning.

Passionate about computers and science, I went to the EFREI engineering school where I acquired a solid foundation in programming, mathematics and physics.
I offer computer language courses (Python, Java, HTML/CSS/JS, C, SQL), suitable for all levels: discovery of programming, skills strengthening or preparation for an exam/project.

My sessions are personalized: we will work together on logic, practical exercises, and concrete projects to progress effectively. My goal is to make programming accessible, clear, and motivating, even for beginners.

- Beginners: you will learn to write your first programs, understand fundamental concepts and develop projects adapted to your needs.

- Intermediate/advanced: you will be able to deepen your knowledge, strengthen your logic and broaden your vision of programming.

Hello dear programmer,

HTML and CSS go hand in hand when it comes to creating websites programmatically.

I propose courses in detail of beginner level - intermediate or advanced. With existing site analysis and gradual explanation.

I myself was a beginner and I made sure to keep the vision that we can have when we start programming. This allows me to often answer questions to which some experts will provide a thorough and theoretical explanation and will remain misunderstood for some.

Answers to your questions!
Objective: YOU "Accompany and make you effective!"

I offer introductory courses in computer science and computer programming.

Computer introductory courses are courses that I give to beginners to better master the use of the computer and carry out common tasks (eg: online shopping, checking accounts, watching replay videos of TV shows, etc.). ), as well as tools such as the office pack with Word, PowerPoint, Excel...

In a second time, I also give computer programming courses, these are courses that are intended primarily for people with a basic knowledge of a computer, if it is not the case there will be no problem to start all over again.

I teach web programming with HTML, CSS, JavaScript, PHP, as well as object-oriented programming with JAVA and C ++. In addition I also do event programming with Visual Basic. Finally, I can give courses for the manipulation of databases with SQL and Access.

Hi,

This course is for anyone who wants to know more about the net (what the Net does not tell you (its languages: HTML, these, JavaScript and others).

Classes will take place in Massy.
I am available Mondays and Thursdays from 10h to 12h.

See you soon, I hope ! :)

Python is a programming language that combines high-level tools and syntax simplicity.

Working in the field of astrophysics, I develop scientific software in Python for several years.

I propose a course adapted to the level of each one: that it is the bases of Python and the programming or possibly an assistance to realize a defined project.

I base much more on the understanding of theoretical concepts before starting the examples since by understanding the concept we will be able to manage all types of questions that may arise.
Make several demonstrations with the whole class before asking the students to make comparisons on their own.
Keep in touch with the students after the sessions to give him help with his homework and do the maximum possible so that he will be able to improve in the way of thinking

As a beginner in computer science and to get acquainted with the world of programming, learn
c language and c ++ is paramount.
This course will help you learn the basics of these two languages which are among the best known and most used programming languages in the world.
Having knowledge of C and C ++ will help you to better understand other programming languages later on.

Student in the research course in Computer Science Linguistics at the University of Paris, I have a background in literature through a license and in mathematics with a CPGE. My goal during private lessons is to explain the lessons with a different vision of a traditional teacher and to train the student not only for his homework and exams but also for the rest of his course.

If you are looking for user-friendly and rewarding courses in computer science and Microsoft Excel, you will find the courses suitable and impactful.

My experience is also multiple as an entrepreneur, employee? Temporary teacher and company manager.
I do both Microsoft Excel initiation and very advanced courses (see price)

I organize your course according to your needs, your requests and your level, the number of hours required is often 2 hours.
I adapt to your needs and personalize your course for you either on your work support or on my already developed supports.

The people I train are: active looking for a job, student or retired. More than 300 people trained since 2016.

Initiation levels: Learning tabs, cell format, Creation of simple pivot tables, graphics on Microsoft Excel.
Getting started with your computer recording and filing your files, voice tools.

If you want to go to the advanced level, I suggest:
On EXCEL: (VBA, Macro, complex formulas index equiv, creation of QRCODE and the principle of $, the 5 SI).

◾ Tools

RStudio • SQL • SPSS • SAS • Jamovi • JASP

◾ Statistical Methods & Tests

Student's t-test • ANOVA • MANOVA • ANCOVA • Regression (linear & logistic) • Correlation • Chi-square • Nonparametric tests • PCA • MCA • Exploratory factor analysis • Classification / Clustering • Mediation • Moderation • Interpretation

◾ Data analysis & decision support

- Data preparation, structuring and validation using SAS, R and SQL
- Descriptive, exploratory and multivariate statistical analyses on business data
- Production of performance indicators and actionable analyses to support decision-making

◾ Selection and implementation of methods

- Preparation and structuring of databases
- Hypothesis testing and univariate, bivariate and multivariate analyses (ANOVA / ANCOVA)
- Linear and logistic regressions
- Factor analyses (PCA / MCA)
- Mediation and moderation models
- Classification / clustering

1) Academic support

- Lectures, tutorials, projects and assignments in statistics
- Help in understanding and interpreting the results
- Preparation for exams and academic presentations

2) Statistical analysis

- Descriptive statistics (univariate and bivariate)
- Multivariate analyses
- Data exploration and outlier detection

3) Statistical tests

- Correlations (Pearson, Spearman, Cohen's Kappa)
- t-tests (one and two samples, independent or paired)
- Chi-square, binomial tests
- z-scores and associated indicators

4) Statistical modeling

- Linear regressions (simple and multiple)
- Logistic regression
- Interpretation of coefficients, diagnostics and validation of models

5) ANOVA & ANCOVA

- One- or multi-factor ANOVA
- Repeated measures ANOVA
- Fixed and random effects
- Post-hoc tests and effect sizes

6) Factor analyses

- ACP / PCA (scree plot, factor scores, matrices)
- Exploratory factor analysis
- Factorial rotations
- Validation and interpretation of structures and clusters

◾ Reporting & communication

- Clear, structured and concise reporting of results
- Visualizations tailored to decision-makers
- Support for strategic and operational decision-making

I am a young teacher who will help you learn programming and algorithms with a very effective methodology.
I am also here to guide you and show you the tricks of this field and how to become a quality software engineer, not just a developer or a programmer.
I prefer to have students who are really interested than to have students who are just looking to find someone to help them with their homework.

Welcome to the exciting world of web development! As a seasoned full-stack developer with 5 years of experience, I contributed to the success of Veepee and a startup that achieved a remarkable exit to the tune of $100 million.

Today, my passion drives me to share my knowledge through teaching web development, focusing on cutting-edge technologies such as React, Node.js, JavaScript, and many other computer languages. Join me on an exciting journey into the world of coding, where innovation and skill mastery are at the heart of every line of code! 🚀

I follow more or less closely the famous book entitled Introduction to Algorithms authored by CLRS on the subject. The coverage is exhaustive as we go through various concepts related to data structures and algorithms, study standard algorithms such as for sorting, searching, finding max/min, handling trees and graphs, and then pursue in detail their application to real world problems.

I work upwards from first principles so the understanding is solid and transferrable to other domains. We work through problems together in a step by step manner before I encourage the student to tackle a problem autonomously so they get an idea of the problem solving process whilst also building their own framework to approach each problem.

With more than 10 years of experience, I offer support courses in mathematics, physics and programming adapted to all levels.

I regularly assisted students through private lessons. In addition, during my doctoral studies, I had the opportunity to teach theoretical physics at the university.

Doctor in particle physics, my training allows me to teach various subjects and prepare effectively for exams. Since mathematics is an essential component of theoretical physics, I am also able to provide in-depth support in this discipline.

In addition, the practice of fundamental research in particle physics involves daily work in programming. I am comfortable in C++, Fortran, Python, Matlab, Bash/Unix, FORM, Mathematica among others.

I teach both in French and in English.

Do you want to learn computer science, programming or deepen your knowledge in information technology? I offer courses adapted to all levels, from beginner to advanced.

👉 Introduction to Computer Science and Operating Systems
👉 Introduction and improvement in object programming (solid experience in the Java language)
👉 Web development and databases (HTML, CSS, Javascript, SQL)
👉 Cybersecurity and information systems management
👉 Support for your projects and help with homework

Personalized courses, interactive teaching and guaranteed progress! Available online or in person. Contact me to discuss your goals and start your learning.

Passionate about computers and science, I went to the EFREI engineering school where I acquired a solid foundation in programming, mathematics and physics.
I offer computer language courses (Python, Java, HTML/CSS/JS, C, SQL), suitable for all levels: discovery of programming, skills strengthening or preparation for an exam/project.

My sessions are personalized: we will work together on logic, practical exercises, and concrete projects to progress effectively. My goal is to make programming accessible, clear, and motivating, even for beginners.

- Beginners: you will learn to write your first programs, understand fundamental concepts and develop projects adapted to your needs.

- Intermediate/advanced: you will be able to deepen your knowledge, strengthen your logic and broaden your vision of programming.

Good-fit Instructor Guarantee

Contact Pascal