I am totally new to Excel and will be required to write some macros, can you
tell me just a simple thing first:
how do I create a new macro in Excel ? By clicking a button or right click ?

there r 3 ways:
1. chose from menu: tools\macro\record new macro then make a set of deeds
then finish
it's for the very simple tasks
2. modify recorded macro: tools\macro\visual basic editor
the best way to learn smtg: record macros, analysing source code then
modifying
3. write functions and procedures directly in vb editor

that's da beginning :-)

I am totally new to Excel and will be required to write some macros, can
you tell me just a simple thing first:
how do I create a new macro in Excel ? By clicking a button or right
click ?