Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals, + Website

Preface

This book was written from my course materials compiled over many years of training in analytical courses in Australia and globally—most frequently courses such as Financial Modelling in Excel, Data Analysis & Reporting in Excel, and Budgeting & Forecasting in Excel, both as face-to-face workshops and online courses. The common theme is the use of Microsoft Excel, and I’ve refined the content to suit the hundreds of participants and their questions over the years. This content has been honed and refined by the many participants on these courses, who are my intended readers. This book is aimed at you, the many people who seek financial analysis training (either by attending a seminar or self-paced by reading this book) because you are seeking to improve your skills to perform better in your current role, or get a new and better job.

When I started financial modelling in the early nineties, it was not called financial modelling—it was just “Using Excel for Business Analysis,” and this is what I’ve called this book. It was only just after the new millennium that the term financial modelling gained popularity in its own right and became a required skill often listed on analytical job descriptions. This book spends quite a bit of time in Chapter 1 defining the meaning of a financial model as it’s often thought to be something that is far more complicated than it actually is. Many analysts I’ve met are building financial models already without realising it, but they do themselves ...