Microsoft Excel Seminar Deepening Basics(Level II)
One-day training in Microsoft Excel for advanced basics. Basic knowledge is consolidated and expanded. The aim is to use Microsoft Excel to carry out and display complex tasks in data preparation and evaluation.
After this Microsoft Excel training for advanced basic knowledge, you will have deepened your basic knowledge and will be able to independently and confidently carry out and present complex tasks in data preparation and evaluation using Microsoft Excel.
Our Microsoft Excel training for advanced basic knowledge is aimed at participants who have good basic knowledge and now want to get to know other spreadsheet tools. Anyone who has already taken part in the Level I – Microsoft Excel basics training also has the ideal prerequisites for this training.
You can also book this seminar as a company seminar
Excel Deepening Basics Seminar Content
1. Data preparation functions
- IF(), also nested, IFS()
- AND(), OR()
- VLOOKUP()
- possibly XLOOKUP()
- IFERROR()
- Understanding and processing error messages
2. Data evaluating functions
- SUMIF()
- COUNTIF()
3. Dynamic tables as an object
- Table formats
- Structured references
- result row
4. Data visualizations
- Sparklines
- Simple Diagrams
- Conditional formatting
There will be tips and tricks for all topics for even faster and more fun working with Excel.
Requirements
Basic Excel knowledge
Duration
1 day (9:00 – 16:00)
Seminar location
Hamburg
Price
390 € plus VAT
Start dates of the next seminars in Hamburg
Do you have any questions or would you like a detailed, personal consultation?
We are happy to help you. Call us on +49 40 80 79 36 111 or send us an e-mail.
I would like to be contacted
Haben Sie noch Fragen oder wünschen Sie eine ausführliche, persönliche Beratung?
Wir sind gern für Sie da. Rufen Sie uns an +49 40 80 79 36 111 oder schreiben Sie uns eine E-Mail.