Olet täällä

Excel in Business

Excel in Business
  • Code: TOO8TF006
  • Extent: 3 cr (81h)
  • Timing: 5th semester
  • Language: English
  • Level: Free-choice studies

Starting level and linkage with other courses

Basic skills of using Excel and knowledge of business processes and financial reporting are required. The course is suitable for students of all business branches.

Learning outcomes

Upon successful completion of the course, the student can learn how to use Excel in financial and management accounting. Application areas are financial reporting, business performance analysis and resource management. Students can learn different kind of financial functions.

Course contents

  • Orientation to business concepts and business reporting
  • Tools for Business Management
  • Excel brush ups
  • Stock Portfolio Management
  • Financial Statements
  • Investment Computing
  • Assignments
  • Exam

Teaching and learning methods

21 h lectures
55 h self-study and assignments
3 h exam
The assessment of one’s own learning 1 h

Course materials

Handouts provided by the teacher and Moodle learning basement.

Assessment criteria

The course is evaluated on a scale 1 to 5.

Components Grade 1 (40 %) Grade 3 (70 %) Grade 5 (90 %)
Knowledge The student has limited understanding of Microsoft Excel when using it in studies and working life especially in business. The student knows partly Microsoft Excel application when using it in studies and in working life especially in business. The student understands fully Microsoft Excel application concept and the role of it in studies and working life especially in business.
Skills The student has satisfactory skills to produce professional tables and charts, business analyses and financial calculations using Microsoft Excel. The student has good skills to produce professional tables and charts, business analyses and financial calculations using Microsoft Excel. The student has excellent skills to produce professional tables and charts, business analyses and financial calculations using Microsoft Excel.
Competence The student shows satisfactory activity and initiative in learning process. The student shows activity and initiative in learning process. He/she is willing to develop his/her IT skills in business. The student shows excellent activity and initiative in the learning process. He/she is willing to develop his/her IT skills in business.

Modes of assessment and their weights

50% individual assignments
50% exam

Attendance at least 80 %

The assessment of one’s own learning does not influence the grade. The assignment is the same for all courses/modules and the answers will also be used for course/module development. The assignment is completed online in WinhaOpaali.