Simon Hurst reviews the techniques available for extracting and reporting on accounts data with the tools available in Excel 2010.
Having covered font formats including the use of Excel Styles and Themes and the
The previous FAQ instalment considered font formats including the use of Excel Styles and Th
Excel numbers and general formatting techniques are worth studying in some depth. In this article, Simon Hurst focuses on font-related questions.
Simon Hurst unearths and highlights some of the most commonly recurring themes from Excel Zone’s Any Answers.
Excel’s VLOOKUP function is probably second only to pivot tables in popularity for management reporting and accounting users. Simon Hurst looks into its potential applications.
An article explaining the Named Ranges feature in Excel 2007 remains the single most popular item ever published on AccountingWEB.co.uk.
Simon Hurst draws on queries and answers from the ExcelZone archives to offer a collection of time-saving worksheet handling tips.
A round up of tips and tricks to help you cope with Excel’s arithmetic foibles.
Why are Excel calculations sometimes incorrect?
This article collects together ExcelZone tips and tricks for dealing with the problems that can occur when working with dates in Excel.