The training is intended for management staff, financial analysts, employees of economic analysis and logistics departments who use Microsoft Excel application.
- Gaining skills of optimising financial decisions
- creating reports with the use of MS Excel tools
- an ability to optimise financial decisions by using MS Excel for business situation modelling
- becomign familiar with data analysis in MS Excel – pivot charts and pivot tables.
*
- Training: English
- Functions supporting decision making process
- Financial (the value of money in time, credits, deposits)
- Investing (a criterion of discounted value net and internal rate of return)
- Search functions
- Array formulas
- An alternative for absolute addressing
- Expanding standard capabilities of Excel functions
- Analysing vulnerabilities
- Table object
- Formants, navigation elements
- Comparative analysis using Scenario Manager
- Power View – report of results
- Optimisation
- The use of Solver add-on for: establishing an optimal production stock; solving transport and distribution problems, employment planning; investment outlays planning
- Data analysis with the use of pivot tables
- Consolidating a few charts – pivot table creator,
- Creating data model – data analysis from several tables
- Creating, modifying, selecting an appropriate table layout
- Calculated fields and elements
- Downloading data from pivot table
- Predicting – a review of Analysis ToolPak add-on possibilities
- Summing up dependencies with the use of correlation
- Polishing time arrays – moving average and exponential smoothing
- Setting the trend (line, exponential, power type)
- Multiple regression: quantitative factors; qualitative factors; seasonality
- Single- and two-factor variation analysis
- Working on multiple documents