# Complete Computer Course (CCC)

### Fundamental Of Computer

Computers are an essential part of modern life, used for a wide range of tasks from browsing the internet to running complex business applications. Some of the fundamental features of a computer include:

### MS Word

Microsoft Word is a word processing program developed by Microsoft. It is one of the most widely used word processing programs in the world, used for creating and editing documents, such as letters, reports, resumes, and more. Some of the fundamental features of MS Word include:

### MS Excel

Microsoft Excel is a spreadsheet program developed by Microsoft. It is used for organizing, analyzing, and manipulating numerical data. Some of the fundamental features of MS Excel include:

Formatting Cells, Rows, Columns
Conditional Formatting
Sorting Data

Advanced Excel is the use of more complex functions and tools within Microsoft Excel to analyze and manipulate data in more sophisticated ways. Some of the advanced features of MS Excel include:

These functions can be accessed through the Formulas tab in Excel, or by typing their names into a cell preceded by an equal sign (=).

#### 6 Statistical Function In Excel:

In Excel, statistical functions are built-in functions that perform various statistical analyses and calculations on data. These functions are designed to help you analyze and understand data by providing you with tools to summarize and make sense of it.

Here are some common statistical functions in Excel:
1. Sumif In Excel In Hindi
2. Sumifs Function In Excel In Hindi
3. COUNTIF Function In Excel In Hindi
4. COUNTIFS Function In Excel In Hindi
5. Averageif Function In Excel In Hindi
6. Averageifs In Excel In Hindi

#### 7 Text Functions :

In Microsoft Excel, the TEXT function falls under the category of "Text" functions. This category includes various functions that can be used to manipulate and format text strings. Some of the other functions in this category include:

1 Proper Function In Excel
2 Upper Function In Excel
3 Lower Function In Excel
4 Left Function In Excel
5 Right Function In Excel
6 Mid Function In Excel In Hindi
7 Len Function In Excel
8 Trim Function in Excel
9 Concatenate Function In Excel

#### 8 Logical reunions :

In Microsoft Excel, logical functions are used to evaluate logical tests or conditions and return a TRUE or FALSE result. There are several logical functions in Excel, including:

1 If Function In Excel
2 If And Function In Excel
3 If Or Function In Excel
4 Nested If Function
5 Choose

#### 9 Cell referenced :

Cell reference in Excel refers to the way that Excel identifies a cell or range of cells on a worksheet. A cell reference is typically a combination of a column letter and a row number that identifies a specific cell, such as A1, B2, C3, and so on. The cell reference tells Excel which cell to use in a formula or function.

1 Relative
2 Absolute Reference
3 Mixed Reference

#### 10 Count functions :

In Microsoft Excel, there are several COUNT category functions that allow you to count cells based on specific criteria. These functions include:

1 Count
2 Counta
3 Countif Function
4 Countifs Function
5 Countblank

#### 11) Financial Formula

Microsoft Excel has a wide range of financial functions that can be used to perform various financial calculations. Some of the commonly used financial functions in Excel include:

#### 12) Lookup Function

In Microsoft Excel, the LOOKUP function is used to search for a value in a range of cells or an array, and return a corresponding value in the same position from a different range or array. There are few types of LOOKUP functions in Excel:

#### Function

ABS Function In Excel

### 1. Accounting

1. What is accounting
2. Golden rules of accounting
4. Basic concepts of accounting
5. Journal entries

### 2. Tally Prime Info

The syllabus for Tally Prime Info course where we will learn company creation, deletion, backup and restore in tally prime.

1. What is tally prime?
3. Create Company
4. Alter Company
5. Select Company / Change Company
6. Shut Company
7. Backup Company
8. Restore Company
9. Delete Company

### 3. Tally Prime Tutorial Basic

The syllabus for Tally Prime Basic course may vary depending on the institution or trainer offering the course. However, below are some of the topics that are commonly covered in Tally Prime Basic course:

1. 28 Predefine Group in Tally
2. How to create Ledger Groups?
3. What is Ledger in Tally
4. Ledger Under Group
5. Create Ledger
6. How to Alter Ledger?
7. How to Delete Ledger?
8. Stock Group Create
9. Stock category create
10. Stock unit creation
11. Stock Item Create
12. How To Create Godowns / Location
13. How to view trial balance?
14. Display Profit &Loss Statement
15. Display Balance Sheet

### 4. Accounting Vouchers - for accounting Entries

Vouchers in Tally is a document having all the details of a financial transaction and is required for recording in the books of accounts. It helps in easy recording and modifying of records.

Types of vouchers in Tally Prime:
1. What is vouchers
2. What is narration?
3. Journal Voucher and Entries
4. Purchase Voucher
5. Sales Voucher
6. Payment Voucher
7. Receipt Voucher
8. Contra Voucher

### 5. Inventory Management

Inventory refers to all the items, goods, and materials held by a business for selling in the market to earn a profit.

Inventory vouchers are used to enter any type of stock transaction receipt and issue of goods/stock (Movement of goods). Only entries can be made in accounting vouchers, but stock, group, purchase return, sales return, etc. can all be entered in inventory voucher.

Types of inventory voucher in tally prime
1. Purchase Order
2. Sales Order
3. Rejection In (Sales Return / Inward Rejection)
4. Rejection Out (Purchase Return / Outward Rejection)
5. Stock Journal Transfer Stock Item
6. Delivery Note
7. Receipt Note

#### 1. Purchase Cycle

1 Purchase Order
2 Receipt Note
3 Rejection Out (Purchase Return / Outward Rejection)
4 Purchase
5 Payment
6 Debit Note
Purchase Cycle Assignment

#### 2. Sale Cycle

1. Sales Order
2. Delivery Note
3. Rejection In (Sales Return / Inward Rejection)
4. Sale
5. Receipt
6. Credit Note
Sales Cycle Assignment

### 6. Banking

Banking is an important aspect of accounting and bookkeeping, and TallyPrime provides a comprehensive solution for managing bank transactions. Here are some of the key features of banking in TallyPrime:

1. Bank Ledger Create
2. Cheque Book Management in Tally
3. Cancel Cheque Book in Tally
4. Pass Blank Cheque Book
5. Bank Reconciliation
6. Bank Interest Calculation
7. Assignment

### 7. Advance Tally Prime Tutorial

The syllabus for an advanced TallyPrime course may vary depending on the institution or trainer offering the course. However, here are some of the topics that are commonly covered in an advanced TallyPrime course:

1. Multi Currency
2. Multiple Price Level
3. Add Discount Column In Invoices
4. Use Actual Qty And Billed Qty In Tally Prime
5. Zero Value Entry
6. Point Of Sales
7. Job Costing & Cost Centers
8. Interest Calculation in Tally Prime
9. Product Manufacturing In Tally Prime
10. Scenario In Tally Prime
11. Budget Control In Tally Prime
12. Tally Auditing In Tally Prime
13. Export/Import Of Data
14. E-mail
15. Split A Company
16. Internal Backup Company
17. How to  Restore Company
18. Printing All The Reports

### 8. Payroll Master

Payroll management is an important aspect of accounting, and TallyPrime offers a comprehensive solution for managing payroll. Here are some of the key features of the payroll master in TallyPrime:

1. Employee Master: TallyPrime allows you to create an employee master with all the necessary details such as name, address, contact information, salary details, and deductions.

2. Attendance Management: TallyPrime enables you to manage employee attendance, including recording leave, overtime, and absent days.

3. Salary Calculation: TallyPrime allows you to calculate employee salaries based on various parameters such as attendance, leave, overtime, and deductions.

4. Payslip Generation: TallyPrime enables you to generate payslips for your employees, which can be customized as per your organization's needs.

5. Payroll Reports: TallyPrime provides a range of payroll reports to help you track your payroll transactions. You can generate reports such as salary statements, statutory reports, and income tax reports.

1. Payroll Master in Tally Prime
2. How to Record Salary Details In Tally Prime
3. Create Employee Group
4. Payroll Work Unit Creation
5. Payroll Attendance / Production Type Creation
7. Payroll Voucher Creation
8. Payroll Employee Creation
9. Attendance Sheet Voucher
10. Make Employee Salary in Tally Prime

### 9. Taxation in Tally Prime

TallyPrime is a comprehensive accounting software that provides a range of features for managing taxation. Here are some of the key features of taxation in TallyPrime:

1. GST Compliance: TallyPrime is fully compliant with GST regulations and enables you to manage GST transactions efficiently. You can create GST-compliant invoices, file GST returns, and generate GST reports using TallyPrime.

2. TDS (Tax Deducted at Source): TallyPrime enables you to deduct TDS on payments made to vendors and generate TDS challans and certificates.

3. TCS (Tax Collected at Source): TallyPrime enables you to collect TCS on sales and generate TCS challans and certificates.

4. E-Way Bill: TallyPrime enables you to generate E-way bills for your goods transportation. It also helps you manage E-way bill compliance requirements.

1. What Is GST?
2. What is TDS?
3. TDS In Tally Prime
4. TCS on Purchase in Tally Prime