How I can use excel for accounting work? -

Don t. It s not suitable at all for accounting.If you want a free accounting program try: http://www.gnucash.org/

I ran a small business for many years and kept my books on excel. It s pretty easy to build simple spreadsheets because you can make columns any with you want and you can highlight down and add total columns. You can also create formulas in a more complicated fashion that changes the totals in several columns when a number is added or subtracted. Play around with it for a while you ll get the hang of it. Also you can ask someone who knows the program for help.