Excel

PivotTables aren't just for show. Simon Hurst shows how some subtle enhancements in Excel 2007 can help you managed aged debtors better.

In response to an Any Answers question on AccountingWEB, Simon Hurst offers some advice on what to do when your Windows PC expires.

15

The case for considering the Apple Mac as an option for accounting applications will improve considerably in the Autumn when Microsoft brings out Office for Mac 2011.

I'm preparing a spreadsheet linking a vertical list of weekly sales (& purchases) to a horizontal weekly cashflow.

14

Currently doing monthly forecasts. Cost of sales in based on a percentage of turnover. Cost of sales consists of opening stock, purchases, carriage, packaging less closing stock.

2

How do I get a cell to turn a certain colour if a value in different column on same row is above a certain value?

6

Trying to use better formulae in my forecasts again, please help/contribute if you can.

7

Ello.

 

7

came across this product on the web......

"" microsoft office2007  standard upgrade, retail boxed plus free upgrade to 2010 ""

12

Pages