Address : 279/1, New Railway Road Gurgaon
Call us : 99 10 192 454 | 98 11 176 098
Email: usflindia@gmail.com

"Speak a new language
so that the world
will be a new world."

Diploma in Computer

Diploma in Computer

Fundamentals of Computer
  1. Introduction
  2. Input/output & Processing (CPU)
  3. Memory Device
  4. Type of Computers
  5. Characteristics of Computer
  6. History & Generation
  7. Applications of Computer

Windows XP Overview


  1. Some Basic Terminology & Typing Skills
  2. Desktop Setting & Control Panel
  3. Ms. Dos
  4. Ms. Paint
  5. WordPad
  6. Accessories & Multimedia

E-mail & Internet


  1. Introduction
  2. E-mail Account & Its Functions
  3. Search Engine
  4. Surfing WebPages
  5. Basic of Social Networking Site

Virus


  1. General Introduction
  2. Antivirus Utilities

Application Software


  1. Microsoft Word
  2. Microsoft Excel
  3. Microsoft Power Point

Overview of the Basics


  1. Customizing common option in Excel
  2. Absolute and Relative cells
  3. Protecting and un-protecting worksheets and cells

Working with Functions


  1. Writing conditional expressions (using IF)
  2. Using logical functions (AND, OR, NOT)
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

Data Validation


  1. Specifying a valid range of values for a cell
  2. Specifying a list of valid values for a cell
  3. Specifying custom validations based on formula for a cell

Working with Templates


  1. Designing the structure of a template using templates for standardization of worksheets

Sorting and Filtering Data


  1. Sorting tables
  2. Using Multiple-level sorting
  3. Using custom sorting
  4. Filtering data for selected view (Auto Filter)
  5. Using advance filter options

Working with Reports


  1. Creating subtotals
  2. Multiple-level subtotals
  3. Creating Pivot tables
  4. Formatting and customizing Pivot tables
  5. Using advanced options of Pivot tables Pivot charts
  6. Consolidating data from multiple sheets and files using Pivot tables
  7. Using external data sources
  8. Using data consolidation feature to consolidate data

More Functions


  1. Date and time functions
  2. Text functions
  3. Database functions

Formatting


  1. Using auto formatting option for worksheets
  2. Using conditional formatting option for rows, columns and cells

Fundamentals of Tally ERP 9


  1. Introduction
  2. Getting Functional with Tally.ERP 9
  3. Company Features
  4. Configurations
  5. Creation of Company

Creating Accounting Masters


  1. Chart of Accounts
  2. Group
  3. Ledgers

Creating Inventory Masters


  1. Stock Group
  2. Stock Categories
  3. Units of Measure
  4. Godowns
  5. Stock Items
  6. Accounting Voucher
  7. Walkthrough for recording Accounting Voucher

Voucher Entry


  1. Inventory Vouchers
  2. Walkthrough for recording Inventory Vouchers
  3. Invoicing
  4. Security Controls

Technological Advantages of Tally ERP 9


  1. Backup and Restore
  2. Print Preview and Online Help
  3. Printing Reports

Advance Accounting


  1. Bill-wise Details
  2. Cost Centres and Cost Categories
  3. Multiple Currencies
  4. Stock Summary

Advance Inventory


  1. Order Processing
  2. Tracking Numbers
  3. Bill of Material (BOM)
  4. Price Levels and Price Lists
  5. Different Actual and Bill Quantities

Taxes & Payroll


  1. TDS
  2. TCS
  3. PAYROLL
  4. GST
    1. Introduction to GST
    2. GST Registration
    3. Why is GST Registration important?
    4. How to Register for GST
    5. What is GSTIN – Goods & Services Tax Identification Number
    6. Casual Registration
    7. Composition Dealer
    8. Migration to GST
    9. Multiple Registrations under GST
    10. HSN Code
    11. Type of GST (SGST, CGST, IGST)
    12. ITC (Input Tax Credit)
    13. GST Rates
    14. Types of GST Return and their Due Dates

Introduction to the C Language


  1. The C Language and Its Advantages
  2. The Structure of a C Program
  3. Writing C Programs
  4. Building an Executable Version of a C Program
  5. Debugging a C Program
  6. Examining and Running a C Application Program

Data Types and Variables


  1. Data Types
  2. Operands, Operators, and Arithmetic Expressions

Input/output Management


  1. Input/output Management
  2. The getchar() and putchar() Functions and Single-character I/O
  3. Formatted Input and the scanf() Function

Control-flow Statements


  1. The Control-flow Program Statements
  2. Looping Statements
  3. The Data-checking Process

Modular Programming with Functions


  1. The C Function
  2. Passing Data to Functions
  3. Passing an Address to Modify a Value in Memory
  4. Using Function in the Checkbook Program
  5. The C Standard Library Functions

Arrays, Pointer, and Strings


  1. Arrays
  2. Pointers
  3. Strings
  4. Using Arrays, Strings, and Pointers in the Checkbook Program

Structures and Dynamic Memory Allocation


  1. Structures
  2. Arrays of Structures
  3. Passing Structures to Functions
  4. Nested Structures
  5. Dynamic Memory Allocation

The Preprocessor and Multiple-file Compilation


  1. The C Preprocessor and the #include and #define Directives
  2. The Conditional Compilation Directives
  3. Global Variables and Variable Storage Classes
  4. Program Organization and Multi-file Compilation

File Input/output


  1. Command-line arguments
  2. File Input and Output
  3. Combining Command-line Arguments and File I/O

your interest

Universal School