How to use MS Excel more efficiently

[GracieSingh]

Hi all,

I am accountant in one company. I am using office org from 5 years, but now i want to swap all my works to ms excel but i feel some trouble in formulas and all that in excel. I want to improve my skills in ms excel. Please provide some excellent skills. Thanks in advance.

[Eric B]

Open the folder where Excel, use the mouse to drag the Excel icon to "Start" folder, then Excel shortcut was copied to the "Startup" folder, next time you start Windows can be a quick-start Excel. If Windows has been activated, you can use the following method is fast to start Excel.
Method 1: Double-click "Start" menu in the "Document" command inside an Excel workbook that can be either.
Method 2: Using the mouse from the "My Computer" will drag the Excel application on your desktop, and then from the shortcut menu, select "Create Shortcut in the current location" to create a shortcut to it to start when you just double-click its shortcut can be.
All the best.

[Glenny]

I will you the for tips for Quick Search Workbook. You can use the worksheet in any text search methods are:
(1) Click the toolbar of the "Open" button in the "Open" dialog, enter the file's full name or partial name, you can use wildcards to replace;
(2) In the "Text Properties" edit box, enter the text you want to search, it is best do you think is the only word or phrase to search more successful;
(3) Select "Start search" button. Found to meet the conditions of the document before the "Open" dialog box, the status bar will display "0 files found" message, you should be patient, only when the "Open" button is available from the ashes of the state into the state only when the show that the search was completed.

[Glenny]

If you choose "File" menu in the "Print" command to print, there will be "Print" dialog box lets you choose the cumbersome procedures involved. To skip the dialog box, you can click the "common" tool bar on the "Print" button or press the Shift key and click the "Print Preview" button, Excel will use the "selected sheet" option Print. Press Ctrl + PageUp key combination to activate the previous worksheet, press Ctrl + PageDown key combinations can be activated by a worksheet. You can also use the mouse to control the bottom of the label sheet to quickly move the scroll button on the name of the table, and then click the worksheet to switch. Check and reply.

[Macarenas]

This procedure for fast switching Workbook. Workbook for small switch, you can click the workbook where the window. Want to work over multiple windows under the switch, use the "Window" menu, the most convenient. "Window" menu at the bottom of lists that have been opened workbook name, to directly switch to a workbook, from the "Window" menu, select its name can be. "Window" menu lists up to nine workbooks, if more than nine, "Window" menu contains a file called "multi-window" command, use the command, then the emergence of a alphabetical list of all open workbook name dialog box, just click the name of which can be required. Check and replty.

[ThoMas321]

This is for fast creation tool bar. Through the toolbar, you can quickly access frequently used commands or custom macros, you can quickly create their own toolbar. Method: Click the "Tools" menu in the "Customize" command, select "Toolbars" tab, click "New" button, enter "New Toolbar" name, and then click "OK." Then a new toolbar appears in the window, you can use your mouse to drag the other button on the toolbar of the new toolbar, the button will be in this "settled." If dragging by pressing Ctrl key, the button will be copied. Note: You can not drag the button "Customize" dialog box or work table, otherwise the button will be deleted. Best of luck.