Resources
Recommended reading
John Walkenbach, Excel 2003 Formulas
John Walkenbach, Excel 2007 Bible. The latest Excel book from one of the best Excel writers.
Curtis Frye, Microsoft Office 2003 Step by Step
You are here: Home > Resources > Word and Excel > Excel for accounting and financial analysis
Microsoft Excel is the standard tool used to analyse financial data, prepare financial reports and prepare graphs and charts. Resources here include advanced information about using Excel.
Excel’s pivot tables are the bread-and-butter tool for management accounting and financial analysis. Debra Dalgleish’s site at Contextures includes a comprehensive series of articles on managing pivot tables.
Last reviewed 11 July 2008
CFO Magazine has several useful articles on using spreadsheets for financial analysis. See a full list of articles about Excel or spreadsheets.
I particularly liked a recent article on Sloppy Spreadsheets that describes readers’ additions to CFO magazine’s ‘worst practices’ list.
Last reviewed 11 July 2008