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 in Sales Analysis Training

Excel in Sales Analysis Training


Will the Excel in Sales Analysis Training be suitable for me?


The Excel in Sales Analysis Training is for those who:

  • want to speed up and improve their work and enhance their knowledge,
  • manage or work in a sales department,
  • want to optimise time required do prepare analyses of processes and costs.

 

 

After the Excel in Sales Analysis Training You will know how to:

  • solve analytical and optimisational problems with sales,
  • create models  calculating costs, proces and profit and implement useful functions and tools of MS Excel,
  • create pivot tables 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 in Sales Analysis Training programme

MS Excel Data import methods

  • importing data from text files, databases and websites,
  • import and analysis of data imported from text files, usage of proper text string processing tools.

Applications of the MS Query tool

  • introduction of selected elements of relational databases,
  • data filtering and joining  content from multiple tables within a query.

Formulas and functions

  • relative and absolute references,
  • the ABC classification – usage of mathematical and statistical functions,
  • logical functions,
  • Lookup and referrence functions,
  • date and time functions, text functions,
  • combining several functions into one – function nesting.

Working with multiple workbooks and worksheets and linking them together

Data analysis and lookup

  • displaying the dynamics of changes in ascending order – sorting changing the order of sorting, advanced options,
  • a sales analysis performed according to different criteria - an autofilter and a custom filter,
  • the find and replace command,
  • building a multi-variant models with scenarios.

Goal seek and solver

  • seeking the markup on a retail price to reach a planned profit level,
  • seeking the optimal price growth indicator for the approppriate profit level,
  • optimisation of product prices,
  • optimisation of transport costs,
  • optimisation of marketing expeditures.

Pivot tables – a tool for enterprose performance analysis

Charts – diagrammatic representation of financial data

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: