Subsidized course „Jsem v kurzu“

Microsoft Excel – Advanced Course

Two-day course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge. The course focuses on the most common and the most useful functions, which are generally used while working with MS Office Excel.

Code
MEXCELP

Course length
2 days (8:30‐16:00)

Form
In our classroom or online

Main course tutor

Eliška Červenková

Eliška Červenková

Microsoft instructor

More about tutor

Dates

10/08/2024‐10/09/2024 Prague Free date 4 400 CZK
without VAT
Add to cart
12/12/2024‐12/13/2024 Prague Free date 4 400 CZK
without VAT
Add to cart
Buy with the subsidy program "Jsem v kurzu" 4 400 CZK 792 CZK
without VAT
Order on Integrated
MoLSA Portal  

This course is intended for

  • The course is intended for all common users who have already worked with MS Office Excel application and would like to extend their basic knowledge.
  • Methodology of education
  • Tutor’s explanation is accompanied by several practical examples, individual and group exercises on PC

Syllabus

Chapter 1: Advanced formatting

  • Keep the source formatting
  • Deleting format
  • Conditional formatting
  • Custom format

Chapter 2: Protecting workbook and worksheet

  • Cell protection
  • Protect sheet and protect workbook
  • Protecting the file by using password, encryption

Chapter 3: Advanced copy and paste options

  • Copy and paste options
  • Fill series using AutoFill
  • Possibilities of cooperation between MS Word and MS Excel

Chapter 4: Applying formulas in Excel

  • Principles of creating and using formulas
  • Relative and absolute references
  • How to quickly find the function, how to revise and edit a formula

Chapter 5: The most used functions

  • Logic functions
  • Text functions
  • Date and time functions
  • Math functions
  • Conditional calculations

Chapter 6: Analysing and organising data

  • Freeze panes, arrange and split windows
  • Data validation
  • Sorting
  • Filtering
  • Creating an outline, group and ungroup rows and columns
  • Converting text to a table
  • Printing large data

Chapter 7: Creating reports and statements using pivot table

  • Principles and using of pivot table
  • Creating and changing pivot table
  • Creating and changing pivot chart

Students will be able to

  • Using advanced formulas and functions
  • Using formulas with values that match your conditions (functions: countif, sumif)
  • Effectively insert the copied values according to given criterias
  • Organise, filter and sort large data
  • Create reports and statements, aggregate data for the relevant period or category and print them

Course requirements

Hardware

Spacious classrooms are equipped with premium computers with the access to the Internet, the wireless access included.

Literature

The workbook in English language is included.

PDF to download

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.

Similar courses

Take a look at some similar courses from our wide range.

New course

Microsoft Word – Creation of Templates MWORDS


2 900 CZK Course detail
New course

Microsoft Excel – Workshop MEXCELW


2 900 CZK Course detail

Microsoft Word – Basic Course MWORDZ


2 200 CZK Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.