Login
Excel Yourself/Advanced Excel Reporting For Management Accountants - complete videos series of the book
Enrollment is closed

The Book is the Manual

PRICE DROP! To celebrate 8 years since the book was published I have halved the price of this course - down to AU$47!

My book was published in April 2014. It was based on Excel 2010. The techniques,  formula and functions included are mostly still relevant today in 2022.

I have recently added links to new free courses that update and supplement some of the content.

This price DOES NOT include the book. You must have or buy the book separately - see the Buy Book sections below.

Between 2016 and 2019 I ran 24 live webinars progressing through the book and finishing with the two case studies. I also did a bonus Q&A webinar at the end.

Screen shots are different in the latest versions and some new features are covered in the videos. The 24 videos update the book by showing the newer interfaces.

There is over 25 hours of video, plus the sample Excel files are also included.

Buy Kindle Book

You can can buy the electronic version at Amazon - see button below. 

The electronic version is great because you can search so much quicker. You can also copy formulas from the book and paste into Excel.
Buy Kindle Version

Buy Paperback Book

I still buy "real" books and the best place I have found is Bookdepository.co.uk. Note: it is owned by Amazon.

It also offers free postage worldwide. Use button below. The book is still avaiable at all online booksellers.

Buy From Bookdepository

  • $47

Advanced Excel Reporting For Management Accountants - complete videos series of the book

  • Closed

Buy now

Contents

Advanced Excel Reporting For Management Accountants

A couple of years after my book was published I decided to run a series of webinars to cover all the content in the book. The first few webinars were free were free and then i charged for them.

This course has all the webinar recordings (25 in all) over 25 hours of video.

There is no manual - the book is the manual for this course.

Chapters 5, 6, 8 and 12 have an Extras lesson at the bottom of their section. Extras have a link to enrol in a separate free online course available on updated topics that are not covered in the book.
Book Index.xlsx
Preview

Chapter Three - Building Tips

We start in Chapter three with tips, tricks and traps.
Chapter 3 Materials
Preview
Chapter Three - Tips - Part One - 30 March 2016
Preview
Chapter 3 completed file 30 March 2016
Preview
Chapter Three - Tips - Part Two - 26 Apr 2016
Preview
Chapter 3 completed file 26 Apr 2016
Preview

Chapter Four - Design and Structure

Chapter Three - Tips - Part Three - plus Chapter Four - 31 May 2016
Preview
Chapter 3 Completed File 31 May 2016
Preview

Chapter Five - Setting the Foundation

Practice Samples - Chapter 5.xlsx
Chapter Five - Foundations - Part One - 28 Jul 2016
Practice Samples - Chapter 5 - completed file - 28 Jul 2016
Extras - Power Query Introduction

Chapter Six - Pivot Tables

Practice Samples - Chapter 6.xlsx
Chapter Five Part Two plus Chapter Six - 30 Aug 2016
Practice Samples - Chapter 6 - Completed File - 30 Aug 2016
Extras - Power Pivot Introduction

Chapter Seven - Tools of the Trade: Summing Functions

Practice Samples - Chapter 7.xlsx
Chapter Six - Pivots - Part Two plus Chapter Seven - 29 Sep 2016
Practice Samples - Chapter 7 - completed file - 29 Sep 2016
Chapter Seven - Summing Functions - Part Two - 27 Oct 2016
Practice Samples - Chapter 7 - completed file - 27 Oct 2016
Chapter Seven - Summing Functions - Part Three - 30 Nov 2016

Chapter Eight - Accessories: Other Reporting Functions and Features

Practice Samples - Chapter 8.xlsx
Practice Samples - Chapter 8 - 20161130.xlsx
Chapter Eight - Accessories - Part One - 20 Dec 2016
Practice Samples - Chapter 8 - 20161220.xlsx
Chapter Eight - Accessories - Part Two - 27 Feb 2017
Practice Samples - Chapter 8 - 20170227 - completed.xlsx
Chapter Eight - Accessories - Part Three - 28 Apr 2017
Practice Samples - Chapter 8 continued - 20170427 - completed.xlsx
Chapter Eight - Accessories - Part Four - 29 Mar 2018
Extras - Dynamic arrays

Chapter 9 - Range Names

This chapter gives you all your need to know about using range names in Excel.
Practice Samples - Chapter 9.xlsx
Chapter Nine - Range Names - Part One - 30 Apr 2018
Practice Samples - Chapter 9 - Completed File - 30 Apr 2018
Chapter Nine - Range Names - Part Two - 29 May 2018
Practice Samples - Chapter 9 - Completed File - 29 May 2018

Chapter Ten - Maintenance Issues

Practice Samples - Chapter 10.xlsx
Chapter Ten - Maintenance - 27 Jun 2018
Practice Samples - Chapter 10 - completed file - 27 Jun 2018

Chapter Eleven - Choose the Right Format

Practice Samples - Chapter 11.xlsx
Chapter 11 - Formatting - 27 Jul 2018
Practice Samples - Chapter 11 - completed file - 27 Jul 2018
Chapter 11 - Formatting - Part 2 - 30 Aug 2018
Practice Samples - Chapter 11 - Completed File - 30 Aug 2018

Chapter Twelve - Picture Perfect: Charting Techiques

Practice-Samples-Chapter-12.xlsx
Chapter Twelve -Charts - Part One - 27 Sep 2018
Practice-Samples-Chapter-12-Completed File 27-Sep 2018
Chapter Twelve - Charts - Part Two - 25 Oct 2018
Practice-Samples-Chapter-12-Completed File-25 Oct 2018
Extras - Chart tips and tricks

Chapter Thirteen - Quality Control: Report Validation

Practice Samples - Chapter 13 -20181129.xlsx
Chapter Thirteen - Validations - 29 Nov 2018

Chapter Fourteen - Case Study One: Month and YTD Reporting

Case-Study-One-Chapter-14-Blank.xlsx
Chapter Fourteen - Case Study One - Part one - 27 Feb 2019
Chapter Fourteen - Case Study One - Part Two - 28 Mar 2019
Case-Study-One-Chapter-14- Completed File - 27 Mar 2019

Chapter Fifteen - Case Study Two: 12-Month Reporting

Case Study Two - Chapter 15 - Blank - webinar.xlsx
Chapter Fifteen - Case Study Two - Part One - 18 Apr 2019
Chapter Fifteen - Case STudy Two - Part Two - 29 Apr 2019
Case Study Two - Chapter 15 - Completed File - 29 Apr 2019

Bonus Video Q&A

Book Q&A Session June 2019.xlsx
Book Q&A 13 June 2019
Book Q&A Session Completed File 13 June 2019