Next Generation Excel +Website: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS)

Overview

Most Excel users never realize just how powerful the programreally is. Featuring more than 400 functions, Excel is packed withan array of complex data mining, analytical, statistical, andgraphical representation tools and other powerful features ofinestimable value to business professionals. But learning how toexploit those features with confidence can be tricky, evenoverwhelming, for the casual user.

Enter Next Generation Excel, Second ...

See more details below
Other sellers (Hardcover)
  • All (8) from $66.52   
  • New (7) from $66.52   
  • Used (1) from $74.74   

Overview

Most Excel users never realize just how powerful the programreally is. Featuring more than 400 functions, Excel is packed withan array of complex data mining, analytical, statistical, andgraphical representation tools and other powerful features ofinestimable value to business professionals. But learning how toexploit those features with confidence can be tricky, evenoverwhelming, for the casual user.

Enter Next Generation Excel, Second Edition.

Growing out of Dr. Gottlieb's many years of teaching universityclasses, as well as his extremely popular corporate workshops,Next Generation Excel, Second Edition is based upon hiswell-founded conviction that, when it comes to teaching people howto use and get the most out of complex software, "show, don't tell"is the golden rule.

Staying true to that philosophy, he eschews the lengthy, oftenperplexing, verbal explanations typical of such guides in favor ofbite-sized descriptive passages, liberally supplemented withExcel-in-action screenshots, skill-building exercises, and reviewquestions. Also, for ease of reference, each subject-specificchapter is self-contained, affording you the option of focusing ononly those features of immediate interest to you.

Demystifying the obscure and simplifying the complex, Dr.Gottlieb walks you, step by step, through all of Excel 2010'sadvanced business and finance functions (with explanations forusers of Excel 2007, 2003, and previous versions, as needed),including:

  • Financial tools, including NVP and IRR
  • Data mining using Pivot Tables
  • Charting, sparklines, and other advanced charting options
  • Data analysis tools
  • What-if analysis
  • Statistics for non-statisticians
  • Accounting functions, including amortization tables anddepreciation functions

Not just another general how-to Excel guide, this fully updatedand expanded Second Edition of Isaac Gottlieb'sinternationally acclaimed Next Generation Excel shows youhow to harness the full power of Excel to help you to perform anarray of advanced business decision making, financial, andaccounting functions. You'll learn how to quickly create modelsthat deliver accurate, relevant information to boost efficiency,improve your forecasting ability, and perform an array of othercrucial business and reporting functions.

Read More Show Less

Product Details

  • ISBN-13: 9781118469101
  • Publisher: Wiley
  • Publication date: 3/4/2013
  • Series: Wiley Finance Series, #826
  • Edition number: 2
  • Pages: 304
  • Sales rank: 734,931
  • Product dimensions: 7.20 (w) x 10.00 (h) x 1.50 (d)

Meet the Author

Dr. Isaac D. Gottlieb, PhD, is a professor of Managementand Statistics at the Fox Business School of Temple University andDirector of the China and Singapore programs. Also, he is a formerdirector of the International Executive MBA at Rutgers UniversityBusiness School. The recipient of numerous excellence-in-teachingawards, Dr. Gottlieb has taught how to use Excel and apply iteffectively to various business disciplines to thousands of MBA andExecutive MBA students at Rutgers, Temple, New York University,Columbia, and other universities. Also, he has instructed Excel forbusiness professionals to over 20,000 participants in corporateseminars, conferences and workshops, including staff from Johnson& Johnson, Merck, Pfizer, Procter & Gamble, Microsoft,Intel, Boeing, Chrysler, JP Morgan, Morgan Stanley, 3M andHewlett-Packard. Dr Gottlieb has an "Excel Tip Of The Month"newsletter that goes to over 50,000 recipients.

Read More Show Less

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 AbsoluteAddressing 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 201138

Review Questions 41

Answers 42

CHAPTER 5 Conditional and Advanced Conditional Formatting inExcel 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 201173

CHAPTER 7 Sparklines and Advanced Topics in Excel Charts81

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 UseStatistics Add-In 141

Descriptive Statistics 141

Frequency Distribution Using Histogram 143

Appendix: Using Data Analysis in Excel Mac 2011 and Excel 2003148

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 2003160

Review Questions 160

Answers 161

PART FOUR What-If Analysis 165

CHAPTER 15 Naming Cells—For Meaningful Decision Makingand Modeling 167

One More Example—If You Have a Ready Model 168

Appendix: Create and Apply Names in Excel 2003 and Mac Excel2011 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 DataTables 185

Two-Way Table 187

Data Tables—One More Example 189

Break-Even Point (BEP) Chart 190

Appendix: Sensitivity Analysis—One- and Two-Way DataTables for Excel 2003 and Mac Excel 2011 192

Review Questions 193

Answers 195

CHAPTER 18 Using Scroll Bars for Sensitivity Analysis199

Scroll Bar Limitations 203

Appendix: Adding a Scroll Bar in Excel 2003, 2007, and Mac Excel2011 205

Review Questions 207

Answers 208

PART FIVE Multi-Page Systems and Lookups 211

CHAPTER 19 Multi-Page Budgets—Going to the ThirdDimension 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 2007and 2010 249

Appendix: The Data Form in Excel 2003 or Earlier versions andMac 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 2011258

Review Questions 260

Answers 261

CHAPTER 25 Excel Subtotals 263

One More Example—Function Applied to Multiple Categories265

Copying Grouped Data 265

Second Example—Larger Database 269

Appendix: Creating Subtotals in Excel 2003 and Mac Excel 2011269

Review Questions 273

Answers 273

CHAPTER 26 Pivot Tables 275

PivotTable Example 275

Appendix: The Pivot Table in Excel 2003 and Mac Excel 2011282

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 Investments309

The Time Value of Money 309

IRR—Internal Rate of Return 311

Review Questions 313

Answers 313

CHAPTER 30 Unconventional Financial Functions: XNPV and XIRR315

Excel XNPV—The Net Present Value Function for UnevenIntervals 315

Excel XIRR—The Internal Rate of Return Function for UnevenIntervals 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 ChangingCell? Use the Solver 343

Example—Break-Even Point 343

Using the Solver 343

Appendix: Using the Solver in Excel 2003 and Mac Excel 2011349

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 ManagementExample 365

About the Author 385

Index 387

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)