Excel 2 – Lower Intermediate
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price
Upon request
Course type:
Online
Course intended for:
Course information:
You will learn how to compose tables from a variety of other sources with an emphasis on data consistency. Your spreadsheets will be able to change colours themselves according to different conditions. You will learn to work effectively with large databases. You will also master working with comments and advanced methods of setting up printing.
Content:
- Custom special cell formats
- Cell styles – built-in and custom
- Insert differently – different options for inserting the contents of the clipboard
- Selected logic functions
- Selected mathematical functions
- Selected information functions
- Selected search functions
- Selected text functions
- Mutual combination of several functions
- Using partitions to work with large tables
- Efficiently control of displaying multiple windows on a single screen
- Working areas
- Conditional formatting
- Compatibility with older versions of Excel
- Comments in cells and their settings relative to print
- Row and column header repeat print settings
COURSE APPLICATION - Excel 2: Lower Intermediate
Contact form
"*" indicates required fields
FMEA – Analysis of Possible Methods and Effects
FMEA analysis is one of the basic methods of risk management and is intended…
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
Quality Manager
Počet účastníků:
5-15 osob
Rozsah:
5 dní / 40 hodin
Cena:
Na vyžádání
APQP – pokročilé plánování kvality produktu
In addition to control planning, participants will learn the theoretical principles of IATF 16949,…
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
PPAP – Mass Production Part Approval Process
Basic PPAP rules to help you process your first sample report correctly and efficiently.
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
ČSN EN ISO 9001 – Training of Internal Auditors
Get an overview of ISO 9001 requirements and approach them from an internal auditor’s perspective.
Number of participants:
4 - 8 persons
Scope:
2 days / 16 hours
Price:
Upon request
IATF 16949 – Training of Internal Auditors
Get an overview of the planning, preparation, execution and evaluation of internal audits.
Number of participants:
4 - 8 persons
Scope:
3 days / 24 hours
Price:
Upon request
VDA 6.3 – Introduction to the Standard
Introduction to the individual requirements of VDA 6.3 (potential analysis P1 / catalogue of questions…
Number of participants:
4 - 12 persons
Scope:
2 days / 16 hours
Price:
Upon request
Formel Q – Introduction to the Requirements
We will introduce you to VW’s supplier requirements with a link to the system and production…
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
Formel Q – SL Supplier Self-Audit
We will help you set up self-audit processes according to the requirements of VW…
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
Formel Q – D/TLD Audit
The Formel Q-D/TLD (quality audit) is a specific process audit for safety parts, which results…
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
Basics of Metrology
Focus on the basic principles and rules of the metrology process.
Number of participants:
4 - 12 persons
Scope:
1 day / 8 hours
Price:
Upon request
ČSN EN ISO 14001 – Introduction to the Standard
The ISO 14001 standard specifies the requirements for an environmental management system (EMS). The…
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…
Scope:
5 days / 40 hours
Price:
27,220 CZK + VAT
Technická čistota
Počet účastníků:
5-15 osob
Rozsah:
5 dní / 40 hodin
Cena:
Na vyžádání
Interní auditor
Počet účastníků:
5-15 osob
Rozsah:
5 dní / 40 hodin
Cena:
Na vyžádání
Management skills
Počet účastníků:
5-15 osob
Rozsah:
5 dní / 40 hodin
Cena:
Na vyžádání
LEAN Management: Basics of Lean Manufacturing I.
Počet účastníků:
5-15 osob
Rozsah:
5 dní / 40 hodin
Cena:
Na vyžádání
LEAN Management: Basic of Lean Manufacturing II.
Počet účastníků:
5-15 osob
Rozsah:
5 dní / 40 hodin
Cena:
Na vyžádání
Safety Management / Basics of OSH System
Introduction to the basic concepts of OHS in terms of setting up a safety system/process.
Number of participants
4 - 12
Scope:
1 day / 8 hours
Price:
Upon request
Basic Tools and Methods for Quality Improvement
Master a set of quality tools and methodologies that lead to continuous system/process improvement.
Number of participants
4 - 12
Scope:
1 day / 8 hours
Price:
Upon request
Basics of Lean Manufacturing
We will teach you to take advantage of opportunities to increase the productivity of…
Number of participants
4 - 12
Scope:
1 day / 8 hours
Price:
Upon request
ČSN EN ISO 9001 – Introduction to the Standard
This is a standard (ISO 9001) specifying the requirements for a quality management system.
Number of participants
4 - 12
Scope:
1 day / 8 hours
Price:
Upon request
8D Report – Complaint Resolution Tool
Learn the 8D report methodology to continuously improve the quality of products and processes…
Scope:
1 day / 8 hours
Price:
Upon request
Safety Management / Basics of OSH System
Introduction to the basic concepts of OHS in terms of setting up a safety system/process.
Scope:
1 day / 8 hours
Price:
4,340 CZK + VAT
