Login

Connect
Sign in using Facebook
To prevent automated spam submissions leave this field empty.

3 tips for Excel 2010

1 reply [Last post]
layne's picture
layne
Offline
Newbie
Joined: Jul 7 2010

My very tech savvy brother shared these with me so I figured I would pass them along:

Microsoft Office Excel 2010 tips:

Microsoft Excel as many know is mainly used as a spreadsheet. It can be used to prepare account sheets, daily reports, and stock details etc. Excel uses a number of sheets with grid of cells arranged in rows and columns. The new edition of Excel, Excel 2010 comes with new features that allow you to analyze, manage and share information in improved ways which helps you in doing things in better ways. With the new software you can easily upload your files to browser as well as you could work with others online. The new Pivot table and Pivot chart helps you in making your data manipulation fast. The Excel Web App helps you in working with other people on the same workbook. Microsoft Excel 2010 uses many tools and formulas to simplify working with spreadsheets.

There are some tips to use the formulas and tools of Microsoft Office Excel 2010. The tips are:

Customize toolbar
Activate formula-bar with keyboard
Equal signs
Customize toolbar

Excel 2010 has 24 pre-configured toolbars each with a number of tools which contain commands for running excels. You need to customize these toolbars to efficiently access these tools. You could create your own toolbars which contain your favorite or most needed tools. For this, you need to click on View, then select “Customize Quick access Toolbars” and then click Customize button. Then a list of tools would be displayed on the screen and then you can add or remove tools as you wish.

Activate formula-bar with keyboard

Excel 2010 provides a number of formulas. You could use these formulas to perform calculations in your Excel sheet. The Formula bar contains a number of formulas. You could open the formula-bar to use different formulas. But, you need not select the formula-bar and then insert the formula with your mouse every time, which is much time-consuming. To avoid this problem you need to activate the formula-bar with keyboard. You could quickly access the formula-bar by pressing F2 button in your keyboard. Then Excel will expand the information in the cell and allow you to edit the information directly in the cell.

Equal signs

When you want to use formula in your Excel sheet, you might be selecting the formula-bar every time. But, it is much time-consuming for those users who perform a number of calculations in the Excel sheet. There is an option for using formula in your Excel sheet easily. You could use the equal (=) sign to use the formula. You have to select the cell where you want to display the result. Then you have to enter an equal sign in that cell. Then, enter the operators and select the operand cells.

mirror's picture
mirror
Offline
Newbie
Joined: May 15 2010

Layne, thanks for taking the time....these are great.