Excel Tutorial
Excel Tools Menu
A click on the "Tools" tab in the Menubar or pressing "Alt + T" keys will open the Tools menu. By default Excel opens the menu with commonly used commands only. (All commands available under the menu can be viewed by a click on the double downward arrow circular tab at the bottom of the menu.) A small triangle against a command name indicates a sub-menu for the command. The commands listed under File Menu can be executed or the sub-menu can be opened by a click on its icon / tab or by pressing key for the underlined letter after opening the menu (or by pressing the keys listed on the right side of the command name). The commands listed under Tools menu are :
| Spelling | Checks spelling of text in the currently open worksheet. |
|---|---|
| Research | Enables search for typed text on web. |
| Error checking | Checks errors in formulas on the worksheet and if an error is found suggestions are given. |
| Speech | Please Click Here to know about Excel Speech. |
| Shared Workspace | Create Shared Workspace (The workspace you want share with others on the web). |
| Share Workbook | Allows editing of the workbook by more than one user at the same time. |
| Track Changes | Please Click Here to know about Excel Track Changes. |
| Compare and Merge Workbooks .. | Please Click Here to know about Compare and Merge Workbooks. |
| Protection | Enables protection of Worksheet and Workbook, Set Password and define rights of the users. |
| Online Collaboration | Please Click Here to know about Online Collaboration and Meetings. |
| Solver | Please Click Here to know about Solver. |
|---|---|
| Formula Auditing | Formula Auditing can be used to find and correct errors in formulas. Please Click Here to know about Finding and Correcting Errors in Formulas. |
| Goal Seek | Please Click Here to know about Goal Seek. |
| Macro | Please Click Here to know about Macros. |
| Add-Ins | Please Click Here to know about Add-Ins. |
| AutoCorrect Options | Please Click Here to know about Auto Correct, Auto Format and Smart Tags. |
| Customize | Please Click Here to know about Customizing Toolbars and Menus. |
| Options | Please Click Here to know about Options for Customizing Excel. |
| Lookup | Please Click Here to know about VLOOKUP nd HLOOKUP functions. |
| Data Analysis | The Analysis Toolpak is an Excel add-in program that is available when you install Microsoft Office or Excel. To use it in Excel, however, you need to load it first. To install Analysis Toolpak
|
The details of various statistical analysis and other data analysis tools available in Microsoft Excel is beyond the scope of this tutorial. The users may use Excel Help to know about various data analysis tools.