Using Excel for Business Analysis and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a £6.95 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading Using Excel for Business Analysis on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website (Wiley Finance) [Paperback]

Danielle Stein Fairhurst
3.5 out of 5 stars  See all reviews (2 customer reviews)
RRP: £50.00
Price: £32.50 & FREE Delivery in the UK. Details
You Save: £17.50 (35%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 9 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 29 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition £30.88  
Paperback £32.50  
Trade In this Item for up to £6.95
Trade in Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website (Wiley Finance) for an Amazon Gift Card of up to £6.95, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

11 Sep 2012 Wiley Finance
A clear, concise, and easy–to–use guide to financial modelling suitable for practitioners at every level Using a fundamental approach to financial modelling that′s accessible to both new and experienced professionals, Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website offers practical guidance for anyone looking to build financial models for business proposals, to evaluate opportunities, or to craft financial reports. Comprehensive in nature, the book covers the principles and best practices of financial modelling, including the Excel tools, formulas, and functions to master, and the techniques and strategies necessary to eliminate errors. As well as explaining the essentials of financial modelling, Using Excel for Business Analysis is packed with exercises and case studies to help you practice and test your comprehension, and includes additional resources online. Provides comprehensive coverage of the principles and best practices of financial modeling, including planning, how to structure a model, layout, the anatomy of a good model, rebuilding an inherited model, and much more Demonstrates the technical Excel tools and techniques needed to build a good model successfully Outlines the skills you need to learn in order to be a good financial modeller, such as technical, design, and business and industry knowledge Illustrates successful best practice modeling techniques such as linking, formula consistency, formatting, and labeling Describes strategies for reducing errors and how to build error checks and other methods to ensure accurate and robust models A practical guide for professionals, including those who do not come from a financial background, Using Excel for Business Analysis is a fundamentals–rich approach to financial modeling.

Frequently Bought Together

Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website (Wiley Finance) + The Economist Guide to Business Modelling
Price For Both: £52.50

Buy the selected items together
  • The Economist Guide to Business Modelling £20.00

Product details

  • Paperback: 336 pages
  • Publisher: John Wiley & Sons; Pap/Psc edition (11 Sep 2012)
  • Language: English
  • ISBN-10: 111813284X
  • ISBN-13: 978-1118132845
  • Product Dimensions: 25.1 x 17.8 x 1.8 cm
  • Average Customer Review: 3.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 297,325 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Danielle Stein Fairhurst is the principal of Plum Solutions, a Sydney-based financial modelling consultancy. With her talent for analytical modelling and professional approach, Danielle helps her clients create meaningful financial models for business analysis. She is regularly engaged as a speaker, facilitator and consultant. She holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management, and has taught management accounting subjects at Sydney University.

A Note from the Author - I hope you enjoy "Using Excel for Business Analysis; a Guide to Financial Modelling Fundamentals". 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 developed 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.

Product Description

From the Inside Flap

Financial modelling is an essential tool for managing risk, planning projects, preparing business proposals, evaluating opportunities, and much more. But despite its importance, many professionals struggle to understand exactly what "financial modelling" really is. Put simply, it's a complex type of spreadsheet, not much different from the ones you create in Excel all the time. In Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website , financial modelling expert Danielle Stein Fairhurst explains exactly how to utilise Excel for modelling, walking you through the principles, best practices, and tools that you need to understand in order to use this widely available software for business analysis. Comprehensive yet accessible, the book is designed for professionals of all backgrounds and levels of experience looking to become familiar with financial modelling, introducing and explaining how to structure a model, the anatomy of a good model, rebuilding an inherited model, and much more. Covering Excel-based financial modelling tools and explaining, in detail, how to use the program to perform model display and model review, stress-testing, and other important topics, Using Excel for Business Analysis describes key strategies for minimising errors and presents other techniques for ensuring accurate and robust models. Packed with indispensable coverage of both the essential concepts behind financial modelling and the practicalities of performing complex analysis, the book presents information in a clear, concise, step-by-step manner that makes it easy to use. Exercises and case studies are included throughout the text to help you practice and test your comprehension. Containing everything you need to know in order to master the tools, formulas, and functions that allow for successful modelling, Using Excel for Business Analysis also provides readers with access to a companion website containing additional resources for a more immersive experience, making it the only book you need to understand and work with financial models.

From the Back Cover

Praise for Using Excel for Business Analysis "Danielle brilliantly manages the balance between business relevance and the necessary technical explanations expected from a book such as this. Her ability to walk in the shoes of the reader and deliver concise practical wisdom is unsurpassed. I highly recommend this book to anyone working with numbers, be it a Chief Financial Officer talking to the board or a Business Analyst starting their career. With Danielle's advice you can transform your career from successful to exceptional." —Garth Holloway , Managing Director, SixFootFour Consulting "Danielle's expertise and experience shines through in a very readable book, introducing the key concepts and considerations inherent in financial modelling. From novice to advanced modeller alike, readers are presented with many useful tips, tools, techniques, and pragmatic examples to refer to time and time again. Readily digestible, this book plugs a gaping academic hole that illustrates the risks and rewards of taking a spreadsheet by the throat and converting it into a robust, transparent, and flexible decision-making device. It will help you to 'Excel '." —Liam Bastick , Managing Director, SumProduct, and Excel MVP "Excel is a powerful and underestimated tool in many business environments. Whilst there are a number of books on the market that help explain the countless functions and features of the product, there are few if any that clearly articulate and teach the analyst how to unlock the power of Excel as an analysis and modelling tool for critical business decisions. Filled with easy to follow examples and based on many years of practical experience and education, Danielle Stein Fairhurst's book Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals has finally bridged that gap with a step-by-step approach to building models that address important real-world business questions." —Michael Morgan , Country Manager (Australia), Intergen Business Solutions

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

5 star
2 star
1 star
3.5 out of 5 stars
3.5 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
4.0 out of 5 stars easy to read quick guide for best practice 24 Feb 2013
Format:Kindle Edition
I was in need of refreshing my Excel knowledge and get ready to build a presentable financial model. the book is easy to read and full of useful tips
Comment | 
Was this review helpful to you?
3.0 out of 5 stars Interesting. 12 May 2014
By Pieter
Format:Paperback|Verified Purchase
The book has extensive inforation, but it would be better if the book came with a CD with excercices / examples.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  9 reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars Great Tips for Organizing Your Workbooks 12 April 2013
By runner7 - Published on
Format:Kindle Edition|Verified Purchase
I thought that this book contained great tips for organizing, maintaining, and managing Excel workbooks so that they are consistent, reliable, accurate, and intuitive. Nothing mind-blowing, but the checklists are fantastic references.
2 of 2 people found the following review helpful
5.0 out of 5 stars Logical and well illustrated 26 Nov 2012
By Balmainbug - Published on
I found this book really well thought through, well laid out and very easy to follow because of the immensely helpful screen prints. I was creating financial models with confidence really quickly. What a clever idea to back up the book with a website for continued support! Highly recommended!
1 of 1 people found the following review helpful
5.0 out of 5 stars Extremely Relevant and Useful 15 May 2014
By Chad M. Sorenson - Published on
Format:Paperback|Verified Purchase
I found this book extremely on-point, concise and thorough. It was perfectly tailored to my needs generating some initial financial models in the renewable energy space. I learned many new tricks in Excel that had previously escaped me. I purchased both the Kindle version and the paperback version I liked it so much. Highly recommended.
1 of 1 people found the following review helpful
4.0 out of 5 stars Excellent book for the intermediate financial modeler. 9 Dec 2012
By Michael J. Hamilton - Published on
Format:Paperback|Verified Purchase
Very informed review of Excel for the intermediate to higher end user. Thoroughly explains the concepts the author is teaching and the practical examples help to reinforce the learning process.
3 of 4 people found the following review helpful
5.0 out of 5 stars Impressed me... AND my boss! 24 Nov 2012
By Suze - Published on
I was charged with the task of preparing a cash flow forecast for an upcoming proposal. After looking at several how-to books, I chose this one due to its practical-looking format. I'm glad I did. It succinctly showed me the best way to format and structure my model, the methods and formulas to use and explained it so well that I can now teach others in the office. Financial modelling sounds intimidating, but Ms. Fairhurst made it seem no different than using Excel to create a grocery list.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category