Course code: MSEX213« Back

Microsoft Excel 2013 – 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 training is replaced by training MSEX216 from autumn 2016.

This course is recommended to prepare for the ECDL certification Preparatory course for MOS certification This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

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

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

  • 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 MS Excel 2013 - praktické využití [Cz/Cz]

Price:
included in course price
Příručka MS Excel 2013 - praktické využití [Cz/En]

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

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