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.
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.
Ahmed
The field of computer science in general, whether theoretical, lectures or practical, as I am a doctor in the university, Department of Computer Science
All lectures or practical computer sciences in general, whether the university course or less, as I received an excellent grade in college and was appointed as a teaching assistant there, and now I am a doctor and I have a talent for conveying and simplifying information. I find myself able to convey information and explain it in a truly professional manner, in addition to my excellent practical experience.
Myat Hein
Maths and Further Pure Maths for Secondary Students
This class is designed to help students tackle key GCSE and secondary-level Maths concepts with confidence. From algebra to trigonometry, I'll guide you through each topic with clear explanations and problem-solving techniques. Whether you're preparing for exams or just looking to improve your Maths skills, this course is tailored to your individual needs.
Having transformed my own understanding of Maths from a beginner to achieving top grades, I know how to break down complex topics and make them easier to understand. You can trust me to help you succeed!
Aymen
Programming: Introduction to Python (Beginner level)
In this class, you’ll embark on an exciting journey into the world of programming with Python. You’ll start by writing your very first Python program, gaining hands-on experience from the get-go. As you progress, you’ll delve into the core fundamentals of Python, including variables, data types, control structures, functions, and modules.
Adam
Learn algorithms and computer programming easily, at home and at your own pace.
As an experienced computer trainer, I offer personalized courses in the field of computer science in general, as well as in algorithms and programming. My goal is to help students progress without overburdening them. After each lesson, homework will be assigned and progress reports will be provided periodically.
This course is intended for beginners as well as intermediate level students. The objective is to learn how to program functions and to develop professional thinking in this area.
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.
Aniket
AI Web Apps and Tools Mastery Classes | Practical Learning by Building Apps using AI (Langchain, OpenAI, HuggingFace, etc)
Hello,
I'm doing a PhD in AI and ML using Python and am an Oracle-certified trainer with 350+ reviews and ratings [with proof attached], I will be able to teach you Python better than any of my competition.
Why choose me?
1. 300 + reviews and ratings
2. Certified tutor
3. More than 5 years of teaching experience
4. Worked as a Software engineer in companies like Virtusa Corp and DIGIDEZ DIGITAL SYSTEMS
5. Hold B.tech and M.tech in Computer Science
Featured Review :
Been trying to learn Java on my own for about 1 year and I couldn't get a grasp on it. Aniket make learning Java a fun experience and challenges you to think for yourself to reinforce the concepts you've learned. I am truly excited for our meetings and he makes time go by so fast that I'm upset when they end. Great teacher and he is genuinely passionate about your success. If I could give him more stars I would!!!
Thanks
Aniket
Yasmine
I have a Master 2 in Audit and management control, I offer Excel courses
Excel lessons based on exercises.
Learn to use formulas, pivots, useful shortcuts.
Demonstration and practice via exercises.
The lessons depend on the level of the student and depending on their needs, this can be adapted gradually.
I have a Master 2 in Audit and Management Control and 10 years of experience in finance with multinationals (in different countries).
As well as experiences in coaching and mentoring in international competitions for students.
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.
Jameel
Introduction to Artificial Intelligence (AI) Basics to Advance
Artificial Intelligence (AI) is transforming industries and reshaping how we interact with technology. This course is designed for individuals interested in understanding the fundamentals of AI, its applications, and its impact on society. Whether you're a complete beginner or have some prior knowledge, this course will provide you with a solid foundation in AI concepts and techniques.
In this course, you will learn about:
Understanding AI Fundamentals:
Explore the core principles of artificial intelligence, including machine learning, deep learning, and natural language processing.
AI Applications:
Discover how AI is being used across various sectors such as healthcare, finance, automotive, and entertainment.
Data and Algorithms:
Gain insights into the importance of data in AI and learn about the algorithms that power machine learning models.
Ethics in AI:
Discuss the ethical implications of AI technologies and their societal impact, including bias, privacy concerns, and job displacement.
Hands-On Projects:
Engage in practical exercises that will allow you to apply your knowledge by working on real-world AI projects.
Amine
Computer course for all levels , EXCEL, WORD, POWER-POINT, Coaching in Computer Science, Office Automation
I offer courses in computer science for different languages and frameworks also intended for students in classes preparatory and license in computer science. Tailor-made training adapted to the profile of each student whatever his difficulties, with a pleasure of teaching; academic orientation sessions, and then the addition of other subjects that I master is surely possible.
Amine
Microsoft Excel (Formules et création des tableaux et calculs)
Une formation selon votre besoin et le niveau sur les fonctionnalités et formules Excel.
Je divise la session sur 2 phases:
Phase 1: Formules Avancées (formules de calculs, formules de logiques, formules mathématiques etc)
Phase 2 : Cas pratique et création des tableaux
Vous serez capable de manipuler les formules avancées
Vous serez capable de les pratiquer dans la création de vos tableaux.
Martial
Graduate teacher gives courses in Physics & Chemistry, Mathematics, many years of experience.
I am a dynamic and demanding teacher who gives private lessons in Physics-Chemistry as well as Mathematics.
I graduated from teaching seven years ago, after a masters in physical sciences with honors, and I teach in college and high school since.
I have also been preparing students for the Baccalaureate Science for many years, all of whom have been awarded very good honors.
I also prepare my students for different exams (Matu, Bac, preparation for EPFL, etc...)
I make sure to rework the basics so that the student can progress quickly. It is important to me that my students acquire a solid foundation of knowledge.
I also give effective work methods that will allow him to progress much more quickly and so he can regain self-confidence.
I can go to the student's home or also take the course via Skype.