Call: 0-9146304108

Email: info@keerti.org

 8:00AM to 8:00PM

Apply Now
Register now and secure your future



Testimonial

K-AOAFA PRO (Keerti Certified Information Technology Program Pro)

Duration: 8 Months (200 Hrs.)

$75
10.jpg

Course Overview

Objective: Keerti Certified Course in Advanced Office Automation Course provides basic training of computer and its most common software use in office work. The Trainee would also be Proficient in Advance Financial Accounting Using Tally Prime The trainee would be efficient and creative, in designing and deploying graphical and animation based vivid presentations in various animatronics. This course is most beneficial for beginners and it is Career oriented course which empowers self-employment. This Course is also referred to as K-IT PRO.

Fundamentals & OS
1.Computer competency
2.System software
3.Windows OS
4.Application software


MS-Office 2013
1.MS-Word 2013
2.MS-Excel 2013t
3.MS-PowerPoint 2013
4.oMS-Outlook 2013


Internet & Web
1.Overview Working Of the Internet
2.World Wide Web
3.E-mail


Adv. Excel 2013
1.Advanced file tasks
2.Working with functions and formulas
3.Managing tables in Microsoft excel
4.Data tools in excel
5.Sparkline
6.Grouping & outlining and subtotals
7.What-if analysis
8.Advanced pivot tables & charts
9.Advanced excel tasks
10.Creating hlookup and vlookup functions
11.Advanced conditional formatting
12.Advanced lookup functions
13.Advanced functions in excel


MIS
1.Creating Dashboards
2.Graphical representation
3.Use of power pivots for data analysis
4.Use of power queries
5.Exporting data from Excel to other formats
6.Creating reports in excel
7.Conditional Formatting for Dashboards
8.Pivot table Dashboard with Slicers


Macros With VBA
1.Macro Recording
2.Visual Basic Editor
3.Understanding Objects, Methods,
4.Properties & Variables
5.Control Structures-Decision
6.Looping Structures
7.User Forms And GUI
8.Worksheet / Workbook Operations
9.Error Handling




*(ONLY AT SELECTIVE CENTERS)*
MS-Access
1.Getting Started with Access
2.Working with Table Data
3.Querying a Database
4.Using Forms
5.Generating Reports
6.Designing a Relational Database
7.Sharing Data Across Applications


Tableau
1.Introduction To Tableau
2.Tableau Interface
3.Chart Types & Data Visualization
4.Run Time Columns
5.Data Formatting & Advanced Function
6.Filters & Advanced Charts
7.Dashboards
8.Storyline In Tableau


MIS
1.Creating Dashboards
2.Graphical representation
3.Use of power pivots for data analysis
4.Use of power queries
5.Exporting data from Excel to other formats
6.Creating reports in excel
7.Conditional Formatting for Dashboards
8.Pivot table Dashboard with Slicers


Macros With VBA
1.Macro Recording
2.Visual Basic Editor
3.Understanding Objects, Methods,
4.Properties & Variables
5.Control Structures-Decision
6.Looping Structures
7.User Forms And GUI
8.Worksheet / Workbook Operations
9.Error Handling


Tally Prime

TALLY PRIME Basics
1. Download Tally Prime Setup File
2. Tally Prime Installation, Company Creation, Alteration, Deletion
3. Tally Prime Ledgers Creation
4. Tally Prime Inventory Creation, Stock Items, Groups, Units)

TALLY PRIME with ADVANCE ACCOUNTING
1. Bill Wise details
2. Cost Centre & Cost Categories
3. Voucher Class & Cost Centre Class
4. Multiple Currency
5. Interest Calculation
a. Simple b. compound
6. Budgets & Controls
7. Scenario Management

TALLY PRIME with ADVANCE INVENTORY
1.Order Processing Reorder Levels
2.Tracking Number Batch- wise Details
3.Rejection in/Out
4.Delivery & Receipt Note
5.Additional Cost Details Bill of Materials (BOM)
6.Price Levels and Price Lists Stock Valuation
7.Stock Journal & Physical Journal
8.Different Actual and Billed Quantities
9.Zero Valued Entries
10.Stock Valuation
11.Point Of Sale
-Single Payment Mode -Multiple Payment Mode -Invoice Printing

Tally Prime with Banking
1.Cheque Book Configuration in Tally Prime
2.Banking Transaction Types
3.Post Dated Cheque Management
4.Post Dated Cheque Note Video
5.BRS Note
6.Bank Reconciliation



Learner Outcome
1.Creative Skills
2.Design Skills
Tally Prime with TAX DEDUCTED AT SOURCE (TDS)
1.TDS Process
2.Enabling TDS in Tally Prime
3.Creating TDS Masters
4.TDS Deduction
5.Payment of TDS in Tally Prime
6.Form 26Q
7.TDS Outstanding
8.TDS Reports

Tally Prime with TAX COLLECTED AT SOURCE
1.Basic Concept of TCS
2.Enabling TCS in Tally Prime
3.Sales of TCS Goods at Lower Rate & Nil Rated
4.TCS on Transfer of Right to Use
5.Payment of TCS
6.TCS Reports
7.Form 27EQ
8.Saving Form 27EQ

Tally Prime with JOB COSTING
1.Introduction
2.Features of Job Costing
3.Enabling Job Costing
4.Creating Required Masters
5.Creating Ledgers for Job Costing
6.Recording of Job Costing Related Transactions
7.Job Costing Reports
8.Job Work Analysis Report
9.Materials Consumption Summary Report
10.Comparative Job Work Analysis Report

Tally Prime with JOB WORKS
1.Introduction
2.Features of Job Order Processing in Tally Prime
3.Configuring Job Order Processing in Tally Prime
4.Company Setup
5.Enabling Job Order Processing
6.Voucher Type Setup
7.Job Order Processing
8.Job Work Out Order
9.Job Work in Order
10.Job Order Reports
11.Job Work Out Reports

Tally Prime with MIS Reports
1.Introduction
2.Advantages of Management Information Systems
3.MIS Reports in Tally Prime
4.Trial Balance
5.Balance Sheet
6.Profit and Loss Account
7.Cash Flow Statement
8.Ratio Analysis
9.Books and Reports
10.Day Book
11.Receipts and Payments
12.Purchase Register
13.Sales Register
14.Bills Receivable and Bills Payable

Tally Prime with Payroll
1.Introduction to Payroll
2.Payroll In Tally Prime
3.Enable Payroll in Tally Prime
4.Payroll Transaction
5.Generate Pay Slips

Tally Prime with GST
1.Activation of GST in Tally Prime
2.Accounting of GST Transactions
3.Purchase from URD
4.Imports
5.Advance Receipt and Payments
6.Mixed Supply & Composite Supply under GST
7.MRP Transaction
8.Defining GST Rate - Slab Rate or Price Range
9.Accounting of Supply of Services
10.Input Credit
11.GST Tax payment
12.GST Reports & GSTR-1 & 2
13.GSTR 3B
14.Filling of GSTR-1 (Excel Format)