Duration : 12 Months

MS Paint

MS Paint The Tools- Selection tool, Eraser, Pencil, Fill, Magnifying, Rectangle, Circle, Line, Paint Brush, Text, Curve, Polygon, Rounded Rectangle. The Color Palette. Activity- Drawing with MS-Paint

Notepad

Create File, Edit File, Save File. How to cut, copy, paste text. Format text. Find and Replace Text

MS Word

Create a new document, Open, save and print a document, Create a new document, Open, save and print a document, Edit and format text, Change the page layout, background and borders, Insert headers and footers, Insert and edit tables, Shapes, Proofing, Protection.Insert clip art and pictures to documents, Perform a mail merge.

MS Excel

(Basic) Navigating with the Mouse and Keyboard, Entering Text and Numbers, Entering Dates, Editing Text Dates and Numbers, Editing within a Cell: Copying, Moving, Pasting and Inserting Cells.(Basic) Navigating with the Mouse and Keyboard, Entering Text and Numbers, Entering Dates, Editing Text Dates and Numbers, Editing within a Cell: Copying, Moving, Pasting and Inserting Cells.Deleting and Clearing Cells: Deleting and & Inserting Rows, Deleting and Inserting Columns, Finding and Replacing Text as well as Numbers; Selecting, Inserting, Deleting, Renaming, Moving and Copying Worksheets.Sorting Data; Filtering Data using Auto Filter.Date and Text functions.Creating a Chart Sheet in a Workbook; Selecting Items in a Chart; Adding Data Labels, Titles, and Other Items to a ChartValidation, Conditional Formatting, Protection, Proofing, Goal Seek.

Advance MS Excel(Level 1)

Advance Excel with Formulas, Excel Application Setting, Paste with CalculationAdvance Excel with Formulas, Excel Application Setting, Paste with CalculationAdvance Custom Formatting, Use Formulas in Conditional Formatting, Excel Protection System, Data Filling with Flash Fill, Data Sorting , Filter and Selection Concept, Data Analyzing with Pivot, Recognized Pivot Table, Relational Pivot, Reporting with Chart, Insert Other Application in Excel SheetConcept of Formulas Inserting, Logical Formulas Use, Working with Text Formulas, Working With Date & Time Formulas, Data Lookup with VLookup, HLookup, Match, Index, using Array, Mathematics Calculation, Database Formulas, Informational Formulas, Financial Formulas, Array formulas, Formulas Nesting, Formulas Tricks, Data Import Other Database, Data Import Access Database, Data Connection with SQL Server, Data Import from Webs, Data Clean and Advance Filter, Validation and What-if-Analysis, SubTotal

Advance MS Excel (Level 2)

Advance Conditional Formating, Array Formulas, Formulas Nesting, Miscellaneous Formula Techniques, Performing With Array Formulas, Report Automation Sample, Understanding the Series Formulas, Creating Links to Cells For Title,Axis,Labels and Text, Charting Progess Toward a Goal, Creating a Gauge Chart, Displaying the Conditional Colors, Creating Comparative Histogram, Creating a Grant Chart, Ceating a Box Plot, Handling Missing Data
Chart with Access and SQL, Chart with Form Cantrol Buttons, Interactive Dashboards using PowerPoint and Excel
Introduction to Dashboards
Dashboard Background, Dashboard Elements, Interactive Dashboards, Type of Reporting in India, Reporting Analyst, Indian print media reporting, audit report, Accounting MIS Reports, HR Mis Reports, MIS Report Preparation Supplier, Exporter, Data analysis, Costing Budgeting Mis Reporting, MIS Report for Manufacturing Company, MIS Reporting For Store and Billing, Product Performance Report, Member Performance Report, Customer-wise Sales Report, Collections Report, Channel Stock Report, Prospect Analysis Report
Calling Reports, Expenses Report, Stock controller MIS reporting

MS Power Point

Create a new presentation, Modify presentation themes, Add and edit text to slides, Add new slides to a presentation, Insert clipart images and shapes to slides, Insert and modify tables and charts,
Add sound and video to a slide presentation, Insert and edit animations and slide transitions, Display a speaker-lead and self-running presentation.

Basics of Accounting

Types of Accounts, Golden Rules of Accounting, Accounting Principles, Concepts and Conventions, Double Entry System of Book Keeping, Mode of Accounting, Financial Statements, Transactions, Recording Transactions

Fundamentals of Tally.ERP 9

Getting Functional with Tally.ERP 9, Creation / Setting up of Company in Tally.ERP 9

Accounting Masters in Tally.ERP 9

F11:Features, F12 : Configurations, Setting up Account Heads

Inventory in Tally.ERP 9

Stock Groups, Stock Categories, Godowns / Locations, Units of Measure, Stock Items, Creating Inventory Masters for National Traders

Voucher Entry in Tally.ERP 9

Accounting Vouchers, Inventory Vouchers, Invoicing

Advanced Accounting in Tally.ERP 9

Bill-wise Details, Cost Centres and Cost Categories, Voucher Class and Cost Centre Class, Multiple Currencies, Bank Reconciliation, Interest Calculations, Budgets & Controls, Scenario Management

Advanced Inventory in Tally.ERP 9

Order Processing, Reorder Levels, Tracking Numbers, Batch- ise Details, Additional Cost Details, Bill of Materials (BoM), Price Levels and Price Lists, Stock Valuation, Zero Valued Entries, Inventory Ageing Analysis, Different Actual and Billed Quantities

Value Added Tax (VAT)

Configuring VAT in Tally.ERP 9, Creating Masters, Entering Transactions, Accounting for Return of Goods, Rate Difference in Purchase / Sales, Accounting for Interstate Transactions, Exempt Transactions under VAT, Purchases from Unregistered Dealers, Claiming ITC on Capital Goods, Inter-State Branch Transfers, VAT Reports, VAT for Composite Dealers

Central Sales Tax (CST)

Basics of Central Sales Tax (CST), Enabling CST in Tally.ERP 9, Recording Interstate Transactions in Tally.ERP 9, Payment of CST, CST Reports

Point of Sale (PoS)

Features of Point of Sale (PoS) in Tally.ERP 9, Configuring Point of Sale in Tally.ERP 9, Entering POS Transactions, POS Reports

Job Costing

Configuring Job Costing In Tally.ERP 9,  Creating Masters for Job Costing, Recording  Transactions, Job Costing Reports

Multilingual Capabilities

Configuring Tally.ERP 9 for Multilingual Capabilities, Creating Masters, Entering Transactions in Multiple Languages, Transliteration, Generating Reports

Technological Advantages of Tally.ERP 9

TallyVault, Security Control, Tally Audit, Backup and Restore, Split Company Data, Export and Import of  Data, ODBC Connectivity, Web Enabled, Print Preview and Online  Help, Printing of Reports and  Cheques,

Tally.NET and Remote Capabilities

Overview of Tally.NET, Configure Tally.NET Features, Connect Company on Tally.NET, Create Remote Users, Authorise Remote Users, Remote Access

Application Management and Controls

Concept of Control Centre, Installing & Activating Tally.ERP 9, Logging to Control Centre, Managing Accounts using Control Centre

Service Tax

Basics of Service Tax, Configuring Tally.ERP 9 for Service Tax, Creating Masters, Entering Transactions, Accounting for Advance Receipts, Accounting for Opening Service Tax Credit, Payment of Service Tax, Service Tax Reports

Tax Deducted at Source

Basic concepts of TDS, Configuring TDS in Tally.ERP 9, Creation of Masters, Processing Transactions, TDS Reports

Tax Collected at Source

Basic Concepts of TCS, Configuring Tally.ERP 9 for TCS, Creating Masters, Entering Transactions, TCS Reports

Excise for Dealers

Basic Concepts, Salient Features of Dealer Excise, Enabling Dealer Excise in Tally.ERP 9, Creating Masters, Entering Transactions, Excise Reports, Sales & Purchase Extract

Excise for Manufacturers

Basic Concepts of Excise Duty, Configuring Excise in Tally.ERP 9, Creation of Masters, Processing Transactions, Excise Reports

Payroll Accounting and Compliance

Configuring Payroll in Tally.ERP 9, Creating Payroll Masters, Processing Payroll in Tally.ERP 9, Accounting for Employer PF Contributions, Accounting for Employer ESI Contributions, Payment of Professional Tax, Generating Payroll Reports

Click Here To Download Advance Diploma in Financial Accounting (Tally 9ERP )