Advanced Excel Reporting for Management Accountants

The advanced tools accountants need to build automated, reliable, and scalable reports using Excel

Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants.

• Explore the structures that simplify the report creation process and make the reports more maintainable
• Learn techniques to "cleanse" data so that it is ready for use in Pivot Tables and formula-based reports
• Find out the tips and tricks that can make the creation process quicker and easier
• Discover all you need to know about Excel's summing functions and how versatile they can be

Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.

Author: Neale Blackwood
Publisher: Wiley
Published: 04/14/2014
Pages: 448
Binding Type: Paperback
Weight: 1.72lbs
Size: 9.90h x 7.06w x 0.92d
ISBN: 9781118657720

About the Author

Neale Blackwood has been using spreadsheets since the late 80's. Starting with Lotus and moving to Excel in the mid 90's. His roles have included Accountant, Project Accountant, Financial Controller and Management Accountant. He developed most of his advanced Excel skills as a Management Accountant.
An Australian CPA and certified Microsoft Office Specialist Expert, he has written for the CPA Australia monthly magazine, INTHEBLACK, since 2002. He has written over 100 of his regular "Excel Yourself" articles and eight feature articles for the magazine. He has freely answered Excel questions from Australian CPA's from many different countries for over nine years.
He has presented at numerous CPA Australia events in Australia, from one hour sessions to half-day Master Classes. He writes and presents his own XL@Lunch Excel webinars to people from around the globe.