Book list Excel Spreadsheet and Financial Modelling Book List 

Systems Modelling Ltd. provides training courses for best practice and accelerated productivity, and expert consultancy in spreadsheet modelling, model review and re-engineering, quality testing, and auditing. Contact us for more details.

Our recommendations with links to Amazon in each country

Book Description   USA
.com
United Kingdom
.co.uk
Germany 
.de
France 
.fr
 
.ca
 
.co.jp
Top rated Excel books   $ £ €  €  CAD JPY
Spreadsheet Check and Control: 47 key practices to detect and prevent errors. Patrick O'Beirne, 200 pages, Sep 2005, buy now direct from us or from your preferred Amazon shop:

USA

UK

Germany

France

Canada

Japan

This Isn't Excel, It's Magic by Bob Umlas, 85 really advanced techniques and shortcuts. No VBA, just Excel's lesser-known features and sophisticated formula capabilities.

USA

UK

Germany

France

Canada

Japan

John Walkenbach's Favorite Excel Tips & Tricks. 200 of his favourite shortcuts, secrets, and workarounds for Excel 2000, 2002, and 2003.

USA

UK

Germany

France

Canada

Japan

Excel Advanced Report Development
by Timothy Zapawa. If you're a SQL programmer or an experienced Excel user, using OLTP databases. Six 5-star reviews.

USA

UK

Germany

France

Canada

Japan

Excel Hacks: 100 Industrial Strength Tips and Tools David Hawley, Raina Hawley Paperback 304 pages (April 30, 2004)

USA

UK

Germany

France

Canada

Japan

Excel Best Practices for Business by Loren Abdulezer, addresses the new features not available prior to Excel 2003: the full suite of XML facilities, and using Excel as web services portal.

USA

UK

Germany

France

Canada

Japan

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish. (2006, 336 pages) Tips, techniques and recipes that cannot be found in Excel's Help.

 

USA

UK

Germany

France

Canada

Japan

Escape From Excel Hell: Fixing Problems in Excel 2003, 2002 and 2000 by Loren Abdulezer, John Walkenbach (2006, 408 pages) For advanced beginners and intermediate users, this book offers quick fixes for anyone bedeviled by perplexing Excel problems  

USA

UK

Germany

France

Canada

Japan

Visual Basic for Applications (VBA)
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA Stephen Bullen, Rob Bovey, John Green Paperback 800 pages (March 31, 2005)

USA

UK

Germany

France

Canada

Japan

Holy Macro! It's 2,200 Excel VBA Examples : Every Snippet of Excel VBA Code You'll Ever Need (CD-ROM)  by Bill Jelen, Tom Urtis, Hans W Herber,

USA

UK

Germany

France

Canada

Japan

Programming Excel with VBA and .NET by Jeff Webb, Steve Saunders. (2006) 1090 pages, 5-star reviews

USA

UK

Germany

France

Canada

Japan

Excel 2010 Power Programming with VBA John Walkenbach

USA

UK

Germany

France

Canada

Japan

Financial Modelling
Principles of Finance with Excel by Simon Benninga. For undergraduate courses in introductory finance or as a reference for finance professionals. CD for students contains the spreadsheets. A companion website contains notes, slides, and a test bank for instructors.

USA

UK

Germany

France

Canada

Japan

Financial Modeling by Simon Benninga. A finance "cookbook" that bridges the gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets

USA

UK

Germany

France

Canada

Japan

Building Financial Models with Microsoft Excel: A Guide for Business Professionals by K. Scott Proctor. (2004, 384 pages) Budgets, valuation, sensitivity analysis, contribution, financial ratios

USA

UK

Germany

France

Canada

Japan

Guide to Business Modelling by John Tennent and Graham Friend. (2001, 272pp) How to structure spreadsheets to build flexible and easy-to-use business models

USA

UK

Germany

France

Canada

Japan

Advanced Modelling in Finance Using Excel and VBA (Wiley Finance S., 2001) Mary Jackson, Mike Staunton. A step-by-step approach to Excel programming to model and manipulate financial data as applied to equities, bonds and options. The spreadsheets and VBA functions are provided on a CD-ROM. 

USA

UK

Germany

France

Canada

Japan

Mastering Financial Modeling Alastair Day (2001)  A practical book and disk combination that will help finance professionals and business students alike to become more proficient in building Microsoft Excel models and applying corporate finance concepts.

USA

UK

Germany

France

Canada

Japan

Mastering Financial Calculations: A Step-by-step Guide to the Mathematics of Financial Markets (Market Editions) Robert Steiner - 5 star reviews. Making use of many worked examples and practical exercises, explains concepts such as forward pricing, duration analysis, the different approaches to bond yield calculations, zero-coupon and yield curve analysis, swap valuation and option pricing. For ACI Dealing certificate exams.

USA

UK

Germany

France

Canada

Japan

Spreadsheet Modeling in Investments (w/CD-ROM) Craig W. Holden. Coverage of investments, portfolio theory, capital asset pricing, arbitrage pricing, pricing of derivative securities, interest rates, and bond management.

USA

UK


France



The Art of Modeling with Spreadsheets : Management Science, Spreadsheet Engineering, and Modeling Craft (with CDROM) by Stephen G. Powell, Kenneth R. Baker. Effective methods for designing, building, and testing models, and for performing model-based analyses; data analysis, simulation, and optimization.

USA

UK

Germany

France

Canada

Japan

Paul Wilmott on Quantitative Finance, 2 Volume Set. Gets five-star reviews. Paul Wilmott, described by the Financial Times as a "cult derivatives lecturer", updates and extends - with 18 new chapters - his earlier classic Derivatives: The Theory and Practice of Financial Engineering. With essential Visual Basic code and spreadsheet explanations of the models

USA

UK

Germany

France

Canada

Japan

Management Decision Making: Spreadsheet Modeling, Analysis, and Applications (with CD-ROM) by George E. Monahan. How to formulate models in Microsoft Excel that can be used to analyze complex problems taken from all the functional areas of management, including finance, marketing, operations, and human resources

USA

UK

Germany

France

Canada

Japan

Managerial Decision Modeling with Spreadsheets By Barry Render, Ralph M. Stair Jr., and Nagraj Balakrishnan. A balanced approach to spreadsheet-based decision modeling, IP and LP, sensitivity, transportation, assignment, network, queuing, simulation, forecasting, inventory control. CD-ROM includes Student Edition (140-day version) of Crystal Ball® Professional. 

USA

UK

Germany

France

Canada

Japan

Scientific Financial Management: Advances in Financial Intelligence Capabilities for Corporate Valuation and Risk Assessment (with CD-ROM) by Morton Glantz, Thomas L. Doorley, Amacom, Bruce Henderson. 

USA

UK

Germany

France

Canada

Japan

Spreadsheet Modeling and Decision Analysis Cliff Ragsdale provides instruction in the most commonly used management science techniques

USA

UK

Germany

France

Canada

Japan

General Excel books
Excel Charts John Walkenbach. One of the world's best-known Excel experts shows how to select charts for different categories of data, modify data in a chart, deal with missing data, format charts, customize shapes, and give charts a professional look.

USA

UK

Germany

France

Canada

Japan

ECDL4: The Complete Coursebook for Office XP Paul Holden, Brendan Munnelly. Five star reviews for this accredited complete coursebook using case studies, practical examples and exercises to pass the exam.

USA

UK

Germany

France

Canada

Japan

Excel for Auditors by Dwayne K. Dowell & Bill Jelen

 

USA

UK

Germany

France

Canada

Japan

Data Mining, Exploratory Analysis, Statistics, Engineering & Science
Analyzing Business Data with Excel by Gerald Knight. Business problems posed and answered in Excel with complete ready-to-use applications.

USA

UK

Germany

France

Canada

Japan

Data Mining Cookbook: Modeling Data for Marketing, Risk and Customer Relationship Management by Olivia Parr Rud. A step-by-step guide showing how to create and implement models of the most commonly asked mining questions.

USA

UK

Germany

France

Canada

Japan

Mastering Data Mining: The Art and Science of Customer Relationship Management by Michael J. A. Berry, Gordon S. Linoff. Berry and Linoff share the lessons they have learned through a series of warts-and-all case studies drawn from their experience in a variety of industries, including e-commerce, banking, cataloging, retailing, and telecommunications.

USA

UK

Germany

France

Canada

Japan

Microsoft Excel Data Analysis & Business Modeling Wayne L. Winston, Microsoft Press 2004

USA

UK

Germany

France

Canada

Japan

Business Modeling and Data Mining by Dorian Pyle

USA

UK

Germany

France

Canada

Japan

Data Analysis With Excel: An Introduction for Physical Scientists  Les Kirkup CUP 2002. Very helpful for Engineering statistics

USA

UK

Germany

France

Canada

Japan

Advanced Excel for Scientific Data Analysis Robert De Levie OUP 2004. The author is an expert: previous publications are "Spreadsheet Workbook of Quantitative Chemical Analysis" and "How to Use Excel in Analytical Chemistry". 

USA

UK

Germany

France

Canada

Japan

Spreadsheet Applications in Chemistry  , Dermot Diamond. Illustrates how Excel can be used to help scientists process, analyze, and present scientific data. (1997)

USA

UK

Germany

France

Canada

Japan

Excel for Chemists: A Comprehensive Guide E. Joseph Billo.(2001) A reviewer says "the book has helped me to not only follow the progress and interrelationships of the data but also to more clearly communicate my needs to a professional biostatistics firm. "

USA

UK

Germany

France

Canada

Japan

Excel Scientific and Engineering Cookbook by David M Bourg, real-world examples from disciplines such as biology, chemistry, and physics. 5-star reviews

USA

UK

Germany

France

Canada

Japan

Excel for Engineers and Scientists, 2nd Edition S. C. Bloch, Univ. of South Florida (2003). Using an informal, conversational style, this "how to" book guides beginning students from spreadsheet basics through the robust engineering and scientific applications of EXCEL, including using EXCEL in the lab.

USA

UK

Germany

France

Canada

Japan

The History of Mathematical Tables - From Sumer to Spreadsheets Edited by Martin Campbell-Kelly, University of Warwick, and others. October 2003, 372 pages. Summarises the history of mathematical tables from earliest times until the late twentieth century.

USA

UK

Germany

France

Canada

Japan

 

 

Current bestselling books from Amazon.com  Yahoo! spreadsheet News  

 

 
and Amazon.co.uk:


Also see

Spreadsheet training and consulting services from Systems Modelling Ltd

Spreadsheet Links:  for news and events, good design, auditing tools, mail lists, research on spreadsheet errors and quality, testing, risks, spreadsheets in accounting, business and financial modelling.

Downloads:  free software, VBA code, tools, examples, templates, utilities, Excel Tips.

Agile approaches to Spreadsheet development (article by Patrick O'Beirne)

 

Back to Systems Modelling home page