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

Training on MS Excel Complete Course

Google Apple Outlook Telegram Bot
  Training on MS Excel Complete Course. Date: 04 November2021. Time: 10:00 18:00. Place: Osvitoria HUB. The training is created for professionals with basic experience in MS Excel and based on many years of practical experience. All the tools are carefully selected for solving typical business problems. Nothing superfluous - just what can be used in practice with maximum results. You will get ready-made solutions for use in everyday practice and will master a wide range of MS Excel tools that will give you the opportunity to find fast and effective solutions for successful business tasks. EBA Management Development Centre together with PwC Academy invite you to join the Training on MS Excel Complete Course. During the training each participant will get: Knowledge and tools for working with MS Excel. Practical skills required for more efficient work with MS Excel. Target audience: Business Analysts Accountants Financial Controllers Specialists who work with big data and big volume of information Professionals from various functional areas using MS Excel on a basic level in their daily tasks and looking for the next-level skills using various tools and solutions Trainer: Denys Shashkov, a trainer with many years of experience in both teaching and business modeling and business evaluation engagements, has experience in consulting where he was responsible for developing MS Excel models for management accounting, business evaluation, performance management. Syllabus: Settings Configuring the quick access user panel - adding buttons for Paste Special, Cell Selection, Filters, Dependencies, etc. Configuring the application interface Keyboard shortcuts Common keyboard shortcuts Lookup and reference functions VLOOKUP, HLOOKUP, OFFSET and their variations to lookup precise and approximate values Error detection Tracing calculations, step by step evaluation of formulas, error processing functions, circular references Conditional sum functions Using SUMIF, SUMIFS functions to sum based on one or multiple conditions Transpose feature Transposing (rotating) tables using functions and paste special features Data validation Applying data validation to specific cells Creating drop-down menus Protection Using passwords to differentiate user access to cells, worksheets and files Names How to use names in calculations. Creating and using named constants and ranges in calculations, navigating worksheets and cells using names Logical functions IF, IFERROR Working with text Text functions - LEFT, RIGHT, MID, LOOKUP Splitting text to columns Working with big data Importing data from database files Pivot tables How to organize data for a pivot table, creating and restructuring reports, various types of totals Pivot charts Creating and using pivot charts Other functions ROUND, COUNTIF, INDEX Conditional formatting Using conditional formats to provide visual cues and lookup data errors Macros Macros overview. Practical examples. Case studies and tasksTrainers. Denis Shashkov. Trainer with many years of experience in both teaching and business modeling and business evaluation engagements, has experience in consulting where he was responsible for developing MS Excel models for management accounting, business evaluation, performance management. You can send a question to:. Contact person:. Anna Ovdii. E-mail [email protected]. Contact Phone. 067 406 65 40.

The training is created for professionals with basic experience in MS Excel and based on many years of practical experience. All the tools are carefully selected for solving typical business problems. Nothing superfluous – just what can be used in practice with maximum results. You will get ready-made solutions for use in everyday practice and will master a wide range of MS Excel tools that will give you the opportunity to find fast and effective solutions for successful business tasks.

EBA Management Development Centre together with PwC Academy invite you to join the Training on MS Excel Complete Course.

During the training each participant will get:

  • Knowledge and tools for working with MS Excel.
  • Practical skills required for more efficient work with MS Excel.

Target audience:

  • Business Analysts
  • Accountants
  • Financial Controllers
  • Specialists who work with big data and big volume of information
  • Professionals from various functional areas using MS Excel on a basic level in their daily tasks and looking for the next-level skills using various tools and solutions

Trainer: Denys Shashkov, a trainer with many years of experience in both teaching and business modeling and business evaluation engagements, has experience in consulting where he was responsible for developing MS Excel models for management accounting, business evaluation, performance management.

Syllabus:

Settings

  • Configuring the quick access user panel – adding buttons for Paste Special, Cell Selection, Filters, Dependencies, etc.
  • Configuring the application interface

Keyboard shortcuts

  • Common keyboard shortcuts

Lookup and reference functions

  • VLOOKUP, HLOOKUP, OFFSET and their variations to lookup precise and approximate values

Error detection

  • Tracing calculations, step by step evaluation of formulas, error processing functions, circular references

Conditional sum functions

  • Using SUMIF, SUMIFS functions to sum based on one or multiple conditions

Transpose feature

  • Transposing (rotating) tables using functions and paste special features

Data validation

  • Applying data validation to specific cells
  • Creating drop-down menus

Protection

  • Using passwords to differentiate user access to cells, worksheets and files

Names

  • How to use names in calculations. Creating and using named constants and ranges in calculations, navigating worksheets and cells using names

Logical functions

  • IF, IFERROR

Working with text

  • Text functions – LEFT, RIGHT, MID, LOOKUP
  • Splitting text to columns

Working with big data

Importing data from database files

Pivot tables

  • How to organize data for a pivot table, creating and restructuring reports, various types of totals

Pivot charts

  • Creating and using pivot charts

Other functions

  • ROUND, COUNTIF, INDEX

Conditional formatting

  • Using conditional formats to provide visual cues and lookup data errors

Macros

  • Macros overview. Practical examples.

Case studies and tasks

Trainers

1 / 1
Denis Shashkov
Trainer with many years of experience in both teaching and business modeling and business evaluation engagements, has experience in consulting where he was responsible for developing MS Excel models for management accounting, business evaluation, performance management
Denis Shashkov

You can send a question to:

Contact person:

Anna Ovdii

Contact
067 406 65 40

Partners

Registration
First name
E-mail
Please, confirm your tel number
Training will be paid by
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 - 2
Training will be paid by
Register
Register
Close

Spelling error report

The following text will be sent to our editors: