Learn to make balance sheet/P&L from trail | 2 hours
Instructor: CA Pooja Gupta (CA Guruji)
Language: English, Hindi, English
Validity Period: 90 days
Excel is a most powerful tool and if you use it in Accounting it works wonders and helps you to save lots of your time. This course helps you in the Automation of balance sheets and Profit & loss on the basis of Trial Balance, 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 a balance sheet on daily basis just in 5 minutes.
What will I learn?
Most Useful for:
CA, CS, CWA, MBA, Advocates, Tax Consultants, Tax Professionals, Accountants, Businessmen, Students, Advance Excel course seekers
Who should take this course?
About the Instructor
CA Pooja Gupta (CA Guruji) is a member of Institute of Chartered Accountants of India since 2009, Qualified ISA and M.Com. She delivers educational videos on Income Tax, GST, Excel, TDS etc.
She has more than 13 years’ experience in Taxation and specialize in all aspect of GST, Income Tax, VAT, Service Tax, Excise etc.
|Automation Of B.Sheet With Excel (116:00)|
|Formula Practice (Downloads)|
|1 BASIC DETAILS & FORMULAS|
|2 VLOOK UP BASIC|
|3 CON &|
|4 VLOOK UP ADVANCE|
|8 DATA VALIDATION, NAME RANGE|
|10 LEFT, RIGHT, MID, LEN|
|11 RAND BETWEEN|
|12 REMOVE DUPLICATE|
|1. TB 2018|
|4 BS PL -LIVE TRAINING|
|Auto (Co.) 2018 TO 2020|
|Auto (HO, BR1, BR2)|
|Auto (Ind.) 2018 2019|
|Auto BS MONTHWISE 2018|
After successful purchase, this item would be added to your courses.
You can access your courses in the following ways :