Tally ERP 9 + MS Excel Baic to Advance Course Pack

Explore a manufacturing company assignment using bill of materials to produce shirts and pants, linking customers and suppliers to control accounts in Tally ERP 9 and Excel.

Create a new manufacturing company in tally, set up inventory, opening balances, financial year, and enable login with security and audit capabilities.

Enter opening trial balances and ledger balances in tally as of January 1, 2019. Create ledgers under groups and post balances for bank, cash in hand, stock, and machinery.

Link customer and vendor opening balances to control accounts, update accounts receivable and payable, and verify changes in the trial balance before entering inventory.

Enter opening balances for raw materials in Tally ERP 9, define units of measure, create stock items, and link to the control account for trial balance verification.

Define the finished goods bill of materials by entering a recipe for one shirt in the recipe management system, listing cloth, thread, zips, and buttons and their quantities to manufacture.

Shows recording accrued expenses paid by cash using cash ledger entries and payments with narration. Guides handling of related journal entries when needed for January 1–14, 2019.

Place a purchase order to a vendor in Tally ERP 9, entering date, order number, items, quantity, due date, and narration, with inventory and accounts affected.

Learn to convert a purchase order to a purchase invoice in Tally ERP 9, by selecting the order, adjusting quantities, and entering reference and narration.

Record direct purchases of multiple items in a single invoice in Tally ERP 9, including creating a new vendor, reference numbers, not against any order, and verify quantities and totals.

Enter a sales order for finished goods without stock, using sealed orders and inventory controls to record delivery dates, quantities, rates, and negative stock warnings.

Record cash taken out for office use in Tally ERP 9 by enabling cash accounts, posting a journal entry with debit and credit, and checking the daybook for January.

Record cash receipts from customers in tally erp 9 by selecting the customer account, entering the amount and date, adding narration, and saving after confirming no linked invoices.

record a customer partial receipts settlement in tally erp 9 by entering cash received, clearing the opening balance as of nine january 2013, with narration.

Learn to process service invoices on credit in Tally ERP 9 by converting the entry to an accounting invoice, creating an alternate party, and recording service charges under direct expense.

Learn how to record a cash purchase of one-time services in Tally, exclude temporary vendors from the vendor list, and enter the cash payment with a clear narration.

Learn to record customer advances in tally erp 9 by creating a new customer entry, applying the advance to a sales order, and issuing a receipt with narration.

Process a customer sales order against finished goods in Tally ERP 9. Enter order 27, quantity, and total amount, note the due date, and observe stock warnings.

Record travelling expenses paid by cheque in Tally ERP 9, select the correct company, post to indirect travel expenses, and process bank payments via MKB Bank with clear narration.

Learn to manage repair and maintenance expenses using tally ERP 9 and MS Excel, integrating practical accounting techniques for accurate cost tracking and reporting.

Learn how to record cash purchases of motor vehicles as fixed assets in Tally ERP 9, handling bank payments (MKB Bank) and asset accounts for proper financial entries.

Enable production and use the manufacturing journal to assemble shirts from raw materials, following the recipe to convert components into finished goods and account for costs to set per-unit price.

Record item-wise finished goods assemblies with specific quantities to complete the manufacturing process and validate all transactions.

Learn how to enter bad debts in a manufacturing company using tally ERP 9, including opening balances, settling on account versus against reference, and recording narration.

Convert a sales order to a sales invoice in Tally ERP 9 by updating the date, switching to an item invoice template, and recording narration and totals.

Enter direct sales in tally by recording a 500-unit sale at 400 each (total 200,000), selecting the correct ledger and item, and noting no reference number.

Learn how to convert a sales order to a sales invoice in Tally ERP 9, including updating dates and references, selecting pending orders, adjusting delivered quantities, and reconciling totals.

Receive cash from customers against pending bills in Tally ERP 9, allocate payments to the opening balance and the reference amounts, verify references, and save the transaction.

Learn how to record partial vendor payments in Tally ERP 9, including opening balances, references, on-account entries, and narration to track balances and settlements.

Learn to record payments for fixed assets and liabilities, including asset sales, cash payments, and clearing liability balances for buildings.

Record a purchase return in tally erp 9 using debit notes and credit notes, enable features, and convert the debit note to an invoice for satara textiles.

Process sales return credit notes for customer shirt returns, recording inventory returns and debit and credit entries, and generating the voucher or invoice reference in Tally ERP 9.

Record the purchase of direct services in cash, creating a new ledger entry for a one-time cash expense. Ensure the entry does not affect inventory and uses suitable narration.

Record director drawings and cash transactions via journal entries in Tally ERP 9 for a manufacturing company, and configure cash accounts for accurate debit and credit narration.

Learn to record abnormal inventory loss in Tally ERP 9, create a loss of inventory account, classify it as indirect expenses, and complete journal entries with narration for inventory allocation.

Learn to transfer January utility bills to accrued expenses with a single journal entry, debiting indirect expenses like electricity, rent, salaries, and telephone bills, and crediting accrued expenses.

Learn to generate the trial balance with debit and credit totals from the main screen, export the report to Excel, and reconcile ledgers with balances.

Learn to generate closing reports and drill into trial balances, ledgers, and vendor and customer balances to identify unusual items, reconcile accounts, and understand a company's prior accounting practices.

Discover how to back up a company, choose a destination drive, manage multiple backups, and prepare for restore with practical steps and common issues.

Learn to restore a backup in Tally ERP 9 by using the restore option, selecting the backup source, and choosing the target company, even if the original company is unavailable.

Learn two methods to delete a company in Tally ERP 9: delete within the software after confirming the serial number, or permanently erase data by deleting the storage folder.

Reconcile supplier accounts with company records by matching statements, validating invoices, and ensuring proper narration for payments to prevent double payments and attach supplier statements.

Learn to manage stock across multiple godowns in tally erp 9 by enabling the multiple godowns feature and creating city-based go-downs, plus generate per go-down and total stock reports.

Enable standard rates to define sales prices for stock items in Tally, moving from multiple stock item creation to single item entries, and set prices from 1 January 2019.

Learn to calculate value added tax in tally erp 9 by balancing input vat and output vat, 2,400 vs 1,600, resulting in 800 payable at 16 percent.

Explore VAT report customization to a columnar format by adjusting settings, enabling columns for quantities, rates, and totals, and exporting the customized report to Excel for further refinement.

Extract the trial balance from reports, spot and question unusual figures, reconcile banks, petty cash, and accounts receivable, and seek third-party confirmations to ensure ledger accuracy.

Learn how to automate recurring entries in accounting software, turning upfront prepaid rent into monthly expenses, and set up memorized journal entries in QuickBooks to streamline monthly closings.

Discover how to manage staff advances in Tally ERP 9 using cost centers and call centers. Create cost categories and ledgers to track advances and deductions against salaries with clear, centralized reports.

learn to set up a payroll system in tally erp 9, including payroll heads, attendance, salary elements like basic and overtime, deductions such as advances and withholding tax, and payslips.

Configure user access rights in Tally by creating security controls, defining data entry and manager levels, and assigning admin logins to restrict accounts, vouchers, and daybook.

Enable multi-currency in Tally ERP 9 in Delhi, create the dollar currency, set exchange rates, and track forex gains or losses.

Configure sealed invoice printing in Tally, adjusting language, title, and preprinted options. Preview print output and save as a printable file on desktop.

Extract statistics reports from Ravi Textiles Company using the display statement of accounts to categorize vouchers, ledgers, and journal types for audit-ready insights.

Set a 300 reorder level in Tally ERP 9 to maintain buffer stock, trigger 500 minimum order quantity, monitor net availability, and use purchase orders to prevent stockouts.

Learn to import data in Tally by exporting master data as XML, creating a new company, and importing opening balances and ledgers to establish the new setup.

Enable the separate discount column for invoices and activate multiple price levels to set quantity-based discounts via a price list, including retail and wholesale pricing, on sales invoices.

Explore how Excel treats a blank worksheet, reads cell addresses, and uses fill series with pattern-based autofill to generate sequences like odd/even numbers, months, and days.

Learn to create and import custom lists in Excel memory to enable automatic name suggestions, and reuse those lists across new workbooks by importing from Excel sheets.

Master excel shortcuts using the golden key: press alt to navigate the ribbon, and use ctrl+shift for selecting, ctrl+c for copy, and quick color, alignment, and borders commands.

Master absolute and relative references in Excel by understanding fixed versus variable values and how formulas start with equals, then drag or fill to auto generate references.

Create a marksheet in Excel by adding a new sheet, listing five subjects for fifty students, and auto-filling numbers; auto-adjust columns and complete a one-minute mock with scores 30–90.

Learn to generate random numbers in Excel with the ran between formula, set bottom and top limits, and quickly fill down results for student data.

Learn how to preserve values from a formula in Excel by copying the range and using paste special values, so cells stop updating when inputs change.

Learn to build a marksheet in Excel: calculate total marks, compute percentages by dividing marks obtained by total marks, and format as percent using auto-fill and decimal place adjustments.

Define student status with if-then criteria in Excel, marking pass or fail by a 50 percent threshold, and propagate results by dragging and double-clicking cells.

Master nested ifs in Excel to automate a grading scheme—assigning A, A-plus, B, B-plus, C based on score ranges—and learn bracket and syntax essentials.

Rank students by percentage using rank function, comparing each score against all classmates to assign positions. Fix the reference range with absolute references and press F4 when dragging the formula.

Learn how to use conditional formatting in Excel to highlight outcomes with red and green colors, apply rules automatically, and add data bars for visual performance indicators.

Use freeze panes in Excel to keep headings and the first column visible as you scroll, by selecting the intersection and using the View tab.

Format data as a table for quick styling, apply a predefined table style, specify headers, and convert to a range when you need to remove table formatting.

Master sort and filter in Excel to manage morning batches, apply format painter for consistent styling, and use between and top 10 filters to select students by percentage.

Compute subject-wise student presence and absence using Excel formulas such as count, count blank, max, min, and average, and apply count if for conditional counting.

Learners build a sales and bonus report in excel, calculate sales amount and profit from units sold at 275, freeze the price, and total January to March.

Group data by month and apply auto totals in Excel to create expandable and collapsible summary reports, using subtotals for February, March, and grand totals for quarterly discussions.

Master hiding and unhiding rows, grouping with expand and collapse, to build expandable summaries. Apply subtotals in the data tab to auto total monthly figures and grand totals.

Remove duplicates and subtotals in the data, then create a sales summary by salesperson using sumif to total units, sales, and profit across the quarter.

Learn how absolute and relative referencing in Excel control which cells change when you copy formulas, using dollar signs to fix columns or rows.

Apply sumif with absolute and relative references to fix the criteria while the range shifts when dragging, enabling automatic totals for units sold and sales amounts.

Learn to use sumif with external sheet references by applying absolute and relative references across bonus and sales reports, and fix ranges with F4 to lock columns.

Master Excel's if functions with multiple logics to determine sales bonuses using units sold and customer reach, applying and/or conditions and fixed references.

Master aged debtors analysis by tracking receivables and the aging of invoices due dates. Use practical data from accounting reports to categorize outstanding balances by aging periods.

Identify and unmerge all merged cells in the sheet, then auto-fit columns and remove unused ones. Use paste special skip blanks to align headings with data before aging analysis.

Automate data arrangement in Excel by recording macros, merging cells, and replaying steps, then attach the macro to a button via the developer tab and form controls.

Format the sheet by applying brown bold 10 to the first column, highlighting the second row, and adding borders. Use the Format Painter with double-click for pasting; note conditional formatting.

Learn to build conditional formatting rules in Excel that highlight payment statuses—cleared in green and unclear in red—using formulas anchored to the table heading.

Learn advanced Excel formatting by creating fake headings, naming ranges, and applying conditional formatting rules to highlight entire rows based on heading text, with color and style adjustments.

Learn to build aging analysis in Excel for accounts receivable, using date extraction, month and year matching, and robust formulas to categorize outstanding balances by month.

Explore fixed and relative references in Excel formulas, drag across months and years with absolute references, and build date-based aging analysis using date value and if logic.

Live aging teaches how to categorize unpaid invoices by days past due (0–30, 31–60, 61–90, 91–120, 121–150 and older) using Excel formulas that auto update with today’s date.

Master vlookup to build a search box in excel, using column lookups, exact and approximate matches, and absolute references to fetch product details: part number, make, location, warranty, and price.

Learn to create and use named ranges for lookup in Excel, apply the iferror function to return blanks on errors, and build robust absolute references for simple, scalable formulas.

Create a named range for the car parts list and apply data validation to restrict entries to that list, enabling a dropdown to quickly select items and prevent typos.

Master creating and configuring Excel combo boxes with ActiveX controls, enabling autocomplete, linking selected values to cells, and integrating with data validation through the developer tab.

Flip and transpose the table to turn headings into rows and use lookups on the flipped data, with data validation for exact matches.

Learn how to perform lookups in Excel to retrieve data by bar numbers and product codes, using lookup value, lookup vector, and result vector.

Learn a drawback-free index match method to find the lowest bid and return the corresponding vendor, enabling flexible lookups in any direction.

Create an automatic invoicing workflow that retrieves medicine details by name, calculates price based on quantity, applies discount tables by bands, and outputs the net total using lookup formulas.

Master vlookup and match to retrieve invoice data, lock columns, name headings, and use exact or approximate matches; calculate discounts and totals with straightforward formulas.

Learn to create a concise sales summary in Excel using sumif and ifs. Practice removing duplicates and totaling sales by product and by sales rep using criteria.

Build a DSUM based search box to sum sales by criteria, using headings to map fields and instantly update results, with guidance on D-Max and average.

Master advanced filters in Excel by building a dynamic search box that extracts region-specific transactions into a sheet, then record macros to refresh results and attach them to a button.

Learn to create and customize pivot tables in Excel to build regional sales reports, arranging regions and salespersons in rows and columns, using the virtual table and classic pivot layouts.

Create a region and month-wise sales report using pivot tables in Excel; group by month and year to reveal total sales and drill down into regional details.

Create pivot tables to track sales, cost of goods sold, and profit per product, using calculated fields to compute gross profit from sales minus cost of goods sold.

Explore pivot charts in Excel to analyze sales across months and two years, choosing line, bar, or pie charts and using stack and 100 percent stacked options.

Create dashboards in Excel using pivot tables and charts to analyze monthly sales, sales reps, and product contributions, and enhance interactivity with timelines and slicers.

Automate payroll cheque printing by linking Excel data to a Word mail merge template, convert amounts to words with a macro, and print many checks efficiently.

Learn how to create hyperlinks in Excel to connect internal cell references and external sources, using named ranges for expenses and linking to files or websites.

Create hyperlinks to external files in Excel to map data, linking to bankbook reconciliation, salaries, and employee loans, and open the data mapping file daily to access these areas.

Split full names into first and last name columns using Excel's text to columns, then concatenate with a space to recreate full names, and convert formulas to values.

Excel flash fill saves the day by quickly combining first and last names into a full name and automatically separating the first name from the last name with autofill suggestions.