`
`CiM Ex. 1051 Page 1
`
`
`
`Microsoft®
`Excel 2000 Bible
`
`John Walkenbacb
`
`-1\1indw
`
`Best,S;;,!Ung Sooks • Digital Download5 • e".Books • Answer NE-tvvorks • e""Newslett,1rs • Branded Web Site.s ·"'"Learning
`
`NewYork,NY + Cleveland,OH + lndianapo!is,iN
`
`emnosUSA0016621
`
`CiM Ex. 1051 Page 2
`
`
`
`Corporation, Inc., for the Philippi:nes; by
`
`Microeoft' Excel 2000 Bible
`Contemporanea de Edkkmes for Venezuela; by
`Publ.lshed hy
`
`
`
`Express Computer Distributors for the Caribbean and
`Hungry Mm.di,. Inc.
`West Indies; by Micronesia Media Dlst:ributor, lnc. lo.r
`009 Third Avenue
`
`M!cron,.,sla; by Chips Computadoras S.A. de C.V. !or
`New York, NY W022
`
`Mexico; by Editorial Norma de Panama S.A. for
`';/WW. hungryrii ncts .con
`
`
`Panama; by American Bookshops for Finland.
`
`Copyright�') 19�) Hungry Minds, Inc. All rights
`
`For general lnformatlon on Hungry Minds' products
`
`reserv(Ki. No pa.rt of this book.. indudlng interior
`
`
`
`
`and services please contact our Customer Care
`design, cover design, and Icons, may be reprodtK:f.',d
`
`Department within the U.S. at 800-762-2974, outside
`
`or trl'l11s1nitt€d in any lonn, by any means (eiedronic,
`
`the U.S. at 317-572-3993 or fax 317-5724002.
`
`
`
`photocopying, recording, or otherwise) without the
`
`
`
`
`For sales inquiries and reseller iniormation, io.clu<lirrg
`
`prior written permission of the publisher.
`
`
`discounts, prn.mium and bulk quantity sales, and
`Library of Congress Catalog Card Nurnber; !18-7537�,
`
`
`foreign-language translations, please contact our
`ISBN: Q..7645-3259-6
`
`
`Cu.'ihimer Can; Department at 80[)434-3422. fax
`
`
`Printed In the United States of America
`
`
`317-572-4002. or write ta Hungry Minds, Inc .. Attn:
`
`
`Customer Care Department, 10475 Crosspoint
`109876
`
`Boulevard, !ndianapolis, IN 46256.
`lB/RV /QW I QR/lN
`
`
`
`For· information on licensing foreign or domestic
`
`Dlstrlbuted In the United States by Hungry Minds, Inc.
`
`
`
`
`rights, please contact our Suh-Rights Customer Care
`
`Distributed by COG Books Canada Inc .. for Canada; by
`Department at 212-884-5000.
`
`
`Transworld Publishers Limited ln the United Kingdom:
`
`For authorization to photocopy items for corporate,
`
`
`by 100 No:rge Books k,r Norway; by 100 Sweden
`
`
`
`ilet'sonal, or educational use, please contact
`Books for Sweden; by IDG Books Australia Publishing
`
`
`Copyright Clearance Center, 222 Rosewood Drive.
`
`Corporation Pty. Ltd. !or Australia and New Zealand;
`
`Dru1vers, MA 0192.3, or fax 978-750-4470.
`
`by TransQucst Publishers Pte Ltcl. for Singapore,
`
`
`
`Fol' information on using Hungry Minds' pr<Jducts and
`
`
`
`Malaysia. Thailand, Indonesia, ,1nd Hong Kong; by
`
`
`
`services in the classroom or for ordering examination
`
`Gotop Information Inc. for Taiwan; by ICG Muse, lnc.
`
`<:oples. please contact our Educational Sal('.S
`for Japan; by lntersoft !or South Africa; by Eyrnlk�s
`Department at 800-434-2086 or fax 317-572-'1005,
`
`for France: by [nt(ornational Thomson Publishing for
`
`Gennany, Austria and Switzer.land; by Oistrlbuidora
`Please contact our Public Relations Department at
`
`Cuspide for Argentina; by LR International for Brazil;
`
`
`2 l 2-334-5163 for press review copies or 2 l 2-884-5000
`
`
`
`
`by Gallleo Llbros for Chile; by Ec\iciones ZE'f/\ S.C.R
`
`
`for author Interviews and other publicity Information
`
`Ltda. for Peru; by WS Computer Publlshlng
`or fa.,; 212--884-5400.
`:LIMIT Of LIABJUTY/DISCLAIMER OF WARRANTY: THE PUBUSHER AND AUTiiOR HAVE USF.D THEIR
`
`
`l BEST EFFORTS IN PREPARING THIS BOOK. TiiE 'PUBUSHER AND AUIHOR MAKE NO
`
`i REPRESE,"llTATIONS OR WARRANTIES WITH RF..sl'ECl' TO THE ACCURACY OR COMl"LETENESS OJ' THE
`)CON'TF.J\TI OF THIS BOOK AND SPECll-'lCALLY DISCLAllf ANY IMPLIED WARRANTIES OF
`
`i MERCHAI•ffABILITY OR FffNFSS FOR A PARTICULAR PURPOSE. THERE ARI: NO WARRANTIES WHICH
`NO WARRA!'1ffY MAY BE
`DFSCRIPTIONS CONTAINED IN nus PARAGRAPH.
`i EXTEND BEYOND THE
`l CREATED OK EXTE.1'!1!DED BY SALE'S REPRESFNL-'\'.flVES OR WRITilffl SALES MATERIAlS. Tilli
`I ACCURACY AND COMPLETENESS OF UIE INFORMATION PROVIDED HEREIN A.l\JD nm OPINIONS
`I STATED HEREIN ARE NOT GUARANTEED OR WARRANl'ED TO PRODUCE ANY PARI1CULAR RESULTS,
`
`
`l AND THE ADVICE AND STRATEGIE.5 CONTAINED HEREIN MAY NOT HE SUITABI.E FOR EVERY
`
`FOR ANY LOSS Of. PROH'f OR! INDIVIDUAL NEITHF.R THE PUBLISHER .NOR AUTHOR SHALL BE LIABLE
`
`
`i ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED TO SPECIAL, INCIDEN'l'AL,
`
`I CONSEQUENTIAL, OR OTHER DAMAGES. FllLFU.LMENT OF EACH COUPON Off'F.R IS THE I
`! KESPONSJBILf
`IY OF THE Ofi"EROR.
`I
`-
`
`
`
`
`
`Trademarks: Mlcms<lft Is a registered trademark of Microsoft Corporation In the United States and./or other
`cotmtries. The MlndSprlng logo is a trademark of MindSprl.ng Enterprises, Inc. Netscap(i Cornmunlcator is a
`
`
`t,adematk, and th(, Netscape N logo Is a registered trademark of Netscape Communkations Corp,orntlon In
`
`
`
`
`
`the United StatL'S and other countries.All brand names and product names used in this book are trade names,
`
`
`
`
`
`service marks, trademark.�. or registered trademarks ui their respective owners. Hungry Minds, Inc. is not
`
`associated with any p:rodtK1: o.r vendor mentioned in this book
`
`
`
`,
`
`,
`
`,_]
`
`,
`
`,
`
`
`
`
`
`__ __ _____ ___ ___
`
`
`
`HUIISl'Y Mi.nds- is a trademru:k of Hungry Minds, ln.:.
`
`
`
`-
`
`CiM Ex. 1051 Page 3
`
`
`
`About the Author
`
`John Walkenbaeh is one of HH! country's foading authorities on spreadsheet
`
`
`
`
`software. He holds a Ph.D. from the University of Montana and has worked as an
`instructor, programmer, and market research manager. He finally found a job he's
`
`
`good at: principal of JWalk and A.5sociates Inc., a one-person San Diego-based
`
`
`
`consulting firm that specializes in spreadsheet application devoelopment. John is
`
`
`also a shareware developer, and his most popular product ls the award-winning
`Power lltllity Pak add-in for Excel-which is used by thousands of people
`
`
`
`
`
`t.hnmghout the world. John started writing ahout spreadsheets in 1984, and he
`has since written mrn·e than 250 articles and reviews for publications such as
`
`PC World, InfoWorld, Windows PL'/Computing.
`magazine, and
`ln addition, he's
`the author of a dozen other spreadsheet books, including Excel 2000 Power
`
`
`Programming Techniques, Excel Programming fiJr Dummies, and Excel 20()() For
`Windows For Dummies Quick Reference
`
`(all from IDG Books Worldwide), In his
`
`
`spare time, John enjoys digital photography and composing and playing music in
`
`
`
`
`a variety of styles. John aiso maintains "The Spreadsheet Page" on the Web. Pay
`
`him a visit at http:/ i www, j -w a 1 K. com.
`
`emnosUSA0016623
`
`CiM Ex. 1051 Page 4
`
`
`
`Credits
`
`Acquisitions Editor
`David 1v1<:tvJ1e1,v
`
`Development Editors
`Brown
`Vaiet'ie
`1'.envon Brown
`
`Technical Editor
`Bm Karow
`
`Copy Editors
`Anne Friedman
`BHI McManus
`
`Cover Design
`Murde:r By Design
`
`Production
`Foster City Production Department
`
`Proofreading and Indexing
`York Production Services
`
`emnosUSA0016624
`
`CiM Ex. 1051 Page 5
`
`
`
`To foRene
`
`emnosUSA0016625
`
`CiM Ex. 1051 Page 6
`
`
`
`E.
`
`,
`
`-.vr.vu;'.uI.\9\9n:':m.;A~>vt:'«e¢<,-39>.
`
`.
`
`CiM Ex. 1051 Page 7
`
`emnosUSA0016626
`
`CiM Ex. 1051 Page 7
`
`
`
`
`
`
`Thanks for
`
`the Microsoft E.xcel 2000 Bible --- your cc,rnplt,te
`powerful and easy-to-use spre,HH.tu~et pn,KHJct
`
`to a
`
`rne ---
`program on the market
`l think that Excel 2000 is the best.
`in various incarnati.ons
`for almost a
`l 've used them
`Excel has been arountl
`the
`a bit
`decade, and each
`release
`this book is to share with
`in
`farther-in
`some cases. a Jot further. My
`you some of what i know about Excel, and in the process make you more efficient
`on the job.
`
`'·"""'"'"H,in,, that you need to kn.ow to learn the basics of Excel
`The book contains
`topics at your own pace. You find rnany useful
`and then move on to more
`and sHck
`that J've accumulated
`exan1pJles as well as some of the
`over the years.
`
`This Book for You?
`
`is
`The Bible series from lDG Rooks Worldwide
`and advanced users, This book covers ali the essential
`provides dear and
`that you can
`
`intermediate,
`for
`of Excel and
`{:Omponents
`to your own needs.
`
`E~cel can be used at many levels--
`balance here,
`10,now1n14 answers
`
`from the
`on the
`this
`
`to the ex1t:ren1t~1vcorm,1ex. I've
`that are most useful to most
`ls tor you:
`
`If you're new to the world of
`to the fold. This book has
`welcome
`that you need to get started with Excel and then advance
`to other topics
`""·'"'r'ut1~1n,o
`as the need arises.
`
`Ye.s -
`
`If you have used previous versions of Excel
`
`going to feel
`at home with Excel 2000. if
`used Excel 97,
`If
`and moving up from Excel 5 or Excel 95, you have lots to
`sk11,1>in1g a few
`has made many
`past few years,
`in
`learn, because
`any case, this book can get you up to
`
`emnosUSA0016627
`
`CiM Ex. 1051 Page 8
`
`
`
`Ye-s-
`
`lf you have used Excel for the Macintosh
`
`simUar to the Windows versions .. U
`find some
`information
`moving over frorn the Mac
`as well as
`details
`to make your transition as smooth as possibh~.
`
`Yes- U' you have used DOS versions of l-2-3 or Quattro Pro
`
`Pro
`a text-based spre;:1{1:smeet such as 1-2-3 or Corers
`If you're
`In favor of a more modern
`product,
`this book can serve you well. You
`are an about, and
`have a head start, because you
`know what
`discover some great new ways of
`things.
`
`Yes-If
`
`you have used "Windows versions of 1-2-3 or Quattro Pro
`
`to go,
`that Excei is the
`If you've tried the other versions and are convinced
`a great
`it has
`this book quickly teaches you what Excel is aU about and
`reputation. Because
`already familiar with Windows and spre,adsheets, you
`can breeze through many In1:rodl!Ctorv
`
`Software Versions
`
`but much of the
`This book is written for Excel 2000 (also known as Excel
`If you use any version of
`information
`also
`to Excel 97, E,,'l.:cei
`and Excel
`Excel prior to Version 5. be aware that the earlier versions are
`different
`from the current version.
`
`Conventions Used in This Book
`
`t() scan thls section
`Take a minute
`that are us,:d in this book
`
`to !earn some of the ty1pogr,:1phi<:al convent.ions
`
`Named Ranges and Your Input
`in boht Named ranges may appear
`Jnput that
`type from the
`appears
`appears on a separate
`line. For in.stance. I n1ay
`in
`cod€
`Lengthy
`instruct you to enter a formula such as the tn11n,.MirHJ·
`
`="Part Name: • &VLOOkUP(PartNumber,PJr
`
`t,2)
`
`----------------------------------···-·----·---~---
`
`emnosUSA0016628
`
`CiM Ex. 1051 Page 9
`
`
`
`Key Names
`Narr1es of the
`be n"'""'"'"".-1 siinuJtiHH::rn.1sly,
`Alt+E to seiect the
`
`in normal
`appear
`!r,c,vh,n~,.-rl
`a.re connected with a
`
`When two
`like this:
`i.n the book:
`to them
`
`Alt
`
`down arrow
`
`End
`
`Lock
`
`Home
`
`Ctrl
`Delett,
`
`fnsert
`left arrow
`
`:\Ium Lock
`Pause
`PgDn
`PgUp
`Print Screen
`
`arrow
`Scroll Lock
`Shift
`Tab
`up arrow
`
`Functions
`Excel's buHt-in worksheet
`in cell C:W.
`formula
`
`functions appear
`
`in uppercase,
`
`like this: Enter a SUM
`
`Mouse Conventions
`I assume
`that
`a mouse or somt! other pointing devlce. You come across
`tenns:
`some of the following mouse-related
`+ Mou.se pointer: The small graphic. figure that moves onscreen wheri you
`an arrow, but It chan1s?es
`move your mouse. The mouse pointer
`is
`when you move to certain areas of the screen or when
`certain actions.
`n<>,rtr·,rrrnr1<1
`+ Point: Move the mouse so t.hat the mouse pointer
`CXiam1ph~, ''Point to the Save button on the·toolbar."
`+ Pre:SS: Press
`used when dr,asH;{ini;;.
`• Click: Press the left roouse button once and .release it im1n(c:diatt~ly,
`+ Right-click: Press the
`button once and release 1t ImrrH~diat,~ly
`The
`button
`is used in Excel to pop up sho.rt.cut menus that are
`for whatever
`is
`selected.
`~nnr,,n,ri,~t"
`+ I>ouble--cU.ck: Press the left-rnouse button
`cto,ul:}1e-clic}(ing doesn't seem to be
`the Windows Control
`·+-Drag: Press the left-mouse butlon and keep it
`while you move the
`is often used to seJect a range ot cells or to
`the size
`mouse.
`of an '"'"l''"""·'·
`
`is on a speciitic item. For
`
`It pr,esi,ec:L NonnaUy, this is
`
`twice in rapid sm::cesslon, If your
`you can
`the double--click
`icon.
`
`emnosUSA0016629
`
`CiM Ex. 1051 Page 10
`
`
`
`What the Icons Mean
`
`'"' ..... ,,....,,~;,~ svff1l:)ols. or icons, in the left m,:1r~rin.
`Ttiro•ull'h(mt the book, you see soecial
`These call your attention
`to
`that are
`important or relevant to
`suecJ.tlc group of readers. The icons in this
`are as follows:
`
`This
`
`denotes features that are new to Excel 2000.
`
`is important or worth
`This icon signals the fad that ,:;:n,;rn.,,th,ina
`alert you to a
`that
`you to master the task at
`something that
`to
`
`This may
`or it may denote
`m.ateriat
`
`This icon marks a more efficient way of
`
`something that may not be obvious.
`
`This indicates that the material uses an ex,1m1ole file located on this book's com(cid:173)
`panion CD-ROM.
`
`I use this symbol when there is a possibility that the ooera1tic,n I'm describing
`if
`could cause problems
`not careful.
`
`This icon indicates that a related
`
`is discussed elsewhere in this book
`
`How This Book Is Organized
`
`Notice that the book is divided
`
`into six main parts, followed
`
`four ap1p,:!nclix,es.
`
`Part I: Getting Started - This part consists of three
`that provide
`background
`about Excet
`in Excel 2000,
`2 describes
`the new features
`Chapter 3 is a hands-on
`lour of Excel, which
`new users an onmcirtunitv
`to get the.ir feet wet immtcdiatt~Jy
`
`chapte!"B in Part H cover
`Part II: Introductory Concepts-The
`with which all Excel users should be farnililar.
`
`the basic concepts
`
`part consists of six d1apte1rs diea.itn,g with
`Part III: Advanced Features-This
`topics that are sometimes considered
`advanced.
`and intermediate
`users may find this information useful, as welL
`
`is the focus of the
`of data
`broad
`Part IV: Analyzing Data-The
`in Part IV. Users of all levels will find some of these chapters of interest.
`chapteirs
`
`emnosUSA0016630
`
`CiM Ex. 1051 Page 11
`
`
`
`part consists of thn~t! cl:11arite:rs
`Excel with other ap1pt1crati«Jn&., audlltiag
`chapte1·s deal with
`ex1pk:1rir1g the
`slde of L"cel
`
`Part VI: Customlzing Excel-Part
`their own use or who a.re
`others.
`It's a good .introduction
`
`to
`
`VI is for those who want to customize Excel for
`workbooks Of' add-Ins that are to be used
`Basic for Ap1pIJica.Uo1ns
`
`appt::rn1i;ll:,es consist of supr>len1,enta! and reference material
`Appendixes.-The
`may be useful to you.
`
`that
`
`How to Use This Book
`This book is not int.ended to be read cover to cover. Rather, ifs a reference book
`that you can consult when:
`+ You're stuck while trying to do something.
`• You need to do something
`that you've never done before.
`+ You have some time on your hands, and you're interested
`something new.
`typically focuses on a single
`and each chapter
`The index is quite comprehensive,
`starting out with Excel, I recornmend
`that
`read the
`broad topic. lf
`first three
`,l basic understanding
`of the product,
`then do some
`familiar with Excers environment,
`
`exnE~r:i,TH'!il! ,ng on your own. After
`become
`you can refer to the
`that interest you the most. Some users, however, may
`to follow the chapters
`in order. Part U is designed with these users in rnind.
`
`in learning
`
`is over your head, Most users get
`if sonie of the material
`Don't be
`rule
`a small subset of Excel's total
`In fact, the
`fine using
`applJles here: 80 percent of Excel users use
`20 percent of its features. However,
`20 percent o.t E'!:<:el's features still
`you lots of power at your
`
`About the CD-ROM
`
`this is true for rnany other oeor,J,ae. i:c,ns,ec1rn~nt:1y,
`ex,:i.mpl<::s in this book. These ,e.,.,:1.u1µ1s:::
`
`Appendix D describes
`
`the inaterial on the CD-ROM.
`
`emnosUSA0016631
`
`CiM Ex. 1051 Page 12
`
`
`
`Power Utility Pak Coupon
`
`·rowa:rd the back of the book,
`of
`Power
`Pak software-a
`W()rksh•eet functions .. This product
`available
`to readers of this book for
`ctevel.ooed this
`using VEA
`are aJso available for
`who want to learn
`
`that you can :redeem for a copy
`find a coupon
`coHection of useful Excel utilities and new
`but rm
`it
`and ha.ndlin~.
`:source mes
`
`I think that the Power
`Excel, and l urge you to
`
`extrem<~ly useful in your lia·v-t,r'rf1,avwork with
`adva.11ta11e of this offer.
`
`Contacting the Author
`rm
`
`to hear from readers of my book.."> .. 'fhe best way to contact me is
`Inten1.et address:
`follnv'fin2
`
`j ohn@j we ·1 :<. com
`
`l get lots of e-mail, so I can't promise a personal
`
`sit 18The Spreadsheet Page''
`
`even more information on :Excel, be sure t.o check out "'The .Sure.cid:;hi~et
`on the World Wide Web. The URL ls:
`
`http://www.
`
`-walk.com/ss/
`
`emnosUSA0016632
`
`CiM Ex. 1051 Page 13
`
`
`
`k owledgments
`
`to everyone at IDG Books Worldwide who played a part
`Thanks
`into your hands.
`Brown and Valerie
`thanks
`to
`able assistance,
`away at my lrnvhnan-1.
`
`I'd still he
`
`in n~,t·+in,~
`
`this book
`
`t!1r(mia;rticiut the world who have taken the time to let
`Thanks also to an the "'"'''",...1"
`My goal is to writ€ books that go
`me know that rny books have made an
`wdl
`the material
`found in
`books. Based on the feedback
`that
`not be the n1ost
`!'ve received,
`I think I'm
`software books
`but I can't think of
`else I'd rather he
`
`emnosUSA0016633
`
`CiM Ex. 1051 Page 14
`
`
`
`
`
`..w._%,«fa»
`
`,,Y.,7»d
`
`.3:V,._..,1u:,«...4....s_.,?.._.‘.é.._séizw
`
`,
`
`CiM Ex. 1051 Page 15
`
`emnosUSA0016634
`
`CiM Ex. 1051 Page 15
`
`
`
`
`
`
`••
`
`• •••••••••••••••••
`
`ta
`
`*&••••~•
`
`I
`
`••••@@•••
`
`•••
`
`Preface
`
`,, ........ ,ix
`., ...................
`"' .....................................................................
`...............
`..... ., ............................... ., ......................... ,, ................................. ,. ..... xiii
`
`Part I: Getting
`., .......... ., ...•.. ,. ...................... 3
`I: A Bit of Hacki{rn,un.<1 .............................................
`et1apter
`Chapter 2; \\/hat's New in f:.xce] 2000:'
`.............................................
`,, .......................... 15
`Chapter 3:
`with Excel ....................................................................
`21
`Part n: lntrodudory
`.43
`Lnaprer 4: N.avi!l:atim? TJ:1rottgh Excel ... ,, ............ ., ........... , ... ,, ........................................
`cna.!)ter 5:
`with Ftlf:'.s and Workbooks
`., ....................................................
`,. .. 71
`........................................................ 9:I
`~'"·"'"!-'"'-' 6:
`and
`Worksheet Data
`Chapter 7: Essentrnl
`Operations
`............................................................
`121
`Chapter 8: \Vorking with Cell
`......................................................................
`, .. 1;39
`'"'""'P~"" 9:
`and Using Formulas
`.............. ., .........................................
`,, ........ 169
`10: Using Worksheet FuncU.ons
`...... ., ....... .., ....... ., ........................................ .,199
`'-'"<.I.P"-·"
`Chapter 11: Worksheet
`.................. "' .......................
`,. .......................
`,. ..... 235
`cnapter 12:
`Your Work
`.............
`.. ............................. ., .. ., ......................... 268
`13:
`Basics
`............................................
`,. .................................. 283
`,.,uapvc,
`14: tuha:nclng Your Work with Pictures and
`.................. ., .......... 317
`uiar,ter
`Chap:ter 15:
`........... .-.................................................................. :343
`
`Part
`
`Chanter 19: '--·"""'"ls
`"-·"'"!-'''"'··' 20: Cn~ating
`C11.apter 2 i:
`
`, ....... ~363
`................. .,,. ......................................................
`.4-0S
`............ ,. ........................................
`J\,ficrosoft
`Worksheet Outlines
`.,. . " ... .A29
`co,nsollrtaUng
`\Vorksheets
`.................................................... 441
`Array For.mu.las
`...................................................... 457
`.................. ., ............. 479
`
`" .. 491
`................................................
`Ch.aoter 22: Importing Data frorn Other Sources
`U1;')pter 23:.
`With Lists ....................................................................
`., ............... 51
`Chapter 24:
`Database Files
`................................................................... 539
`u1apter 25:
`Data with Ph1ot Tables
`.........................................................
`559
`Ch,:1..pt1:!r 26:
`WhaNf
`....... ............
`. .... .595
`Chapter 27;
`Goal
`Solver
`.................................. 617
`.................................................. 6:19
`Chapter 28: Ana1vzm:ll Data with Analysis ToolPak
`
`emnosUSA0016635
`
`CiM Ex. 1051 Page 16
`
`
`
`Part V: Other Topics ~ .... , ........ n•••····'··········••n•u••••••••••••u-•,••····~········"'·············~n••HVQ.JI
`Ci11aoter 29:
`Data with Other
`... ,. ..... ., ........... ,,.,..,. ... ,." .. •·""'·"665
`Cll1apt.er 30: Excel and the Internet
`,, ...........................................
`, ........... " .................. .,685
`31:
`Your Worksheets Error~Free
`.............. .,,. ................ ., ................ .,699
`\AJ1au,1i:::i
`, ............ , ................... ., ..... , ............................ """'""············"'·'''''"'' 715
`
`
`Part Vt Customizing Excel .........• , ............ ,. .................. ., ............................ , .......... ,·""::ti!
`Chao·t.er 33: Customizing Toolbars and Menus
`........... ., .. rn,
`•••• 731
`Chapter 34: Using and Creating Templates
`... ,," ............................... .., ... ,, .... , ............. 747
`Chapter 35: Using Visual Basic for Applications
`.............................................. ,, ...... 755
`Chapter 36'. Creating Custom Worksheet Functions
`................................................
`785
`Chapter 37: Creati.ng Custom Dialog Boxes ................ ., .. ,. .......................................... 801
`:18: Using Dial.og Box Controls
`Chapter
`in Your Worksheet:
`................................ ,. .... 823
`Chapter 39; VBA Programming Examples
`................. ., .................. ., ........ ,. ....... , ....... 839
`Chapter 40:
`Custom Excel Add-Ins
`.................... ,. . .,. ................ ,, .................. 857
`
`....
`
`,,.
`
`..
`
`rn,.,
`
`....
`
`, .......
`
`,,,,.,.
`
`............ ,. ........ ,. ..................... ,. .......... , ....... 871
`Appendix A: Using Online Help: A Primer
`Appendix B: Worksheet
`function Refe.rence .................... ,. .. ,. .................................... 881
`Appendix C: Excel's Shortcut Keys ................ ., ................. ,. ..... ., ................................. 897
`Appendix D: What's on the CD-ROM .................. "'"""'""'"""""'"""""'""'""'""'"""'"""'''"905
`Index ...................................................................
`,, ................. , ......................... , ............... 915
`End..:LJser License Agreernent
`, ..... , ....... , ...... 937
`, ..................................................................
`CD-ROM Installation
`Instructions
`.......................... ,. .. ,. ................................................. 94:s
`
`emnosUSA0016636
`
`CiM Ex. 1051 Page 17
`
`
`
`ntents
`
`Acknowledgments .......... , ..•••. ,. .............. -,. ........ ., .........................................................
`,uu
`
`..................................................
`
`Chapter 1 : A Bit of Background
`, .............. :1
`What Is Excel"? ..... " ..................................... ., ..............................................
`The Evolution of Exce:i .............................................. ., ... ., ........................................ 4
`Excel 2 ............... " .................. ., ............................................................ ,. ............. 4
`Excel 3 ............... ,,. ...........................................................................................
`,,4
`Excel 4 .......... ., ............................................................................................
`.,"'.4
`Excel 5 ..............................................................................................................
`4
`Excel 7 .... ,. ..........................................................................................................
`4
`Excel 8 ............... ,, .............. ., ................... ,, ............................................................ 5
`Excel 9 ..................................................
`, .. w,
`., .. S
`..................................................
`E.xcers Competitors
`............................................................
`,, ...... .,,, . ., ..................... ,,.5
`\Vhat Excel Has to Offer
`......................................................................................... 5
`-6
`!v1uitisheet Files
`............ ., ............. ,. .............. H
`M1ultiplle Document
`foterface
`...............................................
`" ........................... v
`File
`................................................
`" ......................................... 7
`Interactive HeJp ....... '° ............
`7
`.,.............
`r.asv'-Hl-LJSe Features
`......................................
`,,.,, ............................................. 7
`Ma.na:C[erne11t " ...................... ., .................................................................. 7
`Built-in Functions
`........................................................................
`, ............ ., .... 8
`Custo1n1zab1e Tool bars
`...................................................................................
`8
`Flexible Text Handling
`....................................................................................
`8
`Rich Text Formatting
`........................................................................................ 9
`Great Ch.arts
`.......................................................................
`., ............................. 9
`Integrated
`l'vlapplng ............ ,, ................................................................................ ~!
`Drawing Tool5 ...........................................
`,. ........................................................ 9
`Worksheet
`...................................................................................
`.
`Pivot Tables ............................................................................................
`, ........ 10
`Advanced
`Tools ..... ,. ....................... ,, ........................................... 10
`Fl,exible Printing and Print Preview....................
`HJ
`and Annotation
`....... " ................................................. 10
`\Vorksheet
`Scenario
`l
`Clte<:king and AutoCorrect
`............................... ,. .................................. 11
`Te1np1att:s
`.......................... " ................................................................................ 11
`................................... ., ............................................... 11
`XLM Macro Compatibility
`................................................ rn,
`l l
`.......................
`
`emnosUSA0016637
`
`CiM Ex. 1051 Page 18
`
`
`
`, ................... , ........ ,.,, ........ , ................. 12
`Visual Basic for Ai::,pl1G.l.ticms
`...............................................
`,, ......... 12
`Custom
`12
`Worksheet Controls
`.. ,..13
`...... w
`Protection Options
`................................................... ,. ....................................... 13
`1\dd-ln
`CJLE
`........... , ........... " .................................. ,., ....... , .. .,, .... ,. ................. 13
`. ........................................ ,.,. ......... 14
`::iui:,pon
`...........................
`............................................ 14
`
`Chapter What's New in Excel
`5
`..... ., ...................................... 15
`Installation
`......... ,.., ..... ., ..................... , ................ ., ... ., ................... ,, . ., ... 16
`Ne\h' Internet Features
`New File
`Boxes ....................... ., .................................. ,. ................................. ..
`PivotTable
`.....................................................
`17
`Automatic Fon:nula
`............................................................................ 17
`T111roug11 Cell Selection
`...............................................................
`,. ............ ,. ..... 17
`Personalized Men.us ............................................................................. ., .................. 17
`Easier Toolbar Customization
`.... ., ....... ,. .................................. ,. ........................... 18
`Documents on the Windows Tnskbar
`18
`Enhanced Clipboard
`.............................................................................................
`,18
`Euro Currency Symbol
`........... .............................
`19
`New Image
`..................................................................................
`19
`A New Help
`.............................................................. ,.............
`19
`19
`()ffice
`il.ssistant.
`................ , ......................................................................................
`Mt1IUHngu,'ll Features
`.....................................................................................
`, ....... 20
`ModeLess Userf.orms
`.......................... ,. .................................................................... 20
`
`..............................
`
`m
`
`Chapter 3: Getting Acquainted
`
`...................................... , ....... 21
`
`
`........ , ......................... ,,.,., ............................... , ..... , ...................................... :n
`
`22
`Title Bar ..........................................................................................................
`Window Control Menu Button
`...... ,,...........................
`.23
`M1nirnize Button
`................. , ..................................................
`,, ..................... 23
`Restore Button
`................................................................................................. 23
`Close Button
`....... , ................................. ,. ............................... 23
`Menu Bar ................
`.., ...... , ....................... , .......................... , ................ 23
`Toolbars
`.....
`. ............ ,, .................... 2:3
`.. 2:-i
`Formula Bar
`Nan1e Box ........... " ........................................... .,. ................. ,.. ....... , ................. 24
`Status Bar ....................................................... , ................................................ 24
`Parts of Vt.'orkbook \:\/indow ................................................................
`24
`a.,
`...........
`,. ................................. 24
`'fitie Bar .........................................................................
`Window Control Menu Button
`...... " .................................... ., ....................... 24
`..................................................................... 24
`Minituize Button
`Maximize Button
`........................... 25
`Close Button
`.....................................................
`., ........ 25
`Select AU But.ton .........................................................................
`., ................ 26
`Act.ive Cell Indicator
`................................. "' ....... , ............................................. 26
`Row Headings
`...............................................................................................
`26
`
`emnosUSA0016638
`
`CiM Ex. 1051 Page 19
`
`
`
`........................................................................
`
`26
`........... , .. ,u
`Coltunn
`....................... ., .... ., .... ,. ....................... " ......... ., ....... ., .. ,,, ... "'26
`Tab Scroll Buttons
`Sheet I',1.bs .. ,, .................. ,......
`. ..... " .............. ,, ................. 26
`Tab
`Bar ........ ,, .................................. .,. ........... ,. ,. ..................................... 26
`Horizontal ScrolH),U"
`......................................
`.26
`Vertical ScroHbar .......... ,,. .............................................................................. 27
`A Hands-on Excel Session
`...................... ., ............................................. ., .............. 27
`.............................................................................
`, ......... ,. ........ 27
`
`................................................................................................
`Aacm1111 a
`34
`Creai