Download the Brochure by filling the form below
Key Highlights
Things To Know
- Aspiring accountants, finance professionals, office administrators, and individuals looking to enhance their office automation and financial accounting skills.
- Advance Computing Skills
- Office Skills
- Web & Social Skills
- Analytical Skills
- Data Presentation Skills
- Administrative Skills
- Advance Accounting Skills
- Data Management Skills
- Report Generation & Management
About the Course
Comprehensive course covering MS Office tools, advanced Excel, and Tally Prime. Gain essential skills for accounting industry.
Learn advanced Excel techniques for data analysis, reporting, and decision-making. Enhance your efficiency in office tasks.
Extensive training in Tally Prime software for accounting, inventory management, banking transactions, and GST compliance.
Develop proficiency in financial accounting principles, journalizing transactions, trial balance, and financial statements.
Practical approach with hands-on exercises and real-world scenarios. Experienced instructors provide personalized guidance.
Gain expertise in TDS, payroll accounting, audit trail, and other crucial aspects of financial management. Prepare for a successful career.
Content
Introducing AOAFA (Professional Certification in Advanced Office Automation & Financial Account), a comprehensive 6-month course designed to equip commerce students with the necessary skills to meet the demands of the accounting industry. This course covers advanced office automation using MS Office tools, along with in-depth training in financial accounting principles and Tally Prime software. With a focus on practical applications and real-world scenarios, AOAFA prepares learners to handle accounting tasks for manufacturing, trading, and service-oriented companies.
- Computer Competency
- System Software
- Windows OS
- Application Software
MS-Office
- MS-Word 2019
- MS-Excel 2019
- MS-PowerPoint 2019
- MS-Outlook 2019
Internet & Web
- Overview Working Of the Internet
- World Wide Web
- Advanced file tasks
- Working with functions and formulas
- Managing tables in Microsoft excel
- Data tools in excel
- Sparkline
- Grouping & outlining and subtotals
- What-if analysis
- Advanced pivot tables & charts
- Advanced excel tasks
- Creating h lookup and v lookup functions
- Advanced conditional formatting
- Advanced lookup functions
- Advanced functions in excel
Fundamentals of Accounting
- Introduction
- Terminology used in Accounting
- Concept of Accounting
- Golden Rules of Accounting
- Journalising Transactions
- Trial Balance
- Financial Statements
- Subsidiary Books & Control Accounts
Tally Prime Basics
- Download Tally Prime Setup File
- Tally Prime Installation, Company Creation, Alteration, Deletion
- Tally Prime Ledgers Creation
- Tally Prime Inventory Creation, Stock Items, Groups, Units)
TALLY PRIME with ADVANCE ACCOUNTING
- Bill Wise details
- Cost Centre & Cost Categories
- Voucher Class & Cost Centre Class
- Multiple Currency
- Interest Calculation a. Simple b. compound
- Budgets & Controls
- Scenario Management
TALLY PRIME with ADVANCE INVENTORY
- Order Processing Reorder Levels
- Tracking Number Batch- wise Details
- Rejection in/Out
- Delivery & Receipt Note
- Additional Cost Details Bill of Materials (BOM)
- Price Levels and Price Lists Stock Valuation
- Stock Journal & Physical Journal
- Different Actual and Billed Quantities
- Zero Valued Entries
- Stock Valuation
- Point of Sale - Single Payment Mode - Multiple Payment Mode - Invoice Printing
Tally Prime with Banking
- Cheque Book Configuration in Tally Prime
- Banking Transaction Types
- Post Dated Cheque Management
- Post Dated Cheque Note Video
- BRS Note
- Bank Reconciliation
Tally Prime with MIS Reports
- Introduction
- Advantages of Management Information Systems
- MIS Reports in Tally Prime
- Trial Balance
- Balance Sheet
- Profit and Loss Account
- Cash Flow Statement
- Ratio Analysis
- Books and Reports
- Day Book
- Receipts and Payments
- Purchase Register
- Sales Register
- Bills Receivable and Bills Payable
Data Security
- Security Control
- Activation of Security Control
- Creation of Security Control (User Roles)
- Creation of Uses & Passwords for Company
- Tally Vault
Company Data Management
- Introduction
- Backup of Company Data
- Restoring of Company Data
- Company Data Repair
- Migration of Tally EPR 9.0 Company Data to Tally Prime
Tally Prime with GST
- Activation of GST in Tally Prime
- Accounting of GST Transactions
- Purchase from URD
- Imports
- Advance Receipt and Payments
- Mixed Supply & Composite Supply under GST
- MRP Transaction
- Defining GST Rate - Slab Rate or Price Range
- Accounting of Supply of Services
- Input Credit
- GST Tax payment
- GST Reports & GSTR-1 & 2
- GSTR 3B
- Filling of GSTR-1 (Excel Format)
Tally Prime with TAX DEDUCTED AT SOURCE (TDS)
- TDS Process
- Enabling TDS in Tally Prime
- Creating TDS Masters
- TDS Deduction
- Payment of TDS in Tally Prime
- Form 26Q
- TDS Outstanding
- TDS Reports
Tally Prime with Payroll
- Payroll Accounting & Compliance
- Configuring Payroll in Tally Prime
- Introduction to Payroll
- Payroll in Tally Prime
- Enable Payroll in Tally Prime
- Payroll Transaction
- Generate Pay Slips
- Pay Sheet
- Payroll Statement
Tally Prime with Audit Trail
- Introduction
- Importance of Audit Trail in Accounting
- Enable Audit Trail in Tally Prime
- Purpose of Audit Trail in Tally Prime
Certificate
-
- Jain: This certificate course is designed to equip learners with the expertise required to efficiently manage office tasks and financial transactions, ensuring smooth operations in the modern business environment.
-
- GJX:The main objective of this certificate course is to provide learners with the necessary expertise to effectively handle office tasks and financial transactions, ensuring seamless operations in today's dynamic business landscape.
Our Affiliations & Associations
We believe people are at the centre of every solution, leading us to the right solution just waiting to be delivered.
Our Students are Working in Following Companies
What Our Students Say
I highly recommend the Web Designing Course at G-TEC JAINx Education for anyone interested in pursuing a career in web design."
The Data Analysis Course at G-TEC JAINx exceeded my expectations. Through practical assignments and real-world case studies, I gained hands-on experience in data analysis techniques and tools.
Taking the Digital Marketing Course at G-TEC JAINx was a game-changer for my career. I am now equipped with the skills to plan and execute successful online marketing campaigns
Keerti Learner Support
Throughout the course,
learners will have access to dedicated support from instructors and course mentors.
They can
ask questions, seek clarification, and receive guidance to enhance their learning
experience.
Additionally, the course provides a collaborative learning environment where
students can
interact with peers, share insights, and learn from each other's experiences.
-
Phone Number +91-90-29341200 -
Email [email protected]