Course code: MSEX2W16« Back

Microsoft Excel 2016/2013 – In Practice – Workshop

The course teaches users who already know the basics of working with spreadsheets how to make full use of its capabilities and create documents containing tables and charts to a professional standard. Participants are expected to have skills corresponding to Microsoft Excel - basic course. This course contains much more practical application of the subject and you will get more examples to try out.

Both versions will be installed in the classroom. Version 2016 will be used primarily, the older version can be also used, if needed.

Workshop This course is recommended to prepare for the ECDL certification Preparatory course for MOS certification
No terms found, contact our client service.

AffiliateDurationCatalogue priceHandbook priceITB
Praha3 7 200 CZK included in course price 0
Brno3 6 300 CZK included in course price 0
Bratislava3 240,00 EUR included in course price 0

User intensity level

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

  • Format/Cell command
  • Cell style
  • Conditional formatting


Automatic saving

Working with files and sheets


  • 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

Previous courses

Next courses

no following course
Příručka MS Excel 2016/2013 - praktické využití [Cz/Cz]

included in course price
The prices are without VAT.