Excel

"More and more we are hearing about Microsoft SharePoint," said Prodiance CEO Soheil Saadat at the recent European Spreadsheet Risks Interest Group (EuSpRIG) conference in London.

Looking for a needle in a haystackThe time wasted working on bad spreadsheets is a bigger practical problem than errors within

1

When you use a formula to calculate a new column of numbers, Excel will sometimes display error messages such as #DIV/0! if a number has been divided by zero.

Hidden behind the rather unpromising sounding Format as Table option in the Home tab of the new Excel 2007 ribbon is a whole set of rather useful functionality.

1

Surrey based software house BTC has devised an Excel add-in that automates the transfer of trial balance data from bookkeeping packages into the popular VT Accounts program.

"Access is the new Excel," declared Simon Murphy at the European Spreadsheet Risks Interest Group (EuSpRIG) conference in London this week.

3

Auditors, who often have to carry the can for corporate mishaps, were praised by a Financial Services Authority official this week for the improvements they have brought about in controlling and ma

1

One really disconcerting change to Excel 2007 is the disappearance of the toolbars. Features you use all the time seem to have disappeared back to into the menus.

Excel 2007 featured in the security updates issued by Microsoft on 10 July, the traditional second Tuesday scheduled for the company's monthly bulletins. John Stokdyk reports.

Pages