Tally
Upon completion of this course, the participant acquiresthe advantage in choosing his/her career as an Application Programmer, Computerised Accountant, Web Programmer.
I. END-USER APPLICATION
Computer Fundamentals - Introduction to OS/GUI- Wordpad - Notepad - Paintbrush - Windows Explorer - Control Panel
Word Creating Text and Documents - Indexes and Tables - Embedding Picture - Table Manipulation - Mail Merge - Macro.
Excel Formatting Cells - Charts - Pivot Table - Data Table - Forms - Scenarios - Goal seek - Macros and Module.
PowerPoint Creating Presentations - OLE - Enhancing Presentation - Adding Audio & Video - Special Effects.
Creating E-mail ID - Receiving & Sending E-mail - Chatting - Locating Information - Downloading.
II. FRONT-END LANGUAGE & LIBRARY
HTML Basics - New Elements - Canvas - Multimedia - Form Elements, Semantic.
Syntax - Id, Class, Tag Styling - Using Text -Fonts - Links - Lists and Tables - Box Model -Text Effects - Transition - Animations.
III. DATABASE MANAGEMENT SYSTEM
Client / Server Concepts - Relational Model - Data Definition Using SQL - Modify Tables - Using ALTER TABLE Queries, Add a Column, Add an Index, Add a Primary Key - INSERT and DELETE Queries - UPDATE Queries - Using Select Queries - SELECT, WHERE, LIMIT, OR - DER BY, GROUP BY, JOIN - Constraints and Indexes - Views - Expressions - Grouping - Us- ing Functions - Math Functions, Compare String values, Work with Dates - JOIN and Subqueries -Advanced MySQL Query Processing.
IV. FINANCIAL ACCOUNTING
Principles of Accounting – 5 Steps - Maintaining Company Data - F11 Features, F12 Confi gure.
Group-Ledger-Chart of accounts-Stock Group-Stock Category-Unit of measurement-Godown-Stock Items.
Accounting, Inventory Vouchers
Balance Sheet - P & L A/c - Ratio Analysis - Cash Flow, Fund fl ow Statements - Ageing Analysis - Movement Analysis.
Billwise Details - Cost Centres and Cost Categories - Voucher Classes and Cost centre Classes - Multiple Currencies - Bank reconcilliation - Interest Calculation - Budgets & Scenario - Job Costing.
Order Processing - Reorder Levels - Tracking Numbers - Batch wise Details - Additional cost Details - Bill of Materials - Price List
Consolidation of Accounts - Tally vault - Security Control - Tally Audit - Back up and Restore - Split company Data - Export and Import of Data - ODBC Compliance
Predetermination of Invoice - Multi payment Modes - Small & Smart Bills - POS Sales Register
Supporting OS - Translation or Transliteration - System & Phonetic Keyboard - Sourcing from other Software.
Accounting of Purchase or Sales returns - Inter State Trade Accounting - Accounting of Exempted Items - Accounting Purchases from Unregistered Dealers - Accounting Input Credit on Capital Goods - GST Computation & Forms.
Entry - Calculator - Reports - e Returns.
Introduction to Payroll - Confi guring Tally for Payroll - Creation of Payroll Masters - Recording of attendance - Preparation of Payroll Vouchers based on attendance - Preparation of a Salary Disbursement Voucher - Payroll Reports (Pay slip, Pay Sheet, Payroll Statement, Payment Advice, Payroll Register, Attendance Sheet, Attendance Register) - Introduction to Provident Fund.
WhatsApp Connect - Import from Excel - Dashboard.
V. ADVANCED EXCEL & VBA PROGRAMMING
Introduction to MS Excel and Understanding Basic Working with it - Formatting Worksheet - Working with Formulas/Functions (Lookup and Reference Functions, Logical Function, Database Functions, Date and Time Functions, Information Functions, Math and Trigonometry Functions, Statistical Functions, Text Functions) - Conditional Formatting - Connect to other Database - Data Sorting and Filtering - Pivot Tables& Charts.
VBA Overview - VBA Programming Variables - Conditional Logic - String and String Functions - Programming Loops - Programming Arrays - Subs and Functions - Creating your fi rst Macro - Excel VBA - Excel Objects - Excel Events - Excel VBA Error Handling - Excel VBA and User forms - Connect with an external data - Work on automation project.
Will be assigned by the faculty member.