Ten serwis używa plików cookies. Brak zmiany ustawień przeglądarki oznacza zgodę na ich używanie.
Więcej informacji o plikach cookies znajdziesz tutaj
Kliknij ZGADZAM SIĘ, aby ta informacja nie wyœwietlała się ponownie
Cognity.pl
You are here: home pageExcel Thematic TrainingExcel Training for Financiers and Accountants

Excel Training for Financiers and Accountants


Will the Excel Training for Financiers and Accountants be suitable for me?


The Excel Training for Financiers and Accountants is for those who:

  • are familiar with the basics of the Microsoft Excel,
  • mostly process financial data,
  • want to learn about financial analysis and creation of complex model enabling them to make decisions based on accurate and reliable data,
  • want to optimise time necessary to prepare analyses of processes and costs.

 

 

After the Excel Training for Financiers and Accountants you will know how to:

  • make use of practical knowledge about functions and tools of the MS Excel spreadsheet useful while creating solutions for analytical and optimisation-related problems in finance and accounting,
  • create cost-, price-, and profit-calculating models and make use of valuable tools of  the MS Excel spreadsheet,
  • work with multiple workbooks and worksheets and link them,
  • create a chart and a pivot table and use their capabilities in data analysis.

 

 

 

What makes us different from other training companies?

 

 

Training needs surveys

Before training, we ask you to specify your expectations and analyse your needs. This way, our trainer will be able to suggest the most suitable kind of training for you and modify the programme according to your needs.

 

 

Training materials

As a participant of our training, you will receive a complete set of carefully developed training materials including:

  • A reference book discussing the issues covered by the training and providing a "step-by-step" description of the respective exercises,
  • Unlimited electronic access to exercises and training materials within the framework of the Cognity Knowledge Zone.

 

Certificate

Having completed a training course, you will receive a certificate confirming the qualifications you gained. The back side of the certificate lists the programme of your training. Cognity certificates are issued pursuant to an entry in the Register of Training Institutions (no. 2.12/00106/2011).

 

 

The comfort of learning

In order to ensure optimum learning conditions, we organise training courses in small groups of no more than 10 participants. We will prepare an individual computer station for you, too.

 

 

Post-training assistance

Having completed our training course, you will be offered the assistance of our trainer. If you have any doubts or questions concerning the subject-matter of your training, you can call us, e-mail us or arrange a personal meeting (in our company) with the trainer, who will be at your service.

 

 

No matter where you choose to have your training...

We offer, as extra service, assistance in finding the right accommodation or restaurant for you and we can organise other attractions as well.


Training courses include lunch and coffee breaks.

Excel Training for Financiers and Accountants programme

Quick review of the Excel basics

  • proper data input rules - number, currency, percentage, text and date formats,
  • filling cells with data series,
  • the format painter,
  • keyboard shortcuts.

Protection of a workbook and a worksheet

  • protecting workbooks and worksheets,
  • protecting file with a password,
  • validation of the entered data.

Processing data with functions:

  • errors in VAT invoices and ways to avoid them,
  • using worksheet functions to create a formula,
  • using proper cell references,
  • using references in formula tables,
  • comparisons and seeking differences between records,
  • mathematical, logical and database functions, operations on dates,
  • financial functions,
  • approximations as a tool for a proper cost calculation.

Statistical data analysis

Importing data from external sources

  • from text files,
  • from databases,
  • from internet websites,
  • from XML files,
  • application of the MS Query tool.

Text processing

  • text functions - LEFT, RIGHT, MID, LEN, UPPER, LOWER, TRIM, PROPER,
  • the Text to Columns tool.

Working with multiple workbook and sheets

  • linking workbooks
  • consolidating data from various worksheets

Multi-level data grouping

Financial forecasting

Building multi-variant models with scenarios

Data search and analysis

  • capturing fluctuations within the data and its cumulative summary – sorting, changing the order of sorting, advanced options,
  • sales analysis according to various criteria – the auto-filter and the custom filter,
  • the change/replace dialog.

Optimisation of complex problems with the Solver tool. The Goal Seek tool

The pivot table as an advance tool of the analysis of enterprise activities

Charts – financial data visualisation

Day 1

Schedule       Time
Registration 9:00 - 9:15
Classes 9:15 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

 

Day 2

Schedule         
Time
Classes 9:00 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

Upcoming dates

DurationNet:16 lesson units / 2 days
Price per person:1480 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Training
Program (PDF)

Selected clients: