Tips+when+using+Excel+for+Business

= Excel Tips when Using it in a Business Environment = These tips will describe how to make things stick out or point on important points in the excel worksheet for your boss or for your employee.

In my experience, I find the most beneficial way of doing it without messing up the worksheet and without creating a lot more work is by adding comments to the cells. This allows the person you send the worksheet to see exactly which cell you are referring to along with making the point that you want to. An employer can use this to point out to the employee something that should be changed, something that is incorrect or something that is unclear. An employee could use this tool to point out key information that they want to emphasize to their employer to a possible customer that wanted a specific product possible. One example of this, is on a breakdown of prices where you can put a comment on why something was more expensive than what was expected. (shown in the image below)

Then, to make a worksheet so that the person you are sending it to cannot change specific data, there is an option in excel to lock certain sheets or the total worksheet. This would only allow them to change data if you gave them the password that you assigned the worksheet when you locked it. This is very useful when you want to send customers things where you only want them to be able to change the values on the first page and the results of the changes appear in other pages where they cannot change anything on purpose or by mistake. This feature is also in the review tab under the changes section.

The last tip is to make a bigger spreadsheet more easily read, there is an option under the view tab that allows you to freeze certain cells, freeze a certain row or freeze a certain column so that it is always visible no matter where you are on the sheet. This is useful to do with headings when there are many types of data that extends far down the page. An example of this is shown below where the headings of the columns are frozen in order to know what the columns mean when viewing the bottom of the data.

These tips should help you perform more efficiently in a business type job environment and allow you to complete your job easier!

Joseph Viviani Info 273

=

 * Excel is a very popular and great program to use when working with Business. It makes it that much easier to calculate statistics, reports, and analyses when working with numbers. **======


 * Here is an easy way to analyze seasonal sales:**




 * This is an easy and effecient way to record your sales. You can see where your business stands and what areas you need to improve in to keep gaining profit. All you have to do is plug in your numbers into Excel and it will create the graph for you. **

Businesses can also use Excel to organize their cash flow: **

The functons in excel allow you look at your expenses, the money you are taking in, and determine if the business is making a profit. You can reference to different areas of your cash flow to calculate your profits, yearly averages, and many more functions related with business. **
 * Calculating your cash flow in Excel is best way to organize and determine where your business stands.

Microsoft Excel is the most **EFFICENT** and **SIMPLE** way to calcuate business statistics, reports, analyses, cash flow, profits, and just about anything you need when working with a business. -Info 273 -Patrick Butler