info@cambridgeinfotech.in   080- 40943580 / 9902461116

Tally ERP.9 with GST

 

1 Creation of Company

2 Selection of Company

3 Shut Company

4 Alteration of Company

5 Deletion of Company

6 Features & Configuration

7 Tally Keys

8 How to Convert Tally Data into Excel

9 How to Copy Tally Data from One System to Another System

10 Creation of Ledger

11 Contra

12 How to Verify Bank Balance

13 Payments

14 Receipts

15 How to Verify Ledger Balance

16 B R S (Bank Reconciliation Statement)

17 Service Tax

18 TDS Payable

19 TDS Receivable

20 Journals

21 Salary Entries

22 Creation of Stocks

23 Purchase Order

24 Purchase including GST

25 Vendor Payment

26 Debit Note

27 Sales Order

28 Sales including GST

29 Customer Payment

30 Credit Note

31 Purchase and Sales Register

32 Order Books

33 Stock Transfer

34 Stock Summary

35 How to Enter Opening Balance

36 Balance Sheet

37 Trial Balance

38 Profit & Loss Account

39 Day Book

40 Professional Tax

41 Import Data

42 Multiple Currency

43 Credit Card Transactions

 

 

Taxation and GST course

  • Introduction to Goods & Services Tax (GST)
  • Requirement of GST Law and its Impact in current Account
  • Detailed understanding of CSGT, SGST
  • Chargeability of CSGT, SGST and IGST
  • Service Tax
  • TDS Payable
  • TDS Receivable
  • Income Tax

 

Finance and Accounting Course

  • Understand the Accounting Process
  • Understand the process of Finalization
  • Understand the Financial Statement Analysis
  • Understand Depreciation Accounting
  • Reconciling Cash & Bank balances
  • Bookkeeping & Accountancy
  • Trading and Profit loss account
  • Balance sheet
  • Trail balance
  • Purchase Register, Sales register and day book
  • Bank reconciliation statement
  • Inventory and stock summary
  • Ledgers
  • Accounts payable and accounts receivable

 

Auditing

  • Introduction to Auditing
  • Auditor’s Report and Responsibilities
  • Audit Planning, Materiality, and Risk
  • Introduction to Internal Control, Assessment of Control Risk, and Audit Program Concepts
  • Audit of the Sales and Receivables Cycle and Cash Balances
  • Audit of the Purchases and Payables Cycle
  • Audit of the Payroll and Inventory Cycles
  • Completion of the Audit and Fraud (Assessment and Management)

 

 

 

 

 

Advance Excel

Formula and Function Tips and Shortcuts

  1. Displaying and highlighting formulas
  2. Auditing tools
  3. Using entire row/column references
  4. Copying column formulas instantly
  5. Converting formulas to values with a simple drag
  6. Updating values without formulas
  7. Simplifying debugging formulas
  8. Enhancing readability with range names
  9. Creating 3D formulas to gather data from multiple sheets


Formula and Function Tools

  1. Understanding the hierarchy of operations in Excel formulas
  2. Using the Formulas tab on the Ribbon for locating functions
  3. Using the Insert Function button for guidance with unfamiliar functions
  4. Using and extending AutoSum button capabilities
  5. Using absolute and relative references in formulas
  6. Using mixed references in formulas

 

IF and Related Functions

  1. Exploring IF logical tests and using relational operators
  2. Creating and expanding the use of nested IF statements
  3. Using the AND and OR functions with IF to create compound logical tests

 

Lookup and Reference Functions

  1. Looking up information with VLOOKUP and HLOOKUP
  2. Finding approximate matches with VLOOKUP
  3. Finding exact matches with VLOOKUP
  4. Nesting lookup functions
  5. Using VLOOKUP with large tables
  6. Finding table-like information within a function with CHOOSE
  7. Locating data with MATCH
  8. Retrieving information by location with INDEX
  9. Using MATCH and INDEX together

 

Power Functions

  1. Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF
  2. Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS

 

Statistical Functions

  1. Finding the middle value with MEDIAN
  2. Ranking data without sorting with RANK
  3. Finding the largest and smallest values with LARGE and SMALL
  4. Tabulating blank cells with COUNTBLANK
  5. Using COUNT, COUNTA, and the status bar

Math Functions

  1. Working with ROUND, ROUNDUP, and ROUNDDOWN
  2. Working with MROUND, CEILING, and FLOOR for specialized rounding
  3. Using the INT and TRUNC functions to extract integer data
  4. Finding the remainder with MOD and using MOD with conditional formatting
  5. Practical uses for the random number functions RAND and RANDBETWEEN
  6. Converting a value between measurement systems with CONVERT
  7. Using the powerful AGGREGATE function to bypass errors and hidden data
  8. Using the ROMAN and ARABIC functions to display different numeral systems

 

Date and Time Functions

  1. Understanding Excel date/time capabilities in formulas
  2. Using TODAY and NOW functions for dynamic date/time entry
  3. Identifying the day of the week with WEEKDAY

 

Counting working days with NETWORKDAYS

  1. Determining a completion date with WORKDAY
  2. Tabulating date differences with DATEDIF
  3. Calculating end-of-month and future/past dates with EDATE and EOMONTH
  4. Converting text entries into dates and times with DATEVALUE and TIMEVALUE

 

Array Formulas and Functions

  1. Extending formula capabilities with arrays
  2. Counting unique entries in a range with an array formula
  3. Determining frequency distributions with FREQUENCY
  4. Flipping row/column orientation with TRANSPOSE
  5. Building analysis via regression techniques with TREND and GROWTH
  6. Using array formula techniques with the MATCH function for complex lookups

 

Reference Functions

  1. Getting data from remote cells with OFFSET
  2. Returning references with INDIRECT
  3. Using INDIRECT with data validation for two-tiered pick list scenarios