Excel zone

Top Story

Excel 2007

Excel tips and tutorials

Excel Zone Compendium Based on members' questions and contributions, ExcelZone has put together an unbeatable package of tips, tutorials and guides Read more.

Other Excel News

  Hits
05-Nov Hidden spreadsheet rows hit Barclays with toxic Lehman contracts 1 Comments1 1703
09-Oct Microsoft works on Chart Advisor to avoid graphical nightmares 291
11-Sep Microsoft publishes online training courses for Excel Services and SharePoint 1 Comments1 750
11-Sep J-Walk's ultimate list of Excel RSS feeds 1295
21-Aug Tips for using Microsoft Excel Services with SharePoint Server 2 Comments2 1423
More >

Excel Features

  Hits
03-Dec The far side of Excel: Excel's most useful chart feature goes missing in Excel 2007? 394
02-Dec ExcelZone Compendium: VBA (Excel 2007 update) 45
05-Nov The far side of Excel: Add visuals to your headers and footers 1 Comments1 982
04-Nov David Carter's round-up of Excel-based report writers 3 Comments3 1569
21-Oct ExcelZone Compendium: Macros (Excel 2007 update) 1333
More >

Want to learn more about pivot tables?

Top TipStart here Over the past six years, AccountingWEB has built up a wealth of tutorials on Excel pivot tables. David Carter takes you through what's available, ranging from budgeting and sales analysis with pivot tables to tips on exporting and cleaning accounts data. Also see:

Any Answers

  Hits
04-Dec Change a cell colour conditionally 2 Comments2 168
01-Dec Excel Date format not give correct result 4 Comments4 204
27-Nov Excel functions 2 Comments2 350
26-Nov count number of days 3 Comments3 437
17-Nov Moving linked Excel Files 2 Comments2 352
More >

Tools & Tutorials

o2olap Structured spreadsheet databases with Excel pivoting, modelling, formatting and data capture for budgeting and forecasting. Integration to general ledgers. Available now at the AccountingWEB members price of £150.00 + VAT Find out more.
AddThis Social Bookmark Button