Excel Book

Free Webinars and Recordings

ADVANCED EXCEL REPORTING FOR MANAGEMENT ACCOUNTANTS

My new book had been published and I am very proud of the result. The book is available on Amazon and other book sites. BookDepository seems to be the cheapest, it has free postage.

Advanced Excel Reporting Cover

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 have started a webinar series based on the book – see bottom of page for recording links. Use the button below to register for upcoming live book webinars. If you own the book, the live webinars are free – there is a clue from the book that is the free voucher code.  These webinars 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

Recording – Chapter 3 – Final + Chapter 4 – 1 Hour

Recording – Chapter 5 – 1 Hour

 

 

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

10 thoughts on “Excel Book

  1. 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

  2. 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

  3. 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

  4. 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