TRAINING ADVANCED EXCEL Geneva, Zürich and Vaud
The goals of this advanced Excel course (Geneva, Zürich and Vaud) are:
To become proficient in search functions, database functions, the If function and nested formulas; to create advanced pivot tables; to customise the Excel environment; and to design macros.
Open to everyone.
Knowledge of pivot tables, proficiency in advanced calculation functions (the conditional, date and text functions).
This Advanced Excel course, which is based on realistic simulation exercises and a comparison of different practices, will equip participants with techniques that can be used directly.
Programme for the advanced Excel course
- Managing documents
- Creating, modifying and saving an Excel document
- Automatic saving
- Choosing the destination directory
- Entering data and calculation formulas
- Entering, changing, correcting, copying and moving data
- Creating calculation formulas: operators (+, -, *, /)
- Using basic features: sum, average, count, conditional, etc.
- Using relative and absolute references
- Logical and search functions
- DATE and TIME functions
- Formatting cells
- Conditional formatting
- Customising the number format
- Printing documents
- Print preview
- Inserting a page break
- Layout (orientation, headers, footers, etc.)
- Managing headers
- Chart wizard
- Modifying and customising charts
- Work group mode
- Working on spreadsheets
- Linking sheets
- Linking workbooks
- Data analysis
- Using automatic filters
- Sorting and subtotals
- Elaborate filters
- Pivot tables
- Target value
- The solver
- Scenario manager
- Recording macros
- Macro recording
- Assigning a button to a macro.
- Running macros: keyboard shortcuts, toolbar, etc.
Course diploma / certificate
A certificate is obtained at the conclusion of the Advanced Excel course.
Similar types of training courses:
- Training Advanced Word (Geneva, Zürich and Vaud)
- Training Introduction to Word (Geneva, Zürich and Vaud)
- Training Word: large documents (Geneva, Zürich and Vaud)
- Training Word Tables (Geneva, Zürich and Vaud)
- Training Excel pivot tables(Geneva, Zürich and Vaud)
- Training Introduction to Excel (Geneva, Zürich and Vaud)
- Training PowerPoint (Geneva, Zürich and Vaud)
- Training Outlook (Geneva, Zürich and Vaud)
- Training New features in Office 2013 (Geneva, Zürich and Vaud)
Our trainings can be provided tailor-made for your organization or organized in-company.
Are you looking for an in-company training? Download our training catalog.
If you are rather interested in tailored training…
Please fill in the form below, we will gladly give you more information about our tailored trainings:
All our courses can be delivered in English, French, German, Swiss German, Italian, or Spanish.
All our services are available in Switzerland: Geneva, Zürich, Vaud, Neuchâtel, Fribourg and Valais.