XLPlanning plugs the gap left by Microsoft
John Stokdyk looks at a new spreadsheet-like planning and budgeting tool called XLPlanning.
Use Excel's MOD() function to allocate quarterly payments
Simon Hurst describes a useful function for building cashflow projections in Excel.During a recent IT Faculty Excel roadshow event one of the delegate...
Use Excel SUM functions to calculate weighted averages
It's not the most complex spreadsheet challenge, but working out weighted averages is a perennial favourite on Any Answers. Simon Hurst explains how t...
Coming soon to a PC near you - Microsoft Office 2010
Throbbing music, golden geometric shapes and a portentious narrator announced this week, “There are 5bn working people in the world. In 2010, their ...
ASAP Utilities releases new edition
ASAP Utilities, one of the undisputed stars of the Excel demi-monde, recently introduced a new version of its add-on collection.The developers explain...
Fun with functions: Dealing with errors and the new Excel 2007 IFERROR() function
Simon Hurst explains how to use the new Excel 2007 function to streamline error-checking in your spreadsheets.Sometimes a formula in a worksheet will ...
Excel User Conference: Tips for more advanced users
The second day of the 2009 Excel User Conference was intended for hardcore users and tackled topics such as spreadsheet optimisation, functions and VB...
Office 2007 Service Pack 2 tackes native OpenDocument and PDF files - update
As previously reported on ExcelZone, Microsoft began distributing the Service Pack 2 update for Office 2007 on 28 April. John Stokdyk reports."The ser...
Charting tips and tricks from Excel MVP Andy Pope
Following his successful series of articles on presenting financial figures with Excel, Simon Hurst picked up a few new ideas at the recent Excel User...
Excel Pivot Tables - Free Training Video
Due to the success of our free video introduction to pivot tables for Excel 2007, we are now making the first video of the Excel 2003 version availabl...
The ExcelZone online video awards
Someone on Twitter recently posed the rhetorical question, "Should I learn that new Excel function, or watch a YouTube video?" His answer was, yes - d...
Excel User Conference: Introductory tips
The first day of the 2009 Excel User conference was designed for ordinary users and eased them in with some relatively straightforward ideas, reports ...
Excel zero-day vulnerability patched
Microsoft's traditional "patch Tuesday" security update for April this week tackled the zero-day vulnerability in Excel that has been targeted by vari...
Presenting financial figures with Excel: Part 3 - Delivery techniques
The story so far...In the first part of the series we looked at some general principles of presenting financial information graphically including the ...
Is this the best use of my time?
When launching the website for our new Spreadsheets by Email service, I started fiddling around designing a logo, knowing I wanted the website live in...
Excel news
Latest discussion groups
This week, join the money laundering and crime discussion group and get talking. To start your own discussion group, email editor@accountingweb.co.uk with your request.
Want to win £500 of digital photography goodies? 
Love it? Hate it? We want to know what you think of the new design and how we can make it even better. Post your views in our new 
Got an opinion you want to share with the rest of the community? Then login and