Premium Essay

Use of Spreadsheets in Business and Technology


Submitted By Texaswoman
Words 949
Pages 4
Use of Spreadsheets in Business and Technology
Marty Montgomery
August 25, 2013

Many corporations depend on spreadsheets as a fundamental (Institute of Corporate Auditors, 2006) device in their financial reporting and operational processes. As a result, the use of spreadsheets is an essential part of the information and decision-making structure for these organizations. In developing and using spreadsheets, organizations need to balance their ease and flexibility against the value of reliable information for management’s application.
As users of spreadsheet applications such as Microsoft Excel® or Lotus 1-2-3® have become more sophisticated, so have spreadsheets. Once used to support simple functions such as logging, tracking and totaling information, spreadsheets with enhanced formulas and built-in advanced features are now used to support such business functions as complex valuation models. The use of macros and multiple spreadsheets which are linked together allows users to build very complicated—and sometimes convoluted—models and other business functions with minimal or no documentation. In addition, these complex spreadsheets are not usually supported by the same control environment as formally-developed, purchased applications. For example, the developers and users of spreadsheets are usually not trained in structured programming, testing, version control or systems development life cycles, and spreadsheets are rarely restricted from unauthorized access by security controls. (Smith, 2013)
How Are Companies Using Spreadsheets * Operational: Spreadsheets used to facilitate tracking and monitoring of work flow to support operational processes, such as a listing of open claims, unpaid invoices and other information that previously would have been retained in manual, paper file folders. These may be used to monitor and control that financial transactions

Similar Documents

Premium Essay

Business Case for Compensation Technology

...White Paper THE BUSINESS CASE FOR COMPENSATION TECHNOLOGY C ompensation accounts for nearly 70 percent of operating expenses for most organizations,1 and is one of the main reasons employees join and leave organizations. Yet despite the foundational role compensation plays in any talent strategy, most organizations continue to manage compensation market analysis, strategy development and program administration using spreadsheets. The perils and pitfalls of handling complex compensation tasks in spreadsheets are well known:2 spreadsheets are prone to human error, require a high-level of skill and expertise to move beyond simple analysis, and are not a scalable solution across decentralized groups. For this reason, most discussions on the use of spreadsheets in compensation and HR focus on productivity loss and risk of error. However, beyond these important but tactical gains, the compensation function and the organization at large have far more to gain by reducing reliance on spreadsheets than reduced risk and greater efficiency. This paper will explore the five areas in which organizations can improve via the adoption of compensation technology solutions: efficiency, consistency, visibility, transparency and trust. the highest salaries in the market, but it does require a deep understanding of the pay landscape in which the company operates so organizations that choose to place a lower emphasis on base salary understand the need to balance this approach with non-salary...

Words: 2870 - Pages: 12

Premium Essay

Snyders of Hanover and 2. Dollar General Corporation

...1. Snyders of Hanover, which sells more than 78 million bags of pretzels, snack chips, and organic snack items each year, had its financial department use spreadsheets and manual processes for much of its data gathering and reporting. Hanover’s financial analyst would spend the entire final week of every month collecting spreadsheets from the heads of more than 50 departments worldwide. She would then consolidate and re-enter all the data into another spreadsheet, which would serve as the company’s monthly profit-and-loss statement. If a department needed to update its data after submitting the spreadsheet to the main office, the analyst had to return the original spreadsheet and wait for the department to re-submit its data before finally submitting the updated data in the consolidated document. Assess the impact of this situation on business performance and management decision making. First, it is easy to see that Snyders of Hanover needs to be updated, with the use of modern systems and technology, or better to update it. For example, how long it takes to do all these activities and how long it takes to making decisions? So, it is evident that the organization of this company is based in a manual system, the management department needs to work in to introduce a new IT. Imagine paying salaries for employers, to pay providers, to pay services, etc. It is important to plan a technological change after a deep study of the functioning in this company. So to apply the management...

Words: 1544 - Pages: 7

Premium Essay

Bis 2200

...| Syllabus School of Business BIS/220 Version 6-2012 Introduction to Computer Application and Systems | Copyright © 2011 by University of Phoenix. All rights reserved. Course Description This course provides an overview of Business Information Systems. Students learn to apply Microsoft® Office tools including work processing, spreadsheet, database, and presentation software to accomplish business objectives. Other topics include uses of application software and the Internet for effective problem solving, exploration of relevant emerging technologies, and how information is used across different industries. Policies Faculty and students/learners will be held responsible for understanding and adhering to all policies contained within the following two documents: University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change. Be sure to read the policies at the beginning of each class. Policies may be slightly different depending on the modality in which you attend class. If you have recently changed modalities, read the policies governing your current class modality. Course Materials Grauer, R. T., Poatsy, M. A., Mulbery, K., Hulett, M., Krebs, C., & Mast, K. (2011). Microsoft® Office 2010: Volume 1. Upper Saddle River, NJ: Pearson Prentice Hall. Rainer, R. K. & Cegielski, C. G. (2011). Introduction...

Words: 1941 - Pages: 8

Premium Essay

Advanced Corporate Finance

...Advanced Corporate Finance [FN2] Examination Blueprint 2013/2014 Purpose The Advanced Corporate Finance [FN2] examination has been constructed using an examination blueprint. The blueprint, also referred to as the test specifications, outlines the content areas covered on the examination and the weighting allotted to each content area. This document also lists the topics, the level of competence for each topic, and the related learning objectives and competencies. The learning objectives have been designed to ensure that the competencies are met. In addition, information is provided on the proportion of each question type presented in the examination (that is, multiple choice, quantitative problems, and so on). Use Candidates should use the examination blueprint to prepare for the course examination. The blueprint may not include all the topics listed in the course materials; however, candidates are still responsible for acquiring a broad-based knowledge of all topics not listed in the blueprint since these topics will be tested in assignment and review questions. The topics not listed in the blueprint will also provide candidates with a greater depth of understanding of finance concepts. Examination Objectives The objective of the 4-hour comprehensive examination is to test CGA candidates on the prerequisite knowledge required for advancement into PA1 and PA2, so as to ensure that the candidates have the broad-based knowledge in finance needed to function properly in the association’s...

Words: 4207 - Pages: 17

Free Essay


...POLYTECHNIC UNIVERSITY OF THE PHILIPPINES College of Business Administration Department of Office Administration Sta. Mesa, Manila SECRETARIAL ATTITUDES AND PROFICIENCY TOWARD WORD PROCESSING, SPREADSHEET, AND PRESENTATION IN SELECTED HIGHER EDUCATION INSTITUTIONS IN MANILA Job, Denise Unika N. Paña, Rosemin R. Ramirez, Mariah Aubrey M, Segui, Karl Louise C. Zabat, Shaira Marie N. BSOA CT 3 – 2N CHAPTER 1 THE PROBLEM AND ITS BACKGROUND Introduction This chapter present and discuss the description, background, and the skill competencies of secretaries and skill qualifications required by the selected higher education institutions in Metro Manila. This also includes the highlight of the relevance of the study, the reason for choosing the topic, and the purpose and scope of the study. In the past few years, secretarial tasks involving word processing evolved from being manual to automate. In today’s technological age, computers are the only way to maintain, develop and secure growing and established business. The computer is trying to change education and tasks dramatically. Currently, with the help of technology, not only computer itself but also its programs were persistently continuing to develop from time to time. Secretaries especially on education institutions, handle more complex duties, such as conducting research, preparing reports, creating spreadsheets, composing correspondence and documents, and organizing other secretarial assignments. ...

Words: 2090 - Pages: 9

Premium Essay

Determining Databases

...Determining Databases and Data Communications Laura Dowell BIS/320 March 18, 2013 Martin Mueller Determining Databases and Data Communications A manager in today’s business environment must have the skills and knowledge to play a role in a variety of departments. Even if he or she is not an expert in the information technology field, a basic understanding of the tools and terminology is a must-have. This understanding can be useful in clearing out some of the options which are obviously untenable and narrow decisions to a limited number of viable options. The scenarios below demonstrate how a basic knowledge of software application and network design can simplify decisions that would perplex many individuals. SCENARIO 1 In the first scenario a marketing assistant for a consumer electronics company is responsible for managing the displays used at industry trade shows. This person must identify the necessary components and equipment and make sure they get shipped to the trade show in a timely manner. Once the shipment arrives at the trade show, the assistant is responsible for verifying the condition of each item and overseeing the set-up and functionality of the display. At the conclusion of the trade show, the assistant makes sure that each piece ships back to the company and is put back into stock at the warehouse in the same condition as when it originally left. This assistant is also in charge of following up on any problems resulting from shipping damage. There...

Words: 1197 - Pages: 5

Premium Essay


...where you work. Kudler’s management is interested in effectively integrating technology into its business operations. They have asked you to prepare a brief detailing how computer systems might be more effectively integrated to meet their business needs and improve their accounting operations. Identify Kudler’s key business and accounting information needs. Analyze the strengths and weaknesses of Kudler’s current computer system and technology use, including hardware and software. Explain what opportunities Kudler has in terms of technology and provide suggestions for improving Kudler’s ability to maximize these opportunities. Evaluate the threats that Kudler may encounter given their current systems and offer your suggestions, in terms of using technology. Use APA formatting where appropriate for references, citations, and title page. Operations Support Systems- ch1 The role of a business firm's operations support systems is to efficiently process business transactions, control industrial processes, support enterprise communications and collaboration, and update corporate databases Transaction processing systems are an important example of operations support systems that record and process data resulting from business transactions. They process transactions in two basic ways. Management information systems (MIS) provide information in the form of reports and displays to managers and many business professionals. The concept of data resources has been broadened by managers...

Words: 1025 - Pages: 5

Premium Essay


...Spreadsheets in the World of Business David Johnson COMP106 – Intro to Spreadsheets Professor Hodges February 25, 2014 Spreadsheets Spreadsheets have become one of the most valuable tools for small business owners over the past few decades. Gone are the days of typewriters, correction paper, hand calculators, and erasers. These have been replaced by computers, printers, a wide variety of powerful programs, and delete keys that perform any number of business tasks that are necessary for companies of all sizes to succeed in today’s competitive business market. There are all in one financial management programs, such as QuickBooks, that do all of the work for the small business owner after inputting the necessary data. Also, there is a very powerful spreadsheet program called Microsoft Excel that provides a litany of financial tools for the small business professional. But, it also requires the user to have an understanding of how to layout, manage, and interpret the data. Spreadsheets have a wide variety of uses in the business environment. It seems as though every department in an average business can use them in one way or another. In a 2000 survey of 227 respondents, over a wide range of careers, it was found that “over 80 percent of respondents use a spreadsheet in their work” (Pemberton & Robson, 2000, p. 388). Respective departments can also easily use these spreadsheets to share data amongst each other. Human resources may use spreadsheets for employee...

Words: 1203 - Pages: 5

Premium Essay

Mis Job Posting

...information technology, the range of career opportunities for IS managers has expanded. To illustrate the variety of jobs running in MIS and the importance of IS to other career paths, I have listed four job openings in MIS and four other ones in Accounting, which is an area that heavily relies on information systems. Careers in MIS Job title: Software quality assurance analyst Skills and knowledge requirements: • Education: Completion of high school, completion of college/CEGEP/vocational or technical training • Experience: 3 years to less than 5 years • Languages: Speak English, read English, write English • Specific skills: Confer with clients to identify and document requirements, conduct business and technical studies, design, develop and implement information systems business solutions, provide advice on information systems strategy, policy, management and service delivery, develop and implement policies and procedures throughout the software development life cycle, conduct reviews to assess quality assurance practices • Computer and technology knowledge: Windows, Intranet, Internet, Multimedia software, Word processing software, Spreadsheet software, Presentation software, Office suites, Electronic mailing software • Work conditions and physical capabilities: Fast-paced environment, work under pressure, tight deadlines, repetitive tasks, attention to detail, combination of sitting, standing, walking • Essential skills: Reading text, document use, numeracy,...

Words: 1801 - Pages: 8

Free Essay

Accounting on the Internet

...The relatively new job sector made available through accounting and the Internet has come to existence with the assistance of E-accounting. The first electronic spreadsheet was designed in developed in 1979, following the creation of the first successful PC created by Steve Jobs and Steve Wozinak. Bob Frankston and Dan Brinklin developed the first electronic spreadsheet for the Apple II created by Steve Jobs and named the spreadsheet program, “VisiCalc”. The creation of VisiCalc turned out to be one of the most important business applications for the PC. Prior to its inception in 1979 all accounting was done primarily by hand or with the use of very complicated and massive computing devices. It was not until the invention of the PC did the public at large and independent accounting professionals have access to accounting technology on the Internet. Electronic accounting began with the use of spreadsheets. Spreadsheets allowed accountants to translate the manual functions of the general ledger into a computerized accounting system. Software companies would eventually create software programs to focus on accounting, based on traditional accounting processes. E accounting is the use of online accounting applications and Internet technologies to support the business accounting function. E-accounting involves performing regular accounting functions, accounting research and the accounting training and education through various computer and internet based accounting tools such as: digital...

Words: 1695 - Pages: 7

Premium Essay

The Broadway Cafe Case Study

...3 1.3 Use of Groupware tool 3 2 Competitive Advantage 4 2.1 Making business decisions I – Porter’s Five Forces & Generic Strategy 4 2.2 Making business decisions II – Customer Order Process 5 3 Customer Relationship Management 7 3.1 Making business decisions II - CRM 7 3.1.1 Extended Strategy 8 3.1.2 New Technologies 8 4 Business Intelligence 9 4.1 Making business decisions II 9 5 Systems Development 14 5.1 Making business decisions II – PYT Business Requirement 14 6 Bibliography 15 Appendix B – PYT Business Requirement for New Payroll System 16 Appendix C - Groupware Tools 20 Figures Figure 1: As-is Broadway Cafe Rich Picture 2 Figure 2: Broadway Cafe Alters Diagram 3 Figure 3: The Broadway Café Five Forces model 4 Figure 4: Customer Ordering Process 6 Figure 5. As-Is payroll system 14 Figure 6. Flow chart payroll system 17 Figure 7: Team ISO Groupware Home Page 20 Tables Table 1: YouTube Pros and Cons 7 Table 2. Comparison of Spreadsheet and Databases 11 Table 3. Wikispaces advantages & disadvantages 20 Introduction This case study addresses the following information systems (IS) concepts for the Broadway Café, as detailed at • Competitive Advantage - Making business decisions I (Porter’s Five Forces & Generic Strategy • Competitive Advantage - Making business decisions II (Customer Order Process) • Customer Relationship Management (CRM) – Making business decisions...

Words: 5097 - Pages: 21

Premium Essay

Spreadsheet Modelling

...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...

Words: 715 - Pages: 3

Premium Essay

Financial Planning executive, you approach the annual process with excitement and a sincere belief that the process will be efficient, positive, and better than last year. Yet when members of your staff ask managers for their departmental budgets, they are met with blank stares, given excuses, or sent a budget whose form is completely unrecognizable from the template you gave the managers at the outset of the budgeting cycle. Eventually, the dreaded consolidation effort begins, in which any number of accountants spend too many days attempting to fix the department budgets so you can roll them up into the company-wide budget. The spreadsheet is broken in so many places you barely know where to start. Just when you’ve got the data into somewhat workable form, the CEO tells you the board of directors would like to see “what if” scenarios reflecting the impact of two major business decisions being considered. You find yourself daydreaming about the time when building a budget was actually fun. Recognize this scenario? As a career CFO, I’ve lived through it, like you. But the scary part isn’t the aggravation that CFOs endure. The scary part is the inaccuracies resulting from this less-than-perfect budget development process that dramatically decrease confidence in the budget, according to a survey conducted by Centage and the Institute of Management & Administration (IOMA). The CFOs surveyed, who represented companies of all sizes in more than 20 industries, expressed a wide range of confidence...

Words: 3260 - Pages: 14

Premium Essay


...(SOEITAHS) Diploma in Information Technology Principles of Information Technology (IT105N) Credit Hours : 4 Class Contact : 5 Hours (3 Hours Lecture + 2 Hour Tutorial/Practical) Independent Self-Learning : 160 Hours Prerequisite : Not Available Consultation Hours : Every Wednesday (02:00pm-5:00pm) (Subject to pre-arrangement only) COURSE OBJECTIVE This course is a comprehensive introduction to the realm of Principles of Information Technology. This is an introductory module to the current and evolving technologies in today’s computer systems. It introduces information technology concepts and principles. This module explains major components of information systems and demonstrates applications of information systems in business. Students are provided with sophisticated knowledge and necessary skills of information technology. Principles of Information Technology is a course that will provide students with computer skills necessary to be successful in “real world” personal and business situations. Students will use Microsoft Office to learn word processing, desktop publishing, presentation software, spreadsheets, and databases. COURSE OUTCOMES On completion of the course, students will be able to: 1. Demonstrate an understanding of basic information technology concepts and principles 2. Describe major components of information systems 3. Discuss business applications of information systems 4. Use Office application software...

Words: 1347 - Pages: 6

Premium Essay


...formed by Lisa and Ruben, two musicians with Bachelor’s degrees in Business Administration. Lisa and Ruben want to take advantage of the e commerce opportunities using the latest technology tools, and also to gain a competitive edge in dealing with their customers. As an intern who was hired by them, I recommend the following based on the facts on findings. I have attached the spreadsheet of Ruby’s club customers who most are young executives and college students, mainly between the ages of 18-35. Most of Ruby Club’s customers are part of the digital age, so they use mobile devices and internet daily. In addition, Ruby’s provides customers with a full night of dancing, food, drinks and fun with friends. I added to the spreadsheet a primary key which is the point of reference just in case the customer is entered twice in error, they can always cross reference and just add information needed to be added without being entered twice. I will uniquely identify a person. What I did, I added a column numbering each customer, that way every customer will be tied to a unique identifier which the customer number in the spreadsheet and so forth. I also added a filter to help better manipulate the data in the spreadsheet. Lastly , I added a tab to help them to the worksheet by keeping the same information but instead creating an easier user friendly for them entering the information needed according the day of business operation. In case they ever need to add more information to the...

Words: 416 - Pages: 2