Download the Brochure by filling the form below


Key Highlights

Duration icon
Duration
9 months (240 hours)
Comprehensive Curriculum
Comprehensive Curriculum
MS Office, Advanced Excel, Graphics Designing, Tally Prime, and more.
Expert Guidance
Expert Guidance
Acquire skills from industry specialists.
Career Opportunities
Career Opportunities
Data Analyst, Graphic Designer, Office Administrator, and more.
Advanced Tally
Advanced Tally Prime
Efficient accounting and financial management.
Practical Learning
Practical Learning
Hands-on experience in real-world scenarios

Things To Know

  • IT professionals looking to enhance their skills, experienced individuals seeking to upskill or specialize in a specific IT domain, and those aspiring for leadership roles in the IT industry should consider enrolling in this program.
The course duration is 240 Hrs. and 9 Months Program
  • Office Administrator
  • Graphic Designer
  • Data Entry Specialist
  • Accounting Assistant
If you are ready to learn and want to light up your future with us. Enroll now in this course.

About the Course

Empower skills

P-AITPRO offers advanced MS Office, Excel, Graphics & Tally training. Elevate your expertise in 9 months!

Diverse curriculum

Master data analysis, graphic design & accounting. Real-world scenarios for practical learning.

Limitless opportunities

Unlock careers as Data Analysts, Graphic Designers, Office Admins & Accountants.

Expert guidance

Learn from industry specialists. Bridge theory & application seamlessly.

omprehensive program

CorelDRAW, Photoshop, InDesign, Tally Prime - all in one course!

Prestigious recognition

Obtain a valued certificate. Join P-AITPRO for a thriving IT career!

Content

  • COMPUTER COMPETENCY
  • SYSTEM SOFTWARE
  • WINDOWS OS
  • APPLICATION SOFTWARE
  • MS-Word 2019
  • MS-Excel 2019
  • MS-PowerPoint 2019
  • MS-Outlook 2019
  • Overview Working Of the Internet
  • World Wide Web
  • E-mail
  • Corel draw
  • Photoshop

Banking

  • Illustrator
  • InDesign
  • 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

Account & Taxation Certificate

    • GJX: The esteemed P-AITPRO is awarded upon the successful completion of an empowering 9-month program. This certificate represents the attainment of vital IT skills, encompassing MS Office 2019, Advanced Excel, Graphics Designing (utilizing CorelDRAW, Photoshop, Illustrator, and InDesign), and Advanced Tally Prime. Graduates demonstrate mastery in these areas, reflecting their dedication to the dynamic world of information technology.
    certificate logo
    • JAIN:The Professional Advanced Certificate in Information Technology Program (P-AITPRO) is a prestigious recognition of successful completion of an empowering 9-month journey. This certificate signifies the mastery of vital IT skills, including MS Office 2019, Advanced Excel, Graphics Designing (using CorelDRAW, Photoshop, Illustrator, and InDesign), and Advanced Tally Prime
    certificate icon

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

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.