Advanced Diploma in Computer Applications

1: Beginner's guide to Computer

  • Know Your Computer
  • Starting and Closing Computer
  • Interacting with Computer
  • Program and Application

2: System Installation and Configuration

3: Working on Text with WordPad

  • Text and Keyboarding
  • Text Navigation
  • Text Selection
  • Using Clipboard
  • Text Formatting

4: The Microsoft Windows XP

  • The Desktop
  • The Start Menu
  • The File and Folder
  • The Windows
  • Customizing the Desktop and Taskbar
  • The Microsoft Windows Accessories
  • The Help and Support
  • The Web Applications
  • The Miscellaneous

PHP and Ajax

  • Ajax Intro
  • Ajax PHP
  • Ajax database

5: The Microsoft Windows Vista

  • The Desktop
  • Icons
  • Taskbar
  • Window sidebar and Gadgets
  • Desktop icons
  • The recycle bin
  • The Quick Launch Toolbar
  • Keep Track of your windows

6: The Microsoft Windows 7<

  • Starting to Explore Microsoft Windows 7
  • Managing File Folder and Library
  • Themes, Background, and Color Schemes
  • Windows 7 Managing and Maintaining
  • Windows 7 Networking (File Sharing)
  • Window 7 Miscellaneous
  • Windows 7 Keyboard Shortcuts

7: Microsoft Office

  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Access
  • Microsoft Outlook

8: Desk Publishing

  • Desktop Publishing(DTP)
  • Adobe PageMaker

9: The Internet

  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Access
  • Microsoft Outlook

10: Communication and Collaboration

  • Basics of Email, Email Addressing, Configuration Email Client
  • Using Emails
  • Opening Email Client
  • Mailbox
  • Creating and Sending a new Email
  • Handling SPAM
  • Instant Messaging and Collaboration
  • Using Smiley

11: Web Designing- HTML

  • HTML Introduction
  • HTML Elements
  • HTML Heading
  • HTML Paragraph
  • HTML Style
  • HTML Color
  • HTML Image
  • HTML Table
  • HTML Form
  • HTML Frame
  • HTML List
  • HTML CSS

Tally ERP 9.0

  • BASIC OF ACCOUNTING Introduction
  • Types of Accounts
  • Accounting Principles or concepts
  • Mode of Accounting
  • Rules of Accounting
  • Double-entry system of bookkeeping

FUNDAMENTALS OF TALLY.ERP 9

  • Company Features
  • Configuration
  • Getting functions with Tally.ERP9
  • Creation / setting up of Company in Tally.ERP9

ACCOUNTING MASTERS IN TALLY.ERP 9

  • Chart of Groups
  • Groups
  • Multiple Groups
  • Ledgers
  • Multiple Ledgers

INVENTORY MASTERS IN TALLY.ERP9

  • Stock Groups
  • Multiple Stock Groups
  • Stock Categories
  • Multiple Stock Categories
  • Units of Measure
  • Stock Items

VOUCHERS ENTRIES IN TALLY.ERP9

  • Introduction
  • Types of Vouchers
  • Chart of Vouchers
  • Accounting Vouchers
  • Inventory Vouchers
  • Invoicing

ADVANCE ACCOUNTING IN TALLY.ERP9

  • Bill wise details
  • Cost centers and Cost Categories
  • Multiple currencies
  • Interest calculations
  • Budget and controls
  • Scenario management
  • Bank Reconciliation

ADVANCE INVENTORY IN TALLY.ERP9

  • Order Processing
  • Recorder Levels
  • Batch-wise details
  • Bill of Materials

TAXES IN TALLY.ERP9 TDS

  • TDS Reports
  • TDS Online Payment
  • TDS Returns filing
  • TDS Certificate issuing
  • 26AS Reconciliation
  • TCS
  • TCS Reports
  • GST
  • GST Returns
  • EPF
  • ESIC
  • Professional Tax

PAYROLL ACCOUNTING IN TALLY.ERP9

  • Employee Creation
  • Salary Define
  • Employee Attendance Register
  • Pay Heads Creation
  • Salary Report

GENERATING REPORTS IN TALLY.ERP9

  • Financial Statements
  • Trading Account
  • Profit & Loss Account Balance Sheet
  • Accounts Books and Reports
  • Inventory Books and Reports
  • Exception Reports
  • Statutory Reports
  • Payroll Reports
  • Trail balance
  • Day Book
  • List of Accounts
  • Stock Summary
  • Outstanding Statement

MS-Excel

Manage Workbook Options and Settings

  • Create Worksheets and Workbooks
  • Navigate in Worksheets and Workbooks
  • Format Worksheets and Workbooks
  • Customize Options and Views for Worksheets and Workbooks

Apply Custom Data Formats and Layouts

  • Apply Custom Data Formats and Validation
  • Conditional Formatting and Filtering

Create Tables

  • Create and Manage Tables
  • Filter and Sort a Table

Perform Operations with Formulas and Functions

  • Summarize Data by using Functions
  • Format and Modify Text by using Functions
  • Perform Conditional Operations by using Functions

Create Charts and Objects

  • Create Charts
  • Insert and Format Objects
  • Format Charts

Apply Custom Data Formats and Layouts

Create Advanced Formulas

  • Apply Functions in Formulas
  • Look up data by using Functions
  • Apply Advanced Date and Time Functions
  • Troubleshoot Formulas

Create Advanced Charts and Tables

  • Create and Manage PivotTables
  • Create and Manage Pivot Charts

Advance Excel

  • What If Analysis
  • Logical Functions
  • Data Validation
  • Lookup Functions
  • Pivot Tables
  • Charts and slicers
  • Excel Dashboard
  • VBA Macro
  • Introduction to VBA
  • Variables in VBA
  • Message Box and Input box Functions
  • If and select statements
  • Looping in VBA
  • Mail Functions – VBA
Best Training Institute for IT Software Hardware & Networking Courses in LucknowClick to call
Best Training Institute for IT Software Hardware & Networking Courses in LucknowEnquiry Now