Question about Microsoft Excel for PC
When you say prepare . .
What data is going in - and what needs to come out ?
At the moment - it looks like you just need standard coloumn control...
From the standard input columns do you need to break the data down into specifics (Ie time frames etc...which will incorporate cumulatives..)
I would personally suggest using MS Access - you will have greater control and GUI to minimize accidental deletion etc..
Posted on Aug 18, 2008
Tips for a great answer:
Oct 26, 2016 | The Computers & Internet
on May 25, 2008 | Nikon COOLPIX S200 Digital Camera
Aug 22, 2013 | Vehicle Parts & Accessories
Jul 22, 2009 | Microsoft Excel 2007 Home and Student...
Apr 06, 2009 | Microsoft Office Professional 2007 Full...
Jun 23, 2008 | Microsoft Excel for PC
May 14, 2008 | 2004 Chevrolet TrailBlazer
Prepare table having coloumns Client, Premium Amount , Month.
Now take Pivot table of the above table. Take Field 'Month' in Page field and Client in 'Row' field and sum of amount in 'Data field'.
If you refresh the data and select the required month you will get the desired information.
Sep 11, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
104 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: