Archive for the 'excel tips' Category

Excel Settings and Options

Friday, April 15th, 2011

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..

Excel Toolbars Personalizing

Thursday, April 14th, 2011

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..

Filling Entire Column in Excel

Monday, April 11th, 2011

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..

Tips on Microsoft Excel (Version 97 and Later)

Monday, April 11th, 2011

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..

Top Ten Excel Tips For Beginners

Monday, April 11th, 2011

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 To The Internet

Monday, April 11th, 2011

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

Read more..

MS Excel Tips – A Quick Tip You Can Use Today

Sunday, April 10th, 2011

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..

Default Date Settings

Thursday, April 15th, 2010

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..