Skip to main content
MOODLE SPU
Kategórie kurzov
Fakulta agrobiológie a potravinových zdrojov
Fakulta biotechnológie a potravinárstva
Fakulta ekonomiky a manažmentu
Fakulta európskych štúdií a regionálneho rozvoja
Fakulta záhradníctva a krajinného inžinierstva
Technická fakulta
Ďalšie vzdelávanie
Projekt LUZK
Web application development
MBA
MBA
SÚŤAŽ
Súťaž o najlepší kurz 2016
Súťaž o najlepší kurz 2023
SandBox - Pieskovisko
Vstup voľný!
Temp
DPŠ2021 - DEN1
DPŠ2021 - DEN2
DPŠ2021 - EXT1
DPŠ2021 - EXT2
DPŠ-Archív
Hľadáte konkrétny kurz?
Vyhľadať kurz
Help
Rady, návody, manuály ...
English (en)
English (en)
Slovenčina (sk)
You are currently using guest access (
Log in
)
Excel for economists
Home
Courses
Fakulta ekonomiky a manažmentu
Ústav účtovníctva a informatiky
EfE2023/24
2. week WS - 29.9. - 3.10.2025
02 Lecture_examples
02 Lecture_examples
Completion requirements
Click
Lecture_2.xlsx
link to view the file.
◄ 02 Functions in Excel
Jump to...
Jump to...
Oznámenia
First lecture and basic information about Excel
Entry test
Entry test results
02 Functions in Excel
01 Transport model
01 Transport model results
02 Bank
02 Bank results
Data validation and database
Data validation and database
03 3D formulas
03 3D formulas results
05_Functions_Vlookup_xlookup_if
05_Functions_Vlookup_xlookup_if_results
06_index_match
06_index_match_results
07_formats
07_formats_results
Custom formats
Pivot tables
Pivot tables - excel file
Pivot table - normalized data
Pivot tables - Show values as
08_database
Models_sparklines_charts_goal_seek_scenarios
Lecture_excel_file
Charts
Scenarios_pdf
Scenarios_Excel
08_database_results
10_sales_overview_PT
10_sales_overview_PT_results
11_Charts
11_Charts_results
Dashboards
12_Excel_tips_general
12_Excel_tips_general_results
Dynamic range, functions and formulas
Dynamic range, functions and formulas
Introduction to macros
Data for dashboard
Dashboard final
Dashboard_partial_20_11_2025_EN
Working with macros
Mortgage_loan_form
Worksheet controls
13_Rental_fee_calculation
13_Rental_fee_calculation_results
Power Query lecture
Power Query data
Functions and forms
Functions and forms
VBA_functions
Form_change_case
Form_show_message
14_Formatting
14_Formatting_results
15_Annual_budget
15_Annual_budget_results
16_Tests
16_Tests_results
Excel macros examples
17_Ownfunction
18_GetNumeric
18_GetNumeric_txt
18_GetNumeric_results
19_Form
19_Entry_Form_Button_txt
19_Form_results
Manual charts
20_Charts
20_charts_results
21_charts2
21_charts2_results
01 Transport model ►