Route de Meyrin 49 
CH-1203, Geneva

+41 22 849 83 85

  • Facebook - White Circle
  • LinkedIn - White Circle
  • Twitter - Cercle blanc
  • Instagram - Cercle blanc

© 2019. All right reserved.

“MTC Training & Consulting is not endorsed by Project Management Institute, Inc. and has no affiliation with PMI®.  PMI, PMP, CAPM and PMBOK are registered marks owned by Project Management Institute, Inc.”

Microsoft Excel is the most used spreadsheet in the private and professional field.

Microsoft Office Excel- ADVANCED

Definition
Excel is the spreadsheet of the Microsoft Office suite. This version offers advanced features for use in the areas of accounting and financial programs or any other field where the creation of tables and calculations is important.

Target audience
This course is designed to train advanced users involved in complex accounting, financial or scientific applications.

Objectives
Master several complex functions of the program such as data consolidation, filters (and thus the notion of database), cross tables, etc ...

progress
One week at half time, maximum 6 participants per class

Prerequisites for this training
Windows, Excel Base

Teaching method
The "Advanced Excel" course is based on a theoretical support, the practice using exercises related to current professional situations, and a personalized coaching by a trainer. Each participant has a workstation.

Course content

  • Advanced functions (SUM, NUMBER, SEARCH, INDEX)

  • Nested functions (IF nested, AND, OR)

  • Target values

  • Databases (basics, data entry, sorting, filters and subtotals)

  • PivotTables (creation, use, modification, graphics)

  • The working group

  • Consolidation by position and category

Attestation / Certificate
Certificate of participation
Certificate if the final test is successfully passed
Level reached on request

Info

Code
BU-EXCEL2

Duration
20 hrs / 1 week 

Languages
English or French 

Capacity
Groups of 4 – 6 participants

Price

CHF 700.-

Dates

Start every day

Contact us for all the details.

Schedule of classes:

Monday Friday

8:30 - 12:45

13:30 - 17:45

18:00 - 20:00