Excel lecturer David Ringstrom continues to share his productivity tips with the trans-Atlantic Excel user community.
tutorial
Excel lecturer David Ringstrom has started publishing a series of quick Excel tips on our sister site AccountingWEB.com.
Simon Hurst advises how Excel’s PowerPivot add-in can streamline your dashboard measures.
Reglar readers of Excel Zone will remember “Mr Excel”, Bill Jelen from our 2008 Golden Cells
Simon Hurst completes his management dashboard tutorial series with a look at effective visual presentation techniques.
Simon Hurst continues his KPI reporting casebook by incorporating some of the more advanced features available with Excel 2010, including PowerPivot.
Simon Hurst continues his tutorial series on KPIs by explaining how to present information clearly and with maximum impact.
An article explaining the Named Ranges feature in Excel 2007 remains the single most popular item ever published on AccountingWEB.co.uk.
Microsoft has upped the educational content in its Excel blog. Here are highlights from recent posts, including the answer to a very popular Any Answers query.
Pages
- Tutorial: Create a P&L from transactions with a pivot table 23,087 1
- Build your own Excel Net to Gross function - Tutorial by Simon Hurst 22,331 4
- Consolidations with pivot tables - putting together a budget 18,437
- Using Excel's VLOOKUP function to add fields 16,244 2
- IT BASICS: Data validation for better spreadsheets. By Simon Hurst 13,088 2
