•   Excel in Business TOO8TF006-3010 27.03.2023-19.05.2023  3   (TF7SWD, ...) +-
    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
    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.
    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.
    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.

    Teaching methods and instruction

    Blended, video lectures or on-site.

    Learning material and recommended literature

    All the material is available in the Moodle.

    Working life connections

    Practical usage of Excel in working life.

    Campus

    Pasila Campus

    Exam dates and re-exam possibilities

    No exams.

    Teaching language

    English

    Internationality

    All the material is in English.

    Timing

    27.03.2023 - 19.05.2023

    Learning assignments

    Practical examples of using Excel in working life.

    Enrollment

    02.01.2023 - 24.03.2023

    Content scheduling

    Weekly assignments.

    Groups
    • TF7SWD
    • TF6SWD
    • TF7DIG
    • TF6DIG
    • BLENDED
    • EXCH
    Alternative learning methods

    Blended, working on your own based on video lectures or on-site.

    Teachers

    Hanna Mäenpää

    Seats

    15 - 40

    Further information

    All the assignments are graded, grade is based on the quality of the assignments.

    Degree Programme

    BITE Degree Programme in Business Information Technology

    R&D proportion

    0.00 cr

    Virtual proportion

    2.00 cr

    Evaluation scale

    H-5