Advanced Excel Reporting For Management Accountants - complete videos series of the book
- Buy now
- Learn more
Advanced Excel Reporting For Management Accountants

Book Index.xlsx
Chapter Three - Building Tips

Chapter 3 Materials
Chapter Three - Tips - Part One - 30 March 2016
Chapter 3 completed file 30 March 2016
Chapter Three - Tips - Part Two - 26 Apr 2016
Chapter 3 completed file 26 Apr 2016
Chapter Four - Design and Structure

Chapter Three - Tips - Part Three - plus Chapter Four - 31 May 2016
Chapter 3 Completed File 31 May 2016
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

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

Chapter 9 - Range Names

This chapter gives you all your need to know about using range names in Excel.

5 Lessons