Tally - Prime Chandigarh - Learn Tally , GST
& Advance Excel Course in Chandigarh
%20in%20Chandigarh%20-Mohali.png)
Chapter 1: Fundamentals of Accounting
Introduction
o Meaning of Accounting
Terminologies used in Accounting
Concepts of Accounting
Double Entry System of Accounting
o Uses of Debit and Credit
o Rules of Debit and Credit
Golden Rules of Accounting
Recording of Business Transactions
o Journalizing Transactions
Trial Balance
Financial Statements.
o Trading Account
o Profit & Loss Account
o Balance Sheet
Subsidiary Books & Control Accounts
o Cash Book
o Petty Cash Book
o Purchase (Journal) Book
o Purchases Return (Journal) Book
o Sales (Journal) Book
o Sales Return (Journal) Book
o Journal Proper
o Control Accounts
Depreciation
o Methods for Depreciation
o Preparation of Depreciation schedule
Computerized Accounting
o Advantages of Computerized Accounting
o Accounting Structure for Computerized Accounting
Chapter 2: Introduction to TallyPrime
o Introduction
o Features of TallyPrime
o Downloading and Installation of TallyPrime
o Types of Licenses in TallyPrime
o Activate New License
o Reactivate License in TallyPrime
o Use License from Network in a Multiuser Environment
o Working TallyPrime in Educational Mode
o Company Creation and Setting up Company Features in
TallyPrime
o Getting Started with TallyPrime
o Navigating from Anywhere to Anywhere in TallyPrime
o F12 Configuration in TallyPrime
o Alter Company Details
o Shut the Company
Chapter 3: Maintaining Chart of Accounts
Introduction
Chart of Accounts
Creation of Masters in TallyPrime
o Accounting Masters
o Inventory Masters
Alteration of Masters in TallyPrime
Deletion of Masters in TallyPrime
Multi-Masters Creation and Display of Chart of Accounts
o Multi Groups Creation
o Multi Ledgers Creation
o Multi Stock Groups Creation
o Multi Stock Items Creation
Chapter 4: Recording and Maintaining Accounting
Transactions
Recording Transactions in Tally
Recording Accounting Vouchers in TallyPrime
o Receipt Voucher (F6
o Contra Voucher (F4)
o Payment Voucher (F5
o Purchase Voucher (F9
o Sales Voucher (F8
o Debit Note Voucher (Alt+F5
o Credit Note Voucher (Alt+F6)
o Journal Voucher (F7
Chapter 5: Banking
Banking
Cheque Printing
o Single Cheque Printing
o Multi Cheque Printing
Deposit Slip
o Cheque Deposit
o Cash Deposit
Payment Advice
Bank
o Manual Bank
o Auto Bank
Chapter 6: Generating Financial Statements and MIS Reports
Introduction
Final Accounts Reports in Tally
o Trial Balance
o Profit and Loss Account
o Balance Sheet
o Cash Flow & Fund Flow Analysis Report
o Receipts and Payments
MIS Reports in Tally
o Stock Summary Analysis
o DayBook
o Cash and Bank Book
o Purchase Register
o Sales Register
o Journal Register.
Chapter 7: Data Security
o Introduction
o Security Control
o Activation of Security Control
o Creation of Security Levels (User Roles)
o Creation of Users And Passwords for Company
Chapter 8: Company Data Management
Introduction
Backup of Company Data
Restoring of Company Data
Company Data Repair
Chapter 9: Goods and Services Tax (GST
Introduction to GST
o Why GST? 317
o GST Tax Structure
o Determination of Tax
o GST Registration
o Managing HSN CODE/SAC
o GST Rate Structure
o Supply of Goods and Services
o Invoicing
o Input Tax Credit
o E-Way Bill
GST in TallyPrime
o Creation of Company and Activating GST at Company Level
o Introducing Capital into the Business
o Creation of Masters in TallyPrime
Recording GST compliant transactions
o Accounting Intrastate Supply of Goods
o Accounting Interstate Supply of Goods
Input Tax Credit Set Off against Liability
GST Tax Payment
o Timeline for payment of GST
o Modes of Payment
o Challan Reconciliation
Generating GST Returns for Regular Dealer in Tally
o GSTR-1
o GSTR-3B
o GSTR-9 – GST Annual Computation
Inventory Management in TallyPrime
Chapter 10: Storage
and Classification of Inventory
Introduction
Supply Chain
o Types of Suppliers
Inventory Management
o Terms Used in Inventory Management
Inventory Masters in TallyPrime
o Company Creation in TallyPrime
o Introduction of Capital into a Business
o Creation of Inventory Masters in TallyPrime
Tracking of Movements of Goods in Batches/Lots
o Activation of Batches/Lots for Stock Items
o Batch Reports
Price Levels and Price Lists
o Activating Price Lists and Defining of Price Levels
o Creation of Price List
o Price Level &Price List usage in Sales Voucher
o Revise Price List
Chapter 11: Accounts Receivable and Payable Management
Introduction
Accounts Payable and Receivable
Maintain Bill-wise Entry
Activation of Bill-wise Entry
o Usage of Bill-wise entry in Purchase and Payment Voucher
o Usage of Bill-wise entry in Sales and Receipt Voucher
o Usage of Bill-wise entry in Payment and Receipt Voucher
o Usage of Bill-wise entry - On Account
Specifying of Credit Limit for Parties
o Specifying Credit Limit for Individual Ledger
o Specifying Credit Limit for Multiple Ledger
o Sales Voucher Restriction Based on Credit Limit
Splitting of Credit Sale Into Multiple Bills
Payment Performance of Debtors
Bills Payable and Receivable Reports in TallyPrime
o Bills Receivable
o Ageing Analysis of Outstanding
o Generating Reminder Letter in TallyPrime
o Generating Confirmation of Accounts in TallyPrime
o Bills Settlement
o Bills Payables
Chapter 12: Purchase and Sales Order Management
Introduction
Purchase Order Processing
o Recording of Purchase Order
o Recording of Receipt Note Voucher
o Recording Rejections Out Voucher
o Recording Purchase Voucher
o Recording Debit Note Voucher
o Recording Payment Voucher
Sales Order Processing
o Recording of Sales Order In TallyPrime
o Recording Delivery Note Voucher
o Recording Rejections In Voucher
o Recording of Sales Voucher
o Recording Receipt Voucher
Order Outstandings
o Sales Order Outstanding
o Purchase Order Outstanding
o Pre-Closure of Orders
Reorder Level
o Display Reorder Status
Godown Transfer in TallyPrime
Chapter 13: Tracking Additional Costs of Purchase
Introduction
Configuration of Additional Cost of Purchases in TallyPrime
o Purchase Transaction with Additional Cost Details in
Voucher
Mode
o Purchase Transaction with Additional Cost Details in Item
Invoice Mode
o Debit Note Voucher with Additional Cost
Chapter 14: Cost/Profit Centres Management
Introduction
Cost Centre and Cost Categories
o Activation of Cost Centre
o Allocation of Expenses and Incomes using Cost Centre
o Cost Centre Classes (Automatic Allocation)
o Allocation of Expenses to Multiple Cost Centres and Cost Categories
Cost Centre Reports
o Category Summary
o Cost Centre Break-up
o Ledger Break-up
o Group Break-up
Chapter 15: Budgets and Scenarios
Introduction
Creation of Budget
Recording Transactions
Display Budgets and Variances Reports for Group Budget
Scenario Management
o Creation of Scenario
o Temporary Inclusion of Reversing Journal Voucher In the
Reports.
Chapter 16:Generating & Printing Reports
Introduction
On the Fly Reporting
o Bird’s eye View/Drill Down Display
o Drill Down Display
o Date/Period Based Reporting & Comparing
Inventory Reports
Stock Summary
Godown-wise Stock Availability
o Movement Analysis
o Stock Query
Financial Reports
o Balance Sheet
o Profit & Loss A/c
Books & Registers
Printing of Invoice and Report
Week 1-2: Excel Basics and Intermediate Skills
Day 1-2: Introduction to Excel
- Navigating the Excel Interface
- Understanding Workbooks, Worksheets, and Cells
- Basic Excel Terminology
Day 3-4: Basic Data Entry and Formatting
- Entering and Editing Data
- Formatting Cells (Font, Color, Borders)
- Number Formatting and Conditional Formatting
Day 5-6: Basic Formulas and Functions
- Introduction to Formulas (SUM, AVERAGE, MIN, MAX)
- Basic Functions (COUNT, COUNTA, IF)
- Understanding Relative vs. Absolute References
Day 7: Practical Exercises and Case Studies
- Applying Basic Formulas and Formatting
Week 3-4: Intermediate Excel Skills for Reporting
Day 8-9: Advanced Formulas
- Nested IF Statements
- Logical Functions (AND, OR, NOT)
- Text Functions (LEFT, RIGHT, MID, CONCATENATE)
Day 10-11: Lookup and Reference FunctionHLOOKUP
- INDEX and MATCH
Day 12-13: Data Management Techniques
- Data Validation (Drop-down Lists, Input Messages)
- Data Cleaning Techniques (Removing Duplicates, Text-to-Columns)
- Using Named Ranges for Better Data Management
Day 14: Practical Exercises and Case Studies
- Applying Advanced Formulas and Data Management Techniques
Week 5-6: Data Analysis and Reporting
Day 15-16: Introduction to PivotTables
- Creating and Customizing PivotTables
- Using Filters and Slicers
- Grouping Data in PivotTables
Day 17-18: PivotCharts and Advanced PivotTable Features
- Creating PivotCharts for Dynamic Data Visualization
- Calculated Fields and Items
- Advanced Sorting and Filtering in PivotTables
Day 19-20: Data Analysis Tools
- Using What-If Analysis (Data Tables, Scenario Manager)
- Utilizing Goal Seek for Target Setting
- Introduction to Solver for Simple Optimization Problems
Day 21: Practical Exercises and Case Studies
- Building PivotTables and Charts for Reporting and Analysis
Week 7-8: Advanced Reporting Techniques
Day 22-23: Creating and Customizing Reports
- Designing Effective Report Layouts
- Using Templates for Consistent Reporting
- Customizing Print Settings and Page Layouts
Day 24-25: Advanced Data Visualization
- Creating and Customizing Charts (Column, Line, Pie, Bar)
- Using Sparklines and Data Bars for Data Insights
- Best Practices for Data Visualization
Day 26-27: Dashboards and Interactive Reports
- Building Interactive Dashboards with Slicers and Timelines
- Designing Dashboards for Data Summary and Decision-Making
- Using Conditional Formatting for Visual Impact
Day 28: Practical Exercises and Case Studies
- Developing and Customizing Reports and Dashboards
Week 9-10: Data Integration and Automation
Day 29-30: Data Import and Integration
- Importing Data from External Sources (CSV, Text Files)
- Connecting to Databases and Using Excel Queries
- Combining Data from Multiple Worksheets and Workbooks
Day 31-32: Data Validation and Error Checking
- Implementing Data Validation Rules to Maintain Data Integrity
- Using Error Checking Tools to Identify and Fix Issues
- Auditing Formulas and Tracking Changes
Day 33-34: Practical Exercises and Case Studies
- Integrating Data, Automating Tasks, and Ensuring Data Accuracy
Day 36-37: Project
%20in%20Chandigarh%20-Mohali.png)
No comments:
Post a Comment