Excel and Working-Paper Skills for CA Articleship at PGT

Illustrative editorial image generated with AI; it does not depict PGT's actual office or staff.
Excel skills for CA articleship begin with reliable data, traceable calculations and clear explanations. A spreadsheet is useful when another person can understand what you checked, identify an unresolved difference and reproduce your result. Speed matters, but accuracy and reviewability come first.
If you are exploring CA articleship at PGT & Associates in Ahmedabad, use this guide to prepare a small, fictional work sample and identify the skills you want to develop. Candidates can send their CV to pgtulsian@gmail.com. The exercises below are preparation suggestions, not a statement of PGT's selection tests or assigned work.
Start with a clean and understandable workbook
Before learning advanced formulas, practise organising a file. Keep original data separate from calculations and explain the purpose of each sheet. Someone reviewing the workbook should not have to guess which figures were imported and which were adjusted.
Use descriptive sheets such as Source Data, Reconciliation, Exceptions and Review Notes.
Record the source file, period covered, date received and preparer's name.
Keep dates, amounts and reference numbers in consistent formats.
Label assumptions and manual adjustments instead of hiding them inside formulas.
Save versions clearly and follow the firm's approved storage and access process.
A beautifully formatted workbook can still be wrong. Check whether the source covers the full period and whether opening balances, reversals or missing rows affect the comparison.
Practise a reconciliation with fictional data
Create two short lists: a fictional receipts ledger and a fictional bank extract. Include a reference number, date and amount for each entry. Deliberately add one unmatched item, one duplicate reference and one amount difference. No actual client information is needed.
First total each list independently. Next match references, compare amounts and classify the exceptions. Record a proposed explanation only when evidence supports it; otherwise mark the item as requiring clarification. A difference should remain visible until someone has resolved it.
For example, assume the ledger totals ₹30,000 and the bank extract totals ₹28,000. The ₹2,000 difference is a starting point for investigation. It does not, by itself, prove an error, omitted income or misconduct. Timing, missing records and incorrect matching are possibilities to examine.
Learn formulas that answer a clear question
Begin with totals, conditional totals and straightforward comparisons. Microsoft's SUMIFS documentation explains how to add amounts that satisfy multiple conditions. Keep the sum range and criteria ranges aligned.
In a fictional sheet with amounts in C2:C20, customer names in B2:B20 and status in D2:D20, the formula =SUMIFS(C2:C20,B2:B20,"Customer A",D2:D20,"Received") totals amounts for Customer A marked Received. Check the answer manually on a small sample before relying on the formula.
A useful practice routine is to change one input, predict how the output should change and then inspect the result. Also check blank cells, numbers stored as text and repeated references. Do not delete a row merely because a duplicate flag appears; first understand whether it is a valid repeated transaction.
Turn the spreadsheet into a working paper
A working paper should explain the work performed, not just display a number. Use a short note alongside your reconciliation:
Objective: the question the exercise was designed to answer.
Records examined: the source and period, with usable references.
Procedure: how items were compared and what was checked.
Exceptions: unresolved differences and supporting explanations.
Review status: questions for the supervisor and changes made after feedback.
This is an introductory learning format, not a complete audit-documentation standard or a substitute for the firm's methodology. On an actual engagement, follow the approved procedures and the supervisor's instructions.
Why consider PGT & Associates in Ahmedabad?
PGT's firm profile describes work across audit, accounting, taxation and management consultancy. That breadth is a useful starting point for discussing how financial records support different professional assignments.
When enquiring, ask which assignments are currently available to trainees, how working papers are reviewed and what software the relevant team uses. The strongest reason to choose a firm is a good match between your learning needs and the training actually offered. Exposure, supervision arrangements and openings should be confirmed directly.
Show your work without sharing confidential information
A short fictional exercise can demonstrate your method more clearly than a long list of software names. Include the objective, the formula checks and a brief note explaining what remains unresolved.
Never attach former employers' working papers, client ledgers, tax identifiers, passwords or private correspondence to an application. A fictional example is enough to start a professional discussion.
Frequently asked questions
Do I need advanced Excel before applying?
You can prepare by building a strong foundation: clear data layout, basic formulas, reconciliations and careful checking. Ask PGT about the skills expected for the specific role; this guide does not set a minimum hiring requirement.
Can a CMA candidate use these exercises?
Yes, the spreadsheet exercises can support practical learning for either qualification. Whether a particular role counts toward CMA practical training must be checked separately against current ICMAI requirements and the proposed arrangement.
How can I enquire about articleship at PGT?
Email pgtulsian@gmail.com with your CV, CA or CMA status, current location and proposed joining date. Mention your interest in Excel, accounting or audit work. Ask the team to confirm current opportunities and training terms.


Comments