ACAE - Aptech Certified Accounting Executive

Aptech Certified Accounting Executive (ACAE) is a one-year career program that specialises in accounting and financial skills. It builds strong office documentation skills, teaches you to analyse data with Microsoft Excel and create effective presentations with PowerPoint. Database management and web tools that improve productivity are also covered. In the second semester you learn computerised accounting with Tally, including GST, so you are ready for jobs as an accountant, accounts assistant or office executive.

ACAE - Aptech Certified Accounting Executive Course Content

Semester 1: Office Automation

•     Windows
•     MS Word
•     MS PowerPoint
•     MS Excel
•     Internet

Semester 1: Building Next Generation Web Sites

•     HTML5
•     CSS3
•     JavaScript
•     jQuery

Semester 1: MS Access

•     Databases and Tables
•     Queries
•     Forms
•     Reports
•     Macros

Semester 1: Website Design

•     Designing Web Pages
•     Style Sheets
•     Dynamic Web Templates
•     Dynamic Effects
•     CPD: Global English (Spoken)

Semester 2: Statistical Analysis using MS Excel

•     Importing and Exporting
•     Workbook Protection
•     Lookup Functions
•     Financial Functions

Semester 2: Computerised Accounting

•     Gateway of Tally
•     Accounting Vouchers
•     Inventory Vouchers
•     Cost Centres and Cost Categories
•     Printing Bills and Reports
•     Cheque Printing
•     Configuration Features
•     GST

Semester 2: Managing Data Using SQL Server

•     Database Models
•     Transact-SQL
•     DML, DDL and DCL
•     Subqueries and Joins
•     Data Integrity
•     Indexes
•     Procedures
•     Triggers

Semester 2: Working with Presentation Software

•     Animation Effects
•     Adding Music and Video
•     Custom Shows
•     Master View
•     Timings