Diploma In Computerised Industrial Accounting Volume( 1 To 6) STANDARD

Rs. 1,620.00

Colour: White

  • Share product:

Description :

Content  : -

Volume 1 :-

1 Basic Accounting (Manual)
2 Starting TallyPrime
3 Creating the Company
4 Creating Ledgers
5 Voucher Entry
6 Altering Ledgers
7 Creating Multiple Ledgers
8 Altering Vouchers
9 Daybook
10 Single Entry Mode
11 Ledgers
12 Viewing Ledgers in TallyPrime
13 Start TallyPrime
14 Trial Balance
15 Viewing the Trial Balance in TallyPrime
16 Profit & Loss Account
17 Profit & Loss Account in TallyPrime
18 Balance Sheet
19 Balance Sheet in TallyPrime
20 Gross Loss
21 Trial Balance (Gross Loss)
22 Profit & Loss Account (Gross Loss)
23 Balance Sheet (Gross Loss)
24 Net Loss
25 Trial Balance (Net Loss)
26 Profit & Loss Account (Net Loss)
27 Balance Sheet (Net Loss)
28 Deleting Voucher
29 Team Work Sales & Services Case Study
30 Company Creation
31 Transactions for April 2019
32 Trial Balance for April 2019
33 Transactions for May 2019
34 Transactions for June 2019
35 Transactions for July 2019
36 Transactions for August 2019
37 Transactions for September 2019
38 Transactions for October 2019
39 Transactions for November 2019
40 Transactions for December 2019
41 Transactions for January 2020
42 Transactions for February 2020
43 Transactions for March 2020
44 Depreciation
45 Entering Closing Stock on Physical Counting and Evaluation
46 Provisions
47 Extending the Accounting Period
48 Transactions for April 2020
49 Finalization of the Period April 2019 to March 2020
50 The Primary Ledger - Profit & Loss A/c
51 List of Accounts
52 List of Transactions

Volume 2 :-

1 Basic Inventory Transaction and Invoicing using TallyPrime
2 Data Entry using Invoice Format
3 Grouping of Accounts
4 Voucher Types
5 Bill Wise Outstanding Receivable
6 Bill Wise Outstanding Payable
7 Interest Calculations in TallyPrime
8 Interest on Loans / Advances (Asset)
9 Interest on Outstanding Receivables
10 Interest on Loan Given (Simple Interest)
11 Interest on Payable & Loans with Advanced Parameters
12 Bank Reconciliation
13 Cheque printing and Post-Dated Transactions
14 Using Multiple Currency - Foreign Exchange Transactions
15 Understanding Direct and Indirect Expenses / Incomes
16 Additional Cost of Purchase
17 Integrate Accounts and Inventory

Volume 3 :-

1 Purchase Order Processing (Purchase Against Purchase Orders)
2 Sales Order Processing (Sales Against Sales Orders)
3 Goods Receipt Note (Purchase Against Goods Receipt Note)
4 Delivery Note / Delivery Challan (Sales Against Goods Delivery
Note)
25 Purchase Return (Debit Note)
6 Sales Return (Credit Note)
7 Rejection Outward Note (Debit Note Against Rejections Outward)
8 Rejection Inward Note (Credit Note Against Rejections Inward)
9 Reorder Level Monitoring (ROL)
10 Using Alternate and Compound Units for Stock Items
11 Classification of Stock Items
12 Group Wise Stock Summary
13 Aging Analysis of Stock Items (Maintaining Batches)
14 Multiple Godowns / Stock Location
15 Manufacturing Voucher Type
16 Cost Centre
17 Cost Centre Group & Categories
18 Job Costing
19 Using Discount, Actual and Billed Quantity & Free Sample
20 Price List and Price Levels
21 POS - Point of Sales
22 Multiple Mailing Details & Logo Printing

Volume 4 : -

1 GST in TallyPrime
2 Defining GST at Company Level
3 Defining GST at Stock Group Level
4 Defining GST at Stock Item Level
5 B2B Inter-State Sales
6 B2C (Large) Inter-State Sales
7 B2C (Small) Inter-State Sales
8 Defining GST at Ledger Level
9 Credit Note
10 Debit Note
11 Nill Rated Invoices
12 Exports
13 Advance Received Towards Supply of Services
14 Supply of Services
15 Import of Goods under GST
16 Services received from Goods Transport Agency
17 GST Returns
18 Change in Tax Rate
19 Availing off Input Credit and Payment of Tax
20 GST Based of Item Rate
21 Effect of Additional Charges & Discount on Assessable Value
22 Trade Discount & Round Off
23 eWay Bill
24 e-Invoicing
25 Payroll
26 Payroll in TallyPrime
27 Printing Reports and Documents
28 E-Mailing Reports & Documents
29 ODBC Open Database Connectivity
30 Exporting Data and Reports to be View or Edited
31 Exporting and Importing Data using XML
32 Synchronization Using IP Address (Direct Sync)
33 Synchronization Using Tally.NET
34 Remote Edit
35 Browser Access to Tally Reports
36 Backup & Restore of Data
37 Multi Lingual TallyPrime
38 TDL Tally Definition Language

Volume 5 :-

1 Concept of Communication
2 Essentials of Good English
3 Business Correspondence – I
4 Business Correspondence – II
5 Administration
6 Inter-Departmental Communication
7 Preparation of Press Releases
8 E-Correspondence
9 The Scheme For Filing Of Tax Returns
10 What are Tax Returns
11 Due Dates For Filing Tax Returns
12 Some Helpful Tips For Income Tax Return
13 Manner of Furnishing Returns
14 How to Fill up a Tax Challan
15 Exemtions from Income
16 Income from Salary At A Glance
17 Income From Capital Gains At a Glance
18 Income from Business Or Profession At a Glance
19 Income from Other Source At A Glance
20 Deduction from total income
21 Income-Tax On Fringe Benefits
22 Some Helpful Tips For Filing Wealth Tax Returns
23 Important Prescribed Forms under IT Rules 1962

Volume 6 : -

1 Worksheet & Functions
2 Exercise 1: Simple Mathematical Calculations
3 Exercise 2: Marksheet Version 1
4 Exercise 3: Marksheet Version 2
5 Exercise 4: Stock Register Version 1
6 Exercise 5: Stock register version 2
7 Exercise 6: Changing fonts
8 Exercise 7: Mathematical and Statistical functions
9 SUM Function
10 PRODUCT Function
11 AVERAGE Function
12 MAX Function
13 MIN Function
14 COUNT Function
15 Exercise 8: Effects of blank cells on AVERAGE function.
16 Exercise 9: Mathematical functions (ROUND, ABS, INT & MOD)
17 ROUND Function
18 ABS Function
19 INT Function
20 MOD Function
21 Exercise 10: Stock register for items with 2 units
22 Exercise 11: Formatting numbers
23 Exercise 12: Bank OD Account passbook
24 Exercise 13: Date functions
25 TODAY Function
26 NOW Function
27 DATE Function
28 YEAR Function
29 MONTH Function
30 DAY Function
31 EOMONTH Function
32 NETWORKDAYS Function
33 NETWORKDAYS.INTL Function
34 Exercise 14: String functions
35 UPPER Function
36 LOWER Function
37 PROPER Function
38 REPLACE Function
39 CONCATENATE Function
40 LEFT Function
41 RIGHT Function
42 MID Function
43 LEN Function
44 FIND Function
45 Exercise 15: IF function
46 Exercise 16: Nested If Function
47 Exercise 17: Marksheet Version 4
48 Exercise 18: Salary Sheet
49 Exercise 19: Aging Analysis Sheet
50 Exercise 20: Sales register with GST calculations
51 Exercise 21: Data validation
52 Exercise 22: Logical functions (OR & AND)
53 Exercise 23: Name Manager
54 Exercise 24: Conditional formatting
55 Exercise 25: SUMIF & SUMIFS functions
56 SUMIF Function
57 SUMIFS Function
58 Exercise 26: COUNT(IF/IFS), AVERAGE(IF/IFS) & COUNTBLANK
59 COUNIF Function
60 COUNTIFS Function
61 AVERAGEIF Function
62 AVERAGEIFS Function
63 COUNTBLANK Function
64 Exercise 27: Daily attendance sheet
65 Exercise 28: Daily wages sheet
66 Exercise 29: VLOOKUP function
67 Exercise 30: VLOOKUP with Approx. match (Mark sheet version 4)
68 Exercise 31: MATCH and INDEX function
69 Exercise 32: Financial functions to calculate depreciation
70 SLN Function
71 DB Function
72 Exercise 33: Financial function to calculate Future value (FV)
73 Exercise 34: FV on interest compounded monthly on lumpsum
74 Exercise 35: FV on investment done monthly
75 Exercise 36: FV on monthly investment compounded quarterly
76 EFFECT Function
77 NOMINAL Function
78 Exercise 37: Financial functions (RATE,NPER, PV)
79 RATE Function
80 NPER Function
81 PV Function
82 Exercise 38: Financial function to calculate EMI (PMT, IPMT & PPMT)
83 PMT Function
84 IPMT Function
85 PPMT Function
86 Data Analysis
87 Exercise 39: Sorting data
88 Exercise 40: Filtering data
89 Exercise 41: Using Advanced filter
90 Exercise 42: Removing duplicates from records in a data
91 Exercise 43: Paste Special
92 Pasting Formulas
93 Pasting Formulas and Number Formats
94 Pasting Values
95 Pasting Values and Number Formats
96 Pasting Formats
97 Pasting Data Validation
98 Pasting all Without Borders
99 Pasting Column Widths
100 Exercise 44: Transpose and Paste Math Operations
101 Exercise 45: Find and Replace
102 Exercise 46: Converting text to column (Fixed width)
103 Exercise 47: Converting text to column (Coma delimited)
104 Exercise 48: Adding subtotals to data
105 Exercise 49: What if analysis - Goal seek
106 Exercise 50: What if analysis -Scenario manager
107 Exercise 51: What if analysis - Data table
108 Exercise 52: Protecting and Unprotecting Sheet
109 Protecting Sheet
110 Unprotecting Sheet
111 Unlock Cells
112 Exercise 53: Pivot Table
113 Exercise 54: Pivot Chart
114 Exercise 55: Insert Chart
115 Column chart
116 Bar Chart
117 Stacked Column Chart
118 Pie Chart
119 Line Chart
120 Exercise 56: Macros
121 Viewing & Printing
122 Exercise 57: Freeze panes.
123 Freeze Rows
124 Unfreeze panes
125 Freeze Columns
126 Unfreeze panes
127 Exercise 58: Split Windows.
128 Split Horizontally
129 Remove Split
130 Split Vertically
131 Remove Split
132 Split both Vertically and Horizontally
133 Exercise 59: Page Setup & Printing
134 Changing Margins
135 Changing Orientation
136 Set Print Area
137 Remove Print Area
138 Repeating Top Rows on Every Page
139 Inserting Page Break
140 Removing Page Break
141 Repeat column at left
142 Change the page order of printing.
143 Page Break Preview
144 Normal View
145 Page Layout View
146 Inserting Header
147 Inserting Footer
148 Adjusting the Page to Fit
149 Center on Page
See More