Opintojakso

Näytä opetus
A220A0053 Investment and Business Analysis with Excel, 6 op 
Tunniste A220A0053  Voimassaolo 01.08.2018 -
Nimi Investment and Business Analysis with Excel  Nimilyhenne Investment and 
Laajuus6 op   
TyyppiYleisopinnot  
LajiOpintojakso   
  ArvosteluasteikkoOpintojaksot 0-5,H,P 
  Jatko-opintokelpoinenei
    Voidaan suorittaa useastiei
Vastuuyksikkö LUT School of Business and Management (23E1) 

Opettajat
Nimi
Mariia Kozlova 

Opintojakson kuvaus opinto-oppaan mukaan
Huom 

Location: full digi

The course requires practicing Excel and self-study on top of the exercises and lectures.

Only for Master's level students.

 
Suoritusvuosi 

M.Sc. (Econ. & Bus. Adm.) 1

 
Periodi 

3-4, summer

 
Opetuskieli 

English

 
Vastuuopettaja(t) 

 Post-doctoral researcher, D.Sc. (Econ. & Bus. Adm.) Mariia Kozlova

 
Tavoitteet 

After the course the students:

- are able to collect and handle data in a spreadsheet environment performing tasks such as data consolidation, data cleaning, and basic data analysis

- are able to plan and perform various business and finance related analyses

- know how to create simple models for optimization and investment analyses

- are able to handle, record and write own simple macros to automate operations in Excel.

 
Sisältö 

I. Basics of data visualization. Basic rules of data visualization, conditional formatting, waterfall chart, combo chart, treemap, 3Dmaps, flowcharts.

II. Data collection and analysis. Creating a watchlist, making investment program consolidation, performing data analysis with pivot tables and charts, creating an interactive dashboard, performing simple statistical analyses. Instruments: power query, pivot tables and charts, data analysis toolpack.

III. Portfolio optimization. Practicing with optimization problem setting, creating a stock portfolio optimization model, recording macros. Instruments: matrix multiplication functions, solver, VBA.

IV. Liquidity budgeting. Creating a liquidity budgeting model, recording macros, learning basics of VBA. Instruments: data tables, scenario manager, goal seek, VBA.

V. Investment analysis. Creating a profitability analysis model, performing break-even analysis, sensitivity analysis with a given macro, writing a Monte Carlo simulation macro. Instruments: data validation, goal seek, VBA.

 

 
Suoritustavat 

Fully online course. Self-preparation for the course with reading and video materials (10 h), working with video-tutorials of the course program (20 h), independent exercise work (100 h), peer to peer evaluation (20 h), moodle tests preparation (10h). Total workload for the student 160 h. Moodle is used in this course.

Available in two forms: scheduled course with teacher support during periods 3-4 and self-paced summer course.

 

 
Kuulustelujärjestyksen mukainen tentti (Kyllä/Ei) 

No

 
Moodle-tentti (Kyllä/Ei) 

Yes

 
Exam-tentti (Kyllä/Ei) 

Yes

 
Arviointiskaala ja arviointimenetelmät 

Grade pass-fail, evaluation 0-100 points, 50% exercises, peer to peer evaluation mandatory, 25% mini-tests after each module, 25% at the end of the course. Only moodle tests, no exam.

Alternatively, if you are proficient with Excel and VBA and all mentioned topics and instruments are familiar, you can skip all the course work and tests and get credits by taking one of the scheduled computer exams in the Origo exam aquarium.

 
Oppimateriaalit 

Video materials, assigned reading Beginning Excel What-If Data AnalysisTools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver, PaulCornell, 2006, Apress - available as an eBook in the library database.

 
Esitietovaatimukset 

Basic proficiency in Excel, assigned reading Beginning Excel What-If Data AnalysisTools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver, PaulCornell, 2006, Apress - available as an eBook in the library database.

For B.Sc students recommended A130A0620 Basics of MS Excel for Business Students.

 
Osallistujamäärää rajoitettu? (Kyllä, lukumäärä, prioriteetit/Jätä tyhjäksi) 

No

 
Vaihto-opiskelijoille paikkoja? (Kyllä,paikkamäärä/Ei) 

15–

 
Paikkoja avoimen yliopiston opiskelijoille? (Kyllä, paikkamäärä/Ei) 

15–

 


Meneillään oleva ja tuleva opetus
Toiminnot Nimi Tyyppi op Opettaja Aikataulu
  Investment and Business Analysis with Excel  KURSSI  Mariia Kozlova 
16.05.20 -31.08.20 -

Tulevat kuulustelut
Tarkasta kuulustelujärjestyksestä jos tässä ei näy kuulustelu mikä sinun mielestä pitäisi näkyä.
Voit myös hakea kuulusteluja vasemman valikon ILMOiTTAUDU TÄSTÄ -kohdasta.