Anas
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from35.64USD/ 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.
Excel versions 2010 - 2013 -2016.

>>> 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.
...
_*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
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

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 -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6            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  Monday at 8:00      Thursday at 8:00  Friday at 8:00  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            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  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00    Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from $35.64At teacher's location
from $35.64Online via webcam
from $45.67At 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
  • 3 repeat students
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -04:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4            Saturday at 4:00  Sunday at 4:00
5            Saturday at 5:00  Sunday at 5:00
6            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  Monday at 8:00      Thursday at 8:00  Friday at 8:00  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            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  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00    Saturday at 18:00  Sunday at 18:00
19              
20              
21              
22              
23              
from $35.64At teacher's location
from $35.64Online via webcam
from $45.67At 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.

Salah Eddine
Excel with Microsoft Office: Unlock Your Potential in the Gulf Region
Do you aspire to maximum efficiency, limitless creativity and unparalleled productivity in the Gulf region? Let us guide you to excellence with Microsoft Office. Why Choose Microsoft Office? Harness Your Creativity: With Word, Excel, PowerPoint and more, you'll have powerful tools to bring your projects to life, whether creating corporate documents, developing cutting-edge financial tables or delivering presentations breathtaking. Save Time with Automation: Excel simplifies complex tasks with its smart formulas, pivot tables and many other innovative features. Accessible Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is available on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Do not accept compromises in your daily professional life. Invest in the power of Microsoft Office and unlock your full potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office. Register now to master Microsoft Excel, Microsoft Word and Microsoft PowerPoint at all levels and drive your business to excellence in the Gulf region.

Oussama
Mastering Web Development: From Fundamentals to Advanced Techniques
Hello everyone ! I'm oussama, a web developer and certified Python instructor with 1 year experience as a fullstack developer. I am passionate about programming and love teaching students of all skill levels how to create professional websites. I've helped many students develop their programming skills, from beginners to advanced levels, and I'd love to help even more people achieve their web development goals. With a solid background in programming and development, I am able to provide my students with theoretical and practical training in algorithms and data structures, as well as in website development languages such as HTML, CSS, JavaScript , React JS, Bootstrap and others. My classes are designed to meet the individual needs of each student and are suitable for different learning styles. Whether you are just starting out or looking to improve your developing skills, my classes can help you achieve your career goals. Do not hesitate to contact me for more information on my web development courses. I look forward to helping you become a competent web developer and succeed in this exciting field!

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.

Salomé
University graduate gives computer/excel/word/typing lessons
A 32-year-old university graduate, management engineer, with 8 years of professional experience offers her teaching services. Course of (1H) - 1H30 or 2H depending on the subject/level/location Educational and organized teacher with good revision and organization techniques Microsoft Office - excel/word/powerpoint - mail - typing - ... Pedagogue and patient 97% success rate with regular monitoring I come to your home and also teach online Group lessons also possible, with reduced rates from 3! Feel free to contact me for more information ! See you soon

Ymama
Electronics & Arduino basics using TinkerCAD for kids and teenagers
Using STEAM principles to teach kids and teenagers the most important subjects and skills these days, they will learn how to connect and program Arduino circuits using virtual labs, estially we are going to use TinkerCAD, it's preferred that the student has simple knowledge or idea about the programming principle in general but not necessarily.

Azzedine
Become an expert in Microsoft Excel, Word and PowerPoint, even from scratch!
Boost your productivity and unleash your creativity with Microsoft Office: unleash your potential with every step! If you're looking for a solution to improve your efficiency, stimulate your creativity, and increase your productivity in everyday life, look no further than Microsoft Office. Why choose Microsoft Office? Test your creativity: With Word, Excel, PowerPoint, and other applications, you can unpack powerful tools to create your ideas, which are to create professional documents, create spreadsheets from executives, or give impressionistic presentations. Save time with automation: Excel simplifies complex touches with smart formulas, dynamic cross-tapes, and other smart functions. Accessible: Whether you use, commute, or want to use the office, Microsoft Office is accessible across all your devices, allowing you to work when you need to. Enjoy the Microsoft Office revolution! Don't let everyday obstacles stop you from progressing. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, start working easily, and do new things with Microsoft Office. Continuously progress to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at all levels, whether beginner, intermediate, or advanced.

Ousmane
Computer science, office automation, algorithms and programming
Computer and office courses are learning programs designed to help individuals acquire essential skills in information technology and office software management. These courses are offered in a variety of educational environments, ranging from elementary and secondary schools to colleges and universities, career training centers and online programs. My commitment to this goal extends to the constant search for varied educational resources, participation in specialized training and the creation of stimulating learning environments, in order to ensure a complete and enriching transmission of IT knowledge to my students. students.

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.

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.

Mo
Computer science at all levels (Algorithmics, Theoretical computer science, Programming, Introduction to computer science)
Computer science is a skill that is always in demand. From computer architecture to artificial intelligence, in this field, thousands of computer scientists are recruited every year all over the world. As a computer engineer with 8 years of experience including 3 years in a very large international company, I give theoretical and practical computer science courses at all levels. I teach algorithms, operating systems, some computer software and programming. I also give lessons for pupils and students (college, high school, university, other). For people who are passionate about IT, even if they have no knowledge in the field, I can help them get off to a solid start.

Florian
Logic, formal languages, and automata theory for computer science
Experienced and patient teacher of logic for computer science. I have taught logic, formal languages and automata theory to undergraduates for six years. My tutoring is adapted to the student's level and goals. Whether you need to learn logic for your studies, or you would simply like to know more about the subject, I will be more than happy to help you improve your understanding and skills. Logic The sciences presuppose a certain standard of rationality. An ability to distinguish between correct reasoning and claims that do not follow from the assumptions. In this class we study the basic principles of logic and apply mathematical techniques to the study thereof. Topics include: Propositional and Predicate Logic Syntax and semantics Semantic Tableaux Natural deduction Correctness and soundness Completeness Formal languages and automata A formal language is an abstraction of general characteristics of programming languages. Such a languages consists of a set of symbols together with some rules to determine whether a string made up out of those symbols is a member of the language. Topics include: Regular languages, context-free languages Finite automata, pushdown automata, Turing machines Regular expressions Regular grammar, context-sensitive grammar Pumping lemmas for regular and context-free languages

Yasmina
Personalized Computer Science, Scratch, Python and ICT Courses for Middle and High School Students
Hello, I am a computer engineer, passionate about sharing knowledge. I offer private lessons intended to help students succeed in their academic career, from middle school (7th year) to the baccalaureate. My offer includes Scratch and Python programming courses, as well as courses on Information and Communication Technologies (ICT). My packages are flexible and negotiable to accommodate each student's individual needs. I am based in Hammam Chatt, and you can contact me for further information. Welcome to everyone who wants to develop their computer skills, explore programming and excel in their studies