Financial analysis in Excel Training Course

Primary tabs

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Requires good knowledge of Microsoft Excel. Basic knowledge of finance is also indicated.

Overview Overview

During the training, will present the issues of financial analysis using the advanced features of Excel.

This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.

Course Outline Course Outline

Advanced functions

  • The logic functions
  • Mathematical and statistical functions
  • Financial functions

Search and data

  • Search and matching
  • Functions MATCH (MATCH) and INDEX (INDEX)
  • Advanced management of lists of values
  • Validate the value entered in the cell
  • Database Functions
  • Summary data by using the histogram
  • Circular references - Practical Aspects

Tables and Pivot Charts

  • The dynamic description of the data using PivotTables
  • Elements and calculated fields
  • Visualize data using pivot chart

Working with external data

  • Exporting and importing data
  • Exporting and importing XML file
  • Importing data from databases
  • Connections to a database or an XML file
  • Analyzing data online - Web Query

Analytical issues

  • Option Goal Seek
  • The Analysis ToolPack addition
  • Scenarios, Scenario Manager
  • Solver and optimization data
  • Macros and create your own functions
  • Starting and recording macros
  • Working with VBA code

Conditional Formatting

  • Advanced conditional formatting using formulas and form elements (eg box - checkbox)

Time value of money

  • The current and future value of capital
  • Capitalization and discounting
  • Interest made ​​simple
  • Nominal and effective interest procetowa
  • Cash flows
  • Depreciation

Trends and financial forecasts

  • Types (functions) trend.
  • Forecasts

Securities

  • The rate of profit
  • Profitability
  • Investing in securities and risk measures

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
From 1100PLN
(74)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Remote
1 1100PLN 2100PLN
2 1000PLN 1500PLN
3 967PLN 1300PLN
4 950PLN 1200PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Gdańsk, ul. Powstańców Warszawskich 45Tue, 2017-06-06 09:002100PLN / 1200PLN
Kielce, ul. Warszawska 19Wed, 2017-06-07 09:002100PLN / 1100PLN
Poznan, Garbary 100/63Thu, 2017-06-08 09:002100PLN / 1100PLN
Lublin, ul. Spadochroniarzy 9Thu, 2017-06-08 09:002100PLN / 1200PLN
Szczecin, ul. Sienna 9Mon, 2017-06-12 09:002100PLN / 1200PLN

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Visual Basic for Applications (VBA) in Excel - Introduction to programming Poznan, Garbary 100/63 Tue, 2017-05-23 09:00 3564PLN / 1691PLN
Oracle 12c – Język SQL dla analityków I - warsztaty Gdynia, ul. Ejsmonda 2 Tue, 2017-05-23 09:00 7920PLN / 3640PLN
Six thinking hats by Edward de Bono Gdańsk, ul. Powstańców Warszawskich 45 Thu, 2017-05-25 09:00 5148PLN / 1726PLN
Facebook in advertising and marketing Poznan, Garbary 100/63 Fri, 2017-05-26 09:00 1881PLN / 952PLN
Python Programming Szczecin, ul. Sienna 9 Mon, 2017-05-29 09:00 10000PLN / 4448PLN
Facebook in advertising and marketing Lublin, ul. Spadochroniarzy 9 Fri, 2017-06-02 09:00 1881PLN / 1002PLN
MongoDB for Administrators Kraków, ul. Rzemieślnicza 1 Tue, 2017-06-06 09:00 3861PLN / 2087PLN
Oracle 11g - Programming with PL / SQL I - Workshops Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2017-06-06 09:00 5990PLN / 2939PLN
Adobe Photoshop Elements Gdynia, ul. Ejsmonda 2 Wed, 2017-06-07 09:00 1881PLN / 1127PLN
Microsoft Office Excel - moduł Business Intelligence Gdynia, ul. Ejsmonda 2 Wed, 2017-06-07 09:00 2673PLN / 1391PLN
Adobe Photoshop Elements Gdańsk, ul. Powstańców Warszawskich 45 Wed, 2017-06-07 09:00 1881PLN / 1127PLN
Adobe InDesign Poznan, Garbary 100/63 Thu, 2017-06-08 09:00 1881PLN / 1027PLN
Design Patterns in C# Poznan, Garbary 100/63 Thu, 2017-06-08 09:00 3861PLN / 1830PLN
SQL Fundamentals Gdańsk, ul. Powstańców Warszawskich 45 Thu, 2017-06-08 09:00 3663PLN / 1610PLN
Visual Basic for Applications (VBA) in Excel - Advanced Warszawa, ul. Złota 3/11 Mon, 2017-06-12 09:00 3069PLN / 1623PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Gdynia, ul. Ejsmonda 2 Mon, 2017-06-12 09:00 3564PLN / 1891PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Opole, Wladyslawa Reymonta 29 Mon, 2017-06-12 09:00 5940PLN / 4230PLN
Spring and Hibernate in Java Applications Poznan, Garbary 100/63 Tue, 2017-06-13 09:00 7722PLN / 3358PLN
Drools Rules Administration Wroclaw, ul.Ludwika Rydygiera 2a/22 Wed, 2017-06-14 09:00 21196PLN / 7023PLN
Build applications with Oracle Application Express (APEX) Katowice ul. Opolska 22 Mon, 2017-06-19 09:00 9801PLN / 4720PLN
Front End Developer Rzeszów, Plac Wolności 13 Mon, 2017-06-19 09:00 23000PLN / 7970PLN
Creating and managing Web sites Poznan, Garbary 100/63 Mon, 2017-06-19 09:00 5841PLN / 2298PLN
Introduction to Selenium Warszawa, ul. Złota 3/11 Thu, 2017-06-22 09:00 1871PLN / 824PLN
Javascript And Ajax Rzeszów, Plac Wolności 13 Mon, 2017-06-26 09:00 5841PLN / 3655PLN
Introduction to Programming Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2017-06-26 09:00 5742PLN / 4121PLN
Implementation and Administration of Elasticsearch Wroclaw, ul.Ludwika Rydygiera 2a/22 Wed, 2017-06-28 09:00 20800PLN / 6903PLN
Effective interpersonal communication with elements of assertiveness Wroclaw, ul.Ludwika Rydygiera 2a/22 Thu, 2017-06-29 09:00 5148PLN / 1430PLN
Elasticsearch Advanced Administration, Monitoring and Maintenance Gdańsk, ul. Powstańców Warszawskich 45 Tue, 2017-07-04 09:00 17741PLN / 5876PLN
Nginx Setup, Configuration and Administration Bydgoszcz, ul. Dworcowa 94 Wed, 2017-07-05 09:00 6930PLN / 2850PLN
SQL Fundamentals Warszawa, ul. Złota 3/11 Mon, 2017-07-10 09:00 3663PLN / 1510PLN
SIP protocol in VoIP Poznan, Garbary 100/63 Mon, 2017-07-17 09:00 15929PLN / 5427PLN
Creating and managing Web sites Poznan, Garbary 100/63 Mon, 2017-09-25 09:00 5841PLN / 2298PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients