Advanced Excel

Semestar: 3
Broj ECTS kredita: 4
Obavezan: Da
Fond časova:
Smjer: VATEL studije

Course objectives:

- Be able to understand how Excel supports business-management and data-analysis work
- Master the automation of calculations using Excel formulas and functions
- Master data charts

Skills to be acquired:

- Know how to implement formulas
- Know how to illustrate series of figures
- Know how to use Excel’s main functions (conditions, searching a table, conditional sums…)
- Understand the data-chart concept
- Know how to build a pivot table
- Know how to use macros


Students deepen their computing knowledge, primarily of Excel. They learn to master the program’s advanced functions for automating calculations. They become familiar with data charts and pivot tables.



Angažovani predavači: