Excel in BusinessLaajuus (3 cr)

Learning objectives

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.

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.

Implementation methods, demonstration and Work&Study

28 h lectures
52 h self-study and assignments

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.

Learning materials

COURSE MATERIALS
Handouts provided by the teacher and Moodle learning basement.