Excel is most powerful tool and if you use it in Accounting it work like wonders and help you to save lots of your time. This course provides you learning of Automation of balance sheet and Profit & loss on the basis of Trial Balance by using excel. Make sure your Trial Balance should be in excel format.

This course will also help you to match opening and closing balances in 5 minutes. Also you can prepare MIS reports, comparative reports etc. with the help of this course. you will gain so much knowledge that you can prepare balance sheet on daily basis just in 5 minutes.

It is very easy to understand.

Content of Course :

1. Powerful Excel Formulas (Most powerful Excel formula sikhaye jayenge jo aapko sirf B.Sheet banane mein hi nhi balki har jagah kaam aayenge)
2. Checking of Trial Balance to correct mistake if any within 2 minutes
3. Trial Balance arrangements using Excel for Automation
4. Creation of Masters and Groups
5. Preparation of Balance Sheet and Profit & Loss automatically with Trial Balance
6. Full automation of B.Sheet ( iska matlab ek baar automation ke baad aap chahen toh daily balance sheet bana sakte hain woh bhi bus 5 minute mein, yaani agar Trial mein koi change ho jaaye toh bhi aapko koi pareshani nhi hogi,Ghanto ka kaam minuto mein hone lagega)
7. Checking of Opening Trial Balance with Closing Trail Balance before finalization of Balance sheet is must and we will let you know how you can do this in minutes