facebook
Anas
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd 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 / Trainer
Computer 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?"

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3            Saturday at 3:00  Sunday at 3:00
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00      Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00      Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8            Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12            Saturday at 12:00  Sunday at 12:00
13            Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00    Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00    Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00    Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00    Saturday at 17:00  Sunday at 17:00
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.

Online reputation

  • Instructor since October 2019
  • 1 repeat student
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3            Saturday at 3:00  Sunday at 3:00
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6  Monday at 6:00      Thursday at 6:00  Friday at 6:00  Saturday at 6:00  Sunday at 6:00
7  Monday at 7:00      Thursday at 7:00  Friday at 7:00  Saturday at 7:00  Sunday at 7:00
8            Saturday at 8:00  Sunday at 8:00
9            Saturday at 9:00  Sunday at 9:00
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12            Saturday at 12:00  Sunday at 12:00
13            Saturday at 13:00  Sunday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00    Saturday at 14:00  Sunday at 14:00
15  Monday at 15:00  Tuesday at 15:00  Wednesday at 15:00  Thursday at 15:00    Saturday at 15:00  Sunday at 15:00
16  Monday at 16:00  Tuesday at 16:00  Wednesday at 16:00  Thursday at 16:00    Saturday at 16:00  Sunday at 16:00
17  Monday at 17:00  Tuesday at 17:00  Wednesday at 17:00  Thursday at 17:00    Saturday at 17:00  Sunday at 17:00
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


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.

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations. Why choose Microsoft Office? Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation. Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily. Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters. Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management. Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master. Available Everywhere: 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 everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Amin
Microsoft Office tools for beginners, intermediates and advanced
Looking to master Microsoft Office tools? This course covers the three most popular Microsoft Office products: Word, PowerPoint, and Excel. Designed primarily for beginners, the course also offers support for those already familiar with the basics, helping you achieve proficiency with these tools. The course can be tailored for individual or group learning. With our assistance, you'll be mastering Microsoft Office in no time. If you have any questions, please do not hesitate to contact us.

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.

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.

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

Riadh
Introductory Course in Computer Science, Computer Networks and Telecommunications.
The course will cover the following points: - Office automation (Word, Excel) - Network administration - CCNA Training (This program provides the foundation for IT professionals who are familiar with the Cisco networks and operating systems) - Teaching network courses (LAN, MAN, WAN, TCP/IP protocols) - Practical work (Packet tracer) - Some notions on computer security

Lahcen
Excel: Mastering the Basics and Advanced Tools for Professionals
Learn Excel remotely with my training accessible to all levels. With a practical and interactive method, develop the skills needed to shine. Register today and start your journey to success!

Sherry
O Level Chemistry for IGCSE (Cambridge and Edexcel) plus the American Diploma Chemistry ( Grade 10-12)
For completing the course of Chemistry, we will need to meet about 50 times, each time is about 90 min. In the first session, I will give you a brief description of the topics we will cover and the difficulty of each. During our meeting, I will explain from my notes which will be available for free on Google Drive for you after the session. After each class, I answer sample questions on each topic and give you a homework to be discussed at the next class. Please, be notified that I need a review of my explanation in turn. This review is helping me to develop. Thanks in advance.

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.

Antonin
Experienced teacher in private lessons gives private lessons in the Geneva region
Need a catch-up, tutoring, private lessons or help with homework in mathematics? In computer science ? In logic? I'm here for you! I offer you a personalized approach; because there is no one method that works for everyone, I adapt to the needs and requests of each student (and their parents). The first hour of class will be used to define the student's needs, deadlines and strengths. My courses are aimed at secondary school students of all levels, higher education students and anyone wishing to refresh or strengthen their knowledge of mathematics and computer science. I have been helping friends and acquaintances on a voluntary basis for a long time in the success of their studies and I hope to be able to put this experience to the benefit of your success :)

Jean Marc
Excel course Word ACCESS PowerPoint general IT
EXCEL POWER POINT WORD and ACCESS are inevitable software when working with a computer. I will introduce you to this software with exercises to do by yourself, exercises accompanied by courses appropriate to your requests.

Younes
Scratch, Roblox: Code for Fun - A Fun Adventure for Kids and Beginners!
With Scratch and Roblox, programming becomes child's play! Learn how to create animations, games, and interactive stories using colorful, easy-to-manipulate blocks of code. No complex language here, just a visual and intuitive approach to make learning as fun as possible. Whether you are a parent wanting to introduce your children to the language of programming or a beginner curious to discover the world of coding, this training is suitable for all ages. No prerequisites necessary, just a dose of curiosity and a desire to have fun while learning. As a trainer, I am committed to creating a caring and creative learning environment. I will use teaching methods adapted to each child, promoting positive interaction and encouraging the free expression of creativity. The goal is to make each lesson an engaging and enriching experience.

Paul
I am a teacher of mathematics and I give extra hours for private lessons in science subjects
As a math teacher, I offer private lessons in science subjects. My classes are mainly aimed at cycle and college students in Geneva, as well as students from private schools. I can also help people who have already finished their schooling but who need to upgrade their knowledge for professional needs. I am generally available within 3 days of your request and I move around the canton of Geneva using public transport (TPG). Travel costs are included in my rates. For a long-term follow-up, I can give you exercises to do between sessions and correct them at home. I speak and understand English, but my lessons will be mainly in French. I am ready to adapt my teaching according to your specific needs and to provide personalized support to help you progress in scientific subjects. Do not hesitate to contact me if you have additional questions or if you wish to schedule a lesson session. I will be happy to help you in your math learning.

Mouad
Support course in Python (For all levels, CPGE)
Passionate about programming, we offer Python support courses adapted to all levels, from beginner to advanced. These courses are aimed at students in preparatory classes for grandes écoles (CPGE) as well as anyone wishing to acquire solid programming skills. The lessons cover the essential foundations of Python with a clear and accessible teaching approach. Whether you are new to programming or want to deepen your knowledge, you will benefit from structured and progressive teaching. With a focus on concrete concepts and practical examples, these courses aim to strengthen your skills in a tangible way. You will be guided through the nuances of Python, gaining a deep understanding that will benefit you both in your studies and in your future career. Join us to explore the fundamentals of Python programming and progress to more advanced levels. Together, we will build a solid foundation and develop the skills needed to succeed in the dynamic world of computer programming.