Microsoft Excel Intermediate

Course code: MEXCELINT

The training is focused on commonly used Excel functions. It is intended for users who have already met Excel and can create a basic table with a simple calculation. Participants will learn about various procedures and tips to simplify creating and working with tables. Learn how to format cells according to a condition. They will discover how to use absolute references and cell and range names to advantage in formulas. On practical examples, they will try out the WHEN function and other useful functions for working with text, date and time. In various functions, they will try to connect several sheets. Students will become familiar with the rules for working with large tables, learn to move quickly in them, search in them, filter and group data. Participants will become familiar with the use of individual functions and tools in various situations.

and certified lecturers

recognized certifications

Wide range of technical
and soft skills courses

Great customer

Making courses
exactly to measure your needs

Course dates

Starting date: Upon request

Type: Virtual

Course duration: 2 days

Language: cz/sk

Price without VAT: 135 EUR


Starting date: Upon request

Place : Praha

Type: In-person

Course duration: 2 days

Language: cz/sk

Price without VAT: 150 EUR


Type Course
Language Price without VAT
Upon request Virtual 2 days cz/sk 135 EUR Register
Upon request Praha In-person 2 days cz/sk 150 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.


Course description

This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, visualize data with graphs.

Course structure

For individual and corporate training, it is possible to adapt the syllabus.

Completion and summary of basic concepts

  • keyboard shortcuts to facilitate work
  • menu Insert differently, Find and replace

Formatting tables

  • about inserting and removing cells, rows and columns
  • about hiding and showing rows and columns
  • about copying formats

Conditional Formatting

  • using the cell value
  • using the formula
  • quick styles in conditional formatting


  • basic mathematical operations
  • modification of the formula
  • quick formula check
  • about copying and moving formulas
  • relative and absolute addressing of cells ($A$1)
  • about entering more complex formulas
  • about naming cells and regions
  • about the effect of moves and copies in absolute addressing


  • about the use of basic functions and their display in the formula bar
  • about entering a function in a cell
  • editing formulas with functions


  • using basic functions and displaying them in the formula bar
  • entering a function in a cell
  • editing formulas with functions
  • IF function
  • selected functions from the Text, Date and Time category


  • about linking sheets, Microsoft Excel workbooks
  • about linking with Microsoft Word and Microsoft PowerPoint


  • automatic chart format – recommended charts
  • basic types of graphs
  • about creating and editing a chart

Database in Microsoft Excel

  • about basic concepts
  • the principles of working with data
  • about anchoring the partitions
  • about sorting data by value or format
  • automatic filter
  • about data grouping


  • print area
  • about repeating the header on each page
  • about advanced page appearance settings for printing


Knowledge of creating simple tables in Excel is assumed before the training.

Do you need advice or a tailor-made course?


product support

ComGate payment gateway MasterCard Logo Visa logo