Preview

Office Automation System

Good Essays
Open Document
Open Document
354 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Office Automation System
Generally, there are three basic activities of an office automation system: data storage of information, data exchange, and data management. Office automation refers to computer, software and machinery combine to accomplish basic tasks in the work place.
Data storage includes office forms and documents. Word processing accommodate textual and spreadsheet applications handling in numbers. Word processing is the most basic and common office automation activity. The input is usually via keyboard to manipulation of text on a computer. Today’s commercial word processing applications provide users with a sophisticated set of commands to format, edit, and print text documents. One of the most popular features of word processing packages are their preformatted document templates. Templates automatically set up such things as font size, paragraph styles, headers and footers, and page number so that the user does not have to reset document characteristics every time they create a new record. Word processing helps documents work easier and faster than typewriter in the old day. Office forms and documents are organized, saved time, and increased in productivity.
Spreadsheet programs allow the manipulation of numeric data. Early popular spreadsheet programs such as Visi Calc and Lotus 123 greatly simplified common business financial record keeping. Particularly useful among the many spreadsheet options is the ability to use variables in pro forma statements. The pro forma option allows the user to change a variable and have complex formula automatically recalculated based on the new numbers. It works like a large calculator and extremely powerful. Many business use spreadsheets for financial management, financial projection, and accounting. An example of spreadsheet use would be to calculate sales profits for the current year and can be presented in graph. The range of formula that can be applied is from basic to complex calculations to calculate different scenarios.

You May Also Find These Documents Helpful

  • Good Essays

    1.1 Outline different types of documents that may be produced and the different styles that could be used…

    • 1887 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    COMP101 U1 IP Document

    • 635 Words
    • 2 Pages

    Paragraph 3: Word, which is a word processing computer program and much more, are an extremely powerful and full-featured business and personal tool for creating documents of all kinds, and Word is studied in Unit’s 1 and 2 in this course. PowerPoint, which is a software product for preparing slides for personal or business presentation, will be studied in Unit 3. Excel, which is an automated spreadsheet, will be studied in Units 4 and 5. The ubiquitus computer have much power when used for purposes of creating, modifying, and storing documents, for tracking and storing data in spreadsheet form, and for making personal and business presentations to convay information or to persuade thinking of others. Those are the Office 2010 functions that are concerned in this course, called COMP101.…

    • 635 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    My company can make a massive use of spread sheets, for this I will use Microsoft Excel as this is the software that easily available. With this software I will be able create many things including a Cash Flow diagram (Appendix 1). This will allow me to then work out efficiently the costs of the business, the income of the business and the cash flow throughout the months. This software will also allow me to have formulas to make sure that the totals are correct, due to using the of the if I was to decide that I wanted to pay lower wages or found a supplier with lower prices I could change the figures in my spread sheet and the formula would then change the totals automatically. The formulas that I have used is the ‘SUM’ function to add up the totals and also then used them to add up my Net Cash Flow and my opening and closing bank balances (Appendix 2). This piece of software is very useful as it means I will have no calculations to do myself and will reduce the possibility of mistakes. It also makes the figures and all of my profits/losses and costs very clear, easy to understand and interpret. The disadvantages are that if you do not have some experience in using excel it can be hard to understand and mistakes can be made, even with experience in using it.…

    • 1872 Words
    • 8 Pages
    Good Essays
  • Powerful Essays

    A business therefore requires employees to have knowledge of how to create a spreadsheet and how to use formulae and functions effectively. This unit will provide the learner with the skills to enable them to create and use a complex spreadsheet model. The aim of this unit is to help the learner understand how spreadsheets can be used to solve complex problems. Learners will learn how to create a complex spreadsheet model and to use a range of formulae and functions.…

    • 3515 Words
    • 19 Pages
    Powerful Essays
  • Good Essays

    References: 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.…

    • 745 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Excel will be able to assist you by performing basic mathematical operations such as summing columns and analyzing data to show trends on the monthly expense report. These functions will help the business professional find information such as loss or profit. It will also assist in calculating payment plans for loans, payroll expenses, and other costs the business may incur.…

    • 1076 Words
    • 3 Pages
    Better Essays
  • Good Essays

    If you were to look at spreadsheet applications much like that of Microsoft Excel you probably already understand that by its design it is much easier to crunch numbers within these types of systems. Programs like Excel are highly known for and recommended for manipulating numbers and complex equations. That may seem to work fine for the time being when you are only dealing with a limited amount of data/ accounts. You will notice as time goes on that the number of spreadsheets that you will need to conduct business will greatly increase making it hard to manage the amount of these spreadsheets and it will make it harder to track your information later on ( ). On top of this you will find yourself having to do a lot more work to attempt to get these different spreadsheets to work hand in hand with one another making the task very frustrating to all the users involved.…

    • 817 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Unit 9 Alvarez

    • 726 Words
    • 3 Pages

    This course has helped me have a better understanding on spreadsheet concepts, including calculations, formulas, built-in functions, and spreadsheet design. It has also given me the opportunity to explore charts, data tables, pivot tables, and what-if analysis. Moreover, I am now able to easily create spreadsheets to solve business problems, use the formulas and functions to perform calculations prepare workbooks to consolidate data, create macros to automate worksheets, and analyze data using the scenario manager.…

    • 726 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Syabus

    • 3034 Words
    • 13 Pages

    Please Note: The CIS105 Textbook/Lab Manual Bundled Package was customized to remove content not utilized in this course. Therefore, page numbering may not be consistent. Textbook required for Course: Title: “Computers Are Your Future” & “Exploring MS Office 2010 Comprehensive” Author: Catherine LaBerta, Robert T. Grauer, Keith Mulbery, and Mary Anne Poatsy ISBN: 9781256434214 Rio Salado College has developed a unique Textbook Savings Program that uses customized textbooks and saves…

    • 3034 Words
    • 13 Pages
    Good Essays
  • Good Essays

    Many organizations use spreadsheets to keep record of financial, employee, customer, and vendor information. Spreadsheets make it easier to create budgets, calendars, invoices, and contact lists. With Microsoft Excel, it can be linked to other programs such as Microsoft Word and Access. Spreadsheets help to compile a company’s data into user friendly data.…

    • 513 Words
    • 3 Pages
    Good Essays
  • Good Essays

    3. Use word processing software tools to format and present documents effectively to meet requirements…

    • 1799 Words
    • 8 Pages
    Good Essays
  • Good Essays

    • MS Word processing (Standard word documents: Use for the creation of most documents such as letters, memos, minutes, etc.)…

    • 2906 Words
    • 12 Pages
    Good Essays
  • Good Essays

    Microsoft Word-Microsoft Corporation was founded in 1975 lead global in the development and production of software and software-related services and solutions. Initially known for home computers, Microsoft, headquartered in Washington, now offers various operating systems and software for desktop computers. This multinational company strives to help the worldwide business community improve efficiency and productivity. In recent years, this company has battled criticism concerning what some consider monopolistic, anti-competitive business practices. Despite legal setbacks including antitrust violations sanctioned by the US Department of Justice, Microsoft remains a major player in its field.…

    • 756 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Application Software

    • 425 Words
    • 2 Pages

    2) Spreadsheet; provides a wide range of built-in functions for statistical, financial, logical, database, graphics, and date and time calculations. I.e., Microsoft Excel, IBM Lotus 1-2-3, Google Spreadsheet, Apple Numbers and Sun Calc.…

    • 425 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    A document is information produced in either printed or electronic (on-screen) format. All documents can be produced using standard applications packages.…

    • 3504 Words
    • 15 Pages
    Powerful Essays

Related Topics