Premium Essay

Spreadsheet Modelling

In: Computers and Technology

Submitted By ElenaKlim
Words 715
Pages 3
Word Count: 587
This is my own unaided work .
SPREADSHEET mODELLING
Word Count: 587 .
SPREADSHEET mODELLING

Spreadsheet modelling

As a future financial analyst my work will be based on analysing data from company’s gathered data spreadsheets. Hence it is crucial for my own career success to understand the importance of spreadsheet modelling and its implementation. As according to (Susan Coles, Jennifer Rowley, 1996) “The decision maker’s judgement must be exercised in the interpretation of the data and the final decision making.” There is no better way of benefiting my future career than developing advanced skills in modelling Excel. As I have learned from few articles I read about this subject, there are many advantages of excelling my skills so as problems I should look out for.
Firstly, studying advanced Excel modelling not only helps students to build technological knowledge but “also largely improve their practical analytical skills and abilities.”(Junying, 2010). By studying how to model spreadsheets students get a real chance to see how actual data is analysed by spreadsheet build in models and help them to further their own analytical knowledge and see how it works in real life. I think it is hugely beneficial for students in their further real life working scenarios.
As I seen how important and beneficial this study is, the question is why don’t all the users have them skills? And the answer lays with the management. As (Michelle L.F. Cheong , Thin-Yin Leong, 2009) write in their article that business management do not realise the importance of the spreadsheet modelling and so do not put any emphasis on its improvement and...

Similar Documents

Premium Essay

Lec2 Material

...CHAPTER 1 What Is Financial Modelling? here are all sorts of complicated definitions of financial modelling, and in my experience there is quite a bit of confusion around what a financial model is exactly. A few years ago, we put together a Plum Solutions survey about the attitudes, trends, and uses of financial modelling, asked respondents “What do you think a financial model is?” Participants were asked to put down the first thing that came to mind, without any research or too much thinking about it. I found the responses interesting, amusing, and sometimes rather disturbing. Some answers were overly complicated and highly technical: n T n n n n “Representation of behaviour/real-world observations through mathematical approach designed to anticipate range of outcomes.” “A set of structured calculations, written in a spreadsheet, used to analyse the operational and financial characteristics of a business and/or its activities.” “Tool(s) used to set and manage a suite of variable assumptions in order to predict the financial outcomes of an opportunity.” “A construct that encodes business rules, assumptions, and calculations enabling information, analysis, and insight to be drawn out and supported by quantitative facts.” “A system of spreadsheets and formulas to achieve the level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future.” Some philosophical: n “A......

Words: 17366 - Pages: 70

Premium Essay

Assignment Brief#

...Level 3 Extended Diploma in Business | Unit 42: Spreadsheet Modelling | Learner name | Assessor name | Martyna Litvinaite | Irene McCourt Francesse Mooney | Date issued | Hand in deadline | Submitted on | 15/09/14 | Task 1 15/10/14 Task 2 12/12/14 Task 3 20/03/15 Task 4 29/05/15 | 15/10/1410/12/14 | | | Assignment title | GamerWorld | In this assessment you will have opportunities to provide evidence against the following criteria. Indicate the page numbers where the evidence can be found. | Criteria reference | To achieve the criteria the evidence must show that the learner is able to: | | Task no. | | Evidence | P1 | * explain how spreadsheets can be used to solve complex problems | | 1 | | Pages1-2 | P2P3M1 | * develop a complex spreadsheet model to meet particular needs * use formulae, features and functions to process information * refine a complex spreadsheet model by changing rules and values | | 2 | | 2 Spreadsheets | P4P5P6P8M2M3 | * use appropriate tools to present data * customise the spreadsheet model to meet a given requirement * use automated features in the spreadsheet model to meet a given requirement * export the contents of the spreadsheet model to an alternative format * analyse and interpret data from a spreadsheet model * compare different automation methods | | 2 | | | P1P7P9M4D1D2 | * test a spreadsheet model to ensure that it is fit for......

Words: 302 - Pages: 2

Premium Essay

Atit

...Module number: U51001 Module title: Key Business Competences Contents Module introduction 1 Semester plan synopsis 2 Module syllabus 3 Week 1 – Module Introduction 7 Week 2: Operations with numbers 8 Week 3: Understanding Data 16 Week 4 – Charts and Graphing in Excel 31 Week 5 – Summarising data 45 Week 6 Reading Week 57 Week 7 & 8 – Principles of elementary modelling 58 Week 9 & 10 – Financial Modelling (1) 69 Week 11 & 12 – Financial Modelling (2) 81 Week 13 – Modelling and Data handling in business 97 Week 14 – Revision Week 107 Week 15 – In-class Test 108 Assessment details 109 Regulations 110 A note on equal opportunities and diversity 114 Module introduction Introduction This module ensures that all students have the necessary numerical skills to proceed with the rest of their degree in Business and related fields. As a compulsory module it must be passed and a maximum of three attempts can be made to pass it, with a resit opportunity for each attempt. Past student comments on the module “Yes it is really enjoyable – I liked the course” “The lecturers are very helpful and friendly” “The handbook is really informative” “Very clear and well explained” “It is very interesting but at the same time very complex” “Maybe make the lectures and seminars more interactive” “Quickly go over the initial mathematics and spend more time on the more complex parts of the module” ...

Words: 27701 - Pages: 111

Premium Essay

Mindjet App Review

...MINDMANAGER PRODUCTIVITY APPLICATION PROGRAM Ivanna Escudero Florida International University MAN 3025 June 10, 2016 Executive Summary Mindjet has a new application program that integrates flowcharts and concepts maps into the framework of the already established application. The application program will allow the firm that I work for in management and improve its organization’s system performance. The program upgrade has been launched with a new 2016 version labeled MindManager 2016 (Appendix 1). The application has 3 portfolios that facilitate the ease in organization of business, these are mind mapping, flowcharting and concept mapping. (Menaouer, 2015) To facilitate the ease in utilization of these portfolios, the new application contains a provision for combining them in a faction called diagramming. This is where we have mapping and map mapping combined in the single package program. This creates additional merit of mixing content types within a single map. The new program is quite effective on some critical business issues. Some of the issues addressed are brainstorming on ideas that affect the business in terms of proposing solutions. Secondly it facilitates the planning process in the business organization. Planning is vital in that it drives the goal acquisition process in the firm. Thirdly, the process improvement in the firm is of essence since it is a sure way to keep relevant in the market front and then stay afloat of the competition. Finally decision...

Words: 1571 - Pages: 7

Premium Essay

Pussytitle

...Section 14: Data Analysis Mark Nicholls – ICT Lounge IGCSE ICT – SECTION 14 DATA ANALYSIS MICROSOFT EXCEL STEP BY STEP GUIDE Mark Nicholls ICT Lounge Section 14: Data Analysis Mark Nicholls – ICT Lounge Data Analysis – Self Study Guide Contents Learning Outcomes ……………………………………………………………………………………… Page 3 What is a Data Model? ..................................................................................... Page 4 Spreadsheet Basics…………………………………………………………………………………………. Page 4 – 6 Resizing Column Widths…………………………………………………………………………………. Page 6 Autofil…………………………………………………………………………………………………………….. Page 7 Absolute Cell Reference…………………………………………………………………………………… Page 8 Printing Spreadsheet Values………………………………………………………………………….. Page 9 Printing Spreadsheet Formulae……………………………………………………………………….. Page 10 Basis Formulae (Operators)……………………………………………………………………………. Page 11 – 13 Naming Cells and Cell Ranges………………………………………………………………………… Page 14 – 15 Introduction to Functions………………………………………………………………………………… Page 16 SUM Function……………………………………………………………………………………… Page 16 – 17 AVERAGE Function……………………………………………………………………………… Page 18 MAX Function…………………………………………………………………………………….. Page 18 MIN Function……………………………………………………………………………………… Page 19 Alternative to Typing in Functions………………………………………………………………….. Page 19 – 20 Activity 1 ………………………………………………………………………………………………………… Page 20 INT Function ………………………………………………………………………………………. Page 21 – 22 ROUND Function ……………………………………………………………………………….. Page......

Words: 5903 - Pages: 24

Free Essay

Superior Manufacturing

...Homework 5: Oracle Crystall Ball MIS 6543 Business Analytics Fall 2013 Arkansas State University Instructor: Dr. Ahmad Syamil Due date: 8:00 PM, Wednesday, December 11, 2013. Name your homework files using your name and location, and then put them on Blackboard>MIS6543> Course Tools>Journals>Digital drop box>Create Journal Entry>Write an appropriate title and message including whether you are an online or face-to-face student> Attach file. Inform me by email after you submit your file. Of course you can submit your homework earlier. If you are an ASU Jonesboro face-to-face student, you must also submit the complete hard copy of your work under my office door (BU 406) by the due time. Do not submit the hard copy of the answer to each problem oneby-one. You can get Oracle Crystal Ball simulation software for chapter 13 from http://www.oracle.com/crystalball/index.html or http://www.oracle.com/technetwork/middleware/crystalball/downloads/index.html ?ssSourceSiteId=ocomen If you never register on the Oracle website, Oracle will ask you to register before downloading Oracle Crystal Ball (CB). Furthermore, you can only use the CB trial version for 2 weeks. Therefore, you should start working on this assignment no sooner than 2 weeks before the day you plan to submit this assignment. Using an older version of CB is also acceptable. Use Google. If you use one version for 2 weeks, you may be able to install another version for another 2 weeks. Consequently, you can use CB for 4 weeks....

Words: 2066 - Pages: 9

Free Essay

2013 Aff 2851

...MonashUniversity Semester Two Examination 2013 Faculty of Business and Economics Department of Accounting and Finance EXAM CODES: AFF2851 TITLE OF PAPER: ACCOUNTING INFORMATION SYSTEMS & FINANCIAL MODELLING EXAM DURATION: 3 hours READING TIME: 10 minutes THIS PAPER IS FOR STUDENTS STUDYING AT: (office use only - tick where applicable)  Berwick  Clayton  Peninsula  Distance Education  Other (specify)  Caulfield Gippsland  Sunway  Open Learning During an exam, you must not have in your possession a book, notes, paper, calculator, pencil case, mobile phone or other material/item which has not been authorised for the exam or specifically permitted as noted below. Any material or item on your desk, chair or person will be deemed to be in your possession. You are reminded that possession of unauthorised materials in an exam is a disciplinable offence under Monash Statute 4.1. AUTHORISED MATERIALS CALCULATORS  YES  NO (If YES, only calculators with an 'approved for use' Faculty label are permitted) OPEN BOOK  YES  NO SPECIFICALLY PERMITTED ITEMS  YES  NO if yes, items permitted are: This paper consists of two (2) parts printed on a total offourteen (14) pages, plus a multiple choice answer sheet. Part A has twenty (20) multiple choice questions. The answers to Part A should be entered on the multiple choice answer sheet provided. Part B has four (4)sets of written answer questions. Students must attempt to answer ALL...

Words: 1037 - Pages: 5

Free Essay

Social Parameters

...Objective: Operations Research is the science of decision making and the art of decision modelling. It is a set of quantitative tools used by the managers to take decisions and formulate their business strategies. The basic objective of this course is to provide an understanding of the important techniques used in decision making. A certain level of mathematical hands-on expertise will be required to ensure understanding of the tools in operations research. At the end of the course you are expected to • Formulate real world decision making situations as mathematical optimisation problems • Solve linear programming problems • Be able to understand what the solution means • Understand basic concepts of transportation, assignment and integer programming problems. Reference [1] F.S.Hillier and M.S.Hillier, Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, Tata McGraw-Hill, New Delhi,. [2] H.A.Taha, Operations Research An Introduction, Prentice Hall of India Private Limited, New Delhi. [3] Hiller and Lieberman, Introduction to Operations Research, Tata McGraw Hill, New York,. [4] N. Balakrishnan, B. Render and R.M.Stair, Managerial Decision Modeling With Spreadsheets, Pearson Education. Objective: Operations Research is the science of decision making and the art of decision modelling. It is a set of quantitative tools used by the managers to take decisions and formulate their business strategies. The......

Words: 373 - Pages: 2

Premium Essay

Cash Management Modeling

...Lakewood Laser Skincare and all business cash budgets really do matter. The business owner who does not pay attention might have a rude surprise when they run out of cash or applies to the bank for renewal of loans. One of the many advantages of utilizing Excel financials or an accounting software program is that updating is calculated automatically by simply completing a new data input. This helps business owners quickly get a handle on the financial strength and capabilities of their business. Creating and Calculating Cash Balances Sheets The first step in creating a multiproduct, multi-period, spreadsheet-based budget is setting up a clear and understandable Data Input Sheet. This sheet will summarize the assumptions and estimates for the entire budget for business like Lakewood Laser Skincare. By putting them in one place, you make it easy for those less familiar with spreadsheets to get into the budget and change their assumptions. It also makes it easy to adjust the budget based on management discussions, to create best- and worst-case scenarios,...

Words: 795 - Pages: 4

Premium Essay

Database Management And Information Retrieval System Case Study

...Question 1 Differentiate between database management system and information retrieval system by focusing on their functionalities. (30 marks). Database management system Information retrieval system Main software in computer system Obtain resources to the information relevant Offer Data modelling Facility Restricted to classify of object Structured data format Unstructured data format Provide precise semantics Provide imprecise semantics Complete of query specification Incomplete of query specification Data dictionary system management Item normalization Data transformation and presentation Document database search Backup and recovery management Index database search Data store management Selective dissemination of information...

Words: 1137 - Pages: 5

Free Essay

Energy Drink

...Welcome to Financial Models in Excel Situation report 1 / 17 • Peter Raahauge Department of Finance Office: A 5.21, Solbjerg plads Background: ˚ – PhD in economics (Arhus) 1999 – System developer (Simcorp) 1999-2000 – Assisting/Associate Professor/Lecturer (CBS) 2000-2012 2 / 17 • Goal The overall goal • Practical implementation of financial theory How to get there? • Exercise-based (solving “real world” problems) • IT-based, everything based on Excel (and VBA) • Professional data source: Datastream Results • • • • Better understanding of (known) financial theory Better Excel-skills Better feeling with real world data All in all: Easier to get started (at your thesis/job) 3 / 17 1 Examples of skills after the course In half a work-day (or 4 hours exam :-) you will be able to solve one of these problems: • • • • Form a reasonable stock portfolio. Price an option, (Eur, Amr, Ber, Asian) Estimation of the term structure, (cubic spline). Predict the standard deviation of stock returns for next week, (basis for risk management). - You know the theories, but it will take you half a “term paper” to get an answer if you have not tried it before. 4 / 17 Structure of the Lessons 15 lessons (2 hours lecture and exercises) 14 has the following structure: 1. 2. 3. 4. E-lec: Review of last weeks exercise E-lec: Financial theory and Excel for next exercise You solve the exercises (guiding solution available) Physical lecture: Your questions /......

Words: 851 - Pages: 4

Premium Essay

Courses on Probability Theory

...autocorrelation. Content: 1. Simple Regression Analysis 2. Multiple Regression Analysis 3. Dummy Variables 4. Heteroscedasticity 5. Autocorrelation Main Textbook: Dougherty, C. (2011). Introduction to Econometrics, 4th edition, Oxford. 2. Module Name: Computational Finance Code: P12614 Credits: 10 Semester: Spring 2011/12 Programme classes: 12 1-2 hour lectures/workshops Aims: The module aims to describe and analyse the general finance topics and introduces students to implement basic computational approaches to financial problems using Microsoft Excel. It stresses the fundamentals of finance; provides students with a knowledge and understanding on the key finance subjects such as money market, return metric, portfolio modelling, asset pricing, etc.; and equips students with the essential techniques applied in financial calculations. Contents: 1. Lecture Topic 1: Money Market Instrument : Introduction to the course; Interest rate types;...

Words: 1425 - Pages: 6

Premium Essay

Estimating Needs

...Objective: Further experience and knowledge in project management and estimating. Qualifications: Received diploma in the Mechanical Engineering program at NAIT. Obtained various technical and project management skills. Proficient in various computer programs including Microsoft Office, design programs such as Mastercam, AutoCAD and 3-D Inventor modelling. Education: Mechanical Engineering Technologist, NAIT April 30, 2010 Completion Date • Learnt principles of the design process and effective ways of creating professional reports, documents and drawings. • Experience building reports, programs, charts and spreadsheets with Microsoft Office. • Principles of Six Sigma, ISO 9001, Statistical Process Control, Production Planing Processes and Continuous Quality Improvements. • Operations Management, experience in Forecasting, Scheduling, Capacity Planning, Inventory Control and Supervision. • Experience in bidding procedure and accurate financial documentation related to products manufacturing. • Proficient in programs such as o Microsoft Word, Excel, Visio, Power Point and Publisher. o Master Cam o AutoCAD and 3-D Modelling Inventor. Geomatics Engineering Technologist, NAIT April 30, 2006 Completion Date • Introduced to AutoCAD, learnt design process and report documentation related to the Alberta Land Surveying criteria. • Completed courses related to basic survey calculations within the field. • Completed H2S training, first aid and construction......

Words: 408 - Pages: 2

Premium Essay

Financial Modelling

...Advanced Modelling in Finance using Excel and VBA Mary Jackson and Mike Staunton JOHN WILEY & SONS, LTD Chichester ž New York ž Weinheim ž Brisbane ž Singapore ž Toronto Copyright  2001 by John Wiley & Sons, Ltd, Baffins Lane, Chichester, West Sussex PO19 1UD, England National 01243 779777 International (C44) 1243 779777 e-mail (for orders and customer service enquiries): cs-books@wiley.co.uk Visit our Home Page on http://www.wiley.co.uk or http://www.wiley.com All Rights Reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except under the terms of the Copyright, Designs and Patents Act 1988 or under the terms of a licence issued by the Copyright Licensing Agency, 90 Tottenham Court Road, London W1P 9HE, UK, without the permission in writing of the publisher. Other Wiley Editorial Offices John Wiley & Sons, Inc., 605 Third Avenue, New York, NY 10158-0012, USA Wiley-VCH Verlag GmbH, Pappelallee 3, D-69469 Weinheim, Germany John Wiley & Sons Australia Ltd, 42 McDougall Street, Milton, Queensland 4064, Australia John Wiley & Sons (Asia) Pte Ltd, 2 Clementi Loop #02-01, Jin Xing Distripark, Singapore 129809 John Wiley & Sons Canada Ltd, 6045 Freemont Blvd, Mississauga, ONT, L5R 4J3, Canada British Library Cataloguing in Publication Data A catalogue record for this book is available from the......

Words: 57326 - Pages: 230

Premium Essay

Executive Admin

...List of Textbooks College of Administrative and Financial Sciences Level 3 ID Course Name Title Author/Edition Publisher ECON 101 Microeconomics Survey of Economics: Principles, Applications, and Tools O’SULLIVAN / 5TH edition Pearson ACCT 101 Principles of Accounting Financial Accounting Wild / 6th edition MGT 101 Principles of Management Management: A Practical Introduction Kinicki / 6th edition McGrawHill CourseSmart McGrawHill CourseSmart Level 4 ID Course Name Title Author/Edition Publisher FIN 101 Principles of Finance Fundamentals of Corporate Finance Breasley, Myers, & Marcus McGraw-Hill MGT 201 Marketing Management Marketing: Defined, Explained, Applied Levens, 2012, 2nd edition Prentice Hall Human Resources Management DeCenzo, 2012, 11th edition Wiley Saudi Arabia Labor Law Outline Michael O'Kane, 2010 Al-Andalus Publishing E- Commerce: Business, Technology, Society Lauden, 2013, 9th edition Pearson MGT 211 E-COM 101 HR Management E-Commerce Level 5 ID ECON 201 MIS 201 ECOM 201 Course Name Title Author/Edition Publisher Macroeconomics Principles of Macroeconomics, N. Gregory Mankiw, 6th Edition, 2011 Cengage Learning Information Systems Management Management Information Systems, R. Kelly Rainer, Hugh J. Watson, Brad Prince, 2nd Edition,......

Words: 947 - Pages: 4