Scenario 1 In a Stock Broking business (Firm), Customers deposit margin money through cheques. Although cheques are received from customers at branches, clearing (realization) of the same normally takes 3-4 days. On one hand, the Firm wishes to allow trading to the customers against the deposited cheques from the day it receives the cheque, on other hand there is […]
Read More →
{ 8 Comments }
Line of Business (LoB) wise CAGR (%) is shown in range A3:B8. A benchmark growth rate is shown in cell B11. The task to show a column chart of the data presented in range A3:B8. LoB’s with a CAGR (%) greater than the benchmark rate should appear in Green colour and those with a CAGR (%) […]
Read More →
Conditionally formatting duplicate values across all versions of MS Excel is quite simple. However, to colour different duplicate values in different colours, refer to this workbook.
Read More →
{ 0 Comments }
If a certain cell entry is found in column C of the other eleven sheets, then colour the entry in red. Furthermore, a summary sheet should show all red coloured entries. You may refer to my solution in this workbook.
Read More →
Analyse all possible combinations of cheques received and identify the combination which gives maximum benefit to the Customer
{ 11 Comments }