Design prototype spreadsheet

Assignment Help Operation Management

Reference no: EM131278751

Task : Build input validation routine controls (EXCEL)

Based on the findings above, you have determined that too many transactions are being entered into the PCard system for the wrong MCC. Paul would like you to design a prototype spreadsheet in Excel that allows administrative staff to enter in the PCard data (same columns/fields as the file you were given) but prevents them from entering in transactions in prohibited MCCs. He would also like the MCC description to appear. In addition, only valid employees should be allowed to be entered. Once the PCard number has been selected from a list, the PCard holder name should automatically appear. In addition, purchase and credit should be the only options for source type (Hint: Data Validation and Lookup). You may want to reorder the columns.

To assist you, your instructor is providing you with a list of valid MCCs.

Provide the steps on how to do data validation and vlookup in excel.

Reference no: EM131278751

Questions Cloud

What strategic issues and problems : What strategic issues and problems does Panera Bread management need to address? What would you suggest that Panera Bread needs to do to strengthen its competitive position vis-à-vis their competitors.

Competency modeling study : From an employee’s perspective, would you prefer to have a job description and performance appraisal based on a task-focused job analysis or on a competency modeling study?

Disabled veteran asian female working for contractor : You are a service disabled veteran Asian female working for a Contractor and see some lucrative business opportunities if you establish your own company. But, you know it takes a lot of cash/capital to start your own business – and you also want to h..

What are some of the hidden requirements : What are some of the “hidden requirements” contained within the Section I of a Government contract (the FAR/DFARS/etc. clauses)? Pick one and advise your classmates what a company must do to comply.

Design prototype spreadsheet : Based on the findings above, you have determined that too many transactions are being entered into the PCard system for the wrong MCC. Paul would like you to design a prototype spreadsheet in Excel that allows administrative staff to enter in the PCa..

Primary characteristics of action plan objectives : What are the primary characteristics of action plan objectives? Are these characteristics descriptive of good organizational strategic goals? Why or why not?

Deciding on potential global market to enter : In your opinion , what key elements about coca cola 's campaign made it so succesful and why? what factors should companies consider when deciding on potential global market to enter?

Positively influence their emotional intelligence : Recommend a strategy that the organization could undertake in order to improve the social skills of leaders within the organization and thereby positively influence their emotional intelligence. Support your recommendation with specific examples that..

Emotional intelligence to manage today workforce : Suggest two to three (2-3) reasons why leaders’ need emotional intelligence to manage today’s workforce. Speculate on at least two (2) possible consequences should a leader not possess emotional intelligence.

User Account

All Pages