Close
Skip to content
Home
Educational programs
Our references
Administrative services
Contact
Menu
Home
Educational programs
Our references
Administrative services
Contact
Select the desired program:
MS Excel
Basic module
Basic functionalities
What is covered
Getting to know Excel
New workbook
Saving and opening workbooks
Data entry and formatting
Deleting and correcting data
Cell labeling
Editing and printing tables
Editing rows and columns
Data and formula management
Copying and moving data
Basic formulas
Copying and moving formulas
Absolute and relative addressing
Number formats and date formats
Creating and editing graphs
Headers and footers
Keyboard shortcuts
Who is it intended for
Participants without knowledge of working with MS Excel
Participants who occasionally use MS Excel
What you will learn
How to use basic functionalities available in the MS Excel interface
How to use basic formulas and functions for data processing
Module structure
Duration:
12 h (6 x 2 h)
Practical part (exercises):
Yes
Exam:
Per agreement
Certificate:
Yes
Advanced module
Formulas and conditional commands
What is covered
Use of functions
Mathematical functions
Rounding numbers
Statistical functions
VLOOKUP and XLOOKUP functions
MATCH function
Logical functions
IF function
Conditional functions SUMIF and COUNTIF)
Calculating with dates
Date and time functions
Text processing functions
Conditional cell formatting
Value dependent cell formatting
Conditional formatting
Data validation
Who is it intended for
Participants with basic knowledge of working with MS Excel
Participants who actively use formulas and functions for data processing
What you will learn
How to use advanced formulas and functions for data processing
How to independently perform more complex calculations and interpret their results
Module structure
Duration:
16 h (8 x 2 h)
Practical part (exercises):
Yes
Exam:
Per agreement
Certificate:
Yes
Expert module
Databases and pivot tables
What is covered
Databases in Excel
Advanced mathematical functions
Data sorting
Data filtering
Filtering by setting criteria
Advanced filtering
Subtotals
Data arrays
Database processing functions
Pivot tables
Creating and working with pivot tables
Data grouping in pivot tables
Value fields in pivot tables
Slicers in pivot tables
Timeline in pivot tables
Pivot charts
Who is it intended for
Participants who know how to perform more complex calculations on their own
Participants who use databases in their work
What you will learn
How to use functions and options for processing databases
How to create and manage reports using pivot tables
Module structure
Duration:
16 h (8 x 2 h)
Practical part (exercises):
Yes
Exam:
Per agreement
Certificate:
Yes