Erp Testing

In: Business and Management

Submitted By samarths
Words 3348
Pages 14
Symbiosis Institute of Business Management, Pune

MS Excel 2010 Preinduction Courseware

Contents
Introduction to Microsoft Excel 2010 ......................................................................................... 2 What is new in Excel 2010 ..................................................................................................... 2 Getting started with Excel 2010 .................................................................................................. 4 Excel worksheet movement keys ............................................................................................ 4 Entering and editing data in Excel worksheet............................................................................. 5 Using AutoFill to enter a series of values ............................................................................... 5 Creating Custom Lists............................................................................................................. 6 Adding comments in the cell .................................................................................................. 6 Editing data in Excel worksheet ............................................................................................. 8 Using Paste Special ................................................................................................................. 8 Formatting data in the worksheet .............................................................................................. 10 Formatting data using Format Cells dialog box .................................................................... 10

Prepared By: Prof. Anjali Abhyankar SIBM, Pune

MS Excel 2010 Preinduction Courseware

Session I

Introduction to Microsoft Excel 2010
Microsoft Excel 2010 is the most widely used spreadsheet program of the Microsoft Office Suite. You can use…...

Similar Documents

Testing

...testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing......

Words: 519 - Pages: 3

Testing

...groups What are the tangible and intangible benefits of ERP system? Tangible benefits are those measured in monetary terms and intangible benefits cannot be measured in monetary terms but they do have a very significant business impact. Tangible benefits: * Improves the productivity of process and personnel * Lowering the cost of products and services purchased * Paper and postage cost reductions * Inventory reduction * Lead time reduction * Reduced stock obsolescence * Faster product / service look-up and ordering saving time and money * Automated ordering and payment, lowering payment processing and paper costs Intangible benefits: * Increases organizational transparency and responsibility * Accurate and faster access to data for timely decisions * Can reach more vendors, producing more competitive bids ; * Improved customer response * Saves enormous time and effort in data entry ; * More controls thereby lowering the risk of mis-utilization of resources * Facilitates strategic planning * Uniform reporting according to global standards Enterprise resource planning, commonly known as ERP, is a computer software system used to manage the organizational resources. It provides a way for integration of data and processes within an organization. Thus, depending on their authorization, the different departments can check upon this unified database. ERP systems are used in both large and small organizations,......

Words: 3282 - Pages: 14

Erp Failures

...Case Study ERP Implementation Failures ERP systems are an integrated software solution that is typically offered through a vendor as packaged software that supports the organization’s supply chain and other business functions, such as, receiving, inventory management, customer order management, production, planning, shipping, accounting, and human resource management. The use of ERP is very widespread across a multitude of industries. As a matter of fact, a report by Computer Economics Inc. states that, “76% of manufacturers, 35% of insurance and health care companies, and 24% of Federal Government agencies already have an ERP system or are in the process of installing one.” Over 60% of Fortune 1000 companies have implemented ERP systems (Hawkins & Stein, 2004). It is not just large firms that are implementing ERP systems, small and medium size companies are making use of ERP systems as well (O’Leary, 2004). ERP systems have expanded across the globe and many of world’s leading companies consider Enterprise Resource Planning (ERP) systems an essential information systems infrastructure to survive and prosper in today’s economy. There are many advantages to ERP systems. Companies that have successfully implemented ERP systems report improvement in management decision making, improvement in efficiency, improvement in information exchange, improvement in performance and productivity levels and improvement in customer service and customer satisfaction, just to name a few.......

Words: 1570 - Pages: 7

Erp Systems

...Bastian Steppin March 24th 2013 000111821 Dr. Reimers CIS 300 Research Paper ERP systems The world’s economy moves fast, indeed it moves so fast that businesses need to be ready to change their strategies and market scope in the blink of an eye. To catch up with the rest of the world companies need to transform their whole resource management system away from old fashioned management consultants up to ERP systems, which operate faster, more effective and more precise. The key to run a business with success is to be innovative and use resources as efficient as possible. Many players on the competitive market make big mistakes on calculating their revenue and expenditure. Unfortunately most of the time the calculations neglect to take all expenditures in account. The human resource department for example often forgets to include the salaries paid to freelancers. Instead they only put the salaries of their permanent employees. Thus they only look at their fixed cost, but not on their real expenditure. The real problem about these relatively small mistakes is that they usually never come alone. Such miscalculations can be seen as cancer, whose metastases crawl throughout a company and make small damage in all the different sectors. Now take the whole company and the small sums ad up to one great deficit. The answer to all these problems is called ERP (Enterprise Resource Planning). Thanks to the digital revolution, which started in the early 1980’s......

Words: 1162 - Pages: 5

Testing

...Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing. Testing.......

Words: 362 - Pages: 2

Testing

...testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing te......

Words: 336 - Pages: 2

Erp and Crm

...Startup companies. Company can use the functionality that are needed and expand their use as the company grows. Since there is no capital investment and no IT team needed, startup companies can test markets and change course if their business changes.    Small to middle-size companies: lack the know-how or financial resources to successfully build and maintain ERP and CRM applications in-house        Companies that want to reduce internal IT cost: Companies which are replacing cost-intensive IT tasks with comparable cloud-based, on-demand services. By using cloud based ERP and CRM, companies can spend less money on software licenses, hardware, storage and training.       Company that wants to reduce their capital costs: There is no need to purchase computer hardware to house your cloud-based ERP and CRM system. Operational costs, including IT support,  power to run servers and server operating systems are reduced or eliminated. Types of companies which are most likely to adopt cloud-based ERP and CRM software services will be companies that want to cut IT staff cost. With CRM and ERP, a business can be up and running with the software quickly which less need for in-house IT staff or high levels of technical skills, and things like security and upgrades are looked after by the vendor. This is because the difference between cloud and on-premise is that cloud-computing makes your software an operational expense rather than a capital spend. There’s usually little or no......

Words: 3549 - Pages: 15

Erp Csr

...* Critical Success Factors for ERP implementation: The Critical Success Factors (CSF) in implementing an ERP system, that enables the Organisation or an Industry has been very challenging; in terms of integrating all the business processes within the Industry, to stay competitive and ahead of other players in the market. In order to increase efficiency and improve productivity the successful implementation of the ERP system would pave way for faster productivity and competitive advantage. Generally, ERP can be defined as enterprise wide IS (Information System) that amalgamates and controls all of the business processes in the organisation intact. According to Nah and Lau (2001) ERP is “a packaged business software system that enables a company to manage the efficient and effective (materials, human resources, finance etc.,) by providing a total, integrated solution for the organisation’s information-processing needs”. If ERP is implemented proper and efficient, the flow of information across the organisation is integrated into single common database. This allows easy and immediate access to information regarding inventory, product or customer data, and prior history information (Shehab et al., 2004). The CSF can also be influenced by the best practices adopted by the organisation. Please see the diagram below for success factor category deriving best practices. The main facets discussed below are the most prominent in the organisation for best implementation......

Words: 2095 - Pages: 9

Testing

...Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing......

Words: 525 - Pages: 3

Testing

...Background: The topic of selecting an Enterprise Resource Planning (ERP) Recruitment Solution vs. a Best in Breed (BoB) Talent Acquisition Solution is very common these days, especially as companies look to reduce costs, while competing and ultimately winning the “War for Talent”. The purpose of this document is to compare and contrast the benefits of each approach, using examples and quotes from individuals who have experienced both types of implementations and finally, to offer thoughts and questions that must be considered when making this decision. Best of Breed Talent Acquisition ERP Recruitment Solution Pros Cons Pros Cons Historically better functionality, more comprehensively meeting business requirements, configurability, and compliance Lesser functionality; playing “catch up” to BoB vendors (some ERP products still have no Career Hosting functionality, are not available as an ASP, offer no Job Agent technology, candidate prescreening, etc.) Requires interfaces to disparate HR systems/components Integration with HR/Payroll components, e.g. eferral payment processing integrated with payroll, on-boarding, etc Integration points & functionality still required for background checking, job posting services, assessment services, tax credit services, etc. Vendor focus & expertise. Dedicated resources to evolving the product. Dealing with a single vendor. Talent Acquisition not focus of development resources and R&D......

Words: 1196 - Pages: 5

Testing

...Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing Testing......

Words: 256 - Pages: 2

Erp Implementation

...UniversityRobert W. Starinsky, InstructorWinter Quarter, 2004 | ERP Implementation Report of Findings and Recommendations CISCO Systems, Inc. Table of Contents Table of Contents 1 Background and Scope 2 ERP Implementation scenario 2 Situation Analysis 3 Conclusion and Recommendations 4 Background and Scope Cisco System, Inc is a Computer Technologies company that was founded in 1984. The company’s primary product is the “router.” The router is hardware and software that control Intranet and Internet traffic. With the growth of the Internet, Cisco products became in high demand. In 1997 Cisco was ranked among the top five companies in return on revenues and on assets. Cisco has been classified in the same category of successful companies as Microsoft and Intel. With the growth of Cisco, their computer systems were unable to handle the increase volume. The Cisco legacy system was a Unix-Based software package that supported its operations of: Financial; Manufacturing; and Order Entry. The system lacked reliability and the ability to expand. Eventually in January 1994, Cisco’s legacy computer system malfunctioned corrupting Cisco’s central database. The company was practically shutdown for two days. As Cisco struggle to recovered from the major shutdown, the company realized that they needed to act quickly and elected to implement an ERP system. Little over a year later, Cisco successfully implemented an ERP system from Oracle. This report has......

Words: 1835 - Pages: 8

Erp in Retail

...Introduction: ERP is the short form of Enterprise Resource Planning. ERP utilizes ERP software applications to advance the performance of organizations' resource planning, management control and operational control. ERP software is multi-module appliance software that integrates activities across functional departments, from product planning, parts purchasing, inventory control, product circulation, to order tracking. ERP software may include application modules for the finance, accounting and human resources aspects of a business. Enterprise Resource Planning systems (ERPs) integrate (or attempt to integrate) all data and processes of an organization into a unified system. A typical ERP system will use multiple components of computer software and hardware to achieve the integration. A key ingredient of most ERP systems is the use of a unified database to store data for the various system modules. ERP is an amalgamation of a company's information systems designed to bind more closely a variety of company functions including human resources, inventories and financials while simultaneously linking the company to customers and vendors. The Aim of an ERP System - The aim of ERP is to advance and modernize inner business processes, which characteristically requires reengineering of current business processes.  The Components of an ERP System - The components of an ERP system are the common components of a Management Information System (MIS).  * ERP Software - Module......

Words: 2779 - Pages: 12

Erp Failure

...ERP lmplementation Failure at Hershey FoodsCorporation Case study Reference 908-001-1 no This case written InduPerepu, was by under direction Vivek the of Gupta, lcFAl center Management for Research. intended be used thebasis lt is to as for class discussion rather thanto illustrate either effective ineffective or handlinq of a management situation.The was case compiled published from sources. @2008, ICFAI Center Management for (ICMR). Research Nopartof thispublication be copied, may stored, transmitted, reproduced or distributedanyformor medium in whatsoever without permission the of thecopyright owner. DlrtÍibuted by sch,UK and USA NoÍth AmcÍie RestoÍth. woÍld GE - thecase learninqffiffI;ïi" for ;ïl;:llï;:ï a ecchusa@ecch.com ;ïillll;:Íïiï; € êcch@ecch.com PÍinted in UK and UsA 908-001-1 ERP IMPLEMENTATION FAILURE AT HERSHEY FOODS CORPORATION "The Hersheydebacleis not an indictmentof ERPsper se, but it should caution any company that choosesto implementsuch a broad suite to make sure that systemwill function smoothly beforeenteringa peak salesperiod."l - Chain StoreAge, in 1999. "There is no doubt that 1999was a most dfficult and disappointingyear for Hershey Foods Corporation. llhile the year got off to a slow start due to excessiveretail inventories, we fully of expecteda strongfinish in the secondhalf of the yea.r.Instead, the implementation theJinal phase of the Corporation's enterprise-wide information systemcreatedproblems in the......

Words: 5652 - Pages: 23

The Abc's of Erp

...The ABCs of ERP Compiled from reports by Christopher Koch, Derek Slater and E. Baatz (From CIO on December 22,1999) What is ERP? Enterprise resource planning software, or ERP, doesn’t live up to its acronym. Forget about planning it doesn’t do that and forget about resource, a throwaway term. But remember the enterprise part. This is ERP's true ambition. It attempts to integrate all departments and functions across a company onto a single computer system that can serve all those different departments’ particular needs. That is a tall order, building a single software program that serves the needs of people in finance as well as it does the people in human resources and in the warehouse. Each of those departments typically has its own computer system, each optimized for the particular ways that the department does its work. But ERP combines them all together into a single, integrated software program that runs off a single database so that the various departments can more easily share information and communicate with each other. That integrated approach can have a tremendous payback if companies install the software correctly. Take a customer order, for example. Typically, when a customer places an order, that order begins a mostly paper-based journey from in-basket to in-basket around the company, often being keyed and re-keyed into different departments’ computer systems along the way. All that lounging around in in-baskets causes delays and lost orders, and all the......

Words: 3921 - Pages: 16