Microsoft Excel – In Practice

Complete this course and get 90 days access to practice in e-learning version for free. You can choose the e-learning course in Czech, Slovak or English. This course is assigned for users, who already work with Microsoft Excel on basic [...]

MSEX2
Duration 2 days
0 ITK points
15 terms
Praha (4 800 Kč)

Brno (4 800 Kč)

Bratislava (200 €)
Beginner

Complete this course and get 90 days access to practice in e-learning version for free. You can choose the e-learning course in Czech, Slovak or English. 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 assigned for users with basic knowledge in Microsoft Excel.

You learn how to fully employ Microsoft Excel in practice.

Microsoft Excel - basic course.

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

Download PDF detail
Download PDF detail (no terms)

The prices are without VAT.

29.05.2025