Translated by GoogleSee original

Master Microsoft Excel (Beginner - Intermediate - Advanced)

From 29.47 £ /h

>>> What is Excel?
Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs.

>>> What about pedagogy?
I favor the learning by doing method

>>> Who am I?
For information, I am consultant / trainer and certified Microsoft Excel Expert.
I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private.

>>> Location of the training?
The place is to be agreed with the apprentice.
Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...)

>>> Content of the training
I can adapt to your level and your needs in terms of content.
Here is a non-exhaustive example of the subjects taught.

**** Excel Training (Beginner and Intermediate) ****

Part I: Basic Concepts
What is Excel?
Discover the Excel window.
Workbooks, spreadsheets, cells.
Use the toolbars, the menu, the help.

Part II: Working in a spreadsheet
Identify basic concepts
Manage cells: capture and copy
Set up formulas.
Master the modes of referencing cells: absolute, relative.
Insert, delete rows or columns, move fields.

Part III: Formatting a spreadsheet
Format cells: present numbers, text, titles.
Define conditional formatting.
Print the entire sheet or part.
Build the layout: titles, pagination

Part IV: Workbook Management
Save, edit a workbook.
Divide your data over several sheets.
Insert, delete, move, copy a sheet.
Edit multiple sheets simultaneously

Part V: Data Analysis Using Functions
Calculate percentages, establish ratios.
Perform statistics: AVERAGE, MAX, MIN
Apply conditions: SI.
Use functions: NOW, TODAY.
Consolidate multiple sheets of a workbook with the SUM function.

Part VI: Linking spreadsheets
Transfer data from one table to another
Copy / paste with link.
Create summary tables.

Part VII: Illustrate with graphics
Create a chart from a table
Change the type: histogram, curve, sector.
Add or delete a series.

**** Excel Training (Advanced) ****

Part I: Configure Excel Options
Set up Excel options.
Customize the interface.

Part II: Gaining time to present his paintings
Define styles, use themes.
Define conditional formats.
Insert Sparklines charts.

Part III: Creating simple and complex calculation formulas
Master the various modes of referencing: relative, absolute, mixed.
Name cells.
Set up simple and complex conditions: IF, OR, AND.
Calculate statistics: NBVAL, NB, NB.SI.
Use mathematical functions: Sum and SUM.
Retrieve data with search functions: VLOOKUP
Calculate dates, times: DATE(), DAY() and MONTH() ...
Manipulate text: CAPITAL, MINISCULE and CONCATENATE.
Protect formulas, sheets or binders.

Part IV: Consolidation of data
Link multiple cells in a workbook.
Manage connections between workbooks.
Consolidate tables in a workbook.
Consolidate data from multiple workbooks.

Part V: Exploiting Data Lists
Tris multicriteria.
Custom sorting: Numeric, Textual and Chronological.
Extract data: advanced filters.
Delete duplicates.

Part VI: Implementing Pivot Tables / Charts
Create charts / pivot tables
Group the information by period and by slice.
Filter and sort
Segment filters
Show / hide data.
Add ratios and percentages.

Extra information

Preferably, the participant must have his own computer.

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Brussels, Belgium

At teacher's location :

Pannenhuis, Métro Pannenhuis

Online from Belgium

About Me

I am Anas, computer trainer / consultant.

Having graduated in Audit Management Management Audit, I first worked in the field of finance before switching to the field of IT management.

I have a lot of affinities with technology and I like to transmit my know-how.
My strong point is to have the ability to transmit knowledge using practical and concrete examples, far from theoretical and abstract concepts. I prefer the learning method "Learning by doing".

I have already trained hundreds of people in:
* Office (Excel, Access, Word, PPT)
* Digital Marketing: Facebook, Linkedin, Search Engine Optimization, Google Adwords, Google Adsense
* Wordpress
* SAP (Introduction, Finance, Sales & Distribution, Material Management)

Education

Master in Management Sciences (Financial Audit Specialty) (UMONS)
Special Master in Tax Management (Solvay - ULB)
Cetificat in Digital Marketing (ICHEC)
Microsoft Office Specialist Excel Certification - Expert
SAP Finance certification

Experience / Qualifications

IT Consultant / Trainer
Computer trainer
Management control
Tax Consultant
Financial auditor

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

60 minutes

The class is taught in

French

English

Arabic

Skills

Computer science

Microsoft excel

Reviews

Availability of a typical week

(GMT -05: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

Master Microsoft Access software (Beginner / Advanced)

29.47 £ /h

I will help you master all the features of Microsoft Access software.

objectives:
---------------
Acquire the essential bases of Microsoft Access software.
Structure a relational database.
Define queries.
Build forms and reports.
Create simple macros.
Acquire a methodology to design and manage a database.

Whatever your basic level, I will adapt to it in order to help you progress.

Program
-------------------
Module 1: Presentation of Access software

Familiarize yourself with Access
Find your way around the screen: toolbar, status bar, menus, ruler
Methodology for building a database
Creation of a database and DBMS
Importing data from Excel into Access

***

Module 2: Design and organize your database

Organize and distribute your data between different tables
Create tables, define fields
Identify the index primary key
Define relationships, ensure referential integrity
Import, export and link data.

***

Module 3: Relationships

Link tables
The different types of relationships (one to one, one to many)
Referential integrity
Join types
Create a drop-down list
Complex relational schemas: relay tables, star schemas, etc.

***

Module 4: Query your database with queries

Selection queries: choice of fields, sort order, definition of selection criteria
Extract data by setting criteria
Grouping on a field, on an expression
Multitable and cross-analysis queries
Action requests: update, add, delete, create a table.

***

Module 5: Calculated queries

Column calculations
Online calculations: formula syntax, use the expression generator
Some calculation functions: (True false, Extraction of strings, Upper case, Lower case)

***

Module 6: Creating Forms and Entering Data

Create an instant form
Create an instant table form
Manage data: add, delete, modify, search, filter records
Modify the form
Subforms: creation, integration into a form
Editable drop-down lists.

***

Module 7: Creating Reports

Create a label report
Create a report using the wizard
Change state
Creation of column or tabular reports
Sorting and grouping
Direct mail report. Printing a report.

***

Module 8: Creating Complex Forms

Hierarchical organization of forms
Create a form and a subform
Insert action buttons: search list, command buttons
Insert calculations

SAP Introduction Training (hands-on training) / Remote training

47.34 £ /h

_*IMPORTANT*_
It will depend on how fast you learn, but you should allow at least 3 hours for a quick start.

Here is the proposed program:

I) What is SAP?
* Introduction to SAP (ECC)
* The main functions of SAP
* SAP architecture
* Structure and organizational data
* Overview of SAP functional modules (FI, SD, MM, PP etc.)

II) SAP : Getting Started
* Navigating the SAP system
* Logging in and out
* Presentation of the home screen
* Organization of SAP screen (fields, tabs, tables...)
* Use of the data search functions
* How to navigate in SAP
* Transaction system
* Examples of flows

Renaud

5.0

(23)

Trainer for 10 years, I offer to support you in your learning of InDesign software by working on concrete examples.

My experience as a trainer allowed me to sharpen my teaching techniques. I adapt to the level of the student to help him master the tools offered by this software.

Maria

5.0

(23)

Hello everyone !

Use 2 fingers to type a document or something else? this keystroke will consume you a lot of time!
The typing course that I propose will allow you to acquire a certain speed of typing without looking at the keyboard, because your fingers will recognize, by default, their places on the keyboard.
Do not waste time, learn to type quickly for your use!

Pavan

5.0

(23)

VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results.

Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc...

Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.

Himank

5.0

(23)

Currently, I am working at MaaS department in Denso Corporation, Shinagawa, Tokyo.
I have done my masters from the Indian Institute of Technology Hyderabad India recently.
I can teach you Mathematics and science in a simpler way as I have lived with those things for 10 years.

I can teach you coding, Science and Math if you wish to learn new things contact me.

This class is for those who really want to use to learn computer languages like C, C++ in a more innovative manner.

I little bit know Nihon-Go as well.

Robert

5.0

(23)

As a Franco-Belgian management teacher, I give Excel lessons with passion!
Whether remotely or face-to-face, I offer many examples and exercises to accompany you.
I travel without problem throughout the region of Brussels and its surroundings, for lessons of at least 2 hours. For France, courses are only given remotely.

Here are some key words that will be covered in my classes:
Scenario analysis, Year, Rounding, Today, Bdnb, Bdnbval, Bdsum, Search, Column, Copy/paste in values, Copy/paste with transposition, Consolidation, Date, Datedif, Determat, Dollar, Right, Righterg, Equiv, Esterror, Estna, Frequency, Filter (simple and advanced), Format of cells, Left, Large.Value, Printing of documents, Index, Indirect, Inversemat, Day, Weekday, Line, Matrix, Max, Maxa, Max.Si, Min , Mina, Mina.If, Formatting of cells and ranges, Month, Average, Average.If, Nb, Nb.If, Nbval, Naming of cells and ranges, No, Small.value, Product, Productmat, Protection of cells, Lookup (Lookup), Lookupv (VLookup), Lookuph (HLookup), If (If), If.Not.Disp, If.Conditions, Iferror, Sum, Sumproduct, Sum.If, Sum.If.Set, Substitute , Pivot tables, Sorting, Cell locking

Do not hesitate to contact me to organize your lessons according to your needs and availability. Together, we will develop your Excel skills in an efficient and personalized way.

Valnor

5.0

(23)

💻 Learn IT easily with tailor-made support! 🚀
Do you want to improve your computer skills or discover the basics to better navigate the digital world? I offer courses adapted to all levels, whether you are a beginner or looking to improve.
🌟 Why choose me?
• Adapted teaching: I explain concepts in a simple and clear manner, even for novices.
• Personalized courses: Each session is designed according to your needs and objectives.
• Hands-on learning: Immediately apply what you learn.
📘 Areas covered:
• Introduction to computers (using the computer, browsing the internet, security).
• Office software (Word, Excel, PowerPoint).
• Introduction to programming (Python, HTML/CSS).
• Basics of data management and analysis with tools like Power BI.
🕒 Flexible hours: Classes available on weekdays or weekends, depending on your schedule.
📍 Modalities: In person or online, according to your preferences.
👉 Contact me now to start your adventure in the digital world!

Salah

5.0

(23)

Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level!

If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office.

Why Choose Microsoft Office?

Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations.

Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features.

Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want.

Join the Microsoft Office Revolution!

Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential.

Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Salomé

5.0

(23)

A 34-year-old university graduate, business engineer, with 12 years of professional experience, offers her teaching services.

Lessons (1 hour online only) - 1.5 or 2 hours depending on the subject/level/location
Educational and organized teacher with excellent revision and organizational techniques
Microsoft Office - Excel/Word/PowerPoint - email - typing - ...

Educational and patient with a good methodology adapted to each student

97% success rate with regular monitoring

Feel free to contact me for more information!
See you soon

Morad

5.0

(23)

You want to boost your Excel skills and unlock the full power of spreadsheets? Our online Excel classes are designed for everyone, from beginners to advanced users. Learn how to organize data, create powerful formulas, generate charts, and streamline your workflow with ease.

Led by expert instructors, our interactive lessons offer hands-on practice, covering everything from basic functions to advanced Excel techniques. Whether you're looking to improve your job performance, manage data more efficiently, or learn new skills, our flexible online classes allow you to learn at your own pace, from anywhere.

Take control of your data—sign up for our online Excel classes today and become an Excel pro!

Ajay

5.0

(23)

I can teach mathematics (from primary to bachelor level), computer science, coding, and high school level physics.
Available to teach online/offline.
I make sure to adapt to the needs of the students, preparing specific exercises according to their knowledge and interest levels while not compromising on the learning aspects. I can also be flexible with the availability and timings so as to suit the needs of all concerned.
Born and raised in India; fluent in English and Hindi, currently learning French. I have been living in Brussels for more than a year now. I have Bachelor of Technology in Computer Science and a Master of Science (Mathematics) from India. Currently pursuing Master in Mathematics from KU Leuven (2nd year).
My dream is to become a high school teacher and I see tutoring as a big and important step in that direction.

Mohamed

5.0

(23)

Whether you are a beginner writing your first lines of code or an advanced learner tackling complex concepts, I tailor lessons to suit your needs. Together, we will focus on practical skills, problem-solving, and real-world projects to make programming intuitive and rewarding. Let’s work together to turn your goals into achievements!

Said

5.0

(23)

Are you preparing for your Digital and Computer Science (NSI) exams and want to maximize your chances of success? "NSI Booster: Intensive Preparation to Shine in Your Exams!" is the course you need to revise effectively, fill in your gaps, and excel on the big day! This comprehensive and intensive program is specially designed for students in Première and Terminale to master all the key concepts of the NSI program and pass with flying colors.

Why choose this NSI preparation course?
Optimize revision time: Focus on the essential concepts to save time and revise efficiently.
Deep understanding of concepts: Don't just memorize, really understand the basics of computing to succeed in the most complex exercises.
Intensive practice: Practice with corrected exercises, exam questions and past papers to be fully prepared.
Exam Methodology: Learn how to manage your time, structure your answers, and avoid common NSI question pitfalls.
Confidence and serenity: Work in a progressive and structured manner to arrive calm on the day of the exam.
What you will learn:
This course covers the entire NSI program for Première and Terminale, focusing on the concepts most often covered in exams:

1. Algorithms and Programming:
Advanced algorithms: Algorithmic complexity, recursion, sorting and searching (quick sort, dichotomous sort).
Programming in Python:
Advanced syntax: list comprehension, lambda, decorators.
Data structures: lists, tuples, dictionaries, sets.
Functions and modularity: Decomposition of the problem, reuse of code.
File Management: Reading and writing files to process real data.
Object-oriented programming: Classes, objects, inheritance, polymorphism in Python.
Practical projects: Development of complete programs to apply the concepts covered.
2. Data Structures and Algorithms:
Lists, Stacks, Queues, and Trees: Implementation, Manipulation, and Use in Problem Solving.
Graphs: Representation (adjacency matrix, neighbor list), breadth-first (BFS) and depth-first (DFS) traversal.
Sorting and searching algorithms: Merge sort, quick sort, binary search.
Algorithmic complexity: Big-O notation, analysis of algorithm performance.
3. Databases and SQL:
Data modeling: Relational model, database design with the Entity-Relationship model.
SQL:
Select, insert, update and delete queries.
Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN).
Aggregate functions and subqueries.
Optimizing queries for better performance.
Practical projects: Creation and management of databases for concrete applications.
4. Computer and Network Architecture:
Hardware architecture: Processor, memory (RAM, cache), input/output devices.
Computer operation: Instruction cycle, execution of programs in memory.
Computer networks:
OSI model and TCP/IP.
IP addressing, routing, protocols (HTTP, FTP, SMTP).
Network security: firewall, encryption, VPN.
5. Web and Front-End Development:
HTML/CSS: Structure and formatting of web pages.
JavaScript: Dynamics of web pages, manipulation of the DOM, events.
Practical projects: Creation of interactive websites to apply the skills acquired.
Methodology and educational approach:
Targeted and structured revisions: Each module is designed to cover the key concepts of the NSI program while adapting to your level and your needs.
Practical exercises and exam questions: Practice with targeted exercises and past exam questions to familiarize yourself with the exam format.
Detailed correction and personalized feedback: Each exercise is corrected in detail with a thorough explanation of the solutions.
Exam methodology: Advice on how to read and understand the statements, structure your answers and manage your time on the day of the test.
Interactive Online Classes: Classes are conducted online with the use of audio and screen sharing, ensuring seamless communication and interactive learning.
For who ?
This course is aimed at:

NSI students in their first and final year of high school who want to pass their exams with intensive and targeted preparation.
Computer science students wanting to strengthen their foundations in programming and algorithms.
Self-taught people passionate about programming and computer science looking to deepen their knowledge.
Parents who wish to support their children in their academic success in computer science.
Why choose this course?
An experienced teacher: The course is led by a computer engineer with a perfect command of the NSI program, with a clear and motivating teaching approach.
An intensive and comprehensive program: Each concept is covered in depth, with varied exercises to practice all types of questions.
Personalized support: The content and pace of the course are adapted to your level and your objectives.
Flexibility and accessibility: Learn from home at your own pace, with additional resources to deepen your knowledge.
How does it work?
Initial assessment: A personalized assessment to identify your objectives and your starting level.
Interactive online courses: Learn from home with live explanations, demonstrations and practical exercises.
Intensive training: Series of exercises and past papers to prepare you for written and practical tests.
Personalized monitoring: Receive regular feedback on your progress and advice to continuously improve.
Register now !
Don't leave anything to chance when it comes to your NSI exams. Join "NSI Booster" for intensive and targeted preparation, and give yourself every chance of excelling in your exams!

Gwendoline

5.0

(23)

I teach interactive courses on Excel, Word, and PowerPoint for all levels, whether for high school, college, or the workplace. I also offer introductions to information and office automation.

My approach is practice-based: I guide students step by step, using concrete examples and exercises tailored to their needs. I also teach methods to help them become more organized, more efficient, and more independent in using these tools. Each session is personalized to target the skills they need to develop, while building a climate of trust and motivation.

I always suggest discussing and defining the learner's needs before starting classes so that you can effectively prepare the course materials and support. It is crucial for me to respond correctly to the student's request.

I am a mathematician by training, with over 10 years of experience in private tutoring and assisted coaching. I currently work as a biostatistician and also provide training in this field. I am very patient and passionate about what I teach. I adapt to each student or learner to provide personalized support and I share my methods and tips for progressing quickly and effectively.

I invite you to contact me to best determine the support you need!

Hanae

5.0

(23)

Hello! My name is Hanae, and I offer personalized lessons in English, Mathematics, and Computer Science for students of all levels — from primary school to university.

With over 10 years of professional experience in the tech and business world, I combine structured methods with a friendly and supportive teaching style to help students gain confidence and achieve their goals.

👩‍💻 In Computer Science, I teach programming basics (C language), digital logic, and software tools such as Power BI, Excel, and SQL.

Whether you want to improve your grades, prepare for exams, or strengthen your practical skills, my lessons are designed to make learning clear, engaging, and motivating.

Lessons can be given online or in person, and I always adapt the pace and content to the student’s needs.

Frédéric

5.0

(23)

Microsoft Office is now a virtually indispensable software suite for almost everyone, whether during our school years, through PowerPoint presentations, document creation with MS Word, calculations and graph creation in MS Excel, or during our professional lives. In the latter case, we need to get even more out of it in a minimum amount of time.

Some may have noticed that it's possible to automate a series of actions by recording "macros" to save time. But have you ever considered that behind these macros lies computer code generated for you in "Visual Basic for Applications" (VBA)? Understanding this type of code and how it manipulates the "object model" associated with the application being used (for example, the worksheets, rows and columns, cells, and the values they contain, in the case of Microsoft Excel) allows you to go further in terms of automation and flexibility.

The course is adaptable to the student and their level. Depending on demand and the number of sessions, it can cover the fundamentals of programming (variables, types, declarations, manipulations, local and global variables, etc.), illustrated using VBA, as well as best programming practices (error handling, using comments, standardizing variable names, code modularity), culminating in the creation of a project enabling interoperability between different Microsoft Office tools (for example, associating notes taken with OneNote with dates in a perpetual calendar created in Excel). It may even cover concepts such as object-oriented programming (polymorphism, encapsulation) and the differences between compiled and interpreted languages.

The sky's the limit :))