##### Hassan
Trusted teacher
##### Hassan
Trusted teacher
from18.35USD/ h

# EXCEL complete training: Beginner, Intermediate and Advanced

Formation's goal :

- Master and combine the most advanced features of Excel,
- Discover new tools and new very useful functions,
- Prepare, organize and control the data to facilitate analysis,
- Exploit the potential of Excel to automate and make calculations more reliable,
- Master the creation of advanced calculation formulas,
- Use data lists with management and summary tools,
- Prepare dashboards via PivotTables…
The training will be enhanced with examples and practical case studies…

Training content :

➢ General and Reminder on Level 1: Excel introduction,
➢ Simple functions then advanced functions,
➢ Calculation audits and advanced graphics,
➢ Excel databases and Management of large workbooks,
➢ PivotTables and PivotCharts,
➢ The validation rules and Conditional formatting,
➢ Import, export or link data…

Training program:

Reminder on Level 1: Excel introduction:
• Discover the Excel Ribbon,
• Name cells, ranges and tables,
• The options to hide, display, insert and delete,
• Concept of workbook and Excel sheet management,
Using time-saving tools
• Create custom formats.
• Define conditional formatting rules.
• Facilitate and control data entry with data validation.
Build simple and elaborate calculation formulas
• Master the copying of formulas: relative and absolute references,
• Make calculations more reliable: name cells or ranges of cells,
• Set up simple, complex, nested conditions: IF, OR, AND,
• Calculate statistics: NBVAL, NB, NB.SI, NB.VIDE,…
• Relate data with the VLOOKUP function.
• Calculate dates and times: MOIS.DECALER, FIN.MOIS…
• Manipulate text: LEFT, RIGHT, STXT, NBCAR,…
• Protect the sheet or filing cabinet.
Using a data list
• Put the data in tabular form.
• Apply multi-criteria and custom sorts.
• Query, extract data with automatic filters.
• Filter one or more tables with segments.
• Remove duplicates.
• Generate a graph from a data table,
• Modify the type: histogram, curve, sector,
Lists / Sorts and filters
• Create a list,
• Use the lists with a data grid,
• Sort the data in a grid (Sort orders, sort by columns),
• Sorting and Filtering,
• Personalized sorting,
• Group the data in a list,
• Display the subtotals of a column, of several columns,
• Filter the data.
Validation rules and Conditional formatting:
• On drop-down lists
• On numbers (integer, decimal)
• On dates,
• Conditional formatting.
Set up pivot tables
• Set up pivot tables in 1, 2 or 3 dimensions.
• Group information by period, by tranche.
• Filter, sort, hide data.
• Insert a cross graph.

## Extra information

Do the training at home as if you are in a fully equipped training room.
I bring with me: my Datashow, My Practical Work, my PC ..

## Location

At student's location: Around Casablanca, Morocco

|
Use ⊞+wheel to zoom!

## General info

#### Age:

Teenagers (13-17 years old)
Seniors (65+ years old)

Beginner
Intermediate

120 minutes

#### The class is taught in:

French, Arabic, English

Consultant Trainer with several Years of experience and MOS EXCEL, GOOGLE DIGITAL ACTIVE and FACEBOOK BLUEPRINT certified.
I teach in:
EXCEL any level
Digital Marketing
SEO and SEA natural referencing
Marketing and Commercial Action
Also courses in Office Automation.

## Education

Master in Digital Marketing at ESITH
Bachelor in Business Management at UNIVERSITY
Bachelor of Life and Earth Sciences.

Master in Digital Marketing at ESITH
Bachelor in Business Management at UNIVERSITY
Bachelor of Life and Earth Sciences.

## Experience / Qualifications

5 years in DIGITAL domain as DIGITAL MANAGER
7 years as a Training Manager.
Currently GENERAL MANAGER
6.60USD/ h

13.09USD/ h

## Taxation training, to keep my taxes under control

We are organizing a Practical Training Seminar in Moroccan Taxation, in order to control your taxes within the framework of the 2019 finance law. ~~~~~~~~~~~~~~~~~~~~~~ TRAINING CONTENT : ___________________________ ▶ ️ 1st part: VAT- Value added tax ▶ ️ ♦ ️ ♦ ️ Taxable persons, activities and property. ♦ ️ ♦ ️ Exemptions and reductions. ♦ ️ ♦ ️ Partial deductions: Prorata de vat. ♦ ️ ♦ ️ The rule of base (generating event and taxable base of deductions. ♦ ️ ♦ ️ Practical case of VAT declaration ♦ ️ ♦ ️ Tele declarations in EFI and EDI mode of VAT… ▶ ️ 2nd part: IS- Corporate tax ▶ ️ ♦ ️ ♦ ️ Taxable persons, Excluded persons and Exempt persons total or partial or provisional. ♦ ️ ♦ ️ Assessment of charges and income. ♦ ️ ♦ ️ Practical case of calculating the IS and deposit. ♦ ️ ♦ ️ Regularization of balance to be paid and excess. ♦ ️ ♦ ️ IS Accounting and Down Payment ♦ ️ ♦ ️ Tele declaration of tax result and tele payment of payments ... ▶ ️ 3rd part: TP: Professional tax ▶ ️ ♦ ️ ♦ ️ The rental value. ♦ ️ ♦ ️ Taxable capital elements. ♦ ️ ♦ ️ The annexes to the relevant tax package. ♦ ️ ♦ ️ Declaration of taxable items… TRAINING AIMS : ____________________________ The purpose of this training cycle is to enable beneficiaries to master the tax aspect encountered in practice in corporate tax matters; value added tax and business tax. This training is consolidated with practical cases and exposed in computer mode while being based on the tele declaration and tele payment implemented by the general direction of the taxes. For more information, do not hesitate to contact us.
15.33USD/ h

## undefinedLearn to create Websites from A to Z, HTML, CSS or WordPress (or choice)

"E-COMMERCE & WORDPRESS" TRAINING CYCLE You are full of imagination and you like to make neat and original presentations, this computer graphics training organized by the EMMGI Center, the LEADER SPECIALIST in professional training, continuous training and modular training, you will be perfectly suited. You will be able to juggle shapes, colors, photos, typography and illustrations, in addition to developing your creativity and speed of execution. In short, you will learn how to use the persuasive power of the image under Adobe suite software (Illustrator and Photoshop). TRAINING AIMS Know how to install and configure WordPress, Master administration interfaces (backoffice), Know how to create turnkey graphic themes, Discover the advanced concepts in website creation, Create a Complete E-Commerce Site ... TRAINING CONTENT Introduction to the Web and E-Commerce. WordPress Cases: Presentation. WordPress installation and configuration. Choice, installation and customization of theme. His first article and notion of category. Creation of the very first WordPress Page. Management of Navigation menus. Installation and integration of extensions and plugins. Make better use of the power of widgets. Final Project Website from A to Z. Backup and update of its website. Migrate and host your Wordpress website. TRAINERS Consultant Trainer Web Project Manager Having more than 8 Years of experience, DELIVERABLES WordPress software Full course material, Pdf format, More than 20 practical cases, Complete Web Project Training certificate.

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  Monday at 9:00    Wednesday at 9:00    Friday at 9:00
10  Monday at 10:00    Wednesday at 10:00    Friday at 10:00
11  Monday at 11:00    Wednesday at 11:00    Friday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00
15    Tuesday at 15:00    Thursday at 15:00
16    Tuesday at 16:00    Thursday at 16:00
17    Tuesday at 17:00    Thursday at 17:00
18    Tuesday at 18:00    Thursday at 18:00
19  Monday at 19:00    Wednesday at 19:00    Friday at 19:00
20  Monday at 20:00    Wednesday at 20:00    Friday at 20:00
21  Monday at 21:00    Wednesday at 21:00    Friday at 21:00
22
23
from \$18.35At 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 August 2019

### Availability of a typical week

MonTueWedThuFriSatSun
7
8
9  Monday at 9:00    Wednesday at 9:00    Friday at 9:00
10  Monday at 10:00    Wednesday at 10:00    Friday at 10:00
11  Monday at 11:00    Wednesday at 11:00    Friday at 11:00
12  Monday at 12:00  Tuesday at 12:00  Wednesday at 12:00  Thursday at 12:00  Friday at 12:00
13  Monday at 13:00  Tuesday at 13:00  Wednesday at 13:00  Thursday at 13:00  Friday at 13:00
14  Monday at 14:00  Tuesday at 14:00  Wednesday at 14:00  Thursday at 14:00
15    Tuesday at 15:00    Thursday at 15:00
16    Tuesday at 16:00    Thursday at 16:00
17    Tuesday at 17:00    Thursday at 17:00
18    Tuesday at 18:00    Thursday at 18:00
19  Monday at 19:00    Wednesday at 19:00    Friday at 19:00
20  Monday at 20:00    Wednesday at 20:00    Friday at 20:00
21  Monday at 21:00    Wednesday at 21:00    Friday at 21:00
22
23
from \$18.35At 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

Youness
Online Power Point course for all levels: distance
Hello, I am a computer teacher and I give online office automation courses and especially Microsoft power point. You will learn how you can create presentations according to your needs. You will also learn how to animate your projects and presentations, etc ..... For more information, contact me. You can contact me through the contact form via Apprentus. I'm waiting for you !!!

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.

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.

Suranjit
English Language, Grammar, TOEFL, IELTS, GRE and computer program with Basic Excel, power point
Specialized in English Language, Grammar and Computer and teaching for 15 years Experienced as English Teacher for all classes of students and TOEFL, IELTS GRE etc. specialized for University Admission Test Learn with pleasure and new technique that i have invented and one can easily learn reading, writing, speaking, listening English. I like to prefer computer application program, just try one class and feel.

Boris
Microsoft Excel, Finance, Investments, Economics, Math
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.

Amina
Microsoft Excel Course, Pivot Tables, V & H Research. Office, outlook.
Here are the courses that I propose for individual or professional: Setting up formulas (VLOOKUP, VLOOKUP etc.) Microsoft Excel, in French or in English. Very suitable for monthly reports and accounting. I can create dynamic, pre-fillable and customized Excel spreadsheets for your type of business.

John
Excel functions for both the classroom and business
The class involves my demonstrating how to execute many Excel special functions. Such as linking information from one spreadsheet tab to another tab; creating V-Look ups, H-Look ups, Pivot Tables, Pivot Charts, Nested If's, Sumif's, "If/Then", “If/And” scenarios among many others. Included in the lesson is an interactive spreadsheet which contains actual working formulas with step-by-step instructions for easy implementation. You will see working, functioning examples of all the Excel functions I teach & explain during the lecture. Excel is one of my specialties. As an experienced CPA who has had both individual and corporate clients, I have constructed both simple to very complex spreadsheets – plus I was always ready to explain how they functioned to my employer, my co-workers, my tax clients, and even auditors!

Syed Abdul
Tutoring (Math, CAD, Excel, Primavera), Experience Pakistani and Indian foods
I have an experience in teaching maths and other subjects for about 10 years. I have professional experience of 5 years also in Production Manufacturing and Project Management sector. I know how to cook Indian and Pakistani dishes. I can give you a company also.

Felipe
Marketing, Projects,
In my classes you will learn all about marketing strategy, controlling projects and advanced excell

Matías
Microsoft Office Suite (Word, Excel, Access, Powerpoint)
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.

Yves
Excel avancé (+VBA) pour professionnels ou en Masters MBA
Vous utilisez régulièrement Excel dans votre job et avez un projet que vous voulez développer; vous êtes à la recherche d'un nouvel emploi et nécessitez un approfondissement de vos connaissances en Excel; vous êtes en stage de formation type MBA et avez besoin d'aide dans les matières de mathématiques, statistiques ou analyse de données. Consultant en entreprise, je donne des cours individuels via webcam (Zoom) pour tous niveaux (débutant, intermédiaire, avancé, et programmation VBA) sur les versions Excel 2010, 2013, 2016, 2019, Office 365 en version anglaise ou française. De formation ingénieur génie chimique (ESCOM), je suis spécialisé dans l'industrie de Supply Chain, et peux vous aider quelque soit votre fonction actuelle. Contactez-moi pour programmer votre entretien personnalisé et définir ensemble un programme de formation adéquate. A bientôt

Jerome
Doctor in Cognitive Psychology helps you prepare for your oral defense.