OBJECTIVE :

Upon completion of this course, the participant acquires the advantage in choosing his / her career as an Application Programmer, Computerised Accountant & Web Programmer.

TARGET AUDIENCE :

School final students / Graduates / Students pursuing a career in Computer.

PREREQUISITES :

No prior Computer knowledge is required.

OVERVIEW :

This course has been tailor made as per the software industry requirement. It is a stepping stone for those who aspire to be a software professional.

COURSE COVERAGE :

END-USER APPLICATION

WINDOWS Computer Fundamentals - Introduction to OS/GUIWordpad - Notepad - Paintbrush - Windows Explorer - Control Panel.

MS OFFICE :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.

INTERNET :Creating E-mail ID - Receiving & Sending E-mail - Chatting - Locating Information - Downloading.

FRONT-END LANGUAGE & LIBRARY

HTML5 HTML Basics - New Elements - Canvas - Multimedia - Form Elements, Semantic.

CSS3 :Syntax - Id, Class, Tag Styling - Using Text - Fonts - Links - Lists and Tables - Box Model - Text Effects - Transition - Animations.

DATABASE MANAGEMENT SYSTEM

MySQL :
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, ORDER BY, GROUP BY, JOIN - Constraints and Indexes - Views - Expressions - Grouping - Using Functions - Math Functions, Compare, String values, Work with Dates - JOIN and Subqueries - Advanced MySQL Query Processing.


FINANCIAL ACCOUNTING

INTRODUCTION TO TallyPrime
Principles of Accounting – 5 Steps - Maintaining Company Data - F11 Features, F12 Configure.

MASTERS
Group-Ledger-Chart of accounts-Stock Group-Stock Category-Unit of measurement-Godown-Stock Item

TALLY VOUCHERS
Accounting, Inventory Vouchers

REPORTS
Balance Sheet - P & L A/c - Ratio Analysis - Cash Flow, Fund flow Statements - Ageing Analysis - Movement Analysis.

ADVANCED ACCOUNTING
Billwise Details - Cost Centres and Cost Categories - Voucher Classes and Cost centre Classes - Multiple Currencies - Bank reconcilliation - Interest Calculation - Budgets & Scenario - Job Costing.

ADVANCED INVENTORY
Order Processing - Reorder Levels - Tracking Numbers - Batch wise Details - Additional cost Details - Bill of Materials - Price List.

SYSTEM ADMINISTRATION AND OTHER UTILITIES
Consolidation of Accounts - Tally vault - Security Control - Tally Audit - Back up and Restore - Split company Data - Export and Import of Data - ODBC Compliance.

POINT OF SALES
Predetermination of Invoice - Multi payment Modes - Small & Smart Bills - POS Sales Register.

MULTI LANGUAGE
Supporting OS - Translation or Transliteration - System & Phonetic Keyboard - Sourcing from other Software.

GOODS & SERVICE TAX (GST)
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.

TDS & TCS
Entry - Calculator - Reports - e Returns.

PAYROLL
Introduction to Payroll - Configuring 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.

PROJECT*
Live simulated projects are given to students.


ADVANCED EXCEL & VBA PROGRAMMING

ADVANCED EXCEL
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 PROGRAMMING
VBA Overview - VBA Programming Variables - Conditional Logic - String and String Functions - Programming Loops - Programming Arrays - Subs and Functions - Creating your first 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.

PROJECT*
Students are given projects using VBA Excel and it will be helpful to explore how to use VBA to automate different tasks or developing applications/ tools using VBA.


DIGITAL MARKETING

ADVANCED EXCEL
Introduction to Digital Marketing, Traditional vs Digital Marketing, Organic vs Inorganic Marketing, Content Creation, Graphic Designing, Social Media Marketing, Facebook, Instagram, Youtube, Search Marketing, Google Ads, Google Analytics.