BSBITU402 Develop And Use Complex Spreadsheets

1. Analyse task and determine specifications for spreadsheets

2. Identify organisational and task requirements of data entry, storage, output, reporting and presentation requirements

 
An organization can be the ISOO 9001 naming convention (HIRSCH, 1996). This convention suggests that files be named according to document level and document number separated by hyphens for example, 74-2-2. 

1. The VLOOKUP FUNCTION

This is a function that is used to search for a chink of information from a large data set and bring that data to a newly formed table.

1. The SUM function

This particular function is used to sum a set of numbers in a particular column of data. It has a button specifically for it in the Home tab that can be used for summing after selecting the part of the column. 

Formatting and design are very important for the presentation and readability of data in several ways. First, a good design of a spreadsheet ensures that errors that would have otherwise gone unnoticed are greatly reduced. This obviously enhances accuracy which is the goal of any spreadsheet analysis. A good design also helps ensure easy navigability of the spreadsheet, ease of use of the spreadsheet and reduce repetitive inputs and easy error location. A well formatted spreadsheet is ensures data is presentable. It is also very clear and therefore easy to understand. 

Organisational requirements for ergonomics, work periods and breaks, and conservation techniques are very important in a number of ways as is explained in this text. Firstly proper requirements and by extension measures for ergonomics in a work place will help ensure productivity for the full duration of working hours as. This is because measures are put in place to ensure the worker is not fatigued at any point during the working hours thus ensuring that they work without feeling wasted thereby greatly enhancing their productivity. In the same way defined work periods and breaks not only ensure productivity but also timely delivery of assigned tasks as workers will always be aware of the time required for them to deliver a particular  work assigned to them or what they must do once they are at work before taking a break. They will also understand the lengths of the breaks and aim to maximize their outputs within the specified time. Conservation techniques on the other hand ensures proper resource utilization by promptly cutting down on wastes. 

One of the simplest yet most efficient energy and resource conservation technique is turning off all electric devices when not in use. This can be done by making it a requirement or part of the organizational safe work practices to ensure that all electric devices are switched off whenever they are not in use. Follow up can always be done after a particular job requiring electrical use has been completed to ensure this is done. Employees found not to have done this should then be encouraged to do so next time. When this is done, it will ensure no unnecessary resource wastage on electricity subscription bills.

Blackwood, N. (2014). Advanced Excel Reporting for Management Accountants (Blackwood/Advanced) || Management Accounting and Excel. 5.

Francez, N. (2013). Extended naming conventions for communicating processes. 14.

Frank Hodge, P. E. (2009). Management reporting incentives and classification credibility: The effects of reporting discretion and reputation. 12.

HIRSCH, D. B. (1996). File It Under EZ2Remember: Adherence to naming conventions can avoid document retrieval problems. 2.

Miller, S. G. (2009). The Simplified Menu-Cost Spreadsheet: Here's an easy way to use a computer spreadsheet as a menu-analysis tool to help you get a handle on food costs and profits. 4.

PROKHOROVA. (2014). METHODS OF MANAGEMENT STRATEGIES. 9.

Wilfried, L. (2014). Integrated Performance Management strategy. Review of Business and Economics Studies, 11.

Yusuf Jafry, C. M.-N. (2008). The Use of Spreadsheet Software in the Application of Management Science and Operations Research || Hypo International Strengthens Risk Management with a Large-Scale, Secure Spreadsheet-Management Framework. 8.