Excel – beginners

Workshop

in person

Academic and non-academic employees of faculties, RMU, HEIs and other units

Czech

language of the event

The Excel workshop will introduce you to Excel options that will make your work more efficient and easier when using Excel. Using concrete examples, we will show you how to use each feature, how to work with them and where they can be applied.

Contents

  • cell addressing, relative, absolute and mixed addressing and its use in formulas and functions
  • graphical editing of tables
  • basic sorting and filtering of data
  • conditional formatting
  • printing options
  • hiding and displaying columns and rows, purpose and use, implementation
  • conditional formatting, purpose and use, implementation and editing
  • IF function
  • customizing the appearance of the program environment (toolbars and their modification, custom toolbars, menu bar and its modification)
  • date and time functions of the program, financial functions, text functions of the program

Goals

  • learn how to navigate the Excel environment, work with toolbars, tab strips and basic functions
  • you will be proficient in working with cells and sheets
  • learn basic formatting and editing of spreadsheets
  • learn to use basic mathematical and logical functions

Lecturer

Ing. Marek Rozehnal

E‑mail:

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.

Venue

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

Map

Contact person

Substitute registration

Loading...

Share event

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

More info