Tuesday, 24 February 2009

How to Start with VB Programming (VBA) in MS Excel

The possibilities of using VB (VBA to be precise) is almost endless and it’s not too complicated (to do simple stuff) if you put bit of an effort and with a small programming background.

Sunday, 22 February 2009

Basics of Excel functions and relations.

Through this post, I would like to introduce the Built in Functions of Microsoft Excel to a beginner. Let me put some excel functions that could be of use to those who what to make a start.

Before touching upon some of the functions, some introductions. The first thing that I would recommend for a beginner is to browse through the list of functions and its uses. At this stage, forget how it to be used, but keep an eye one what all you can do using functions. For that, go to INSERT -> FUNCTIONS. You will see the following dialog. Here you can either select ALL, or a specific category like TEXT. Now select a function and at the bottom, you will see what it will do. To find more detailed explanation, click HELP ON THIS FUNCTION.

Note: Click the cell with Function(s) and press F2 and you will be able to see the references in different colors.