G.RAHUL REDDY_CRIT-A

Problem - Now a days companies are buying tally operation to calculate and manage accounts and profit, loss. Tally operator is very expensive so excel will be easier and a lot cheaper than tally. Once you get a good hand on it then it will be easier. In excel there is much easier functions and also it has functions which will do most of the things which tally can do. Also tally is only used for accounting and profit, loss whereas excel can be used for multiple purposes.

1. We can show how excel is more easier.

2. We can show how excel is cost efficient.

3. We can show how excel can be used in any gadget.

4. We can show how excel can be taught easier. For clients who do not know can learn it faster.

5. We can show how excel can be used for multiple purposes.

6. We can show how excel has a variety of functions.

#How is Excel being a good method and application for doing business in a company or single:

#1) How will excel help you in making good or exceptional Charts? (RESEARCH QUESTION 1 INCLUDING DESIGN BRIEF POINT 2)

Excel allows business companies and users to do the maximum with their data, by using formulas across a grid of cells. Data is inserted into individual cells in rows or columns, and then easily allowing it to be sorted and filtered, the next process would be displayed in a visual presentation to make it look better. Using pie charts, graphs and clustered columns adds meaning to data as it is classifying them into different parts. These appearances and design outlines can add more interest to business reports and persuasive marketing material. This will help you in getting more offers from other companies through your presentation skills through which you can make profits after the project is done.

#2) Use formatting

Excel users can put and format their spreadsheets using different emphasis like -colours, fonts etc to differentiate between columns and bring the most important data to the be bold or whatever their key graph is. There are number of tasks that can be performed and achieved using this tool which makes it more impressive so that it is easier to convince the target audience and also organise the data in a clearer and productive manner. This will lead to more income and profits than before.

#3) How will excel let you be fast find and identify trends? (RESEARCH QUESTION 2 INCLUDING POINT 2 OF DESIGN BRIEF)

When you are presenting data in the form of charts or graphs, it can be helpful to include bold letters or lines, which explicitly detail the key information as well as separating it with others making people catch their eye on it. This may help you describe and demonstrate the key points to other users in a straightforward manner. Through this your target audience will understand the topic straight forward and make deals with you. As wrong information will lead to wrong understanding and no deals.

#4) Bring data together

Excel can be used to bring information from various files and documents together, so that you do not have to put the same concept related files separately and you can put it in a single location. As well as data and information from other spreadsheets, it is possible to import text and images from anywhere in the pc, internet or other spreadsheets. This will help you get all the data related to accounting in one place like you do not need to put profits in one document, loss in one document and income in one document etc. You can put all of them in one.

#5. Audit tool bar.

Many users are looking up towards ensuring that the right columns and rows are being used in any given format in their company or business. When you are calculating profit and loss if the data will get mixed up with loss or jumble up then it will be very hard for you to get it back.

#6. Quickly sum up numbers.

The most common thing you can do is mathematical sum function in the excel. For calculating profit and loss easily.

#7. Does this feature of auto fill series help your work be done faster? (Research Question 3 Including point 2 of design brief)

Spreadsheets are normally about some type of series or continuation. This feature will save a lot of time in the typing of months or any series. This will autofill the series once you type two number in column and the rest will be done by excel. Auto fill will help you to fill up months with which you can write income and profit/loss.

ANALYSIS of the Existing products:

As we can see they have used excel for their company in the concept of business. They used it multiple purposes. They are –

1. Revenue multiple

2. EBIT – Multiple before Capex

3. EBIT – Multiple after Capex

4. Price earnings multiple

5. Revenues

6. Cost of sales

7. Gross margin

8. Pay roll cost

9. General and Admin

10. Marketing

11. Other operating expenses

12. Debt Interest

13. Operating profit/loss

14. Management charges

15. Pre-Tax profit/loss

16. Income Tax

17. After tax income

18. Depreciation

19. EBIT-DA

20. EBIT

21. PRE-TAX Operations FLOW-CASH

So here as you can see excel is being used in up to 21 different methods in one company so just imagine how many companies would have been using it and for what have they used it for. One of the most important thing is Profit and loss calculation before capex and after capex (capital expenditure). In this topic it can be the easiest to do in excel as there is complete calculations option in which you type in your expenditure and income, then it tells you your profit and loss. This Objective is very important as you do not need to calculate each and every thing one by one. This makes you work on time of pre-time.

I would improve it by making things easier. I would put all subtopics in one head topic like pre capex and post capex profit/loss in one and then it would only tell profit or loss. I would also make it more organised by putting or doing grouping of variables so that the product spread sheet is not messed up and confusing for any supervisor or anyone who has this job.

#2 -------------------------------------------------------------------------------------------

We can see that here to make the details of the employees easier they have made an excel sheet in which they have:

1. Employee Name

2. SSN

3. Department

4. Title

5. Hire date

6. E-mail

7. Office

8. Home address

9. City

10. State

11. Zip code

12. Home phone

In this sheet they have used 12 types of access points which helped them keep their company employee details more organised.

They could improve it, by putting the amount of salary as it varies from each department and also Their ratings and suggestions on any important event which happened so that the owner of the company may act accordingly. Also how many employees have actually contributed to increase the profit of the company and also they can blacklist the people are not contributing and causing them a loss of money in as salary.

#3 ----------------------------------------------------------------------------------------

As we can see here this excel spread is very unique as they have –

So here as we can see they have 5 expenses in the given each month given and their Expense trends are also displayed in a graphical order on the right hand side.

They could improve as in one month they have in total 5 expenses so they can put in one column as total expense and then divide it by their own for the first month second month and continuation. For the graph thy can put the data in this detailed manner which is above in the photo of the excel spread sheet.

In this way we can connect it with profit and loss as they could calculate income and total expenditure per month to get profit or loss of one month or for the full year to get profit or loss per annum.

Design Brief

- - - - - - - - - - - - - - - - - - - - - - - - -

The information I wrote talks about how the features of excel help in calculating profit and loss, income. I basically found out that the software (excel):

This software is very outstanding. These features help you in your business statistics, faster work and less time. Excel has all the features listed above through which you can make your work outstanding by just sitting. Excel has features which enable you to a complete new world which has nearly everything you need. It also gathers data and makes a graph. This whole thing not only lets you calculate profit, loss and income but also organise and present it in a perfect manner.

The features and images of the spread sheets are very important for calculating profit and loss as without any of these features you will stay one step behind success. So the features will help you and your data to be more important as calculating the income and profit, loss is very essential in a company as then you can see how much you can do the expenditure accordingly to get a better data process or excel spread sheet product.

My problem was that - Now a days companies are buying tally operation to calculate and manage accounts and profit, loss. Tally operator is very expensive so excel will be easier and a lot cheaper than tally. Once you get a good hand on it then it will be easier. In excel there is much easier functions and also it has functions which will do most of the things which tally can do. Also tally is only used for accounting and profit, loss whereas excel can be used for multiple purposes. (Do not count 86 words as this is repeated)

The features are improving day by day and I also included how each feature lets you be a better owner of a company.

The product will help the client or the owner to make a better organised work office.

This information is very essential to company owners to keep their data more confidential and organised. I have also written the features of each product related to my problem so that even if the pictures are not showing and unavailable the information says it all.

My sources are very reliable as the websites are approved and also liked and good comments are given by the people. The information is also cross checked with other websites and is the most same. My sources are also reliable as the data given in the website are important according to my task and also I have analysed the data from the cites in a better and understandable way. The websites are showing accurate information and also are in context, related to my problem.