Atnaujinkite slapukų nuostatas

El. knyga: NEXT GENERATION EXCEL, Second Edition plusWebsite - Modeling in Microsoft Excel for Analysts and MBAS (for Windows and Mac OS): Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS) 2nd Edition [Wiley Online]

(New York, NY)
  • Formatas: 304 pages
  • Serija: Wiley Finance
  • Išleidimo metai: 23-Apr-2013
  • Leidėjas: John Wiley & Sons Inc
  • ISBN-10: 1119198984
  • ISBN-13: 9781119198987
Kitos knygos pagal šią temą:
  • Wiley Online
  • Kaina: 121,59 €*
  • * this price gives unlimited concurrent access for unlimited time
  • Formatas: 304 pages
  • Serija: Wiley Finance
  • Išleidimo metai: 23-Apr-2013
  • Leidėjas: John Wiley & Sons Inc
  • ISBN-10: 1119198984
  • ISBN-13: 9781119198987
Kitos knygos pagal šią temą:
Take Excel to the next level in accounting and financial modeling

In this new Second Edition of Next Generation Excel, Isaac Gottlieb shows financial analysts how to harness the full power of Excel to move forward into the new world of accounting and finance. Companies of all sizes use financial models to analyze their finances and plan business operations, as well as to create financial accounting reports like balance sheets, income statements, and statements of cash flows.

While many businesspeople are quite familiar with the reports created with financial models, most are not as familiar with the creation of the models themselves. This book shows them how to build an accurate and effective financial model using the solid functionality and easy usability of Excel.

  • Fully updated and revised to include support for Apple users
  • Written by a professor of management and statistics who has taught the discipline for fifteen years
  • Appropriate for professional financial analysts, as well as MBA students

For professionals and students whose responsibilities or studies include a full understanding of financial modeling, Next Generation Excel, Second Edition offers comprehensive training.

Foreword xv
Preface xvii
Acknowledgments xxi
PART ONE Using Excel Efficiently
1(92)
Chapter 1 AutoFill
3(12)
AutoFill Options
8(1)
Right-Drag AutoFill
8(2)
Appendix: AutoFill in Excel 2003 and Excel Mac 2011
10(3)
Review Questions
13(1)
Answers
14(1)
Chapter 2 Selecting Efficiently in Excel
15(6)
Review Questions
18(1)
Answers
19(2)
Chapter 3 Formulas, Functions, and Relative and Absolute Addressing
21(10)
Relative and Absolute Addressing
22(3)
Other Functions
25(3)
Appendix: Doing It in Mac Excel 2011
28(1)
Review Questions
29(1)
Answers
30(1)
Chapter 4 Naming Cells and Ranges
31(14)
Naming a Single Cell
31(2)
Naming a Range of Cells
33(1)
Using the Name Menu to Create Names
34(4)
Appendix: Using the Names Menu in Excel 2003 and Mac Excel 2011
38(3)
Review Questions
41(1)
Answers
42(3)
Chapter 5 Conditional and Advanced Conditional Formatting in Excel
45(12)
Simple Conditional Formatting; Adding a Rule
45(1)
New Conditional Formatting Features
46(3)
Advanced Conditional Formatting
49(3)
Appendix: Using the Conditional Formatting in Excel 2003
52(1)
Review Questions
53(2)
Answers
55(2)
Chapter 6 Excel Charts
57(24)
Quick/Instant Chart
57(1)
Creating a Chart Using the Menu
57(4)
Adding More Data to an Existing Chart
61(3)
More about Charts
64(2)
Three-Dimensional Charts---Column and Pie
66(4)
Pie Charts
70(3)
Appendix: Generating Charts in Excel 2003 and Mac Excel 2011
73(8)
Chapter 7 Sparklines and Advanced Topics in Excel Charts
81(12)
Sparklines
81(2)
More about Charts
83(7)
Review Questions
90(1)
Answers
91(2)
PART TWO IF Functions and Text Manipulations
93(20)
Chapter 8 IF Functions
95(8)
Simple IF Functions
95(3)
Nested IF Functions
98(1)
Nested IF---Payroll Example
99(2)
Appendix: Using the IF Function in Mac Excel 2011
101(1)
Review Questions
102(1)
Answers
102(1)
Chapter 9 Text Manipulation
103(10)
Text to Columns
103(5)
Appendix: Using Text to Column in Excel 2003
108(3)
Review Questions
111(1)
Answers
112(1)
PART THREE Statistical Tools
113(52)
Chapter 10 Descriptive Statistics
115(6)
Descriptive Statistics
115(2)
Appendix: Descriptive Statistics with the Mac Excel 2011
117(2)
Review Questions
119(1)
Answers
119(2)
Chapter 11 Frequency Distributions
121(10)
One More Example
126(3)
Appendix: Frequency Distributions with Mac Excel 2011
129(1)
Review Questions
129(1)
Answers
130(1)
Chapter 12 Statistical Regression
131(10)
Using the Scatter Chart in Excel
131(2)
Linear Regression---Using Excel Functions
133(4)
Appendix: Using the Chart Feature to Create a Trend Line in Excel 2003 and Mac Excel 2011
137(3)
Review Questions
140(1)
Answers
140(1)
Chapter 13 Data Analysis---The Excel Easy to Use Statistics Add-In
141(10)
Descriptive Statistics
141(2)
Frequency Distribution Using Histogram
143(5)
Appendix: Using Data Analysis in Excel Mac 2011 and Excel 2003
148(1)
Review Questions
148(1)
Answers
149(2)
Chapter 14 Data Analysis---Multi-Regression
151(14)
Simple or Single Variable Regression
151(1)
Multi-Regression
152(8)
Appendix: Using Data Analysis in Excel Mac 2011 and Excel 2003
160(1)
Review Questions
160(1)
Answers
161(4)
PART FOUR What-If Analysis
165(46)
Chapter 15 Naming Cells---For Meaningful Decision Making and Modeling
167(10)
One More Example---If You Have a Ready Model
168(2)
Appendix: Create and Apply Names in Excel 2003 and Mac Excel 2011
170(5)
Review Questions
175(1)
Answers
175(2)
Chapter 16 What-If Analysis and Goal Seek
177(8)
Goal Seek
178(4)
Appendix: Goal Seek in Excel 2003 and Mac Excel 2011
182(1)
Review Questions
183(1)
Answers
183(2)
Chapter 17 Sensitivity Analysis One and Two-Way Data Tables
185(11)
Two-Way Table
187(2)
Data Tables---One More Example
189(1)
Break-Even Point (BEP) Chart
190(2)
Appendix: Sensitivity Analysis One and Two-Way Data Tables for Excel 2003 and Mac Excel 2011
192(1)
Review Questions
193(2)
Answers
195(1)
Chapter 18 Using Scroll Bars for Sensitivity Analysis
196(15)
Scroll Bar Limitations
203(2)
Appendix: Adding a Scroll Bar in Excel 2003, 2007, and Mac Excel 2011
205(2)
Review Questions
207(1)
Answers
208(3)
PART FIVE Multi-Page Systems and Lookups
211(18)
Chapter 19 Multi-Page Budgets---Going to the Third Dimension
213(8)
A Payroll Example
213(4)
A Second Example---Bakers' Supplies
217(2)
Review Questions
219(1)
Answers
220(1)
Chapter 20 Lookup Tables
221(8)
Range---Approximate Match Lookup
221(3)
An Exact Match Lookup
224(3)
Review Questions
227(1)
Answers
228(1)
PART SIX The Data Menu and Ribbon
229(78)
Chapter 21 Sorting Data
231(10)
Sorting by Multiple Parameters
233(3)
Appendix: Sorting in Excel 2003 and Mac Excel 2011
236(2)
Review Questions
238(1)
Answers
239(2)
Chapter 22 AutoFilter
241(8)
Dates
241(2)
Below and Above Average
243(1)
Filter by Color
243(1)
Appendix: AutoFilter in Excel 2003
244(2)
Review Questions
246(1)
Answers
247(2)
Chapter 23 Data Forms and Features Eliminated In Excel 2007 and 2010
249(6)
Appendix: The Data Form in Excel 2003 or Earlier versions and Mac Excel 2011
251(1)
Review Questions
252(1)
Answers
253(2)
Chapter 24 Group and Outline Data
255(8)
Appendix: Group and Outline Data Excel 2003 and Mac Excel 2011
258(2)
Review Questions
260(1)
Answers
261(2)
Chapter 25 Excel Subtotals
263(12)
One More Example---Function Applied to Multiple Categories
265(1)
Copying Grouped Data
265(4)
Second Example---Larger Database
269(1)
Appendix: Creating Subtotals in Excel 2003 and Mac Excel 2011
269(4)
Review Questions
273(1)
Answers
273(2)
Chapter 26 Pivot Tables
275(14)
PivotTable Example
275(7)
Appendix: The Pivot Table in Excel 2003 and Mac Excel 2011
282(4)
Review Questions
286(1)
Answers
286(3)
Chapter 27 Data Mining Using Pivot Tables
289(12)
Appendix: Advanced PivotTable Techniques in Excel 2003
296(1)
Review Questions
297(1)
Answers
298(3)
Chapter 28 Using Slicers to Filter Pivot Tables
301(6)
Format a Slicer
302(2)
Sharing Slicers for More Than One Pivot Table
304(1)
Review Questions
305(1)
Answers
306(1)
PART SEVEN Excel Financial Tools
307(34)
Chapter 29 NPV and IRR---Evaluating Capital Investments
309(6)
The Time Value of Money
309(2)
IRR---Internal Rate of Return
311(2)
Review Questions
313(1)
Answers
313(2)
Chapter 30 Unconventional Financial Functions: XNPV and XIRR
315(4)
Excel XNPV---The Net Present Value Function for Uneven Intervals
315(1)
Excel XIRR---The Internal Rate of Return Function for Uneven Intervals
316(2)
Review Questions
318(1)
Answers
318(1)
Chapter 31 Frequently Used Financial Functions
319(6)
Similar Excel Functions
320(3)
Review Questions
323(1)
Answers
323(2)
Chapter 32 Amortization Tables
325(12)
Amortization Example
325(9)
Review Questions
334(1)
Answers
334(3)
Chapter 33 Accounting Depreciation Functions
337(4)
SLD Straight Line Depreciation
337(1)
SYD Sum of the Years Digits
337(2)
Review Questions
339(1)
Answers
339(2)
PART EIGHT Using the Solver Add-In
341(24)
Chapter 34 Beyond the Goal Seek---More Than One Changing Cell? Use the Solver
343(10)
Example---Break-Even Point
343(1)
Using the Solver
343(6)
Appendix: Using the Solver in Excel 2003 and Mac Excel 2011
349(1)
Review Questions
350(2)
Answers
352(1)
Chapter 35 The Solver Add-In---Optimizer
353(12)
Solver Example
353(2)
Nonlinear Example Using the Solver
355(5)
Appendix: Using the Solver in Excel 2003 and Mac 2011
360(1)
Review Questions
360(1)
Answers
360(5)
Appendix Summary Case Study---Supply Chain Management Example 365(20)
About the Author 385(2)
Index 387
Dr. Isaac D. Gottlieb, PhD, is a professor of Management and Statistics at the Fox Business School of Temple University and Director of the China and Singapore programs. Also, he is a former director of the International Executive MBA at Rutgers University Business School. The recipient of numerous excellence-in-teaching awards, Dr. Gottlieb has taught how to use Excel and apply it effectively to various business disciplines to thousands of MBA and Executive MBA students at Rutgers, Temple, New York University, Columbia, and other universities. Also, he has instructed Excel for business professionals to over 20,000 participants in corporate seminars, conferences and workshops, including staff from Johnson & Johnson, Merck, Pfizer, Procter & Gamble, Microsoft, Intel, Boeing, Chrysler, JP Morgan, Morgan Stanley, 3M and Hewlett-Packard. Dr Gottlieb has an "Excel Tip Of The Month" newsletter that goes to over 50,000 recipients.