Trusted teacher
Trusted teacher
from20.66EUR/ 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

Skills: Teenagers (13-17 years old)Adults (18-64 years old)Seniors (65+ years old) BeginnerIntermediateAdvanced 120 minutes 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

# Reviews(1)

good and professional teacher I loved the way of teaching

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  Monday at 3:00    Wednesday at 3:00    Friday at 3:00
4  Monday at 4:00    Wednesday at 4:00    Friday at 4:00
5  Monday at 5:00    Wednesday at 5:00    Friday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00
9    Tuesday at 9:00    Thursday at 9:00
10    Tuesday at 10:00    Thursday at 10:00
11    Tuesday at 11:00    Thursday at 11:00
12    Tuesday at 12:00    Thursday at 12:00
13  Monday at 13:00    Wednesday at 13:00    Friday at 13:00
14  Monday at 14:00    Wednesday at 14:00    Friday at 14:00
15  Monday at 15:00    Wednesday at 15:00    Friday at 15:00
16
17
18
19
20
21
22
23
from 20.66€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 August 2019
• Phone number verified

### Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0
1
2
3  Monday at 3:00    Wednesday at 3:00    Friday at 3:00
4  Monday at 4:00    Wednesday at 4:00    Friday at 4:00
5  Monday at 5:00    Wednesday at 5:00    Friday at 5:00
6  Monday at 6:00  Tuesday at 6:00  Wednesday at 6:00  Thursday at 6:00  Friday at 6:00
7  Monday at 7:00  Tuesday at 7:00  Wednesday at 7:00  Thursday at 7:00  Friday at 7:00
8  Monday at 8:00  Tuesday at 8:00  Wednesday at 8:00  Thursday at 8:00
9    Tuesday at 9:00    Thursday at 9:00
10    Tuesday at 10:00    Thursday at 10:00
11    Tuesday at 11:00    Thursday at 11:00
12    Tuesday at 12:00    Thursday at 12:00
13  Monday at 13:00    Wednesday at 13:00    Friday at 13:00
14  Monday at 14:00    Wednesday at 14:00    Friday at 14:00
15  Monday at 15:00    Wednesday at 15:00    Friday at 15:00
16
17
18
19
20
21
22
23
from 20.66€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.