Effective Prototyping with Excel: A practical handbook for developers and designers

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $15.82
Usually ships in 1-2 business days
(Save 73%)
Other sellers (Paperback)
  • All (7) from $15.82   
  • New (4) from $36.35   
  • Used (3) from $15.82   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2009

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New Book from multilingual publisher. Shipped from UK in 10 to 14 business days.

Ships from: Fairford, United Kingdom

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2008

Feedback rating:


Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Batavia, IL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2007

Feedback rating:


Condition: New
Brand New Item

Ships from: Dover, NJ

Usually ships in 1-2 business days

  • Standard, 48 States
Seller since 2011

Feedback rating:


Condition: New
2009 Paperback New Book New and in stock. *****PLEASE NOTE: This item is shipping from an authorized seller in Europe. In the event that a return is necessary, you will be able ... to return your item within the US. To learn more about our European sellers and policies see the BookQuest FAQ section***** Read more Show Less

Ships from: Morden, United Kingdom

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


Although recognized as a key to the design process, prototyping often falls victim to budget cuts, deadlines, or lack of access to sophisticated tools. This can lead to sloppy and ineffective prototypes or the abandonment of them altogether. Rather than lose this important step, people are turning to Microsoft Excel® to create effective, simple, and inexpensive prototypes. Conveniently, the software is available to nearly everyone, and most are proficient in its basic functionality.

Effective Prototyping with Excel offers how-to guidance on how everyone can use basic Excel skills to create prototypes – ranging from narrative wire frames to hi-fidelity prototypes. A wide array of software design problems and business demands are solved via practical step-by-step examples and illustrations.

• Step-by-step guide to prototyping with a simple and affordable tool nearly everyone already has on their desktop.
• Quickly and easily allows web and software designers to explore usability, design alternatives, and test theories prior to starting production.
• Perfect companion to Effective Prototyping for Software Makers – with the same author team and full-color treatment, useful case studies, and hands-on exercises.

Read More Show Less

Editorial Reviews

From the Publisher
“Collaboration across marketing, design, engineering, and QA organizations is key to the successful creation of a new software product. The Excel prototyping method is the only approach I am familiar with that allows all these stakeholders the same platform for communication without having to learn lots of new tools.”
- Daniel Rosenberg, Senior Vice President, SAP User Experience

"It is always a challenge to find good tools for interactive rapid prototyping. The authors have created an excellent methodology that allows both novice and advanced user experience professionals to use their knowledge of common desktop tools to quickly illustrate and test their ideas for interactive products."
- Jeremy Ashley, Vice President, Applications User Experience, Oracle

Read More Show Less

Product Details

  • ISBN-13: 9780120885824
  • Publisher: Elsevier Science
  • Publication date: 1/8/2009
  • Series: Interactive Technologies Series
  • Edition description: New Edition
  • Pages: 240
  • Product dimensions: 7.40 (w) x 9.10 (h) x 0.70 (d)

Meet the Author

Nevin Berger is design director at Ziff Davis Media. Previously he was a senior interaction designer at Oracle Corporation and Peoplesoft, Inc., and has held creative director positions at World Savings and OFOTO, Inc.

Michael Arent is the director of user interface standards at SAP, and has previously held positions at Peoplesoft, Inc, Adobe Systems, Inc, MetaDesign,Sun Microsystems, and Apple Computer, Inc. He holds a number of U.S. and international patents.

Jonathan Arnowitz is a User Experience Architect at Google Inc. and is the co-editor-in-chief of Interactions Magazine. Most recently Jonathan was a User Experience Architect at SAP Labs and was a Senior User Experience Designer at Peoplesoft. He is a member of the SIGCHI extended executive committee, and was a founder of DUX, the first ever joint conference of ACM SIGCHI, ACM SIGGRAPH, AIGA Experience Design Group, and STC.

Read More Show Less

Read an Excerpt


A Practical Handbook for Developers and Designers
By Nevin Berger Michael Arent Jonathan Arnowitz Fred Sampson

Morgan Kaufmann Publishers

Copyright © 2009 Elsevier Inc.
All right reserved.

ISBN: 978-0-08-091671-2

Chapter One


In this chapter you will learn

* A case study

* The benefits of using Excel [R] for prototyping

* The productivity and collaboration opportunities

* Our goal in creating this book


If you are eager to dive immediately into Excel prototyping, skip ahead to the "How to create your first Excel prototype" section of Chapter 2, on page 16.

A Case Study

In an unnamed software company, long ago and far away, a developer learned that his product was going to have little access to the company's user interface design resources. This meant that he received no help with the design—only random, ad hoc advice from product stakeholders. The developer was concerned about his product's usability. He did not want to see his efficient coding wasted on a less than optimal user interface design. He heard that some user interface designers had set up a stealth prototyping service to assist developers who needed some unscheduled and unbudgeted help. How such a thing was possible he didn't know or care; he needed their help.

In desperation the developer went to the designers' Friday office hours. He thought he would need a whole day to mock up a prototype based on the functional requirements he had received. He was disappointed to hear that he would have only an hour of the designers' time and could not imagine that he might walk away with anything that resembled a codeable prototype.

At the prototyping office, the two designers explained that they would develop the prototype together; he would get enough direction so that he could do the rest himself. He could not believe it, but what could he do? He did not know any prototyping tools, nor did he have the skills to use such tools.

Much to his surprise, the designers opened Microsoft Excel and used a template file to implement his designs. The file looked like nothing he had ever seen in Excel before. The spreadsheet grid was changed into a layout grid, and the worksheets resembled software window layouts rather than spreadsheets. He learned in the session how, by using only copy and paste commands, the designers could quickly create his basic window layout. In fact, within the hour the two designers finished the work he needed and gave him an Excel file with his designs.

Back at his own office, the developer was satisfied with the results until he realized that there were some functions that had been neglected. At first he thought he had to wait until the next Friday for another appointment with the designers. But when he opened the Excel file and realized that, because he had used Excel before to create spreadsheets, he was very familiar with the software's features. With no more training than that short session with the designers, he started to add the missing functionality.

Within the Excel file he found worksheets with the widgets and buttons he needed and even a worksheet of instructions. He found it easy to copy buttons and to add fields and text. He made a few mistakes, but CTRL-Z always undid them. In fact, he learned, as with normal Excel use, that CTRL-Z undid and CTRL-Y redid multiple steps. This allowed him to make changes, back up, and go forward to compare his changes before committing to them. No one taught him this prototyping technique; he stumbled on it by exploring the skills he had already learned with Excel for creating spreadsheets.

After what he thought of as playing around, he realized that he had put the finishing touches on his prototype and had something to show product management. Without thinking about it, the developer became an Excel prototyper and had produced a good enough prototype of his application screens within an hour.

This book will share with you this developer's experience with the simplicity and ease of Excel prototyping. Having worked in many companies and seen how using Excel as a prototyping tool helped designers, developers, and product managers better express their requirements, we feel that we have the experience with Excel prototyping to empower you as well.


This book is about how to prototype with Excel (or another spreadsheet application with similar functionality).

This book will also touch lightly on the larger topic of prototyping. Although the book does not attempt to completely cover the topic of prototyping, it will discuss prototyping as it relates to prototyping with Excel. For a comprehensive discussion on prototyping, we refer the reader to our first book, Effective Prototyping for Software Makers.

Excel is an amazing prototyping tool. It is amazing because it is the only tool we know that combines these advantages into a single tool:

* Prototyping flexibility

* Efficiency and ease of use

* Professional results

* No special skills required

* Readily available

Excel Prototyping

"Using Excel for prototyping? I don't get it!"

This is a common reaction from people when we first try to describe prototyping with Excel. The concept is far from what you use Excel for in your daily work. For some it is like claiming that their washing machine can mow the lawn. People cannot visualize how it can be done until they see it.

When you look at Excel, you probably just see a spreadsheet; you just can't think outside the table cell. To understand Excel as a prototyping tool, you will have to step out of the mental model that says Excel is only a spreadsheet application. This book will show you how.

Prototyping Flexibility

As a prototyping tool, Excel is not only easy to use, it is quite flexible for the various methods of prototyping. You can create static screen wireframes, screens with click-through interaction and navigation, and even prototypes that can be optimized for different types of usability testing.

To illustrate what we mean, the following images are prototypes created in Excel. You can experience these prototypes for yourself by visiting the book's Website and downloading each of these examples as native Excel files: www.effectiveprototyping.com/ep_excel/.

An interaction flow diagram in Excel, which might be the most basic visualization of a software concept, is illustrated in Figure 1.1.

Storyboard Prototypes

A storyboard is a narrative prototype, usually created in the early stages of the software-making process, to articulate business and marketing requirements in the form of a usage scenario or story. These stories narrate the user actions needed to perform tasks as specified by marketplace, customer, and user requirements. These requirements are interpreted into a scenario before the storyboarding process begins. Because requirements drive the storyboarding process, they provide early insight into what users, the software, and the system are meant to do in conjunction with each other. The primary goal of a storyboard is to align the design team's thinking to the goals and behaviors of the software, regardless of the screen design.

Figure 1.2 is an example of a storyboard in which an interactive narrative is shown through text and images. The user interface design embodied in an Excel prototype reflects this narrative as you click from one screen to another, with each screen contained in a worksheet.

Wireframe Prototypes

A wireframe is a narrative prototype, usually created in the beginning of the design process. The narration is usually derived from a use case or scenario, often the same scenario used in a storyboard. This prototype shows flowcharts, high-level sketches visualizing conceptual assumptions about the product structure and general interaction. The primary goal of this method is to get a design team to agree on basic concepts.

Figure 1.3 shows a rough wireframe of a Website that was created in minutes. This tool allows functional and rough conceptual issues to be separated from the detailed, more precise designs that should come later.

Figure 1.4 shows a medium-fidelity wireframe that evolved from the rough wireframe shown in Figure 1.3. The design of a medium-fidelity wireframe can help establish a visual design direction. It can also show a more evolved concept that includes interaction. As a result, stakeholders get a better idea of the design commitment without your prototyping a finished product.

Figure 1.5 shows a similar design to the previous two figures but with higher visual and content fidelity, to serve as the specification.

Paper Prototypes

A paper prototype is an interactive prototype that consists of a paper mockup of the user interface. The interface represents a fully functional interface that allows you to usability-test a design. The intended audiences are targeted users who test the design and the software makers who use the prototype as a means to implement the software.

Digital Interactive Prototypes

A digital interactive prototype is a digital version of a paper prototype. Interactive prototyping shares the same objectives as paper prototyping; that is, they can both be used to

* Understand task flow and context of use

* Validate assumptions in scenarios, requirements, and user profiles

* Shape task sequencing and interaction design direction

* Evolve prototypes from early rough sketches to the next level of detail

* Validate a visual design direction

Figure 1.6 shows that Excel can also be used to create interactive prototypes of list-driven products such as email clients.

Figure 1.7 shows that Excel can also be used to prototype interactive business software. Notice the drop-down list, which was activated by a user clicking on the menu button.

Excel can also be used to prototype a range of designs, from Windows applications to AJAX-enabled Websites. Figure 1.8 (page 14) shows an example of a Windows application prototyped in Excel.

Efficient and Easy

By using Excel, the user can quickly and easily create user interface prototypes. The results are both quick and professional looking. We know of few other tools that offer this level of quality for a minimum of effort. Nearly all the effort involves using features that you probably already know: cut, copy, paste, cell formatting, and so on.

Professional Results

Regardless of the level of prototyping, Excel's adapted layout grid ensures that you get professional-looking layouts. Field alignment and spatial distribution have never been easier. Applying company colors and graphics can also be automated, allowing you to leverage the work of professional designers in your company to achieve professional-looking results.

No Special Skills Required

Prototyping in Excel requires only the use of basic desktop and Excel functionality. You can create forms, tabs, and tables using simple cell formatting. You can create 3-D borders for buttons or input fields simply by using cell borders. Field length can be changed via drag and drop or copy and paste. The only mental shift required is to stop thinking of the Excel grid as a spreadsheet, instead thinking of it as a graphics layout grid.

Readily Available

If you want your prototyping process to empower your software makers, you need a tool that everyone can use. Excel is a readily available tool; it is frequently included on business computers. For the few of you who don't have Excel, there are alternatives such as OpenOffice, available for free, that put 90 percent of the techniques from this book to use, although some commands will differ.

Still Not Convinced?

As we start to explain the process of prototyping with Excel, you will eventually understand how it is done. The figures in this chapter help, but you might need some quick, hands-on experience, which we cover in the next chapter.

At our tutorials and seminars at PeopleSoft, Ziff Davis Media, Google, and SAP Labs, we encountered the same doubt. After our demonstrations, the results were the same at all these venues: Excel became an important tool in the audience's prototyping toolbox. This is not to say that Excel is the essential tool; Excel does not fulfill all prototyping needs. But for basic wireframes and digital interactive prototypes, Excel is an efficient tool you will not want to be without.

Who Should Consider Using Excel?

This book is for anyone who needs to prototype an interface for desktop software or the Web. It is intended not only for designers but for anyone who is part of the soft-waremaking process. Software makers include the full range of participants, from people with extensive graphics experience to those with little or no graphics background.


Excerpted from EFFECTIVE PROTOTYPING WITH EXCEL by Nevin Berger Michael Arent Jonathan Arnowitz Fred Sampson Copyright © 2009 by Elsevier Inc. . Excerpted by permission of Morgan Kaufmann Publishers. All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.

Read More Show Less

Table of Contents

Chapter 1 – Preface – A Developer’s Dilemma
Chapter 2 – Getting Started – Your First Excel Prototype
Chapter 3 – Basics – The Excel Prototyping Canvas
Chapter 4 – Creating an Excel Prototyping Template
Chapter 5 – Excel Prototyping - Storyboards
Chapter 6 – Wireframes
Chapter 7 – Digital Interactive Prototypes
Chapter 8 – Iterating Prototypes with Excel
Chapter 9 – Communicating Your Design in Excel
Chapter 10 – Sharing Your Excel Prototype
Appendix A – Useful Techniques with Excel
Appendix B - Nevin Discovers Excel as a Rapid Prototyping Tool

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)