ICAEW.com works better with JavaScript enabled.

eBooks on Excel

We offer instant, full text access to over 450 eBook titles on key business and reference topics. Browse eBooks on Microsoft Excel.

Our eBooks are available to logged-in ICAEW members, ACA students and other entitled users.

See the A–Z of eBooks for a complete list of titles available across all subjects.

Principles of financial modelling: model design and best practices using Excel and VBA

A practical guide to financial modelling, demonstrating how to plan, design and build financial models. The book provides an introduction to modelling and discusses model design, the process of building models and sensitivity and scenario analysis, with practical examples of using Excel functions and Visual Basic for Applications (VBA) within financial modelling.

Financial modeling in Excel for Dummies

A beginner's guide to financial modeling using Microsoft Excel - this book shows you how to harness Excel's capabilities to determine profitability, develop budgetary projections, model depreciation, project costs, value assets and more. You'll learn the fundamental best practices and know-how of financial modeling, and how to put them to work for your business and your clients.

Mastering financial mathematics in Microsoft Excel: a practical guide to business calculations (3rd edition)

Fully updated and compliant with Excel 2013, this clearly explains the basic calculations for mathematical finance, backed up with simple templates for further use and development, and a workbook with exercises and solutions at the end of each chapter. Contains chapters on: basic Financial Arithmetic; cash flows; bonds calculations; bond risks; floating rate securities; amortisation and depreciation; swaps; forward interest rates; futures; foreign exchange; options; real options; valuation; leasing; basic statistics.

Advanced Excel reporting for management accountants

Learn about the Excel functions that can automate the process of financial reporting for management accountants. The book demonstrates how to create and run reports and apply software tools to two case studies.

Excel dashboards and reports for dummies

Introduces Excel functionalities for building better financial reporting mechanisms. Includes tips on exploiting Excel for data analysis and visualisation.

Mastering financial modelling in Microsoft Excel: a practitioner's guide to applied corporate finance (3rd edition)

Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling techniques before moving through to more complex models. The book is divided into two parts: the first part outlines model designs and gives templates, key features and techniques. The second part of the book shows how to build corporate financial models in Excel. This new edition includes a reworking of the book in Excel 2010 (but with older material still included), inclusion of Apple Mac, addition of specific 2010 features and end of chapter exercises.

Using Excel for business analysis: A guide to financial modelling fundamentals

Practical guidance on how to design, build and test financial models. The book opens with a general guide to financial modelling, followed by step-by-step instructions to walk you through modelling in Excel 2013. Finally, advice is given on effectively presenting your model's results via a written report or oral presentation.

Financial planning using Excel: forecasting, planning and budgeting techniques

Aimed at people who already have some knowledge of Microsoft Excel. It looks at spreadsheet skills for different types of planning, and contains detailed sections on business planning, forecasting and managing budgets with business software.

Structured finance modeling with object-oriented VBA

An aid to using business software for financial modelling in the securities market. It is primarily concerned with Microsoft Excel and Visual Basic but includes general guidance on modelling and corporate finance.

Financial modeling with Crystal Ball and Excel

Guide to financial modelling using business software, including Oracle Crystal Ball and Microsoft Excel. It includes chapters on financial forecasting, modelling financial statements, and other modelling functions available in Excel.

Showing 10 of 12 items

Terms of use: You are permitted to access, download, copy, or print out content from eBooks for your own research or study only, subject to the terms of use set by our suppliers and any restrictions imposed by individual publishers. Please see individual supplier pages for full terms of use.

Further reading

The Library collection also contains books and articles on Excel. To find out how you can borrow books from the Library please see our guide to book loans. You can obtain copies of articles or extracts of books and reports by post, fax or email through our document supply service.

Can't find what you are looking for?

If you're having trouble finding the information you need, ask the Library & Information Service. Contact us by telephone on +44 (0)20 7920 8620, by web chat or by email at library@icaew.com.