Microsoft Excel 2013_ Data Analysis and Business Modeling(2).pdf

(21518 KB) Pobierz
Microsoft Excel 2013:
Data Analysis and
Business Modeling
Wayne L. Winston
Pub shed w th the author zat on of M crosoft Corporat on by
O’Re y Med a, Inc
1005 Gravenste n H ghway North
Sebastopo , Ca forn a 95472
Copyr ght © 2014 by Wayne L W nston
A r ghts reserved No part of the contents of th s book may be reproduced or transm tted n any form or by any
means w thout the wr tten perm ss on of the pub sher
ISBN 978-0-7356-6913-0
2 3 4 5 6 7 8 9 10 LSI 9 8 7 6 5 4
Pr nted and bound n the Un ted States of Amer ca
M crosoft Press books are ava ab e through bookse ers and d str butors wor dw de If you need support re ated
to th s book, ema M crosoft Press Book Support at
mspinput@microsoft.com
P ease te us what you th nk of
th s book at
http://www.microsoft.com/learning/booksurvey
M crosoft and the trademarks sted at
http://www.microsoft.com/about/legal/en/us/IntellectualProperty/
Trademarks/EN-US.aspx
are trademarks of the M crosoft group of compan es A other marks are property of
the r respect ve owners
The examp e compan es, organ zat ons, products, doma n names, ema addresses, ogos, peop e, p aces, and
events dep cted here n are fict t ous No assoc at on w th any rea company, organ zat on, product, doma n name,
ema address, ogo, person, p ace, or event s ntended or shou d be nferred
Th s book expresses the author’s v ews and op n ons The nformat on conta ned n th s book s prov ded w thout
any express, statutory, or mp ed warrant es Ne ther the author, O’Re y Med a, Inc , M crosoft Corporat on, nor
ts rese ers, or d str butors w be he d ab e for any damages caused or a eged to be caused e ther d rect y or
nd rect y by th s book
Acquisitions and Developmental Editor:
Kenyon Brown
Production Editor:
Kara Ebrah m
Editorial Production:
nS ght, Inc
Technical Reviewer:
Peter Myers
Copyeditor:
nS ght, Inc
Indexer:
nS ght, Inc
Cover Design:
Tw st Creat ve • Seatt e
Cover Composition:
E e Vo ckhausen
Illustrator:
Rebecca Demarest
[2014-01-31]
Contents at a glance
Introduction
ChAptEr 1
ChAptEr 2
ChAptEr 3
ChAptEr 4
ChAptEr 5
ChAptEr 6
ChAptEr 7
ChAptEr 8
ChAptEr 9
ChAptEr 10
ChAptEr 11
ChAptEr 12
ChAptEr 13
ChAptEr 14
ChAptEr 15
ChAptEr 16
ChAptEr 17
ChAptEr 18
ChAptEr 19
ChAptEr 20
ChAptEr 21
ChAptEr 22
ChAptEr 23
ChAptEr 24
ChAptEr 25
ChAptEr 26
ChAptEr 27
ChAptEr 28
ChAptEr 29
ChAptEr 30
xxi
1
15
23
27
35
51
59
67
75
87
93
111
117
123
127
139
149
155
161
169
175
187
195
223
231
245
261
267
273
285
range names
Lookup functions
INDEX function
MAtCh function
text functions
Dates and date functions
Evaluating investments by using net present value criteria
Internal rate of return
More Excel financial functions
Circular references
IF statements
time and time functions
the paste Special command
three-dimensional formulas
the Auditing tool and Inquire add-in
Sensitivity analysis with data tables
the Goal Seek command
Using the Scenario Manager for sensitivity analysis
the COUNtIF, COUNtIFS, COUNt, COUNtA,
and COUNtBLANK functions
the SUMIF, AVErAGEIF, SUMIFS, and AVErAGEIFS
functions
the OFFSEt function
the INDIrECt function
Conditional formatting
Sorting in Excel
tables
Spinner buttons, scroll bars, option buttons, check
boxes, combo boxes, and group list boxes
the analytics revolution
Introducing optimization with Excel Solver
Using Solver to determine the optimal product mix
Using Solver to schedule your workforce

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin