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
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