Add to Wish List
from33.00EUR/ h
Master Microsoft Excel (Beginner - Intermediate - Advanced)
Translated by Google. Click to view original.
>>> 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
Translated by Google. Click to view original.
Preferably, the participant must have his own computer.Location
Online via webcam
At teacher's location: Pannenhuis, Métro Pannenhuis
At student's location: Around Brussels, Belgium
|
Use ⊞+wheel to zoom!
General info
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 |
About Me
Translated by Google. Click to view original.
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
Translated by Google. Click to view original.
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
Translated by Google. Click to view original.
IT Consultant / TrainerComputer trainer
Management control
Tax Consultant
Financial auditor
Reviews (12)
Very attentive, really tries to offer a technical solution adapted to our professional needs.
Translated by Google. Click to view original.
Anas is great teacher! He is really patient, helpful and supportive; and he explains everything in a clear way. I definitely recommend him! Thank you very much!
very friendly and good teacher
Anas is an excellent teacher and very patient!
thanks to him
Translated by Google. Click to view original.
I recommended for Excel courses. I learned a lot in just a few courses
Translated by Google. Click to view original.
...
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
_*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
Accounting on SAP:
- General accounting (G/L accounting)
- Supplier Accounting (Accounts Payable)
- Customer accounting (Accounts Receivable)
- Automatic Payment Program
- Bank accounting (Banking)
- Cost center accounting
Ask a question
Send a message explaining your needs and Anas will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"
Ex. "Hi, when are you available to meet for a lesson?"
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 33€At teacher's location
from 33€Online via webcam
from 42€At student's home
100% Satisfaction Guarantee
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since October 2019
- 1 repeat student
- Phone number verified
- Google connected
Availability of a typical week
(GMT -04:00) New York
Mon | Tue | Wed | Thu | Fri | Sat | Sun | |
---|---|---|---|---|---|---|---|
0 | |||||||
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | |||||||
9 | |||||||
10 | |||||||
11 | |||||||
12 | |||||||
13 | |||||||
14 | |||||||
15 | |||||||
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | |||||||
21 | |||||||
22 | |||||||
23 |
from 33€At teacher's location
from 33€Online via webcam
from 42€At student's home
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Share
You are here
Private lessons
in Brussels
Similar classes
Imane
Introductory programming course for children or beginners
Passionate about the world of programming, I offer courses suitable for beginners of all ages, including children. I am a computer engineer, also with experience in online tutoring with high school and university students, I guided them in understanding their homework and assimilating sometimes complex concepts. In addition, I had the privilege of introducing the basics of programming to young people through fun courses using Python and Scratch software. My goal is to make learning programming accessible, engaging and stimulating, thereby encouraging a lasting passion for this fascinating discipline.
Salah Eddine
Master Microsoft Excel, Word and PowerPoint from zero to expert!
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.
Kamal
Microsoft Excel: Operation, Formulas, Calculations, Macros...
The purpose of this session is to allow the learner to understand the usefulness of Excel, to understand its principle and how it can be used at the school and professional level. It is also about Excel formulas, application exercise.
contact me
Nassim
Microsoft Office (Word, Power-Point, Excel), preparation and learning
This course is designed to provide comprehensive instruction and practice in all aspects of Microsoft Office. Whether you are a beginner starting from scratch or an advanced learner looking to advance your Microsoft Office skills, this course provides a supportive and dynamic learning environment.
We will focus on the four core skills: Word, Power-Point and Excel. Through a variety of interactive activities, exercises and discussions, you will enjoy a comprehensive and engaging learning experience.
Contact me.
Manel
Learn computer skills / HTML from scratch /CSS/Javascript
“Welcome to the magical world of HTML! 🌟
We're going to show you how to create amazing web pages, just like the sites you love to visit! Imagine being able to create your own website where you can share your passions, your favorite games, or even stories you make up. Ready to become web wizards? Let's go!"**
Hamza
Maîtrisez Python avec un Expert en Programmation et Data Science
Découvrez la puissance de Python avec un formateur expérimenté en informatique !
Je suis Hamza, un développeur passionné et mentor chevronné avec une vaste expérience dans l'enseignement de la programmation. Mon approche pédagogique unique vous permettra d'acquérir rapidement des compétences solides en Python, tout en découvrant ses applications concrètes dans le monde professionnel.
Ce que vous apprendrez :
Fondamentaux de Python (variables, structures de contrôle, fonctions)
Programmation orientée objet avancée
Analyse et visualisation de données avec pandas et matplotlib
Développement d'interfaces graphiques avec PyQt
Projets pratiques inspirés de cas réels en entreprise
Pourquoi me choisir ?
Plus de 5 ans d'expérience en formation et mentorat
Méthode pédagogique adaptée à tous les niveaux
Approche hands-on basée sur des projets concrets
Passion contagieuse pour le code et l'innovation technologique
Que vous soyez débutant cherchant à vous lancer dans la programmation ou professionnel souhaitant monter en compétences, ce cours vous ouvrira de nouvelles perspectives passionnantes dans le monde du développement logiciel et de la data science.
Rejoignez-moi pour un voyage captivant au cœur du langage de programmation le plus polyvalent et demandé du marché !
Réservez maintenant et faites le premier pas vers la maîtrise de Python. Votre carrière en tant que développeur Python commence ici !
Robert
Excel lessons, at your place, at my place or remotely, at your best convenience!
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.
Bozhidar
Math/Computer Science Tutoring for high-school and BSc Computer Science students
Hey! Are you looking for a young, approachable yet meticulous tutor in Computer Science or Mathematics? Then I believe I might be the tutor for you! I offer lessons in the aforementioned subjects (English only) for high-school and bachelor students at the start of their studies.
A little bit about me:
My name is Bozhidar and I am a MSc Data Science student at ETH Zuerich. Last year, I completed my bachelor's in Computer Science at TU Delft (the #1 technical university in the Netherlands) with distinction. I was a teaching assistant for 10 courses during my stay at the university. Additionally, I have given private lessons to a few high school and bachelor's students, so I believe I have accumulated enough experience with guiding and tutoring students across different disciplines. I have found out that I enjoy teaching a lot, so that is why I am here - to help you and myself!
My expertise:
During my high school years, I won tens of awards and scholarships for achievements in Mathematics and Computer Science. I also won my high school's recognition award which is given to one student every year for distinctive results. I've helped high-school and university peers with exam preparation, taught whole courses privately, prepared sample exams, and reviewed and graded real ones. Regarding the university courses I have experience in, I have taught:
- Object-Oriented Programming
- Reasoning & Logic
- Computer Organisation
- Algorithms and Data Structures
- Web and Database Technologies
- Calculus
- Information & Data Management
- Automata, Computability and Complexity
- Concepts of Programming Languages
- Computational Intelligence
Here are some of the reviews I have received as a teaching assistant:
Overall: 4.97/5 (70 reviews)
5/5 - "Great job! Did far more than just explaining this example and went far deeper into the material, helping me to understand it."
5/5 - "Favourite TA. Always there for the difficult questions. Never leaves anything unanswered no matter how long it takes."
5/5 - "Delightful person with an insightful way of thought! Brilliant TA!"
5/5 - "Clear explanations and expert in the material"
So, what are you waiting for? Write me a message and let's get the knowledge train running.
Oussama
Python Programming for All Levels: From Fundamentals to Advanced Libraries and Frameworks
What You Will Learn:
Core Principles: Introduction to programming, algorithms, and data structures to build a strong foundation.
Advanced Libraries and Frameworks: NumPy, Pandas, and Django to create web applications and perform efficient data analysis.
Practical Projects: Real-world applications to strengthen your skills and build an impressive portfolio.
How You Will Benefit:
Students: Gain the necessary skills to excel in academic projects and lay the groundwork for your career.
Self-Taught Learners: Avoid common mistakes and fast-track your progress with clear, hands-on guidance.
Professionals: Enhance your skill set to meet industry demands and open up new career opportunities.
Why Choose My Courses?:
Personalized Approach: Each course is customized to your level and learning pace, ensuring tailored guidance and support.
Theory and Practice: You’ll combine theoretical concepts with hands-on exercises for a comprehensive and lasting understanding.
Solving Real-World Problems: Learn how to tackle the common challenges faced in programming, from debugging to performance optimization.
Professeur
- Cours d'Excel à distance Pour tous les niveaux : EN LIGNE-
- Cours d'Excel à distance Pour tous les niveaux : EN LIGNE-
Je donne des Cours d'Excel à distance pour tous les niveaux.
J'offre des séances en Excel à distance pour tous les niveaux.
J'assure un soutien approfondi et bien supporté par des outils d'apprentissage les plus efficaces.
Pour plus d'informations, contactez moi
Brahim
Introduction to NoSQL DataBase MongoDB by Pratique
Do not deal with the manual with terms of reference statements and basic documents that cannot be obtained in order to avoid the MongoDB problem. Please include the connection to one of the MongoDB données base, comment on simple CRUD operations and sujets clés que l'agrégation, l'indexation, la mode des données et les Transaction.
1- Install MongoDB
2- Implement MongoDB
3- Use of documents and collectibles
4 - Leadership Committee
5- Execute CRUD commands (create, read, update, delete) avec mongo shell
6- Type the register in a MongoDB database
7- Reset the base to remonter specific documents depuis mongo shell.
8- Lagrégation
9- Indexing
10- Amending institutions and transactions
Youness
Office Automation Training: Excel, Word, Remote Power Point / Online
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely.
- For more information, contact me.
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely.
- For more information, contact me.
- I teach in Excel, Word, Power point, Access, Outlook, internet, computer maintenance at home or remotely.
- For more information, contact me.
Azzedine
Développez votre expertise en Power BI et Business Intelligence : Créez des tableaux de bord percutants et des visualisations de données pro
Vous êtes impliqué dans les finances, la gestion, la planification, la gestion de projet, les ressources humaines, ou peut-être même un étudiant ambitieux désireux de perfectionner ses compétences en matière de tableau de bord professionnel. Si vous recherchez une solution qui va au-delà des limitations d'Excel et de PowerPoint, alors vous êtes au bon endroit : permettez moi de vous présenter Power BI.
Avec Power BI, je vous propose bien plus qu'un simple outil. C'est une passerelle vers des rapports interactifs, une gestion efficace des données et une analyse avancée. Voici ce que je peux vous offrir :
- Création et gestion experte de rapports interactifs.
- Transformation et nettoyage minutieux des données pour une précision maximale.
- Utilisation des puissantes formules DAX pour une analyse de données avancée.
- Création de visualisations personnalisées et de tableaux de bord percutants.
- Partage sécurisé et publication de vos rapports pour une collaboration sans heurts.
-Automatisation des tâches répétitives avec Power BI & Power Query.
Peu importe vos besoins spécifiques - qu'il s'agisse de projets professionnels, d'études ou d'aspirations personnelles - je suis là pour vous offrir une solution sur mesure. Ensemble, nous créerons un programme adapté à vos objectifs, vous guidant à chaque étape de votre parcours d'apprentissage.
Que vous soyez un novice cherchant à maîtriser les bases ou un expert désireux d'approfondir vos connaissances en analyse de données, je suis là pour vous fournir l'expertise et le soutien nécessaires pour réussir.
Ikram
Microsoft Office programmes (Word, Excel, and PowerPoint) / Online Private Classes
I would guide you step by step to get familiarised with the tools of Microsoft Office programmes (Word, Excel, and PowerPoint) that you believe you might need to meet your purposes. Your level of experience will determine where we start and how we proceed through the course.
Contact me
Hayat
Master the Essential Tools of Microsoft Office: Word, PowerPoint and Excel"
Do you want to master Microsoft Office tools?
This course offers you comprehensive training on the three most popular applications in the Microsoft Office suite: Word, PowerPoint and Excel.
Whether you are a beginner or already have some basics, this course is designed to adapt to your level. You will learn how to create documents, dynamic presentations and use spreadsheets for efficient management of your data.
Sessions can be customized to your needs, whether you prefer individual or group learning. With my support, you will quickly become comfortable with these essential tools.
If you have any questions or would like to know more, please do not hesitate to contact me!