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 TrainingExcel in Data Analysis Training

Excel in Data Analysis Training


Will Excel in Data Analysis Training be suitable for me?

 

The Excel in Data Analysis Training is for those who:

  • know the basics of Microsoft Excel,
  • use Excel in everyday work as a tool for data analysis and want to improve their knowledge of the advanced MS Excel tools,
  • work with large volume of data and want to improve such work with advanced tools,
  • want to get to know the possibilities of complex analysis and presentation of data.

 

After the Excel in Data Analysis Training you will know how to:

  • efficiently use the Excel functions and tools
  • use date and time functions, text functions, information and statistical functions for data analysis,
  • use formatting to highlight data containing specific values,
  • perform data lookup with advanced sorting tools and filter,
  • set a workbook and spreadsheet protection at different protection levels,
  • create a pivot table and use it for data processing.

 


 

 

 

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 in Data Analysis Training programme

Review of Excel basics

  • inserting, modification and deleting data,
  • data series,
  • font parameters, aligning and framing,
  • format painter,
  • correct formatting - numeric, currency, percentage, text and date format

Application of MS Query tools

  • introduction to selected elements of relational database,
  • filtering and joining data from various tables within queries

Data analysis with functions

  • logical functions - IF, OR, AND,
  • statistical and mathematical functions - COUNTIF, SUMIF, COUNTIFS,
  • lookup and reference functions - VLOOKUP, HLOOKUP, INDEX, MATCH,
  • date and time functions – TODAY, DAY, MONTH, YEAR, WEEKDAY, NETWORKDAYS, WORKDAY,
  • text functions - LEFT, RIGHT, MID, LEN, UPPER, LOWER, TRIM, PROPER,
  • function nesting

Key analytical tools

  • conditional formatting,
  • advanced sorting options,
  • auto-filter and non-standard filter,
  • protection and verification of data,
  • subtotals,
  • merging data from multiple spreadsheets,
  • consolidation of data,
  • application of Search results tool

Pivot tables

  • creating pivot tables,
  • data refresh,
  • change of calculating functions,
  • grouping data by values, dates,
  • filtering and sorting in pivot tables,
  • grouping data in pivot tables,
  • calculated fields and elements,
  • pivot table with external data,
  • examples: sales report, ageing of receivables, logistics report

Advanced charts – visualisation of data

  • presentation of data sorted by orders of magnitude,
  • rules of selection of charts, types of charts,
  • creating complex charts,
  • changing the data scope,
  • advanced settings – change of colours, layout and scale,
  • detailed settings of chart data,
  • adding graphic objects to charts,
  • graph with two axes,
  • trend line.

Registration, activation and editing macros.
Printing.

 

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 godzin lekcyjnych / 2 dni
Price per person:1480 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Training
Program (PDF)

Selected clients: