Excel 4 – Upper Advanced
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price
Upon request
Course type:
Online
Course intended for:
Course information:
We will teach you to work with data from a bigger perspective and look at it in a more systemic way. We will deepen your knowledge of working with contingency tables and graphs. Of interest will be iterative recalculations using cyclical links.
Content:
- Selected features for data cleaning
- Selected text functions
- Creating named areas
- Working with dynamic links to different areas
- Selected mathematical functions
- Selected search functions
- Merging data from multiple sheets
- Import data from external sources
- Advanced work with graphs
- Tables
- Data grouping
- Data tabulation
- Advanced work with contingency tables
- Mini graphs
- Using cyclic links for iterative recalculations
- Selection of useful aids
COURSE APPLICATION - Excel 4: Upper Advanced
Course code:
Date of the course:
Time of the course:
Course Application
"*" indicates required fields
Safety Management / Basics of OSH System
Introduction to the basic concepts of OHS in terms of setting up a safety system/process.
10.12.2024,
Course date:
10.12.2024
Scope:
1 day / 8 hours
Price:
4,340 CZK + VAT
Basics of Lean Manufacturing
We will teach you to take advantage of opportunities to increase the productivity of individual workplaces or processes and to think in the spirit of lean manufacturing.
19.11.2024,
Course date:
19.11.2024
Scope:
1 day / 8 hours
Price:
4,340 CZK + VAT
8D Report – Complaint Resolution Tool
Learn the 8D report methodology to continuously improve the quality of products and processes in your plants.
08.10.2024,
Course date:
08.10.2024
Scope:
1 day / 8 hours
Price:
4,340 CZK + VAT
Management Skills: 5-Day Course
Development of soft and management skills. Emphasis will be placed on the transfer of acquired knowledge into practice.
02.10.2024, 03.10.2024, 12.11.2024, 13.11.2024, 03.12.2024,
Course date:
2.-3.10., 12.-13.11.2024, 3.12.2024
Scope:
5 days / 40 hours
Price:
27,220 CZK + VAT
ČSN EN ISO 14001 – Introduction to the Standard
The ISO 14001 standard specifies the requirements for an environmental management system (EMS). The basic content of the standard is environmental protection and pollution prevention.
Course date:
21.5.2024
Scope:
1 day / 8 hours
Price:
4,340 CZK + VAT