Winston - Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)

7th Edition

Wayne Winston

MICROSOFT EXCEL DATA ANALYSIS AND BUSINESS MODELING (OFFICE 2021 AND MICROSOFT 365), 7TH EDITION

Published with the authorization of Microsoft Corporation by: Pearson Education, Inc.
Copyright 2022 by Pearson Education, Inc.

All rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, request forms, and the appropriate contacts within the Pearson Education Global Rights & Permissions Department, please visit www.pearson.com/permissions.

No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-13-761366-3
ISBN-10: 0-13-761366-0

Library of Congress Control Number: 2021948290

ScoutAutomatedPrintCode

Trademarks

Microsoft and the trademarks listed at http://www.microsoft.com on the Trademarks webpage are trademarks of the Microsoft group of companies. All other marks are property of their respective owners.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an as is basis. The author, the publisher, and Microsoft Corporation shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the use of the programs accompanying it.

Special Sales

For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding interests), please contact our corporate sales department at or (800) 382-3419.

For government sales inquiries, please contact .

For questions about sales outside the U.S., please contact .

EDITOR-IN-CHIEF

Brett Bartow

EXECUTIVE EDITOR

Loretta Yates

SPONSORING EDITOR

Charvi Arora

DEVELOPMENT EDITOR

Kate Shoup

MANAGING EDITOR

Sandra Schroeder

SENIOR PROJECT EDITOR

Tracey Croom

COPY EDITOR

Scout Festa

INDEXER

Erika Millen

PROOFREADER

Abigail Manheim

TECHNICAL EDITOR

David Franson

EDITORIAL ASSISTANT

Cindy Teeters

COVER DESIGNER

Twist Creative, Seattle

COMPOSITOR

codeMantra

Dedication

To Vivian, Jen, and Greg. You are all so great, and I love all of you so much!

About the Author

Wayne L. Winston is Professor Emeritus of Decision Sciences at the Indiana University School of Business. He has also taught at the University of Houston and Wake Forest. He has won more than 40 teaching awards and taught Excel modeling and analytics at many Fortune 500 companies, accounting firms, the U.S. Army, and the U.S. Navy. He is a two-time Jeopardy! champion, and also is a co-developer of a player tracking system utilized by Mark Cuban and the Dallas Mavericks.

Introduction

Whether you work for a Fortune 500 corporation, a small company, a government agency, or a not-for-profit organization, if youre reading this introduction, the chances are you use Microsoft Excel in your daily work. Your job probably involves summarizing, reporting, and analyzing data. It might also involve building analytic models to help your employer increase profits, reduce costs, or manage operations more efficiently.

Since 1999, Ive taught thousands of analysts at organizations such as Abbott Labs, Booz Allen Hamilton consulting, Bristol-Myers Squibb, Broadcom, Cisco Systems, Deloitte Consulting, Drugstore.com, eBay, Eli Lilly, Ford, General Electric, General Motors, Intel, Microsoft, MGM Hotels, Morgan Stanley, NCR, Owens Corning, Pfizer, Proctor & Gamble, PWC, Sabre, Schlumberger, Tellabs, 3M, the U.S. Army, the U.S. Department of Defense, the U.S. Navy, and Verizon how to use Excel more efficiently and productively in their jobs. Students have often told me that the tools and methods I teach in my classes have saved them hours of time each week and provided them with new and improved approaches for analyzing important business problems.

Ive used the techniques described in this book in my own consulting practice to solve many business problems. For example, I have used Excel to help the Dallas Mavericks and New York Knickerbockers NBA basketball teams evaluate referees, players, and lineups. During the last 20 years, I have also taught Excel business modeling and data analysis classes to MBA students at Indiana Universitys Kelley School of Business, the University of Houstons Bauer College of Business, and the Wake Forest Professional MBA Program. (As proof of my teaching excellence, I have won more than 45 teaching awards and have won the schools overall MBA teaching award six times.) Also, I would like to note that 95 percent of MBA students at Indiana University took my spreadsheet modeling class even though it was an elective.