data validation - consolidations - use of 3D formula - data table - goal seek - data table - scenario manager to forecast budget - subtotal and sum if formula - flash fill - advance filter - protection of cell , sheet and workbook , macros , print setup - use of text to column, formula auditing , name manager- conditional formatting - transpose - GST billing - payroll working - paste special - object link embedding - fill series - print settings ......and many more
cheque printing setup - GST auto billing using voucher class - price level - TDS working - Service tax billing - Ledger scrutiny and complete finalization - Reports preparation like Trading , Profit and loss accounts and balance sheet , outstanding and A TO Z reports preparation ( due date wise )- Various Stock programming - Manufacturing voucher WIP - Group and ledger Indexing - Tally ODBC - Tally's Data in excel - budget preparation - get exception reports and scenario management - solution if forget security password - Bank and Branches & Stock reconciliation - use of physical stock / memorandum / optional / post dated / reversing journal vouchers - shortcuts techniques...and many more