Microsoft® Excel® 2010 Tips
Microsoft has introduced a package of Office products. These include Word, Excel, and PowerPoint etc. The Microsoft Excel is mainly used as a spreadsheet. It can be used to prepare account sheets, daily reports, and stock details etc. The Excel uses a number of sheets with grid of cells arranged in rows and columns. The new edition of Excel, the Microsoft Excel 2010 comes with new features to satisfy customer needs. The software allows 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. The Microsoft Excel 2010 uses many tools and formulas to simplify working with spreadsheets.
- Customize toolbar
- Activate formula-bar with keyboard
- Equal signs
The Microsoft 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
The Microsoft 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 the Excel will expand the information in the cell and allow you to edit the information directly in the cell.
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 just 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.
iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction.
- Comprehensive support for using formulas and tools in Microsoft Office Excel 2010
- Diagnosis & repair for your technologies
- Troubleshoot software errors
- Update drivers and security to protect against online threats
- Connect to Internet, devices and peripherals
- Optimize your computer’s speed and performance