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.
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
Similar posts about this topic
- 19.4.2018 Training Excel VBA basics
3.11.2017 
30.9.2017 
30.9.2017 
12.8.2017
Zanechat komentář