Project

Keeping Up with the Times – IT Knowledge

GINOP Plusz-3.2.1-21

As part of our project, we plan to implement training programs focused on ICT knowledge. In line with the objectives of the project, our goal is to develop the knowledge and competencies of our employees, thereby laying the foundation for improving our operations and productivity.

Beneficiary name: IRON-TECH Kereskedelmi, Szolgáltató és Gyártó Kft.
Development objective: Improving the adaptability and productivity of employees and companies through workforce development.

Grant amount:

Training cost support: up to 2,160,000 HUF
Wage subsidy for lost working hours: up to 1,500,000 HUF
Project management costs: up to 175,000 HUF

Support intensity: 50%
Planned completion date of the training: 22.11.2023
Project identification number: BAM/01/001064-3/2023

Presentation of the Training Programs Implemented Within the Projects:

KEEPING UP WITH THE TIMES – IT KNOWLEDGE

EXCEL FILTERING (ADVANCED 1.)

Training objective:
The aim of the course is to familiarize participants with the use of one of the most frequently used Microsoft Office programs, enabling them to edit and work with spreadsheets while enhancing their digital and ICT skills. The training specifically focuses on demonstrating the filtering capabilities in Excel and mastering advanced filtering operations to ensure more effective and proficient user competence.

Training content:

Sorting data based on multiple columns
Custom sorting
Filtering by data type:
- Date filter
- Number filter
Text filter
Filtering by color
Creating queries using a single condition
Creating queries using multiple conditions
Advanced queries and filter settings
Using the FILTER function (Microsoft 365)
Practical exercises

EXCEL FUNCTIONS (ADVANCED 2.)

Training objective:
The aim of this course is to familiarize participants with the use of one of the most frequently used Microsoft Office programs, enabling them to edit and work with spreadsheets while enhancing their digital and ICT skills. The training specifically focuses on demonstrating the application of Excel functions and mastering their advanced use to ensure more efficient and high-level user competence.

Training content:

Mathematical functions
Statistical functions
Date and time functions
Logical functions
Financial functions
Matrix functions
Database functions
Text functions
Using the FILTER function (Microsoft 365)
Nested functions
Practical exercises

EXCEL PIVOT TABLES (ADVANCED 3.)

Training objective:
The aim of this course is to familiarize participants with the use of one of the most frequently used Microsoft Office programs, enabling them to edit and work with spreadsheets while enhancing their digital and ICT skills. The training specifically focuses on demonstrating the application of pivot tables in Excel and mastering their advanced use to ensure more efficient and high-level user competence.

Training content:

Grouping data in pivot tables
Creating pivot tables with predefined field names
Displaying and grouping data in pivot tables
Basic filtering of pivot tables
Using slicers and timelines
Pivot charts, trendlines, and forecasting, including formatting options
Pivot table tricks:
- Value summarization options
- Number formatting
- Field names
- Order modification
- Displaying values
- Column width adjustments
Practical exercises