Training Excel for experts
Training description
Are you only interested in a specific part of Excel? We offer the opportunity for consultation of specialized methods and tools in Excel in any combination. A list of possible topics is given below. Choose topics that you want to learn during the training. Topics are presented by the trainer, then he answers any questions from the audience about the topic and then students do exercises on their computer to use their new knowledge. Throughout the trainer assists them and advises individually.
- For beginners
- For intermediate
- For advanced
- For experts
Topics
Duration
Course date
Topics
Modul EXCEL7
- import data from other files or database sources
- use the special tool to import data – MS Query
- retrieve up to date information from a table located on the Internet (eg. exchange rates)
- compare variants of solving the problem through scenarios
- solve the economic and optimization problems using Solver and find solutions – Goal Seek
- forecast the future using statistical functions FORECAST and TREND
- calculate financial variables using the functions working with payments and interest
- obtain statistical data on measured values using Descriptive statistics add-in
Duration
This course lasts 1 day.
Course date
Go to a contact form to make an order or obtain more information.
Similar posts about this topic
- 19.4.2018 Training Excel VBA basics
3.11.2017 
30.9.2017 
30.9.2017 
12.8.2017
Leave a Comment