excel tips

Workbook defaults
There are various options in Excel that you can modify to make setting up your workbooks quicker and easier according to your preferences.

Read more..

It is useful therefore, to know how to effectively use toolbars e.g. how to access hidden buttons, move them, view them and customise them.

Read more..

MS Excel can be customized in a way that suits a user to achieve his goal. It is extensively used in financial organizations. The features of MS Excel are as follows:

Read more..

Microsoft Excel Tips – The classes that I teach most often are Microsoft Excel versions 2003 and 2007. I put together these tips for the Excel beginner. These tips will work for Excel ’97 or later.

Read more..

There are many tips for Excel. This article is for the beginners and covers the tips that I go over in the classes that I teach at local schools.

1. 80% of the most commonly used features, for beginners, in Excel can be done with two toolbars. A toolbar is the icons that are under the menus that are in text format (File, Edit, etc.). You should have the Standard toolbar and the Format toolbar on your screen.

Read more..

Publishing your worksheet on the Internet makes it readily available to anyone who has Internet access.

Read more..

Microsoft Excel is a great product. I use it every day at work to do a number of tasks. I love when I find a good Excel tip or find a trick that I didn’t know about. It makes the program even more useful and I become more productive as a result.

Read more..

The default setting for dates (in both cell and in headers and footers) is a format that drops the zeros and gives the shortest date possible.

Read more..