Courses - AICPE

Course Syllabus

Computer Basic
MSOFFICE 2013
- MS word 2013
  - Introduction
  - Creating New document
  - Writing and simple formatting
  - Page layout
  - Screen and Its Elements
  - Pictures and Graphics
  - Tables
  - Mail Merge
  - Envelop and Labels
  - Proofing(Spelling and grammar check, track changes, treasures)
- MS PowerPoint 2013
  - Getting started with PowerPoint
  - Creating basic presentation
  - Using presentation views
  - Using text pictures and graphics
  - Using smart art, chart, tables and objects
  - Using slide show view
  - Appling animation, transition
  - Drawing object
  - Insert video and sound
  - Using themes, using presentation masters
  - Setting up the presentation (setting up slide show, recording narration, rehearsing time)
  - Applying action (hyperlink)
- Ms Excel
  - Getting started with excel
  - Creating basic workbooks
  - Using ranges
  - Copying , pasting, creating formulas
  - Columns and rows
  - Worksheet tools
  - Formatting worksheets
  - Setting worksheet layouts, printing worksheets
  - Conditional formatting and cell styles
  - Paste special
  - Creating ,formatting, editing worksheet charts
  - Pivot tables
Sorting and filtering data
Tally Erp 9 with GST
Basic Tally Erp 9 with GST
- Introduction to financial accounting and basic
- Advance financial accounting
- Inventory
- Taxes- TDS, VAT,
- GST
Non trading Organization
- Business Organization
  - Service organization
  - Trading organization
  - Manufacturing organization
- Accounting On computers
  - Basic Accounting concepts
  - Rules of Accounts
  - Basic Journals Entries
  - Benefits of A/c on Computers
  - Transaction in Tally ERP 9
- Tally fundamentals
  - Features of Tally ERP9
  - Configuration of Tally ERP 9
  - Creation/ Setting up Company in Tally ERP 9
  - Use of vouchers
  - Ledgers and Groups
- Service Organisation
  - Structure of Service Organisation
  - GST for service
  - GST for expenses
  - GST adjustments and payments voucher
  - GST for reports
Trading organisation
- Inward and outward supply with GST
  - Cash and credit purchase and sales
  - Invoicing in tally ERP 9
  - Inventory creations with HSN
  - Inventory transaction with GST
- Overview of tally ERP 9
  - Features of tally erp9
  - Advantages ac and inventory features
  - F11 features
  - F12 configuration
  - GST activation
- Advanced accounting with GST features
  - Bill wise details with GST
  - Voucher class for GST
  - Cost centres/ cost categories with GST
  - Purchase from URO
  - Bank reconciliation statement
  - Zero valued entries
  - Backup restore
  - Additional cost of purchase
  - Interest calculations
- Advanced inventory features
  - Actual and billed quantity
  - Separate discount columns
  - Multiple price levels
  - Point of sales POS
- GST R accounting and inventory reports
  - Accounting reports
  - GST R1 reports
  - Inventory reports
  - GST R2 reports
  - GST R3 reports
  - B2B invoice reports
  - B2C invoice reports
Manufacturing organization
- Purchase and sales with GST
  - Purchase of raw materials
  - Storage of goods
  - Production process
  - Processing in manufacturing
  - Maintenance of locations
- Getting functional with tally erp9
  - Recording transactions with GST
  - Advance accounting vouchers with GST
  - Advance inventory vouchers with GST
  - Manufacturing vouchers with GST
- Advance stock transactions
  - Order processing
  - Tracking numbers
  - Rejection notes
  - Invoicing and billing
- Statutory features
  - GST for composition dealer
  - GST under E way bill
  - Capital good under GST
  - TDS
  - TCS
  - Payroll
- Technical advantages of tally erp 9
  - Multicurrency
  - Predefined cost centers
  - Batch wise details
  - Consolidation of accounts
  - Bill of Material
Display & Reporting
- Management & Control Systems
  - Budget & Control
  - Scenario Management
  - Variance Analysis
- Reporting & Generations
  - Sales Register
  - Purchase Register
  - Re-order Levels
  - Optional Vouchers
  - Credit Limits
- System Administration & Utilities
  - Consolidation of A/c
  - Split Company Data
  - Export & Import of Data
  - ODBC Compliance
- Technical Advantage of Tally.ERP 9
  - Multi Lingual
  - Security Control
  - Audit in Tally.ERP 9
  - Key points of Display
- Printing in Tally.ERP 9
  - Cheque Printing
  - Voucher Printing
  - Company Logo Printing
  - Receipt Printing
- Finalization of Accounts
  - Closing Entries
  - Adjustment Entries
  - Profit Screening
EXCEL
- Module I- Microsoft Excel
  - Introduction to Ms excel
  - Worksheet fundamental
  - Formatting cell and worksheet
  - Formatting cell and worksheet
  - Pivot table and pivot chart option
  - Graphics and designing in excel
  - Adds ins groups buttons of insert tab excel
  - Analysing data in excel
  - Data validation in excel
  - Using macros in excel
- Module II- Functions and Formulas in Excel
  - Working with formulas and functions
  - Logical, text, financial, date and time functions
  - Lookup and reference function
  - Mathematical and trigonometry functions
  - Statistical, database function in excel
  - Information function in excel
  - Engineering function
- Using names to work with ranges
- Internet
- Project Work

Account Name	:	AICPE EDUCATIONAL SERVICES PVT. LTD.
Account No.	:	50200031129652
Bank Name	:	HDFC Bank
Branch	:	Shankar Nagar, Nagpur
IFSC Code	:	HDFC0000102

DIPLOMA IN COMPUTER BUSINESS MANAGEMENT

Course Syllabus

Eligibility

CERTIFICATE IN IT PROFICIENCY

CERTIFICATE IN DESKTOP PUBLISHING

CERTIFICATE IN COMPUTER BASED ENGLISH...

CERTIFICATE IN ACCOUNT EXPERT WITH...

CERTIFICATE IN COMPUTER BASED ENGLISH...

CERTIFICATE IN COMPUTER BASED MARATHI...

CERTIFICATE IN COMPUTER BASED MARATHI...

CERTIFICATE IN MS OFFICE AND INTERNET

CERTIFICATE IN TALLY.ERP9 ADVANCED

CERTIFICATE IN COMPUTERIZED ACCOUNTING

CERTIFICATE IN DATA ENTRY OPERATOR

CERTIFICATE IN INFORMATION TECHNOLOGY

CERTIFICATE IN OFFICE AUTOMATION

DIPLOMA IN SOFTWARE APPLICATION

CERTIFICATE IN PROGRAMMING IN C

CERTIFICATE IN COMPUTER FUNDAMENTALS

ADVANCE CERTIFICATE IN COMPUTER...

CERTIFICATE IN AUTOCAD

MASTER CERTIFICATE IN COMPUTER...

CERTIFICATE IN C++ PROGRAMMING

CERTIFICATE IN ADVANCED EXCEL

DIPLOMA IN OFFICE AUTOMATION

DIPLOMA IN DESKTOP PUBLISHING

CERTIFICATE IN COMPUTER APPLICATIONS

DIPLOMA IN INFORMATION TECHNOLOGY

CERTIFICATE IN ACCOUNTING AND TAXATION

CERTIFICATE IN FUNDAMENTALS OF COMPUTER...

CERTIFICATE IN HARDWARE AND NETWORKING

CERTIFICATE IN COMPUTER TEACHERS...

DIPLOMA IN FINANCIAL ACCOUNTING

CERTIFICATE IN COMPUTER HARDWARE

ADVANCE DIPLOMA IN INFORMATION...

CERTIFICATE IN WEB DESIGNING

CERTIFICATE IN INTERNET USAGE AND...

CERTIFICATE IN COMPUTER BASED HINDI...

DIPLOMA IN COMPUTER SOFTWARE

CERTIFICATE IN JAVA - CORE

ADVANCE DIPLOMA IN SOFTWARE ENGINEERING

CERTIFICATE IN OFFICE PROFESSIONAL

CERTIFICATE IN CATIA V5

ADVANCE DIPLOMA IN COMPUTER SOFTWARE

CERTIFICATE IN COMMUNICATION IN ENGLISH

CERTIFICATE IN FINANCIAL ACCOUNTING...

CERTIFICATE IN INTRODUCTION TO C...

CERTIFICATE IN COMPUTER BASED HINDI...

DIPLOMA IN 2D AND 3D AUTOCAD

CERTIFICATE IN PHOTOSHOP

CERTIFICATE IN C# .NET PROGRAMMING

CERTIFICATE IN CAD

CERTIFICATE IN COMPUTER NETWORKING

CERTIFICATE IN VB.NET PROGRAMING

CERTIFICATE IN ASP.NET PROGRAMING

CERTIFICATE IN JAVA - ADVANCE

CERTIFICATE IN MOBILE PHONE REPAIRING

CERTIFICATE IN JAVA PROGRAMMING

CERTIFICATE IN C++

CERTIFICATE IN ADVANCE NETWORKING

CERTIFICATE IN ADVANCE WIRELESS AND...

CERTIFICATE IN ADVANCE COMMUNICATION

CERTIFICATE IN BUSINESS COMMUNICATION

CERTIFICATE IN COMPUTER GRAPHICS

CERTIFICATE IN DATA STRUCTURES

CERTIFICATE IN DATABASE MANAGEMENT...

CERTIFICATE IN ENTREPRENEURSHIP

CERTIFICATE IN FASHION RETAILING AND...

CERTIFICATE IN FINANCIAL MANAGEMENT

CERTIFICATE IN FRONT OFFICE OPERATIONS...

CERTIFICATE IN HORTICULTURE NURSERY...

CERTIFICATE IN HUMAN RESOURCE MANAGEMENT

DIPLOMA IN WEB DESIGNING

CERTIFICATE IN MARKETING MANAGEMENT

CERTIFICATE IN NETWORK MANAGEMENT

CERTIFICATE IN OBJECT ORIENTED...

CERTIFICATE IN OPERATING SYSTEMS

CERTIFICATE IN PRINCIPLES OF MANAGEMENT

CERTIFICATE IN PROFESSIONAL SKILL...

CERTIFICATE IN PROJECT MANAGEMENT