229 28 An Introduction to Optimization with Excel Solver. 217 27 Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes. 149 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions. 143 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions. 137 19 Using the Scenario Manager for Sensitivity Analysis. 121 17 Sensitivity Analysis with Data Tables. To participate in a brief online survey, please visit:ġ5 Three-Dimensional Formulas. What do you think of this book? We want to hear from you! Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. 49Ĩ Evaluating Investments by Using Net Present Value Criteria. Acquisitions Editor: Rosemary Caperton Developmental Editor: Devon Musgrave Project Editor: Rosemary Caperton Editorial and Production: John Pierce and Waypoint Press Technical Reviewer: Mitch Tulloch Technical Review services provided by Content Master, a member of CM Group, Ltd. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book. The information contained in this book is provided without any express, statutory, or implied warranties. This book expresses the author’s views and opinions. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. All other marks are property of their respective owners. Visit our Web site at Send comments to Microsoft and the trademarks listed at Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax (425) 936-7329. Microsoft Press books are available through booksellers and distributors worldwide. Library of Congress Control Number: 2010934987 ISBN: 978-0-7356-4336-9 Printed and bound in the United States of America. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. PUBLISHED BY Microsoft Press A Division of Microsoft Corporation One Microsoft Way Redmond, Washington 98052-6399 Copyright © 2011 by Wayne L. Microsoft Excel 2010: Data Analysis and Business Modeling ®