i want to make macros and need to know how as i am used to excel
The relevant menu is Tools▸Macros.
Tools
Macros
Also see available documentation and help topics.