fbpx
Size of letters 1x
Site color
Image
Additionally
Line height
Letter spacing
Font
Embedded items (videos, maps, etc.)
 

Training: MS Excel – Everything You Need to Know for Successful Work with Data (advanced level)

  • Date: 20/02/2019 (WED)
  • Language: Russian
  • Time: 10:00 - 17:00
  • Ticket:2500 UAH for EBA members (2125 UAH till 20 January)
Place:

EBA Kyiv Office, 1A Andriyivskiy Uzviz

Google Apple Outlook Telegram Bot
  Training: MS Excel – Everything You Need to Know for Successful Work with Data (advanced level). Date: 20 February2019. Time: 10:00 17:00. Language: Russian. Ticket: 2500 UAH for EBA members (2125 UAH till 20 January). Place: EBA Kyiv Office, 1A Andriyivskiy Uzviz. The Registration is Closed. The main problem of the modern business world is the need to work with huge volumes of information. EBA Management Development Centre Team together with EY Academy of Business Ukraine invite you to join the Training: MS Excel - Everything You Need to Know for Successful Work with Data (advanced level). During the training the expert will share his years of experience of a successful work with MS Excel program.  Trainer: Vyacheslav Syrotkin, EY Academy of Business Ukraine, trainer-consultant. Partner: EY Academy of Business Ukraine Target Audience: - Advanced specialists and company managers - Specialists working with large volumes of data Syllabus: Сombined tables (Pivot Table) Creating and updating Pivot Table Displaying and filtering data Applicative aspects of work with Pivot Table Working with macros The concept of macro Algorithm of macros writing Entering correction and removing macro Assignment of the file Personal.xlsb Writing macros for formatting \ displaying data Working with blocks of data Autosave - advantages and disadvantages Automatic formulas re-count - the pros and cons The means of reducing the file size Building Pivot Table from MS Access Target audience. Registration is obligatory. To become a participant, please, click the “Register” button. Only the users of the EBA site can register at the event. Number of listeners is limited. Should you have any questions, please, write at [email protected] or call (044) 496-06-01.Trainers. Vyacheslav Syrotkin. EY Academy of Business Ukraine, trainer-consultant. You can send a question to:. Contact person:. Liliya Yamborak. E-mail [email protected]. Contact Phone. +38 044 496 06 01.

The Registration is Closed.

The main problem of the modern business world is the need to work with huge volumes of information.

EBA Management Development Centre Team together with EY Academy of Business Ukraine invite you to join the Training: MS Excel – Everything You Need to Know for Successful Work with Data (advanced level). During the training the expert will share his years of experience of a successful work with MS Excel program. 

Trainer: Vyacheslav Syrotkin, EY Academy of Business Ukraine, trainer-consultant.

Partner: EY Academy of Business Ukraine

Target Audience:

– Advanced specialists and company managers

– Specialists working with large volumes of data

Syllabus:

Сombined tables (Pivot Table)

  • Creating and updating Pivot Table
  • Displaying and filtering data
  • Applicative aspects of work with Pivot Table

Working with macros

  • The concept of macro
  • Algorithm of macros writing
  • Entering correction and removing macro
  • Assignment of the file “Personal.xlsb”
  • Writing macros for formatting \ displaying data

Working with blocks of data

  • Autosave – advantages and disadvantages
  • Automatic formulas re-count – the pros and cons
  • The means of reducing the file size
  • Building Pivot Table from MS Access Target audience.

Registration is obligatory. To become a participant, please, click the “Register” button. Only the users of the EBA site can register at the event. Number of listeners is limited. Should you have any questions, please, write at [email protected] or call (044) 496-06-01.

Trainers

1 / 1
Vyacheslav Syrotkin
EY Academy of Business Ukraine, trainer-consultant
Vyacheslav Syrotkin

You can send a question to:

Contact person:

Liliya Yamborak

Contact
+38 044 496 06 01

Partners

Registration
First name
E-mail
Your expectations from the training
Register If your company is already a member of the EBA and you have a personal cabinet / or want to create it, please follow the link.
Close - 1
Register
Register
Close

Spelling error report

The following text will be sent to our editors: