Course Languague
HINDI
Speaker
CA POOJA GUPTA
Famous YouTuber (Income Tax, GST and Excel)
To Save time in Today’s Busy life It is most useful for :
Chartered Accountants (CAs), Tax Consultants, Tax Professionals, Accountants, Businessmen and All students etc.
Content of Course :
Introduction
Benefit of Automation
Powerful Excel Formulas
Creation of Master and Group
Checking of Last Year Trial Balance with Op. Balance of New Year Trial Balance
Organization of Trial Balance using Excel for Automation
Checking of Trial Balance for possible errors
Prepration of Automated Balance Sheet and Profit & Loss from TB
Additional Content of Course related to GST:
How to find, if any change happened in Books of Accounts up to last month.
Validity of Accessability :
10 Days
Duration of Course :
2 Hours
Course Material :
1 Excel Formula file with Practice sheet – 12 Nos
2 Automated Balance Sheet Formats for following categories : – 5 Nos
- Balnce sheet Practice File
- As Per Company Act
- Properitorship
- Business entitiy who has Head Office and Multilple Branches.
- Monthly Balance Sheet Format
3 Trial Balance Formats for Comparison of Opening Balnce with Closing Balance – 2 Nos
4 Steps of Automation of Balance Sheet and Profit & Loss Account. – 1 Nos.
Prerequisite:
A Computer/Laptop with MS Office
Reviews
There are no reviews yet.