Business intelligence developer MicroStrategy is challenging the accepted wisdom that PCs and Microsoft Excel are the default tools for analysis and reporting.
The surprise announcement last week that Microsoft Business Division president Stephen Elop was leaving the company to join Nokia was just the sort of bad news that Microsoft doesn’t need at the mo
I have client data exported from Iris into Excel.
I want to send a batch email to all those clients whose year ends we have not yet done.
I have a question I have been googling for weeks now.
I am trying to work out the APR on a loan, I have the principal, the number of months and the monthly instalment amounts. I have tried one web based calculator and one Excel formula using RATE for
Cell-based modelling is a root cause of Excel Hell. James Power offers a few tips on how to avoid some common sources of trouble.
I'm looking for a way to protect certain sheets on a spreadsheet file, whilst still allowing the user to open and close "grouped" rows and columns. Anyone know if this is possible and how?
A resident of the Californian mountains, Daniel Ferry must have a lot of spare time on his hands.
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.
- New Range Name features in Excel 2007. By Simon Hurst 451,960 6
- Want to learn about Excel pivot tables? Start here. By David Carter 113,280 6
- ExcelZone's Five Minute Pivot Table Tips - Index 88,161
- Exporting data from Sage Line 50 into Excel #1. By David Carter 77,897 10
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 71,276 2