Free Excel Tutorial

Show Full Menus All The Time You are trying to learn Excel. Microsoft only shows you the most common menu choices under each menu. While learning Excel, use the Tools Customize feature to show the complete list of commands on each menu.

Show Full Toolbars All The Time While learning Excel, use the Tools Customize feature to show the complete version of Standard and Formatting toolbars.Microsoft only show the most common menu choices from Excel’s two most important toolbars: Standard and Formatting.

Add A Close Button To The Standard Toolbar Experiment with adding new buttons so that any task that you perform regularly has a one-click option.Your effi ciency with Excel would increase if you had a oneclick option for closing workbooks.

Double The Value of The Recently Used File List You routinely open the same six workbooks. The File menu shows only the last four workbooks that you opened or saved. It sure would be nice if it showed at least the last six workbooks.

Remember Workbooks To Open Using A Workspace To reduce the time in opening more than one workbook.You need to open seven files in order to prepare a weekly report. It is tedious to open all seven workbooks.

Automatically Move The Cell Pointer In A Direction After Entering a Number You can have the cell pointer move in any direction after using Enter by changing this setting on the Edit tab of the Options menu.

HOW To See Headings As You Scroll Around a Report You want to be able to scroll through the data and always see the headings.