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.