How to use Macro

[niharika]

I wish to take help by using Macro in MS Excel. But dont know how to use. As I click 'Macro' from tool option there my confusion begin. As to where do I write code?

• in macro (which ask 1st macro name & then a blank window)
  

• or in Visual Basic option
  

In Visual Basic window... there are lot of sublist for worksheets & workbook.

So, which one I going to choose for simplyfy my job in excel. Is there any free e-book availble for us (beginner).