Excel 3 – Intermediate
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 how to create complex linked tables. Great emphasis will be placed on data security and protection and maintaining consistency of all input and output data. We will also provide you with a function to back-calculate input values according to the desired target values. Contingency tables and graphs will perfectly extract maximum context from your databases and provide new insights.
Content:
- Linking multiple sheets and workbooks
- Creating named areas
- Working with indirect links
- Extended filter
- Data summaries
- Verification of cell inputs and setting criteria
- Working with dynamic links to different areas
- Scenarios
- Solution search and advanced Solver
- Locking formulas, sheets and workbooks
- Contingency tables and charts
- Form elements in sheets
- Shared workbooks
- Hyperlinks
- Discussion
COURSE APPLICATION - Excel 3: Intermediate
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