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

Course code:

Date of the course:

Time of the course:

Course Application

"*" indicates required fields

Red Triangle
White Triangle

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

About the course
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

About the course
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

About the course
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

About the course
Č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

About the course
Load more