"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.
The time wasted working on bad spreadsheets is a bigger practical problem than errors within
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.
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.
Following the success of his popular Five Minute Pivot Table Tips, Ac
"Access is the new Excel," declared Simon Murphy at the European Spreadsheet Risks Interest Group (EuSpRIG) conference in London this week.
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
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.
- New Range Name features in Excel 2007. By Simon Hurst 414,289 6
- Want to learn about Excel pivot tables? Start here. By David Carter 108,469 6
- ExcelZone's Five Minute Pivot Table Tips - Index 83,743
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 69,033 2
- Exporting data from Sage Line 50 into Excel #1. By David Carter 61,852 10