BUSINESS MODELLING WITH EXCEL IN ACCOUNTING - COURSE OUTLINE

Business modelling with Excel in Accounting - course outline

Date issued: May 23, 2017
Instructor:  Joseph, K.K. Ho


I. Course description
This programme aims to enable students to use EXCEL as a tool to create powerful spreadsheet models for analysis and presentation of financial/accounting data and business results. Students will learn the important features of Microsoft EXCEL from basic spreadsheet design and creation through formulas, functions, formatting, charts, multiple worksheets, “what-if” analysis and there quantitative analysis techniques.


II. Medium of instruction
Cantonese supplemented with English (course materials are prepared in English and course lectures are conducted in Cantonese).

III. Duration of workshop: total 48 hours.

IV. Venue: Sheung Mei House, Sheung Tak Estate, Tseung Kwan O.

V. Syllabus
1. Introduction of modelling design and practices
2. Basic Excel functions as model building blocks
2.1. Range naming and cell addressing
2.2. Excel formula with +, -, x, /, total, %, vlookup, and IF, etc.
2.3. Basic cell formatting functions and multiple worksheets usage
2.4. Basic statistical functions: average, standard deviation, maximum and minimum values, etc..
2.5. Excel financial functions:  annuity, future and present values, and internal rate of return
2.6. Chart construction with Excel
2.7. Audit Excel-based models
3. Advanced Excel functions for Accounting/ quantitative modelling
3.1. Scenario/ what-if analysis
3.2. Goal seeking
3.3. Forecasting
3.4. Linear programming
4. Modelling applications in Accounting: specific examples and hands-on practices
4.1. Financial statements construction and analysis
4.2. Budgeting and variance  analysis
4.3. Breakeven analysis
4.4. Target costing
4.5. Customer profitability analysis
4.6. Capital investment evaluation

VI. ASSESSMENT AND AWARD
Students are awarded the Certificate for Module if they can achieve 70% attendance rate and successfully complete the assessment (4 individual assignments, each  25 marks, on business modeling).



E-resource: https://www.facebook.com/groups/1442218825840072/


-end-

Comments

Post a Comment

Popular posts from this blog

MBA Research Project [MGTM05] class [topup57/58/Full PF11] Teaching plan

Image
  MBA Research Project [ MGTM05 ] class [ topup57/58/Full PF11 ], 2023 (Nov)-2024(Mar) Synopsis Form: 18 Jan 2024   Proposal: 7 Mar 2024   Dissertation only Dissertation with 1 module Dissertation with 4 modules Dissertation: Jul 2024   HK Teaching Plan: Online class and classroom class Stream 1 Session Lecture Date (All online sessions) Topics 1 Nov 2-2023: 19:00-22:00   1) A briefing on the module guide I 2) review proposal and report samples Online session 1 *  HK U thesis portal :  *  Additional advice on dissertation projects . *  Dissertation table of contents template  [consulting-oriented project type) [compared that with  the academic-oriented project type ].  Dissertation table of contents template  (academic-oriented project type). *  Module guide info on dissertation report content . *  a sample on synopsis document . *  a sample of project proposal . *  the updated proposal te
Read more

Mind mapping the topic of gender

Image
Mind mapping the topic of gender Joseph Kim-keung Ho Independent Trainer Hong Kong, China Abstract: The topic of gender is a main one in Social Sciences. This article makes use of the mind mapping-based literature review (MMBLR) approach to render an image on the knowledge structure of gender. The finding of the review exercise is that its knowledge structure comprises four main themes, i.e., (a) Descriptions of basic concepts and information (b) Major underlying theories and thinking, (c) Main research topics and issues, and (d) Major trends and issues related to practices . There is also a set of key concepts identified from the gender literature review. The article offers some academic and pedagogical values on the topics of gender, literature review and the mind mapping-based literature review (MMBLR) approach. Key words: Gender , literature review, mind map, the mind mapping-based literature review (MMBLR) approach Introduction Gender is a main topic
Read more

Synopsis form - an example for a fake case

Synopsis form - an example on a fake case, made up by me Discipline related: other: innovation management Project Title:  An investigation of the innovation and managerial leadership capabilities of the Wong Tai Sin (WTS) Branch of the Lion Bank: a mixed methods research Project synopsis:  The dissertation project studies the Wong Tai Sin (WTS) branch of the Lion Bank (Hong Kong). It offers retail banking services to the WTS residents. The Lion Bank is a subsidiary bank of the CG Bank Group. The Wong Tai Sin branch management is concerned about the weak innovation and managerial leadership capabilities which affects its ability to compete in the district of Wong Tai Sin. These management concerns are of practical significance to this student, who is the deputy branch manager of the Wong Tai Sin Branch. The research objectives are: [objective 1] to evaluate the innovation capability of the WTS branch of the Lion Bank and [objective 2] to evaluate the managerial leade
Read more