ADVANCED EXCEL REPORTING FOR MANAGEMENT ACCOUNTANTS
My book was published in 2014 and I am very proud of the result. The book is available on Amazon and other book sites.
In this book I share the reporting techniques that I’ve learned over the 20 years that I’ve been using spreadsheets. You don’t need to be an advanced user to take advantage of this book. If you have basic skills, the book with guide you through the techniques required to create advanced, automated reports.
As a bonus I completed a live webinar series based on the book – see bottom of page for free recording links. If you own the book some of the recorded webinars are free. These webinar recordings have no manuals – the book is the manual.
Even though the book is aimed at Management Accountants, the techniques in the book can be applied by most Accountants and finance staff. Excel skills are portable, and the better you are with Excel, the easier your everyday tasks will become.
Most chapters have an example Excel file available on the companion website to enable you to better understand how these techniques work. The book includes whole chapters on
- tips and tricks that can save you time and effort
- data cleansing techniques to assist in getting your data right
- Pivot Tables – the quick way to create reports
- summing functions – discover things you didn’t know Excel could do
- other functions you need to master in the report creation process
- range names, how and when to use them
- formatting – including conditional formatting
- charting – what to avoid and what to use
The book finishes with two separate case studies that demonstrate how to bring together most of the book’s techniques into a reporting model. This book contains lots of practical tips and tricks throughout the chapters. It also explains how to avoid common traps when creating reporting spreadsheets.
I have assumed the reader is using Excel regularly and has a basic grasp of Excel and how to create formulas. The book takes the reader through some of the basics required to build effective formulas, and then builds upon those skills and explains advanced techniques in an easy to understand style. I’ve included lots of images to help explain the techniques.
My Book Webinar Recording Links
I started the webinars with Chapter Three as Chapters One and Two weren’t webinar material.
I am only making the first four recordings available for free on this site. You can contact me directly to get access to other free and paid sessions in the series.
Recording – Chapter 3 – Part One – 1.5 Hours
Recording – Chapter 3 – Part Two – 1 Hour
Hi Neale
Thank you for the great work on helping us create beautiful and smart work that can facilitate better and faster decisions.
I found myself lucky enough to visit this lovely page of your website couple of days back. It didn’t take long place order for the book (paperback). Loved the cover and contents page.
These Webianrs are wonderful idea and absolute bonus for the learners.
Looking forward to delivery of the book (BookDepository) ASAP and enjoying the caramel (webinars).
Kind Regards
Thanks – I you hope you enjoy the book and the webinars.
Hi Neal
I know about you from articles in the CPA magazine. You have provided some amazing tips on Excel.I have bought your book and thought could be easier to go through the book on your webinar.
Could you please give me the link for the webinar from Chapter 6 onward?
Kind regards
Hi William
Thanks for your comment. I have sent the links to your email address.
Regards
Neale
Neale,
Hi. I have bought your book. Can you please give me access to the recordings for Chapters 6 and 7. Let me know costs etc.
Thank you,
Joe
Hi Neale,
I’ve bought your book, which is really easily understood and comprehensive to apply the excel functions to the real world. However, I came across some difficulties to include the check-box into the table. Could you please give me the link for the webinar from Chapter 10 onward?
Thanks and regards,
Lois
Hi Lois
The webinars aren’t up to Chapter 10 yet – still on Chapter 8. The last few webinars have also been paid sessions.
Hope you enjoy the rest of the book.
Regards
Neale
You could check out one of my free webinars that did cover checkboxes as well as other controls. It is towards the bottom of the page.
Thanks Neale – for your reply.
I worked it out by following the instruction in the book – pretty easy to understand. Really enjoy reading the book. Thanks again.
Best regards,
Lois
Thanks Lois – the case studies at the end of the book really bring all the content together.
Great book Neale.
I have learnt a lot from this book. Your valuable techniques and skills make tackling excel a seamless process.
A book to be at every excel enthusiasts’ bookshelf definitely. Specially, the webinars that come along with the book is very helpful.
Thank you for for this masterpiece.
Thanks, glad you learned a lot from the book.