Section outline
-
EXCEL FOR ECONOMISTS
ID E15-0054-I
Excel belongs to a group of programs called spreadsheets. Spreadsheet processors are complex programs for solving general calculations. They offer a wide range of functions (mathematical, statistical, financial...), but an important part is the graphic presentation of data, complex analyses, and analyses. Spreadsheet processors are used by a wide range of users not only from the point of view of professionals but also at a professional level. Some users are satisfied with the essential functions, others set higher demands and try to improve the advanced functions of the program - macros, and programming using the VBA language.
Course coordinator: doc. Ing. Marcela Hallová, PhD.
Lectures and exams: doc. Ing. Marcela Hallová, PhD.
-
Basic information on the subject, evaluation method, and informative entry test.
-
Basic environment description. Creation of formulas. Using basic functions and some other functions from the category of conditional functions.
-
Creating three-dimensional formulas, locking sheets, and cells. Work with selected functions - search, date, mathematical, text. Working with cell formats.
-
Work with database - sorting, filtering, subtotal, conditional formatting.
-
Work with pivot tables - creating, editing...
-
Graphical visualization of data - creating and editing charts. Additional tips for working in Excel.
-
Excel dashboards - theoretical background.
-
Exercise - practical test from Excel.
-
Introduction to macros - explanation, principles, simple macros.
-
Another information about macros and using of form controls.
-
Working with macros - creating your own macros. Theoretical introduction to the creation of functions and forms.