Topics

CERTIFICATE COURSE IN IT AND ADVANCED EXCEL WITH DBMS (SEMSETER-I)

OFFICE AUTOMATION

• Fundamentals of Computer Systems, Hardware, Software, and Input/Output Devices
• Basic File & Folder Management, Including Creating, Organizing, Deleting, and Restoring Files
• Internet and E-mail Operations, Including Downloading Images, Creating Gmail Accounts, and Managing E-mails with Attachments
• Screenshot Capture and File Conversions
• Document Creation and Formatting Using Word, Including Tables, Pictures, Mail Merge, and Printing
• Presentation Development Using PowerPoint with Text, Images, Designs, Transitions, Animations, and Slideshows
• Protecting Documents Using Password
• Practical Computer Skills for Day-to-Day Office Work and Personal Productivity Tasks

ADVANCED EXCEL WITH VBA

• Data Entry and Worksheet Management
• Formatting Documents and Text Formatting
• Basic Formulas, Chart Creation, and Workbook Protection
• IF, Nested IF, AND, OR Functions, and Text & Date Functions
• Sorting, Filtering, Conditional Formatting, and Data Validation
• SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, and MINIFS
• VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH, and Database Functions
• Financial Functions, CONCATENATE, SUBSTITUTE, and DATEDIF
• Pivot Tables, Pivot Charts, Advanced Charts, and Dashboards
• What-If Analysis, Goal Seek, Forecasting, Trend Analysis, Data Import, Transformation, Cleaning, and Query Merging
• VBA Editor, Programming Basics, Variables, Data Types, Loops, and Macros
• Working with Worksheets and Ranges
• Creating User Forms and Form Controls with Validation

DATABASE MANAGEMENT USING ACCESS

• Database Creation
• Table Design
• Queries
• Forms
• Reports
• Relationships
• Database Management Using Access

CERTIFICATE COURSE IN BUSINESS ACCOUNTING-TAXATION & GST (SEMSESTER-II)

CERTIFICATE COURSE BUSINESS ACCOUNTING

• Essentials of Accounting
• Company Creation, Backup, Restore, and Alteration
• Ledger and Group Creation with Voucher Entry
• Adjustment Entries Including Depreciation and Cost Allocations
• Trial Balance, Cash Flow, and Financial Statements
• Stock Item Creation, Inventory Concepts, and Inventory Management
• Purchase, Sales, Returns, Discounts, and Free Gift Transactions
• Balance Sheet and Profit & Loss Account
• Budget Reports, Day Book, and Cash/Fund Flow
• Stock Summary and Invoice Printing

CERTIFICATE COURSE IN ADVANCED ACCOUNTING

• TDS Entry and Adjustment
• TCS Entry and Adjustment
• Payroll Voucher and Entry
• Pay Head Voucher and Entry
• Pay Slip Generation
• Cheque Printing and Bank Reconciliation Statement
• Bank Reconciliation Adjustment Entries
• Order Processing
• Debit and Credit Note
• Stock Journal and Manufacturing Journal
• Post-Dated Voucher
• Ratio Analysis and Statutory Reports
• Income Tax Return
• VAT Entry

CERTIFICATE COURSE IN GST

• Introduction to GST
• Types of GST Registration
• Stock Item Creation Using HSN Code and GST Rate
• Supply and Invoicing Using GST
• Input Tax Credit
• Calculation of Net Tax
• GST Setoff
• GST Return
• Types of GST
• Job Work
• Return Filing (GSTR-1, GSTR-3B, and GSTR-9) Using Offline Tools