Excel Spreadsheet and Financial Modelling 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.
| Book Description |
 .com |
 .co.uk |
 .de |
 .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: |
|
||||||
| 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. |
|
||||||
| John Walkenbach's Favorite Excel Tips & Tricks. 200 of his favourite shortcuts, secrets, and workarounds for Excel 2000, 2002, and 2003. |
|
||||||
| 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. |
|
||||||
| Excel Hacks: 100 Industrial Strength Tips and Tools David Hawley, Raina Hawley Paperback 304 pages (April 30, 2004) |
|
||||||
| 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. |
|
||||||
| 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.
|
|
||||||
| 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 |
|
||||||
| 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) |
|
||||||
| 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, |
|
||||||
| Programming Excel with VBA and .NET by Jeff Webb, Steve Saunders. (2006) 1090 pages, 5-star reviews |
|
||||||
| Excel 2010 Power Programming with VBA John Walkenbach |
|
||||||
| 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. |
|
||||||
| 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 |
|
||||||
| 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 |
|
||||||
| 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 |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| 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. |
|
|
|
|
|||
| 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. |
|
||||||
| 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 |
|
||||||
| 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 |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| Spreadsheet Modeling and Decision Analysis Cliff Ragsdale provides instruction in the most commonly used management science techniques |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| Excel for Auditors by
Dwayne K. Dowell & Bill Jelen
|
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| Microsoft Excel Data Analysis & Business Modeling Wayne L. Winston, Microsoft Press 2004 |
|
||||||
| Business Modeling and Data Mining by Dorian Pyle |
|
||||||
| Data Analysis With Excel: An Introduction for Physical Scientists Les Kirkup CUP 2002. Very helpful for Engineering statistics |
|
||||||
| 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". |
|
||||||
| Spreadsheet Applications in Chemistry , Dermot Diamond. Illustrates how Excel can be used to help scientists process, analyze, and present scientific data. (1997) |
|
||||||
| 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. " |
|
||||||
| Excel Scientific and Engineering Cookbook by David M Bourg, real-world examples from disciplines such as biology, chemistry, and physics. 5-star reviews |
|
||||||
| 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. |
|
||||||
| 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. |
|
||||||
| Current bestselling books from Amazon.com | Yahoo! spreadsheet News | |
|
|
|
|
| and Amazon.co.uk: | ||
|
|
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)
