Microsoft Excel VBA / Access VBA / SQL Server - Business Reporting and Data Analysis - Formula, Pivot, Calculations, External data, coding. - London - Private lessons

Microsoft Excel VBA / Access VBA / SQL Server - Business Reporting and Data Analysis - Formula, Pivot, Calculations, External data, coding.

From 39.07 $ /h

I have 15 years of experience working in companies large and small, specialising in Excel VBA, Access VBA and SQL to create databases and reports.

If you want to learn Excel, be it a beginner introduction class or expert level than I can help.

I am a native English speaker with friendly and clear communicaton.

Location

|

Use Ctrl + wheel to zoom!

At student's location :

Around London, United Kingdom

At teacher's location :

London, UK

Online from United Kingdom

Age

Children (7-12 years old)

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

30 minutes

45 minutes

60 minutes

90 minutes

120 minutes

The class is taught in

English

Skills

Microsoft excel

Computer programming

Availability of a typical week

(GMT -04:00)

New York

At teacher's location and 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

My formation in engineering school (Information Technology at the ÉTS in Montreal, Canada), techinian school (GEII at the IUT de Cachan, France) and my previous placements experiences (Croesus Finansoft and the National Institute of Sports) helped me specialize myself in Math, Physics and Computer Sciences.

I'm able to teach and help the students in Math, Physics and the basic of Computer Sciences (depending on the student's level). The focus of the class is to develop the ability to learn, think and solve problems.

As for the Computer Sciences class, you will learn the basics of current programming languages such as C/C++, Java, Python, Objective C (IOS programming).

At the end of the class you could have some homeworks to do for the next session. These would help you to assimilate the subject previously learned.

I will teach them biology, some fundamentals of programming language so that if someone has no prior knowledge in coding he can get familiar with it and I will also teach them about public speaking what we should keep in mind while speaking to others.

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.

I am an Economics graduate with the strong background in Econometrics, Statistics, and Data Analytics. Moreover, I have worked for Unilever (Fortune 200 company) as a Data Analyst, where I have applied my Econometrics, Statistics, Economics and Data Analytics knowledge using tools such as: Python (Pandas, Numpy), MS Excel, MS PowerPoint, MS PowerBI and SQL.

Due to my educational background I possess high level knowledge of:

-Linear, Multiple and Logistic regression and time series analysis.
-Give interpretations and predictions of regression analysis.
-Descriptive statistics (Mean, Median Mode, Skewness, Kurtosis, etc.)
-Inferential statistics
-Chi-Square Tests, Confidence Interval
-Monte Carlo simulation
-Anova Analysis
-Hypothesis Testing (T -tests, Z test, F-tests),
-Correlation Analysis and interpretation.
-Non-Parametric Tests (Kruskal-Wallis, Wilcoxon Signed Rank Tests, etc.)

Tools: MS Excel, MS PowerPoint, MS PowerBI, Python (Pandas, Numpy, Matplotlib, Spark), STATA, eViews, SQL

I am a Graphics Designer and web developer with over 5 years of experience, I have worked with more than 200 clients around the world and created more than 2000 designs, and designed more than 15 websites. I am a man of knowledge that can change and build your future not just by helping you in your studies but also with life and helping your businesses and Jobs to grow and how to work with the market. I will do my best to make you run with society and lead to the future.

You are a highschool student?
You have a baccalaureate?
You need help with Python (Algorithmic Programming).
I am here to teach you !

I am certified from Python Institute (PCAP: Certified Associate in Python Programming) and I work with Python for more than 5 years.
I am also a teacher and my students love the way I teach with (simple, clear and always funny)

As an online and physical tutor, i am knowledgeable and experienced in your subject matter. I possess excellent communication skills, and i am patient and understanding when working with students. I have a passion for teaching and are committed to helping your students succeed. I adept at using technology to facilitate online learning, and you are able to create engaging and interactive lessons that cater to each student's learning style. In a physical setting, I create a welcoming and comfortable learning environment that allows students to feel at ease and encourages them to ask questions and participate in discussions. Overall, I am a skilled and effective tutor who is dedicated to helping students achieve their academic goals.

<Course Description>
This course is designed for beginners who are interested in learning programming with Python. It covers the basic concepts of programming such as data types, variables, control structures, functions, and file I/O. Participants will learn how to write Python programs, debug code, and design algorithms using Python. The course also introduces the basics of object-oriented programming and the Python libraries used for data manipulation and visualization.

<Prerequisites>
No prior programming experience is required. However, familiarity with basic computer concepts such as files, folders, and operating systems is recommended.

<Learning Objectives>
By the end of the course, participants will be able to:

* Understand the fundamentals of programming and how it applies to Python
* Write Python code for simple applications and automate repetitive tasks
* Use control structures such as loops and conditional statements
* Create functions to encapsulate code and enable code reuse
* Work with Python libraries such as NumPy, Pandas, and Matplotlib
* Use object-oriented programming principles to design more complex programs
* Debug code and use error-handling techniques

<Course Outline>
The course is divided into modules that build on each other to provide a comprehensive introduction to Python programming. Each module consists of lectures, demonstrations, hands-on exercises, and quizzes to reinforce learning. Here is an outline of the course:

Module 1: Introduction to Python
History and Overview of Python
Setting up Python environment
Writing and running basic Python programs
Variables, data types, and operators

Module 2: Control Structures
Conditional statements and Boolean logic
Loops and iteration
User input and output

Module 3: Functions
Writing and calling functions
Scope and namespaces
Return values and parameters
Lambda functions

Module 4: File Input and Output
Reading and writing files
File modes and buffering
Handling exceptions and errors

Module 5: Object-Oriented Programming
Classes and objects
Inheritance and polymorphism
Data encapsulation and abstraction
Special methods and decorators

Module 6: Python Libraries
Introduction to NumPy, Pandas, and Matplotlib
Data manipulation and analysis with Pandas
Data visualization with Matplotlib

Conclusion
This beginner's programming class in Python provides a solid foundation for anyone interested in learning programming and using Python for data analysis, automation, or software development. With hands-on exercises, interactive quizzes, and a comprehensive final project, participants will learn how to write Python code that is efficient, maintainable, and elegant.

I am a Cambridge graduate in CS, with over 10 medals and national distinctions for competitive programming.

For over 5 years, I have helped hundreds of students discover how easy and beautiful Computer Science is:

- Assisted students in improving from a C to an A* grade.
- Helped motivated students qualify for the National Informatics Olympiad.
- Guided many achieve their target grades in A-Levels, even attaining the perfect score.
- Prepared for IB/IA, A-Levels, GCSE, University Entry, or equivalent.
- Assisted with specific projects at a professional level, including interview preparation.

All my success in Computer Science is due to my teachers, who knew how to inspire my passion and turn any concept into an easy-to-understand story. That's why I decided to help others further to elucidate the secrets of Computer Science and to smile with relief in the exam hall when they notice that they know how to solve all the subjects perfectly.

It's amazing how quickly a student can progress when the material is explained to them in their understanding.

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 :).

Hi!

Welcome to my class on Python programming! As a PhD student in Geophysics my main tool is my computer. In order to do science one needs to know how to program. I use Python everyday in order to analyze data, run numerical models, plot results and much more. So, let's embark on the journey of learning Python and explore its diverse capabilities together!

For beginners:
I have designed it for absolute beginners to become at ease with the language within 5 sessions of 1h. Message me to know the 5 classes curriculum and I will be more than happy to share it with you!

For intermediate users:
If you already know the basics of Python but want to go more in-depth on certain packages this is the right place! Message me and we can discuss what your needs are! I am a professional user of Numpy, Pandas, Matplotlib, os, scipy and many more packages!

Are you not sure Python is the right language for you? Check the following out and let me know if you have any questions!

First of all, what is Python? According to its creator, Guido van Rossum, Python is a:

“high-level programming language, and its core design philosophy is all about code readability and a syntax which allows programmers to express concepts in a few lines of code.”

Learning Python is a rewarding experience for several reasons. Firstly, Python is inherently beautiful as a programming language, offering a natural and expressive way to translate your thoughts into code. Its readability and simplicity make coding an enjoyable and intuitive process.

The Python language finds applications across various domains, including data science, web development, machine learning and AI. For example, platforms like Quora, Pinterest, and Spotify leverage Python for their backend web development!

This versatility makes Python a powerful tool for those eager to delve into different aspects of programming. If this caught your curiosity message me and I'll make you a Python hero! Welcome to the community!

6 Python Programming Sessions of 1 hour each:

Session 1: Basics
Python Data Types and Variables:
Operators and Expressions.
Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else.

Session 2:
Using Loops:
The while, while-else.
For loop;
Jump statements: break, continue;
Nesting loops.

Session 3:
Working with variables and its scope;
Conversion and casting types in Python.

Session 4: Python Built-in functions
Maths Functions.
Random Functions.

Session 5: Strings Functions.

Computer Science is the future. As we are moving towards a digital age with a high speed. As a programmer you can be a part of that future and can develop many different novel things. This course is made specifically for any person of any age to get a crystal clear image of Computer Science.

You will learn basic concepts of Programming (using Python and C++) and of many other fields (such as, AI, database, networking and so so). After completing the course you will be able to create and implement many different novel idea digitally.

Ready to unlock the beauty of the Arabic language? Our online Arabic classes are designed for learners of all levels, from beginners to advanced speakers. With our flexible, self-paced format, you can learn Arabic anytime, anywhere, fitting your language studies into your lifestyle.

Led by expert instructors, our interactive lessons will help you build confidence in speaking, listening, reading, and writing Arabic. Whether you’re learning for travel, career, or cultural enrichment, our classes provide the tools you need to succeed.

Don’t wait to start your Arabic journey—sign up today and learn Arabic anytime, anywhere!

Mathematics is the best way to enhance your intellect but also work on your intuition and your ability to see patterns.

Good day, my name is Alex, I have been teaching math for over 10 years to hundreds of students. I will teach all grades from elementary school all the way to high school and IB/GCSE etc.

My philosophy revolves around these three values:
-Encouragement
-Inspiration
-Discipline

I specialize into teaching mathematics and programming, but in some occasions I teach physics too.
Feel free to contact me.

I offer engaging and comprehensive programming lessons in C++ and Python, designed to help you master essential concepts and advanced topics in computer science. From problem-solving techniques, object-oriented programming, and data structures to database management, operating systems, digital logic design, and algorithm analysis, my lessons cover it all. I also introduce exciting areas like parallel and distributed computing and the basics of artificial intelligence. Whether you're preparing for GCSEs, A-levels, or pursuing a BSc in Computer Science, my tailored approach ensures you build a strong foundation and advance to becoming an exceptional programmer. Let’s make programming both accessible and enjoyable as you unlock your full potential in this ever-evolving field!

My formation in engineering school (Information Technology at the ÉTS in Montreal, Canada), techinian school (GEII at the IUT de Cachan, France) and my previous placements experiences (Croesus Finansoft and the National Institute of Sports) helped me specialize myself in Math, Physics and Computer Sciences.

I'm able to teach and help the students in Math, Physics and the basic of Computer Sciences (depending on the student's level). The focus of the class is to develop the ability to learn, think and solve problems.

As for the Computer Sciences class, you will learn the basics of current programming languages such as C/C++, Java, Python, Objective C (IOS programming).

At the end of the class you could have some homeworks to do for the next session. These would help you to assimilate the subject previously learned.

I will teach them biology, some fundamentals of programming language so that if someone has no prior knowledge in coding he can get familiar with it and I will also teach them about public speaking what we should keep in mind while speaking to others.

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.

I am an Economics graduate with the strong background in Econometrics, Statistics, and Data Analytics. Moreover, I have worked for Unilever (Fortune 200 company) as a Data Analyst, where I have applied my Econometrics, Statistics, Economics and Data Analytics knowledge using tools such as: Python (Pandas, Numpy), MS Excel, MS PowerPoint, MS PowerBI and SQL.

Due to my educational background I possess high level knowledge of:

-Linear, Multiple and Logistic regression and time series analysis.
-Give interpretations and predictions of regression analysis.
-Descriptive statistics (Mean, Median Mode, Skewness, Kurtosis, etc.)
-Inferential statistics
-Chi-Square Tests, Confidence Interval
-Monte Carlo simulation
-Anova Analysis
-Hypothesis Testing (T -tests, Z test, F-tests),
-Correlation Analysis and interpretation.
-Non-Parametric Tests (Kruskal-Wallis, Wilcoxon Signed Rank Tests, etc.)

Tools: MS Excel, MS PowerPoint, MS PowerBI, Python (Pandas, Numpy, Matplotlib, Spark), STATA, eViews, SQL

I am a Graphics Designer and web developer with over 5 years of experience, I have worked with more than 200 clients around the world and created more than 2000 designs, and designed more than 15 websites. I am a man of knowledge that can change and build your future not just by helping you in your studies but also with life and helping your businesses and Jobs to grow and how to work with the market. I will do my best to make you run with society and lead to the future.

You are a highschool student?
You have a baccalaureate?
You need help with Python (Algorithmic Programming).
I am here to teach you !

I am certified from Python Institute (PCAP: Certified Associate in Python Programming) and I work with Python for more than 5 years.
I am also a teacher and my students love the way I teach with (simple, clear and always funny)

As an online and physical tutor, i am knowledgeable and experienced in your subject matter. I possess excellent communication skills, and i am patient and understanding when working with students. I have a passion for teaching and are committed to helping your students succeed. I adept at using technology to facilitate online learning, and you are able to create engaging and interactive lessons that cater to each student's learning style. In a physical setting, I create a welcoming and comfortable learning environment that allows students to feel at ease and encourages them to ask questions and participate in discussions. Overall, I am a skilled and effective tutor who is dedicated to helping students achieve their academic goals.

<Course Description>
This course is designed for beginners who are interested in learning programming with Python. It covers the basic concepts of programming such as data types, variables, control structures, functions, and file I/O. Participants will learn how to write Python programs, debug code, and design algorithms using Python. The course also introduces the basics of object-oriented programming and the Python libraries used for data manipulation and visualization.

<Prerequisites>
No prior programming experience is required. However, familiarity with basic computer concepts such as files, folders, and operating systems is recommended.

<Learning Objectives>
By the end of the course, participants will be able to:

* Understand the fundamentals of programming and how it applies to Python
* Write Python code for simple applications and automate repetitive tasks
* Use control structures such as loops and conditional statements
* Create functions to encapsulate code and enable code reuse
* Work with Python libraries such as NumPy, Pandas, and Matplotlib
* Use object-oriented programming principles to design more complex programs
* Debug code and use error-handling techniques

<Course Outline>
The course is divided into modules that build on each other to provide a comprehensive introduction to Python programming. Each module consists of lectures, demonstrations, hands-on exercises, and quizzes to reinforce learning. Here is an outline of the course:

Module 1: Introduction to Python
History and Overview of Python
Setting up Python environment
Writing and running basic Python programs
Variables, data types, and operators

Module 2: Control Structures
Conditional statements and Boolean logic
Loops and iteration
User input and output

Module 3: Functions
Writing and calling functions
Scope and namespaces
Return values and parameters
Lambda functions

Module 4: File Input and Output
Reading and writing files
File modes and buffering
Handling exceptions and errors

Module 5: Object-Oriented Programming
Classes and objects
Inheritance and polymorphism
Data encapsulation and abstraction
Special methods and decorators

Module 6: Python Libraries
Introduction to NumPy, Pandas, and Matplotlib
Data manipulation and analysis with Pandas
Data visualization with Matplotlib

Conclusion
This beginner's programming class in Python provides a solid foundation for anyone interested in learning programming and using Python for data analysis, automation, or software development. With hands-on exercises, interactive quizzes, and a comprehensive final project, participants will learn how to write Python code that is efficient, maintainable, and elegant.

I am a Cambridge graduate in CS, with over 10 medals and national distinctions for competitive programming.

For over 5 years, I have helped hundreds of students discover how easy and beautiful Computer Science is:

- Assisted students in improving from a C to an A* grade.
- Helped motivated students qualify for the National Informatics Olympiad.
- Guided many achieve their target grades in A-Levels, even attaining the perfect score.
- Prepared for IB/IA, A-Levels, GCSE, University Entry, or equivalent.
- Assisted with specific projects at a professional level, including interview preparation.

All my success in Computer Science is due to my teachers, who knew how to inspire my passion and turn any concept into an easy-to-understand story. That's why I decided to help others further to elucidate the secrets of Computer Science and to smile with relief in the exam hall when they notice that they know how to solve all the subjects perfectly.

It's amazing how quickly a student can progress when the material is explained to them in their understanding.

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 :).

Hi!

Welcome to my class on Python programming! As a PhD student in Geophysics my main tool is my computer. In order to do science one needs to know how to program. I use Python everyday in order to analyze data, run numerical models, plot results and much more. So, let's embark on the journey of learning Python and explore its diverse capabilities together!

For beginners:
I have designed it for absolute beginners to become at ease with the language within 5 sessions of 1h. Message me to know the 5 classes curriculum and I will be more than happy to share it with you!

For intermediate users:
If you already know the basics of Python but want to go more in-depth on certain packages this is the right place! Message me and we can discuss what your needs are! I am a professional user of Numpy, Pandas, Matplotlib, os, scipy and many more packages!

Are you not sure Python is the right language for you? Check the following out and let me know if you have any questions!

First of all, what is Python? According to its creator, Guido van Rossum, Python is a:

“high-level programming language, and its core design philosophy is all about code readability and a syntax which allows programmers to express concepts in a few lines of code.”

Learning Python is a rewarding experience for several reasons. Firstly, Python is inherently beautiful as a programming language, offering a natural and expressive way to translate your thoughts into code. Its readability and simplicity make coding an enjoyable and intuitive process.

The Python language finds applications across various domains, including data science, web development, machine learning and AI. For example, platforms like Quora, Pinterest, and Spotify leverage Python for their backend web development!

This versatility makes Python a powerful tool for those eager to delve into different aspects of programming. If this caught your curiosity message me and I'll make you a Python hero! Welcome to the community!

6 Python Programming Sessions of 1 hour each:

Session 1: Basics
Python Data Types and Variables:
Operators and Expressions.
Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else.

Session 2:
Using Loops:
The while, while-else.
For loop;
Jump statements: break, continue;
Nesting loops.

Session 3:
Working with variables and its scope;
Conversion and casting types in Python.

Session 4: Python Built-in functions
Maths Functions.
Random Functions.

Session 5: Strings Functions.

Computer Science is the future. As we are moving towards a digital age with a high speed. As a programmer you can be a part of that future and can develop many different novel things. This course is made specifically for any person of any age to get a crystal clear image of Computer Science.

You will learn basic concepts of Programming (using Python and C++) and of many other fields (such as, AI, database, networking and so so). After completing the course you will be able to create and implement many different novel idea digitally.

Ready to unlock the beauty of the Arabic language? Our online Arabic classes are designed for learners of all levels, from beginners to advanced speakers. With our flexible, self-paced format, you can learn Arabic anytime, anywhere, fitting your language studies into your lifestyle.

Led by expert instructors, our interactive lessons will help you build confidence in speaking, listening, reading, and writing Arabic. Whether you’re learning for travel, career, or cultural enrichment, our classes provide the tools you need to succeed.

Don’t wait to start your Arabic journey—sign up today and learn Arabic anytime, anywhere!

Mathematics is the best way to enhance your intellect but also work on your intuition and your ability to see patterns.

Good day, my name is Alex, I have been teaching math for over 10 years to hundreds of students. I will teach all grades from elementary school all the way to high school and IB/GCSE etc.

My philosophy revolves around these three values:
-Encouragement
-Inspiration
-Discipline

I specialize into teaching mathematics and programming, but in some occasions I teach physics too.
Feel free to contact me.

I offer engaging and comprehensive programming lessons in C++ and Python, designed to help you master essential concepts and advanced topics in computer science. From problem-solving techniques, object-oriented programming, and data structures to database management, operating systems, digital logic design, and algorithm analysis, my lessons cover it all. I also introduce exciting areas like parallel and distributed computing and the basics of artificial intelligence. Whether you're preparing for GCSEs, A-levels, or pursuing a BSc in Computer Science, my tailored approach ensures you build a strong foundation and advance to becoming an exceptional programmer. Let’s make programming both accessible and enjoyable as you unlock your full potential in this ever-evolving field!

Good-fit Instructor Guarantee

Contact Yaseen