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

Zanechat komentář

Your email address will not be published. Required fields are marked *

Scroll to Top