Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
TallyPrime + Micosoft Excel Training
Rating: 4.2 out of 5(15 ratings)
87 students

TallyPrime + Micosoft Excel Training

A Complete TallyPrime with GST along with Basic to Advance level of Microsoft Excel
Created byHimanshu Dhar
Last updated 8/2022
English

What you'll learn

  • How to Create Company in TallyPrime
  • Accounting basics like debits and credits that will help you understand and post entries with confidence
  • Learn to transfer account information (Bookkeeping) from physical to TallyPrime Software
  • Learn to create ledger and alter ledger as well
  • Voucher Entry – Learn to do voucher entry and checking Balance sheet and Profit and Loss Account on that basis
  • Stock & Inventory Management in TallyPrime - Set up details of Inventory and reports like availability of certain stock in particular warehouse and its cost.
  • Learn how sales Bill is generated in TallyPrime in POS (Point of Sales)
  • Bill of Materials (BOM) - Learn in how many ways Bill of material can be generated
  • Learn the procedure of TDS and TCS in general and implementing it in Tally.
  • GST in TallyPrime - Learn GST topics like GST Taxation, Reverse Charge Mechanism, GST on Services, GST on Fixed Assets Mutiple GST rates etc
  • Payroll in TallyPrime - Learn complete Corporate Payroll set up that complies with Govt. prescribed deduction rates
  • Cost Center and Cost Categories
  • Budget in Tally
  • Bank Reconciliation
  • Good understanding of Excel at MIS level
  • Expertise in Text Function
  • Expertise in Logical Function
  • Expertise in Math Function
  • Expertise in Lookup and Reference Function
  • Expertise in Date and Time Function
  • Mastery in Pivot Table and Chart Preparation
  • Mastery in 'What if Analysis' tools
  • Print Option in Excel
  • Data Validation, Filter and Conditional Formatting
  • Mastery in Data organizing Tools in Excel
  • Mastery in Data creation and Data Manipulation in Excel
  • Managing data protection and data sharing in Excel
  • Work with Macro Recording

Course content

2 sections • 105 lectures • 11h 34m total length

  • How to Install TallyPrime2:54

    Learn how to download and install tally prime, and start the software. Explore the educational license options, including a date-limited setup, and note the small difference from ERP nine.

  • Create Company in TallyPrime5:29

    Learn to create, open, shut, and delete companies in tallyprime using the f3 and all company menus, entering details like name, address, state for gst, and begin date, then save.

  • Create Ledger in TallyPrime13:47

    Create ledgers in TallyPrime, set opening balances for capital, cash, P&L, machine, rent paid, bank accounts, and loans taken or given, then view a balance sheet.

  • Voucher Entry Understanding6:53

    Apply the three golden rules of accounting to voucher entry, debiting expenses and losses and crediting income and gains, with examples like rent, commission, and bank deposits.

  • Types of Voucher9:39

    This lecture explains voucher types in TallyPrime, including payment, receipt, general, and control vouchers such as cash to cash and cash to bank, with examples.

  • Voucher Entry in TallyPrime16:53

    Learn how to perform voucher entry in TallyPrime through practical examples. Explore payment and received vouchers, ledger creation, and double-entry mode with bank and cash.

  • Inventory Management Understanding3:50

    Identify and define five inventory attributes—stock category, stock group (brand), go down, unit of measurement, and stock item—and apply them to stock like mobile phones for women stock management.

  • Inventory Management in TallyPrime10:42

    Learn to configure inventory in TallyPrime by creating stock category, stock group, units, and go downs, then add a stock item like mobile phone under Nokia and review stock reports.

  • Purchase Procedure in TallyPrime4:10

    Explore the five-step purchase procedure in tallyprime, covering purchase order, received note, rejection (if any), bill, and debit note, and understand how these steps relate before processing payments.

  • Purchase Order in TallyPrime9:45

    Learn to create and activate a purchase order in TallyPrime, set up a party account, create the item and order details, and adjust quantities with close order.

  • Receipt Note in TallyPrime4:57

    Activate the receipt note in TallyPrime, link it to a purchase order, enter reference, date, party, and order number, and record received quantity to update stock and identify bill pending.

  • Rejection Out in TallyPrime2:27

    Activate the rejections out process in TallyPrime after a purchase order and receipt note, selecting the enterprise, item, and the quantity to reject, then save to update stock.

  • Purchase Bill in TallyPrime3:13

    Record a purchase bill in TallyPrime by converting a received note into a supplier invoice, tracking order quantities and rejections, and updating current liabilities.

  • Debit Note (Purchase Return) in TallyPrime4:52

    Learn how to process a debit note (purchase return) in TallyPrime to return defective goods, including selecting the party, order number, and quantity, and reviewing its inventory impact.

  • Sales Order, Delivery Note, Rejection In, Sales & Credit Note in TallyPrime16:36

    Learn to manage sales in tallyprime: create sales orders, issue delivery notes, record rejections with reduction in, and finalize sales bills and returns while updating inventory and finances.

  • Bank Reconciliation in TallyPrime6:29

    Explore bank reconciliation in TallyPrime by creating a bank ledger, recording receipts and payments, and aligning company and bank statements to resolve date differences.

  • Understanding GST (Goods and Services Tax)2:54

    Understand GST, the goods and services tax introduced on July 1, 2017, with five slabs, and learn to apply CGST, SGST, and IGST for intra and inter-state transactions, year-end settlement.

  • GST Practical in TallyPrime17:57

    Learn to enable GST in tallyprime, set state and GST details, process intrastate and interstate purchases and sales, create GST components, and review GST reports and adjustments.

  • Multiple GST Rate In Single Invoice In TallyPrime11:20

    Learn how to apply multiple GST rates to different products in a single invoice in TallyPrime by configuring item GST slabs and auto-calculated totals.

  • GST on Services in TallyPrime8:55

    Explore how to set up GST on services in TallyPrime, create service items, process inter-state sales and purchases, and track integrated tax and duties in ledgers.

  • GST on Fixed Assets and Recording Input Tax Credit in TallyPrime11:22

    Explore GST on fixed assets in TallyPrime, learn to claim input tax credit for capital goods, and record advance tax on capital goods with journal adjustments.

  • Reverse Charge Mechanism (RCM) in TallyPrime11:11

    Learn how to implement the reverse charge mechanism in TallyPrime for purchases from unregistered dealers, including activating GST, recording purchases and tax components, and increasing tax liability.

  • Bill of Materials (BOM) in TallyPrime18:04

    Learn how to create a bill of materials and map raw materials to finished goods in manufacturing using TallyPrime. Follow purchases, gst, and cost calculation to understand the bom workflow.

  • Tax Deducted at Source (TDS) in TallyPrime13:36

    Activate tax deducted at source (tds) in TallyPrime and create ledgers for party and government. Apply tds on interest above 5000 at 10 percent and review Form 26Q.

  • Tax Collected at Source (TCS) in TallyPrime11:16

    Activate the tax collected at source feature in TallyPrime, configure gst and tcs, and set the tax on goods with a 0.75% to 1% rate.

  • Point of Sale (POS) in TallyPrime8:37

    Learn to set up a point of sale in TallyPrime, create a POS voucher, configure GST features, and process payments through gift vouchers, cards, and cash.

  • Cost Centre and Cost Category in TallyPrime6:20

    Activate the cost center feature, create a salary cost category and cost centers for employees, and record salary payments to generate category and center reports like the statement of account.

  • Budget in TallyPrime6:29

    Create and manage a budget in TallyPrime by setting indirect expenses ledgers. Allocate a three-month office budget, record voucher entries, and review budget variance.

  • Payroll in TallyPrime (Managing Attendance, Pay-heads, Overtime, Payslip etc )17:10

    Activate payroll in TallyPrime, set up attendance, pay heads such as basic salary, travel expense, and overtime, configure provident fund, create employee groups, and generate payslips and payroll reports.

Requirements

  • Basic Computer Knowledge

Description

TallyPrime is simple and designed to be used by people from non-IT and non-accounts background as well. Ease of discovering information, consistent options, navigating without the need to remembering the paths and much more makes you start using TallyPrime right away. The course content is going to teach students in detail on how to manage accounting, Inventory, orders and payroll in Tally.

If you are going to learn TallyPrime you must get well acquainted with MS Excel.
Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications. The course curriculum is one of the most comprehensive and most advanced. In this 7 hours of training with 74 lectures videos, you will be taken through the fundamentals of Excel till the Expertise level.

Who this course is for:

  • Anyone wants to learn TallyPrime along With Advance Excel

Report abuse