Next Generation Excel
Home > Business and Economics > Finance and accounting > Finance and the finance industry > Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)(827 Wiley Finance)
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)(827 Wiley Finance)

Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)(827 Wiley Finance)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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

About the Author :
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.


Best Sellers


Product Details
  • ISBN-13: 9781118469071
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: John Wiley & Sons Inc
  • Edition: Revised edition
  • No of Pages: 256
  • Sub Title: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)
  • ISBN-10: 1118469070
  • Publisher Date: 04 Feb 2013
  • Binding: Digital (delivered electronically)
  • Language: English
  • Series Title: 827 Wiley Finance


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)(827 Wiley Finance)
John Wiley & Sons Inc -
Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)(827 Wiley Finance)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Next Generation Excel: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)(827 Wiley Finance)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!