•     marker--v2 302, B - Wing, 3rd Floor, Pinnacle Corporate Park, Bandra Kurla Complex, Bandra East, Mumbai - 400051

Key Highlights

G-Tec Jain Education Diverse Curriculum
Diverse Curriculum
MS Office, Advanced Excel, Graphics Designing, Tally Prime
G-Tec Jain Education Skilled Instructors
Skilled Instructors
Industry experts to guide you through the course
G-Tec Jain Education Learner Outcome
Learner Outcome
Spreadsheets, Graphic Design, Financial Recording, and more
G-Tec Jain Education Career Path
Career Path
Opportunities as Office Administrators, Graphic Designers, and more
G-Tec Jain Education Keerti Learner Support
Keerti Learner Support
Expert domain assistance throughout the program

About the Course

Master essential IT skills
Master essential IT skills

MS Office, Advanced Excel, Graphics Designing & Tally Prime. Launch your tech career.

Empower your creativity
Empower your creativity

Empower your creativity with CorelDRAW, Photoshop, Illustrator & InDesign. Excel in graphic design.

Proficient Office Administrator
Become a proficient Office Administrator

Become a proficient Office Administrator, Graphic Designer, or Accounting Assistant with our 8-month program.

Data Analysis
Unlock the power of data analysis

Unlock the power of data analysis and office productivity. Achieve excellence in IT with P-ITPRO.

Comprehensive course
Comprehensive 8-month course

Comprehensive 8-month course: MS Office, Advanced Excel, Graphics Designing, Tally Prime. Transform your career.

Hands-on expertise
Join P-ITPRO to gain hands-on expertise

Join P-ITPRO to gain hands-on expertise in image editing, layout design, and financial accounting. Open new doors.

Content

Welcome to the Professional Certification Course in Information Technology Program (P-ITPRO)! This comprehensive 8-month course is designed to equip participants with essential IT skills, covering MS Office 2019, Advanced Excel, Graphics Designing, Tally Prime, and more. Whether you aspire to be an Office Administrator, Graphic Designer, Data Entry Specialist, or Accounting Assistant, this program will empower you to excel in your chosen career. Join us and embark on a journey of knowledge and practical expertise.

  • COMPUTER COMPETENCY
  • SYSTEM SOFTWARE
  • WINDOWS OS
  • APPLICATION SOFTWARE

  • MS-Word 2019
  • MS-Excel 2019
  • MS-PowerPoint 2019
  • MS-Outlook 2019

Internet & Web

  • Working of the Internet
  • World Wide Web
  • E-mail

DTP

  • Corel draw
  • Photoshop

  • 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


  • Introduction ChatGPT with Excel
  • Enhancing Excel Formulas with ChatGPT
  • Advanced Formula Assistance with ChatGPT
  • Data Cleaning and Transformation
  • Basic Data Analysis Techniques

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

Recording and Maintaining Accounting Transactions

  • Recording Transaction in Tally
  • Recording Accounting Vouchers in Tally Prime
  • Receipt Voucher
  • Contra Voucher
  • Payment Voucher
  • Sales Voucher
  • Debit Note Voucher
  • Credit Note Voucher
  • Journal Voucher
  • Recording for Provisions

Tally Prime with Advanced 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 Advanced 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 & Multiple Payment Mode,
  • Invoice Printing

Tally Prime with Banking

  • Cheque Book Configuration in Tally Prime 2019
  • Banking Transaction Types
  • Post Dated Cheque Management
  • Post Dated Cheque Note Video
  • BRS Note
  • Bank Reconciliation

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
  • E-Way Bill
    • Components of E-Way Bill
    • Who must generate E-Way Bill
    • Validity of E-Way Bill
    • E-Way Bill Process Flow
    • Export for e-Way Bill Report
    • Update e-Way Bill Information
  • Input Tax Credit Set Off against Liability
  • GST Tax Payment
  • Generating GST Returns for Regular Dealer in Tally
    • GST Reports & GSTR-1
    • GSTR 3B
    • GSTR 9 - GST Annual Computation
  • Filing GST Returns in Tally
    • Filing GSTR-1 Returns
    • Generating the JSON file from Tally and uploading the same in the GST portal
    • Filing GSTR-9 Returns - GST Annual Computation
  • Generating e-Invoice in Tally Prime
    • Recording Outward Supply and Generating e-Invoice without e-Way Bill
    • Recording Outward Supply and Generating e-Invoice with e-Way Bill


Tally Prime with TAX DEDUCTED AT SOURCE (TDS)

  • Introduction to TDS
  • Basic Concepts of TDS
  • TDS Process
  • Enabling TDS in Tally Prime
  • TDS Statutory Masters
  • Configuration of TDS at Different levels
  • Recording TDS Compliant Transactions in Tally Prime
  • TDS Exceptions
  • TDS Deduction
  • Payment of TDS in Tally Prime
  • TDS Reports


Payroll Accounting & Compliance

  • Configuring Payroll in Tally Prime
  • Enable Payroll in Tally Prime
  • Payroll Masters
  • Payroll Transaction
  • Statutory Reports
  • Generate Pay Slips & Pay Sheet
  • Payroll Statement

Tally Prime with Audit Trail

  • Importance of Audit Trail in Accounting
  • Enable Audit Trail in Tally Prime
  • Purpose of Audit Trail in Tally Prime

Generating & Printing Reports

  • Drill Down Display
  • Date/Period Based Reporting & Comparing
  • Inventory Report
  • Stock Summary
  • Go down Wise Stock Availability
  • Movement Analysis
  • Stock Query

Printing of Invoice & Reports

  • Management of Business Data
  • Exporting of data in available formats
  • Export and Import of Data
    • Export and import of master’s from one company to another in XML format
    • Export and Import of Transactions from one company to another in XML format
  • Exporting Reports to MS Excel
  • Exporting Reports to PDF
  • Open Database Connectivity (ODBC)
  • Printing of Company Logo on Vouchers, Invoices & Reports

Generating Financial Statements & MIS Reports

  • Advantages of Management Information Systems
  • MIS Reports in Tally Prime 2019
  • 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

  • Backup of Company Data
  • Restoring of Company Data
  • Company Data Repair
  • Migration of Tally EPR 9.0 Company Data to Tally Prime 2019

Learner Outcome

G-Tec Jain Education Learners Outcome
  • Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios
  • Develop technical and scientific presentations which use charts and visual aids to share data.
  • To gain a broad understanding on the internal & external factors which have an impact in the business environment, institutions & the application of suitable strategies in modern business
  • To develop computer skills of recording financial transactions, preparation of annual accounts and reports using Tally Prime
  • To develop the skills of recording financial transactions and preparation of reports for ascertaining the financial position of the various firms.
  • Ability to create and develop visual form in response to communication problems, including an understanding of principles of visual organization/composition, information hierarchy, symbolic representation, typography, aesthetics, and the construction of meaningful images.

Career Path

  • Office Administrator
  • Graphic Designer
  • Data Entry Specialist
  • Accounting Assistant
G-Tec Jain Education Career Path

Certificate

    • GJK: The distinguished certificate acknowledges the accomplishment of the Professional Certification Course in Information Technology Program (P-ITPRO) from G TEC JAIN Keerti. By attaining proficiency in vital IT skills, including MS Office 2019, Advanced Excel 2019, Graphics Designing (CorelDRAW, Photoshop, Illustrator, InDesign), and Tally Prime 2019, participants are prepared to excel in diverse career avenues. This certificate represents a comprehensive 8-month curriculum and expert mentorship, signifying expertise in office productivity, data analytics, graphic design, image editing, layout design, and accounting software. Graduates emerge as competent professionals, poised for success in the ever-evolving world of technology.
    G-Tec Jain Education

Course Overview

Video Bg Image


Our Affiliations & Associations

We believe people are at the centre of every solution, leading us to the right solution just waiting to be delivered.



G-Tec Jain Education abma-education
G-Tec Jain Education acca
G-Tec Jain Education ac-council
G-Tec Jain Education adobe-certified
G-Tec Jain Education aie
G-Tec Jain Education autodesk
G-Tec Jain Education certiport
G-Tec Jain Education esb
G-Tec Jain Education iaap
G-Tec Jain Education
G-Tec Jain Education iab
G-Tec Jain Education iibi
G-Tec Jain Education information-technology-specialist
G-Tec Jain Education jain
G-Tec Jain Education media-intertainment
G-Tec Jain Education microsoft-office-specialist
G-Tec Jain Education niekit
G-Tec Jain Education nsdc
G-Tec Jain Education pmi
G-Tec Jain Education prometric
G-Tec Jain Education quick-books
G-Tec Jain Education rasci
G-Tec Jain Education sap
G-Tec Jain Education sap-partner
G-Tec Jain Education sap-student-academy-program
G-Tec Jain Education tally
G-Tec Jain Education uk


TESTIMONIALS OF THE ESSENTIAL COURSE

Frequently Asked Questions

  • The Professional Certification Course in Information Technology Program is a comprehensive training program that covers various aspects of Information Technology (IT), providing learners with the skills and knowledge needed to pursue a successful career in the IT industry.
  • Aspiring IT professionals, recent graduates, and individuals seeking to switch to a career in IT should consider enrolling in this program.
  • The course typically covers a wide range of IT subjects, including programming languages, networking, database management, cybersecurity, cloud computing, web development, and IT project management.
  • The course is designed for individuals with varying levels of IT knowledge, including beginners with little or no prior experience in the IT field.
  • The program equips individuals with a diverse skill set, making them versatile and well-prepared to work in various IT roles, leading to better career opportunities.
  • Yes, successful completion of the program results in a professional certification validating the IT skills acquired throughout the course.
  • The course duration is 150 Hrs. and 6 Months Program
  • Yes, many courses offer practical exercises and hands-on training to apply the concepts learned and gain practical experience.
  • Yes, with the broad range of IT skills gained, graduates of this program can explore various job opportunities in software development, system administration, cybersecurity, IT consulting, and more.


Interested In Course

Download the Brochure by filling the form below