Training on MS Excel Complete Course
- Date: 02/06/2021
- Time: 10:00 - 18:00
- Fee for EBA members:4500 UAH
- Early Registration for EBA members:4050 UAH till May 2
- Place: HUB 4.0 (Yaroslavskyi Lane, 1/3)
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.
- Business Analysts
- 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.
- Configuring the quick access user panel – adding buttons for Paste Special, Cell Selection, Filters, Dependencies, etc.
- Configuring the application interface
- Common keyboard shortcuts
Lookup and reference functions
- VLOOKUP, HLOOKUP, OFFSET and their variations to lookup precise and approximate values
- 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
- Transposing (rotating) tables using functions and paste special features
- Applying data validation to specific cells
- Creating drop-down menus
- Using passwords to differentiate user access to cells, worksheets and files
- How to use names in calculations. Creating and using named constants and ranges in calculations, navigating worksheets and cells using names
- IF, IFERROR
Working with text
- Text functions – LEFT, RIGHT, MID, LOOKUP
- Splitting text to columns
Working with big data
Importing data from database files
- How to organize data for a pivot table, creating and restructuring reports, various types of totals
- Creating and using pivot charts
- ROUND, COUNTIF, INDEX
- Using conditional formats to provide visual cues and lookup data errors
- Macros overview. Practical examples.
Case studies and tasks