How to use MSExcel 2010 easier than earlier?

We use MSExcel for calculations , auditing and for many other tasks but do we really work efficiently by knowing every small feature present in that? Lets find out how to use it in efficient manner. I hope it will be useful for you.

<BR>How to use MSExcel 2010 easier than earlier?<BR>

How to use Equation Support?

You can find new equation editing tool in Excel 2010 to insert mathematical equations into worksheets or you can build your own equations but for which you have to use library math symbol.
New equations can be set inside the textboxes as well as in other shapes.

How to use picture charts in Excel 2010?

You can fill 2D columns or bar charts with images. To achieve this , select column or bar which you want to change then right click the mouse.
Choose format Data series->Fill and select picture or texture fill. Select an image to use from your hard disk from your clip art collections or from clipboard.
Click stacked to ensure images are stacked. Make sure images are not streched. Then close.

How to save worksheet as a picture?
If anyone wants to create picture of a worksheet or a chart to use as a thumbnail or in a cover page then it can possible to do inside the excel. To start by selecting data range in the cells, anyone wants to convert into a picture. If it is a chart then select chart itself.
From the copy of a ribbon toolbar, select copy as Picture, then choose to capture the image either as it appears on the screen or as it will appear when printed.
Select the picture or a bitmap if those options are available and then click on OK. Now it is available for pasting.

How to add your logo to an Excel printout?
We can add company logo or any other images to the header of an excel worksheets so that it will be printed on the every page of the sheet. To achieve this, follow the steps
1. Choose insert and then click one of the boxes at the top of the sheet.
2.Click mountain picture and then choose an image to insert.

How to co-author your workbook?
Different people can edit same workbook from different locations. Windows live account is used to authorize others to use that book. If we have firewall in our company and we use Microsoft Sharepoint 2010 then , others can be used same workbook from their home or outside of the company.

What is the protected mode?
Whenever any person downloads any document , it will be opened in the protected mode. To edit the document, we have to make editing enabled. Click "enable editing " option to make any changes.


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: