Anas
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
from32.88USD/ h

Master Microsoft Excel (Beginner - Intermediate - Advanced)

Translated using Google Translate. 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.
The trainings can be organized also on 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 using Google Translate. Click to view original.
Preferably, the participant must have his own computer.

Location

At teacher's location: Pannenhuis, Métro Pannenhuis
At student's location: Around Brussels, Belgium
Online via webcam

|
Use ⊞+wheel to zoom!
+

General info

Skills:
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 using Google Translate. 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 using Google Translate. 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 using Google Translate. Click to view original.
IT Consultant / Trainer
Computer trainer
Management control
Tax Consultant
Financial auditor

Reviews (1)

very friendly and good teacher
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 diagrams: relay tables, star diagrams, 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

MonTueWedThuFriSatSun
7              
8              
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            Saturday at 15:00  Sunday at 15:00
16            Saturday at 16:00  Sunday at 16:00
17            Saturday at 17:00  Sunday at 17:00
18            Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday at 21:00  Saturday at 21:00  Sunday at 21:00
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23  Monday at 23:00  Tuesday at 23:00  Wednesday at 23:00  Thursday at 23:00  Friday at 23:00  Saturday at 23:00  Sunday at 23:00
from $32.88At teacher's location
from $32.88Online via webcam
from $32.88At 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
  • Phone number verified
  • Google connected

Availability of a typical week

MonTueWedThuFriSatSun
7              
8              
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            Saturday at 15:00  Sunday at 15:00
16            Saturday at 16:00  Sunday at 16:00
17            Saturday at 17:00  Sunday at 17:00
18            Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday at 21:00  Saturday at 21:00  Sunday at 21:00
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23  Monday at 23:00  Tuesday at 23:00  Wednesday at 23:00  Thursday at 23:00  Friday at 23:00  Saturday at 23:00  Sunday at 23:00
from $32.88At teacher's location
from $32.88Online via webcam
from $32.88At 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


Daniele
Private lessons for Computer Science, Java, Python, Javascript, React, Angular, Node
I'm a professional and young software engineer working in Munich, Germany. I have completed many different enterprise projects that came to life and are accessed by thousands of users. In this class, we can cover any general computer science topic related to high school and university exams, as well as real-life enterprise project consultancy. I have been teaching for many years and I have adopted a way of learning with "ELI5": "Explain like I'm five". I'm gonna explain hard concepts in easy and real-world examples. We're not just gonna learn a language or topic, but learn how to learn fast and adapt it in every aspect. I'm a passionate software developer and I will make you love the subject by teaching it in a fun and successful way. Please get in touch with me to let me know what kind of help you need. I'm here for you!

Tom
Mathematics and computer science accessible to all
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 outside technical courses (engineering, physics, mathematics, etc.) and anyone wishing to refresh or strengthen their knowledge in mathematics and computer science. Through my reading and my studies in computer science at the École Polytechnique de Louvain, I have amassed a quantity of knowledge in mathematics and computer science that it would be a shame not to share :) Being a student myself, I know the difficulties that certain subjects can cause and the lack of pedagogy of certain teachers. I look forward to working alongside you and unlocking your skills :) I am a master's student in computer science at the École Polytechnique de Louvain (UCLouvain), with a bachelor's degree. Naturally curious, I supplemented my course in computer science with numerous courses in physics (classical and quantum) and logic. I have also been brought to work with people from many backgrounds in various contexts, I learned a great adaptability. I have been volunteering for a long time helping friends and acquaintances in the success of their studies and I hope to be able to use this experience for the benefit of your success :)

Roman
Computer Science and Programming ONLINE Class for all ages.
If you want to start learning computer science and programming or if you need a tutor to help you with computer science in high school, then look no further. I am a qualified high school teacher with many years of experience in teaching and tutoring at all levels. My lessons are engaging, fun, and student-focused and I am using a vast library of tools and media to get the best experience and results possible. Feel free to contact me at any time.

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint) and VBA
Office, in particular Excel and Access, are programs widely used both in industry and in the personal field. It is worth learning. I am used to working with people of different ages. I believe in segmentation, visualization of progress, objective results and practice. Beyond these general lines, there is no rule or magic method. Some things work with some students and not with others. Adapting to needs is really the goal of private lessons. So I will do my best to find what motivates and helps my student.

Zakarya
Statistics, Econometrics and Data science - Programming with R & Python
Engineer in Statistics and Econometrics graduated from the University of Strasbourg, holder of a master 2 of research in Statistics and Econometrics and an engineer degree Data Science. I have worked a lot on several projects in statistical data analysis and econometric models, I therefore offer detailed and depth courses in Statistical / Econometric Analysis. I help you in your modeling projects in Statistics / Econometrics and Data Science: - Advanced Statistics and Machine Learning Modeling - Bayesian econometrics - Multivariate Time Series Analysis and Forecasting - Stastistical Methods in Econometrics - Semi and Non-parametric Econometrics - Modeling assistance (R / Python / Stata, ...) - Micro & Macro-econometric Evaluation of Public Policies

Ayoub
IT developer training (c, c ++, c #, java ...)
👉 I offer distance learning courses, programming languages such as JAVA, Python, C #, C ... from basic to advanced level, individual or small group 📌 With nearly 2 years of experience as a Full Stack Developer, I participated in many projects in several different fields for French, American, Australian clients, ... I hope to bring you not only the theoretical knowledge but also practical experiences drawn from my personal experiences. 💯 The program based rather on the practical applications side will give you the opportunity to acquire knowledge, practice and hone your skills in the most comprehensive way! ⏰ Study time: weekday evenings from 8:00 a.m. and weekends 📨 Those with any needs don't hesitate to message me for specific study program advice

Zen
Strengthen your knowledge of networks and telecommunications in the form of practical work, via LABS.
NB: I ALSO DELIVER LESSONS IN THE FORM OF TP, VIA LABS. To allow the student to have a better practical understanding. My teaching is aimed particularly at university students who would like to strengthen their knowledge of networks and telecommunications, but also to professionals who need to strengthen their knowledge. The courses will be carried out remotely (skype) or by other videoconferencing tools. I have several methods of dispensing lessons, depending on the profile of the student. If the student has a particular topic, we can take more time on it, for example spanning tree, EIGRP, resilience, default route ... But I prefer to give lessons with my personal guides that I could share with the student.

Kelly
Python, learn how to think and build effective code
Python is a Programming Language widely used with huge capabilities on building projects of many different kinds but the most important advantage is that it is easy to learn and it can be a good start for someone to embrace Computer Science and improve their logical thinking.

Sachin
Basics of C and C++ languages for budding programmers
Programming has become an important skill in today's ever-changing world. C and C++ are one of the bests when it comes to learning the fundamentals of programming, especially object-oriented programming. This class is designed to address the basics of the C and C++ language while building a programming mindset among the students. I am looking forward to welcoming you on your journey to learn one of the most important skills of our time. See you all soon!

Boris
Microsoft Excel, Finance, Investments, Economics 🔥 🔥 🔥
Lessons from an experienced tutor (8 years of tutoring privately and in groups). I have a B.Sc. and an MBA, specializing in Finance and international Business. If you are a student, a professional or just building up your business, then Excel is a MUST tool for you. I can also help you with financial planning, investment portfolios, sensitivity and feasibility analysis for your projects, and much more. Tutoring is either online (Zoom/Skype) or at my place.

Ilias
Games, animations and interactive stories with Scratch (adults)
Are you dreaming of creating your own games, animations or interactive stories? This course aims to enagage learners regardless of their programming experience. The course for beginners starts with a description of the interface and how you can import or create various backgrounds or objects. An introduction to basic command blocks follows, and as the course progresses, learners are given many opportunities to be creative, practise analytical and critical thinking, and combine various command blocks to add functionality to their programs. The course also aims to foster effective communication, as learners have the opportunity to share their creations on Scratch community, receive feedback and exchange ideas with other members. This course is intended for teachers who want to use Scratch in the classroom.

Youness
Formation À Distance en Sphinx : Création et analyse Des Données Avec Sphinx
Formation À Distance en Sphinx : Création et analyse Des Données Avec Sphinx - Je donne des cours en Sphinx. ( Logiciel Sphinx ). - Grace à cette formation, vous pourrez facilement créer des questionnaires, enquêtes et sondages selon les besoins de votre marché. - Cette formation est accompagneé avec des exemples Pratiques, réels et Concrets. - J'attends votre réservation!!! *** Pour plus d'informations, Contactez moi.

Amandine
Mastering IT for your daily needs
Hello, You are an adult and you need the technology to take steps or take actions. But it seems difficult to see insurmountable on your own. Arm with your notebook, you would like us to explain you step by step and know how to reproduce in order to gain confidence and autonomy! That's good, I'm able to guide you and explain what the platforms / sites expect from you! For example, how to lighten a file so that it is accepted on official sites? What are the different file formats? What are the tips to save time or make your job easier? I have a European license for computer graphics (design using the computer) and the handling and use of the different software (in French and in English) does not scare me. I have been helping those around me for many years, I have also learned to create tutorials. The language barrier is not a barrier. I have patience, curiosity and I am a teacher. And above all, I will create real situations drawn from our learning in order to assess your progress, give feedback and anchor your new skills! Take a first lesson in order to get to know each other and understand your needs, whether they are one-off or part of a longer course. Hope to meet you ! Amandine

Laurent
Cybersecurity - Information systems security
This course is intended for cybersecurity enthusiasts. In this course, we will come back to the fundamental aspects of systems security. As the best way to learn is through practice, we will put into practice the knowledge you gain in exercises based on real world scenarios, from understanding attacks to hacking machines. This course will also give you a good understanding of the Linux operating system (Kali Linux distribution) as well as the different tools used during computer attacks.

Hajar
Computer courses in Office automation (Beginner, Intermediate, Advanced): "Word", "Excel", "PowerPoint"
Throughout my engineering student studies, I worked on multiple projects which require mastery of office automation tools ("Word", "Excel", "PowerPoint", ...). I would therefore like to share my knowledge with you, whether you are a student or not, in order to introduce you to office automation, to train you, and to guide you in your projects.