Course code: MSEX2« Back

Microsoft Excel – In Practice

This course is assigned for users, who already work with Microsoft Excel on basic level. We will teach you to fully employ its possibilities and create documents with tables and graphs on a professional level. It is assumed that you already know Microsoft Excel on “Microsoft Excel - basic course” level.

This course is recommended to prepare for the ECDL certification This course was updated Preparatory course for MOS certification
 DateDurationCourse priceHandbook priceCourse languageLocation 
GTK 10/1/2019 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
10/3/2019 2 4 800 CZK included in course price Anglický jazyk GOPAS Praha
 
GTK 10/10/2019 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
GTK 10/22/2019 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
10/31/2019 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
11/12/2019 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
11/21/2019 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
1/7/2020 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
2/3/2020 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
GTK 2/27/2020 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
3/16/2020 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
GTK 4/22/2020 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
GTK 5/28/2020 2 4 800 CZK included in course price Český jazyk GOPAS Praha
 
10/8/2019 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
GTK 10/24/2019 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
11/7/2019 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
11/19/2019 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
12/3/2019 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
1/20/2020 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
3/5/2020 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
4/16/2020 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
5/21/2020 2 4 200 CZK included in course price Český jazyk GOPAS Brno
 
10/7/2019 2 160,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
11/11/2019 2 160,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 
12/5/2019 2 160,00 EUR included in course price Slovenský jazyk GOPAS Bratislava
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 4 800 CZK included in course price 0
Brno2 4 200 CZK included in course price 0
Bratislava2 160,00 EUR included in course price 0

Who is the course for

This course is assigned for users with basic knowledge in Microsoft Excel.

What we teach you

You learn how to fully employ Microsoft Excel in practice.

Required skills

Microsoft Excel - basic course.

Teaching methods

Professional explanation with practical samples and examples.

Teaching materials

GOPAS guide book for this course.

Course Outline

Formatting cells

  • Cell style
  • Conditional formatting

Template

Automatic saving

Working with files and sheets

Copying

  • Series
  • Using clipboard with Paste options

Creating formulas

  • Inserting formulas rules
  • Absolute addressing
  • Naming of regions

Insert function wizard

  • Examples of different types of functions

Databases and working with large tables

  • Windows, panes, splitting
  • Forms
  • Validation
  • Find, Replace, Go To
  • Sorting
  • Large tables printing options

Filters and working with lists

  • AutoFilter and advanced filter

Managing databases accessories

  • Text decomposition to columns
  • Outlining, Grouping, Subtotals, Consolidation
  • Pivot tables

Formatting charts

Příručka Microsoft Excel – praktické využití [2019] [Cz/Cz]

Price:
included in course price
Příručka Microsoft Excel - praktické využití [2019] [Sk/Sk]

Price:
included in course price
The prices are without VAT.