Upon successful completion of the course, the student can learn how to use Excel in finance, analytics and management accounting. Application areas are financial reporting, business analysis and ICT development. Students can learn different kind of Excel functions. They will also get extra knowledge in development of data to information
Contents
Orientation to business concepts and business reporting
Excel Formulas mostly needed in business
The value of data - building business knowledge with Excel
Business analytics with Excel
Charts & Pivots
Stock Portfolio Management
Financial & Investment Computing
Macros, VBA,
Templates
Assignments only, no exam.
Implementation methods, Demonstration and Work&Study
28 h lectures
52 h self-study and assignments
Learning materials
COURSE MATERIALS
Handouts provided by the teacher and Moodle learning basement.
Starting level and linkage with other courses
Basic skills of using Excel and knowledge of business processes are required. The course is suitable for students of all business branches.
Assessment criteria
Assessment criteria - grade 1
Grading is based on the quality of assignments, all of those are graded. 45% of max. points.
Assessment criteria - grade 3
Grading is based on the quality of assignments, all of those are graded. 70% of max. points.
Assessment criteria - grade 5
Grading is based on the quality of assignments, all of those are graded. 85% of max. points.
Assessment criteria, approved/failed
Grading is based on the quality of assignments, all of those are graded. 45% of max. points.