Get started with all Function and Formula in Excel

To be a good programmer in Microsoft Excel we should understand every function in excel itself. To open all these function:

1. Click Home tab.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
2. Under Home tab Click at Arrow down button beside sum symbol.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
3. Click at More Functions.
   
   
4. Select a category.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
5. Select a function and this function or formula will be inserted into selected cell.
   

All this functions already build in and can be use instantly or call using VBA code. To create new function we must create using VBA code inside Excel workbook and this will appeared under this insert function dialog box.

The most importance function is under Math & Trig which is related to number  and Text which is related to string.