Excel – advanced

  • 13 October 2023
    9:00 AM – 4:00 PM
  • Computer agency o.p.s., NOSRETI administrative building, Křenová 409/52, 2nd floor, 602 00 Brno
  • The event has already taken place

RMU employees only

The Excel for advanced users workshop will streamline how users work with Excel and extend it with more complex formulas and functions. The workshop already assumes that the user is familiar with the program and has automated the basics of its operation.


  • expansion of basic functions and their efficient use
  • absolute and relative referencing and their use in formulas ($ dollars)
  • conditional formatting and its use
  • conditional functions =IF(), =SUMIF(), =COUNTIF()
  • filtering and sorting data
  • contingency table basics


  • You will make your work more efficient.
  • You will be able to use more complex formulas.
  • You will be able to automate your work with Excel.
  • You will apprehend when using more complex formulas and functions is appropriate.
  • You will practice your new knowledge with plenty of examples.


Ing. Marek Rozehnal


Marek Rozehnal studied at the Faculty of Economics and Administration of Masaryk University. He has been training MS Office products for ten years, specializing in more complex operations in the Excel environment. Now, he works as a CEO in an international company and teaches to make his work more enjoyable.

Computer Agency o.p.s.

Practical information

Computers with MS Excel will be available for workshop participants at the venue.


Computer agency o.p.s., NOSRETI administrative building, Křenová 409/52, 2nd floor, 602 00 Brno.


Contact person


Registration is closed

The event has already taken place.

Share event

You are running an old browser version. We recommend updating your browser to its latest version.

More info