Tally Course In Chandigarh & Mohali -(9988113578) | (TallyPrime -Tally ERP Training in Chandigarh , Learn Tally in Chandigarh ,Tally Certification in Chandigarh)


  •  Tally  In Chandigarh & Mohali  
  •  Tally With GST Course  In Chandigarh & Mohali 
  •  Affordable Tally with Advance Excel Training  In Chandigarh & Mohali 
  •  Tally Certification In Chandigarh & Mohali ,


GB Training & Placement Centre

TALLYPRIME  - GST  -TALLY ERP TRAINING INSTITUTE  CHANDIGARH & MOHALI 





 



Chapter 1. Fundamentals of Accounting

•   Introduction

•   Accounting Terms

•   Accounting Assumptions, Concepts and Principles

•   Assumptions

•   Concepts

•   Principles

•   Double Entry System of Accounting

•   Types of Accounts

•   The Golden Rules of Accounting

•   Source Documents for Accounting

•   Recording of Business Transactions

•   The Accounting Equation

•   Recording of Transactions in Books of Original Entry/Journal

•   Use of Debit and Credit

•   Rules of Debit and Credit

•   Recording of Business Transactions in Journal

•   Ledger

•   Need for Ledger

•   Differences between a Journal and a Ledger

•   Classification of Ledger Accounts

•   Posting from Journal

•   Trial Balance

•   Methods of Preparation

•   Subsidiary Books & Control Accounts

•   Cash Book

•   Single Column Cash Book

•   Double Column Cash Book

•   Three Column Cash Book

•   Petty Cash Book

•   Purchase (Journal) Book

•   Purchases Return (Journal) Book

•   Sales (Journal) Book

•   Sales Return (Journal) Book

•   Journal Proper

•   Control Accounts

•   Financial Statements

•   Trading and Profit & Loss Account

•   Trading Account

•   Profit & Loss Account

•   Balance Sheet

•   Types of Assets and Liabilities included in a Balance Sheet

•   Key Takeaways Chapter 2. Maintaining Chart of Accounts in 

 




Chapter 2. Tally Prime

•   Introduction

•   Getting Started with Tally Prime

•   Mouse/Keyboard Conventions

•   Company Creation

•   Shut a Company

•   Select a Company

•   Alter Company Details

•   Company Features and Configurations

•   F11: Company Features

•   F12: Configuration

•   Chart of Accounts

•   Ledger Group                             

•      Ledger Creation

•      Single Ledger Creation

•   Multi Ledger Creation

•   Altering and Displaying Ledgers

•   Group Creation

•   Single Group Creation

•   Multiple Group Creation

•   Displaying Groups and Ledgers

•   Displaying Groups

•   Display of Ledgers

•   Deletion of Groups and Ledgers

•   Key Takeaways

 


Chapter 3. Maintaining Stock Keeping Units(SKU)

•   Introduction

•   Inventory Masters in Tally Prime

•   Creating Inventory Masters

•   Creation of Stock Group

•   Creation of Units of Measure

•   Creation of Stock Item

•   Creation of Godown

•   Defining of Stock Opening Balance in Tally Prime

•   Stock Category

•   Reports

•   Key Takeaways

 

Chapter 4. Recording Day-to-Day Transactions in Tally Prime

 

•   Introduction

•   Business Transactions

•   Source Document for Voucher

•   Recording Transactions in Tally Prime

•   Accounting Vouchers

•   Receipt Voucher (F6)

•   Contra Voucher (F4)

•   Payment Voucher (F5)

•   Purchase Voucher (F9)

•   Sales Voucher (F8)

•   Debit Note Voucher

•   Credit Note (Ctrl+F8)

•   Journal Voucher (F7)

•   Key Takeaways 

 







Chapter 5. Accounts Receivable and Payable

Management  

Chapter 6. MIS Reports

•   Introduction

•   Trial Balance

•   Balance Sheet

•   Profit and Loss Account

•   Cash Flow Statement

•   Ratio Analysis

•   Books and Reports

•   Day Book

•   Receipts and Payments

•   Purchase Register

•   Sales Register

•   Bills Receivable and Bills Payable 

•   Key Takeaways 

 

Chapter 7. Goods and Services Tax (GST) in Tally

 

•   Introduction

•   Goods and Services tax (GST)

•   Key Takeaways 

 

GST Modules on Real-time Based Software


 

1                 Registration in GST

  • Registration is the first task every taxable person should when they are starting the business or starting a new office in another state. They can complete Part A and Part B for GST REG-01 after filling necessary information and uploading relevant documents. 

2                 Payment of Taxes

  • You can make a GST payment either online or offline. Businesses must assess the tax that needs to be paid in cash after the offset of the input tax credit availed. Thereafter, it must generate a GST challan either before or after logging into the GST portal or while filing the GST return.

 

3                 E-way Bill

  • A waybill is a document issued by a carrier giving details and instructions relating to the shipment of a consignment of goods. Typically it will show the names of the consignor and consignee, the point of origin of the consignment, its destination, and route. E-way Bill is required for movement of goods worth more than Rs. 50,000/- or as per rules. 

4                 GSTR-3B

  • GSTR-3B is a self-declared summary GST return filed every month (quarterly for QRMP scheme). A separate GSTR-3B must be filed for every GSTIN. The GST liability must be paid on or before the date of filing GSTR-3B, earlier of its due date.

5                 GSTR-1

  • GSTR-1 is a sales return that is required to be filed by every GST registered person. Tax payers are to enter details relevant to their sales & outward supplies in the GSTR 1 sales return.

 

Chapter 8. Recording Vouchers with TDS (Tax  

Deducted at Source)

 

•   Introduction

•   Basic Concepts of TDS

•   TDS in Tally

•   Activation of TDS Feature in Tally Prime

•   TDS Statutory Masters

•   Configuring TDS at Group Level

•   Configuring TDS at Ledger Level

•   Booking of Expenses in Purchase Voucher

•   TDS Report

 Basic To Advance Level Excel Course



 

Module 1: Introduction to Excel

1. Introduction to Excel:

   - Overview of Excel interface

   - Navigating worksheets and workbooks

   - Basic data entry and editing

 

 Module 2: Basic Functions and Formulas

1. Basic Formulas:

   - SUM, AVERAGE, MAX, MIN

   - Simple arithmetic operators

2. Cell Referencing:

   - Relative, absolute, and mixed referencing

3. AutoFill and Flash Fill:

   - Using AutoFill for quick data entry

   - Utilizing Flash Fill for automatic data

     formatting

 

 Module 3: Formatting and Styling

1. Cell Formatting:

   - Font styles, sizes, and colors

   - Cell borders and shading

2. Number Formatting:

   - Formatting numbers, dates, and times

   - Custom number formats

3. Conditional Formatting:

   - Applying conditional formatting rules

   - Data bars, color scales, icon sets

 

 Module 4: Data Management

1. Sorting and Filtering:

   - Sorting data alphabetically and numerically

   - Using filters to display specific data

 

2. Data Validation:

   - Setting up drop-down lists

   - Custom validation rules

3. Removing Duplicates:

   - Identifying and removing duplicate records

4. Grouping and Subtotaling:

   - Grouping data in rows and columns

   - Adding subtotals to grouped data

 

 Module 5: Introduction to PivotTables

1. Creating PivotTables:

   - Understanding PivotTable structure

   - Creating PivotTables from data ranges

2. PivotTable Analysis:

   - Summarizing data with PivotTables

   - Filtering and sorting PivotTable data

 

3. PivotTable Calculations:

   - Adding calculated fields and items

   - Grouping data in PivotTables

 

 Module 6: Advanced Formulas and Functions

1. Logical Functions:

   - IF, AND, OR, NOT

   - Nested IF functions

2. Lookup and Reference Functions:

   - VLOOKUP, HLOOKUP

   - INDEX, MATCH

3. Statistical Functions:

   - AVERAGEIFS, SUMIFS, COUNTIFS

   - Statistical functions (e.g., AVERAGE,

      MEDIAN, MODE, STDEV)

 

 

4. Text Functions:

   - CONCATENATE, TEXTJOIN

   - LEFT, RIGHT, MID

 

 Module 7: Data Analysis Techniques

1. What-If Analysis:

   - Goal Seek

   - Scenario Manager

   - Data Tables

2. Regression Analysis:

   - Using Excel's regression tools

   - Interpreting regression output

3. Solver Tool:

   - Setting up and solving optimization

     problems

   - Constraints and options

 

 Module 8: Data Visualization

1. Charts and Graphs:

   - Creating different types of charts (e.g.,

     column, line, pie, scatter)

   - Customizing charts (e.g., titles, legends,

      axes)

2. Sparklines:

   - Creating and customizing sparklines

   - Using sparklines for data trends

 

 Module 9: Collaboration and Productivity Tools

1. Excel Tables:

   - Creating and formatting Excel tables

   - Using structured references 

 

2. Sharing and Protecting Workbooks:

   - Sharing workbooks

   - Protecting worksheets and workbooks

3. Reviewing and Tracking Changes:

   - Track changes

   - Comments and notes

   - Protecting sheets and workbooks

 

 Module 10: Advanced Excel Tips and Tricks

1. Keyboard Shortcuts:

   - Essential keyboard shortcuts for efficiency

2. Named Ranges:

   - Creating and using named ranges

   - Dynamic named ranges 

3. Data Import and Export:

   - Importing data from external sources (e.g., text files, databases)

   - Exporting data to different file formats (e.g., CSV, PDF)

4. Advanced Paste Special Options:

   - Transpose, Paste Values, Paste Link

 

 Module 11: Macros  

1. Introduction to Macros:

   - Recording and running macros

   - Editing macro code

 

Join Our  Free Demo Class

Services Available – Classroom Training &  Online

WhatsApp at – 9988113578 |7888919083

Enroll now and unlock your potential with GB Training . 

Need Help?

www.gberp.com

Click Here To Book Your Free Demo Class      

Click-->  See Content








No comments:
Subscribe to: Posts (Atom)

SAP Training in Chandigarh I Tally ,QuickBooks & Xero Course Chandigarh I HR Courses in Chandigarh I

Tally Course In Chandigarh & Mohali -(9988113578) | (TallyPrime -Tally ERP Training in Chandigarh , Learn Tally in Chandigarh ,Tally Certification in Chandigarh)

  Tally   In Chandigarh & Mohali    Tally  With GST Course   In Chandigarh & Mohali   Affordable Tally with Advance Excel Training  ...