Excel, SAP, Oracle & automation tips — plus wacky facts
Read and use Tally reports: Day Book, ledger, trial balance, profit & loss, balance sheet, receivables/payables outstanding with ageing, ratio analysis and exporting to…
Read article →EngineeringLevel: ExpertAvailable in: Excel 2007+BESSELY returns the Bessel function of the second kind (Weber/Neumann), Yn(x).Syntax=BESSELY(x.
Read article →Reconcile your bank ledger with the statement in TallyPrime: why differences occur, marking bank dates, importing statements, auto-reconciliation and the BRS report.
Read article →Manage stock in TallyPrime: units of measure, stock groups and items, opening stock, godowns, batch and expiry tracking, stock summary and valuation methods.
Read article →Configure GST in TallyPrime at company, ledger and item level, create a GST tax invoice with CGST/SGST or IGST, set HSN codes, and check…
Read article →Record daily transactions in TallyPrime: the voucher types and function keys, sales and purchase in item vs accounting mode, receipts and payments against bills,…
Read article →Understand Tally’s chart of accounts: the 28 predefined groups, creating ledgers under the right group, sundry debtors and creditors with GSTIN, opening balances and…
Read article →Set up a company in TallyPrime correctly: books beginning date, financial year, base currency, security, and the F11 features to switch on for GST,…
Read article →BESSELJ returns the Bessel function of the first kind, Jn(x): vibrating drums, FM radio spectra and wave problems.
Read article →Send the same letter to many people with their own details: connect Word to an Excel list, insert merge fields, format amounts and dates,…
Read article →Send personalised letters, emails or labels from an Excel list with Word Mail Merge — including number and date formatting fixes that trip everyone…
Read article →A complete, reusable monthly MIS workbook: raw data sheets, a mapping table, SUMIFS-driven P&L and KPI pages, variance vs budget and last year, conditional…
Read article →
