Anas
Trusted teacher
FavouritesAdd to Wish List
FavouritesAdd to Wish List
Trusted teacher
FavouritesAdd to Wish List
from34.54USD/ 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

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 $34.54At teacher's location
from $34.54Online via webcam
from $34.54At 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 $34.54At teacher's location
from $34.54Online via webcam
from $34.54At 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


Pavan
VBA (Excel, Word, Outlook) training with Practical Sessions
VBA is a tool which is easily within People's reach and can take productivity, accuracy to levels beyond imagination. When data and complexity of projects are not very huge to get into fancy IT applications, VBA comes into picture to get things done efficiently with satisfactory results. Some of the projects (VBA based) that I have personally undertaken in the past include Building financial and deal models to simulate best/worst case scenarios, Automated Legal contract generation with appropriate wordings and clauses based on specific inputs, Outlook/Mail automation to handle data through attachments or within body of mail, automated market analysis or financial analysis, data consolidation etc... Based on the level, the training is designed to help and understand VBA and Macros and the power of building custom modules. To reinforce what is taught, there will be a few hands on sessions with a problem statement or example data/files.

Suranjit
English Language and Grammar for all classes of students and for TOEFL IELTS GMAT GRE and Computer Progam (Word, Excel, Powerpoint Internet.
Teaching English Language in India and Bangladesh for 15 Years, Specialized in English Language and English Grammar Teaching for all classes of students and for the students who wants to sit for the exam of TOEFL, IELTS, SAT, GRE, GMAT etc. I will show some techniques and some rules by which a student can easily excel in Reading, writing, speaking and listening. I can teach from primarily levels to tertiary levels so that any weak student can easily learn English Language as a Native speaker can. I have invented some rules of English Grammar after completing B.A Honors and Masters in English Language from Rajshahi University, Bangladesh, India. I will give homework but you can learn all at the time of teaching with pleasure, The technique which you have never got in your life i will teach you and will never forget in your life. I can teach in Computer Basics, and Program Microsoft Word, Excel, Access, Power point, Operating System, Visual Basics, Internet Browsing.

Mohand
Courses in scientific subjects for beginner level up to Bac + 2: Maths - Physics - Chemistry, Computer courses for beginners
Graduated from a Bachelor in Computer Science and Mathematics and Student in Computer Science - I offer tutoring courses, refresher courses to all kinds of students without overloading them, with evaluation of progress over time and provide them with the necessary motivation to continue his efforts individually with advice and documentation resources already tested before, and supplemented with advice and discussions on a good study project that will lead to a successful professional career. Course subjects: Maths, Physics, Computer programming, General computing, Office, Computer science initiation, English.

Manoj
Computer Basic to Front End, Back End, App Development, Services and Testing etc.
I am Professional Full Stack Developer from last 9 years. I can teach you all cool Stuff about Computers and Computer Programming. You can learn from basic to professional level.Following Topics Which I can teach you. Front End: HTML, HTML5, CSS, CSS3, BootStrap,JavaScript, Angular JS, Angular 9, React Js,Jquery,Ajax Back End: C, C++, DataStructure,OOPS, Java, J2EE,Hibernate, Spring, Struts,Wicket, ShellScripting,PHP, microservices,Node JS, Docker, AWS, Azure, ELK App Developement : Android, Hybrid App Development(Cordova, Ionic) Services: REST, SOAP Testing: Junit, Selenium Database: MySql, Oracle, DB2 OS: Windows, Linux, Ubntu, Unix Others: Artificial Intelligence(API AI/Dialog-flow), Web Crawling, Web Scrapping, Maths, Science, Game development

Michael
Math, Sciences, Computers and software for children, adolescents, adults and seniors
I teach mathematics and science courses for levels: - Primary - Lower secondary - Higher and University Secondary - Central jury I teach computer and software courses: - Programming: Initiation, Beginner, Intermediate - Software: Initiation, Beginner, Intermediate, Experienced Before agreeing on a course, we can discuss the subject to study. In the case of a particular request, we can make a first meeting to discuss the matter to see. If I can help you, we are go! My technique is summarized in 5 steps: - Analysis (of your needs) - Adaptation (to your learning skills) - Motivation - The practice - Repetition

Renaud
Learn the tools of InDesign CC 2020 software.
Trainer for 10 years, I offer to support you in your learning of InDesign software by working on concrete examples. My experience as a trainer allowed me to sharpen my teaching techniques. I adapt to the level of the student to help him master the tools offered by this software.

George
Computer Science courses from beginner to intermediate level
Computer Science courses from beginner to intermediate level - Using Windows - Using Microsoft Office (Word, Excel, PowerPoint) - Safe-surfing (using Web without risks) - Using specific applications (on-demand) - Trick of using computer - Programming courses

Said
Accelerated computer courses: office automation, programming for all levels, advanced programming
For all levels, I offer programming courses according to your needs: -Web technology. (php, angularjs, javascript, css, html ...) -JAVA / J2EE technology (frameworks: Spring Boot, JPA, hibernate), RMI, Sockets ... -Office (Word, Excel, PowerPoint) -The use of the machine.

Abderrazzak
IT Support: Algo, Java, C, PHP, Python, UML, PFE
Hello, I'm Abderrazzak, Trainer and Computer Engineer, I offer computer courses and coaching sessions: - Programming (Java, C, C #, PHP, Python) - Supervision of PFE, IT Project and Internship - Assistance in the use of information technologies - Database (MySQL, SQL Server, Oracle, SQL, PL SQL) - Web (HTML CSS JavaScript, Vue JS, PHP, Laravel) - Mobile (Andriod) - Analysis and Design UML and Merise For more info, please contact me

Fawzi
International freelance trainer offers training on CATIA V5 and Solidworks
Experienced trainer specializing in CAD software (Computer Aided Design) offers its services to professionals and individuals, in terms of training and homework help / technical support on CATIA V5 and / or Solidworks. the content of CATIA V5 or Solidworks basic training (24 hours = 3h x 8 sessions) is as follows: - Introduction to CAD, presentation of the user environment - Creating geometries from sketches - 3D modeling of prismatic parts - Creating parts using advanced tools - Realization of assemblies - Development of drawings from parts and assemblies if you already have basic knowledge and want to improve it, I offer intermediate (15 h) or advanced (9 h) if you prefer more specific and shorter courses, I also offer other courses: advanced mechanical design, advanced assemblies, surface, sheet metal, kinematics, mold making, Knowledgeware ... you can also opt for a la carte training. I specify that I prepare myself course materials / exercise books and assessments.

Thales
Comp Sci/Chem/Bio/Math/Science/Phys/AP/SAT/GRE/MCAT/LSAT/GMAT, Ph.D
We offer tutoring in GMAT, MCAT, LSAT, DAT, SSAT, ACT, IGCSE, DAT, GED, TEAS, PSAT, CBEST, PCAT, OAT, CSET, GRE (General Test and Subject Tests), SAT (General Test and Subject Tests), AP courses, IB courses, AP exam prep, TOEFL, TOEIC prep, and in subjects such as Science, Biology, General Biology, Ecology, Microbiolgoy, Zoology, Developmental Biology, Ornithology, Botany, Molecular Biolgy, Genetics, Geology, Economics (Microeconomics, Macroeconomics), Business, Finance, Political Science, Environmental Science, Computer Science, Engineering (Civil Enginerring, Computer Engineering, Electrical Engineering, Materials Engineering, Bioengineering) Psychology, Engineering, Japanese, Chinese, Korean, Biochemistry, Accounting, History, Government, Geography, Math (Algebra, Pre-calculus, Calsulus, Differential Equations, Linear Algebra), English, Physics (General Physics, Modern Physics), Chemistry (General Chemistry, Organic Chemistry, Analytical Chemistry, Physical Chemistry), AP courses including: AP Research AP Seminar Art History Biology Calculus AB Calculus BC Chemistry Chinese Language and Culture Computer Science A Computer Science Principles English Language and Composition English Literature and Composition Environmental Science European History French Language and Culture German Language and Culture Government and Politics - Comparative Government and Politics - US Human Geography Italian Language and Culture Japanese Language and Culture Latin Macroeconomics Microeconomics Music Theory Physics 1 Physics 2 Physics C: Electricity and Magnetism Physics C: Mechanics Psychology Spanish Language Spanish Literature Statistics Studio Art Drawing Studio Art 2D Design Studio Art 3D Design US History World History We offer to tutor from 1st grade to college level. We use Skype and an online whiteboard and all of our tutors have a Ph.D. in their respective field. We have a proven track record with more than 22 years of experience and excellent grades and scores by our students. We have many students in Tokyo, Tsukuba, Sapporo, Sendai, Osaka, Kyoto, Nagoya, Hiroshima, Fukuoka, Okinawa, as well as Taiwan, Taipei, Korea, and Seoul etc. and we would be happy to help you with any subject or test preparation. References are happily given upon request. The rate goes from 3780 yen/hour depending on the level. Thank you.

Houria
Computer Tutoring - English (Beginner)
Graduate in computer science applied to management, offers courses for individuals as well as for students (7 th, 8 th, 9 th, secondary) in computer science. (Office tools: Word, PowerPoint, and Outlook, etc.) Data structures, Algorithms and programming. Beginner's English: a good starting point if you do not know English

Olivier
Basic Computer Course, Word / Excel / PowerPoint
I have more than 30 years of experience in the field of IT. I use a personal method, adapted to each user, to allow him to progress easily, at his own speed, without him never feeling under pressure or "null"! I am very patient ... The basic idea is that everything seems intuitive and easy. You will not need to review pages of notes to find yourself once you alone, you will KNOW. The content of the course may vary according to your request, it is an "à la carte" system. You learn to use only what you REALLY need and want to master. You will be surprised by what you will be able to do without help after the course ... e-mail, Internet searches, management and editing of your photos, Skype calls, composition and printing of letters, spreadsheets, presentations, creation of PDF files , business cards, flyers, simple and easy website creation, use of social networks (Facebook, Google+, LinkedIn), backup or sharing of data (photos, documents) on the Internet, PayPal or e-banking payments, and very important , a sound management of your computer, what you absolutely must do and especially what to avoid! My classes are given by appointment, either at home or at home if you are in the region, or you prefer to move. I am based in Echallens near Lausanne. I can also provide follow-up or remote assistance when needed or on request, help with a program or task that you would like to do that is not mentioned here. If you have just purchased a computer, I can also help you configure it properly.

Muhammad
Learn Micosoft Excel, VBA, Word, Powerpoint. Lectures can be delivered online (e.g. Skype)
I am specialized in accounting and finance. I am currently completing my PhD degree in the field of Finance from University Clermont Auvergne, France. I also have two master's degree in Business Administration (MBA) and Accounting and Finance. Furthermore, I have a two years experience in Audit in a bank. My goal is to keep students challenged, but not overwhelmed. I assign homework after lesson and provide periodic progress reports. Please note that I will teach in English.

Tresor
Civil Engineer provides courses in network administration
. Civil engineer, holder of numerous network certifications (CCNA, CCNP, CCDP, CICA, CICE, F5), accompanies and supervises students or professionals wishing to obtain their CCNA certification. This course is designed specifically for CCNA applicants and anyone interested in understanding and administering a medium-sized network. This course includes several modules namely: - general knowledge of network services - understanding and configuration of the switches - Understanding and configuring routers -understanding WAN (Wide Area Network) networks