Currencies:HKD

You have no items in your shopping cart.

Next Generation Excel: Modeling in Excel for Analysts and MBAs

Next Generation Excel Modeling in Excel for Analysts and MBAs

  • Author:
  • Publisher: John Wiley & Sons
  • ISBN: 9780470824733
  • Published In: October 2009
  • Format: Hardback , 250 pages
  • Jurisdiction: International or US ? Disclaimer:
    Countri(es) stated herein are used as reference only
Out of stock
OR
  • Description 
  • Contents 
  • Author 

Details

Dr. Isaac Gottlieb personally trained 35 of our top analysts and finance professionals in a customized advanced Excel seminar. Many of the tools covered in this book were part of this well-received training. For the past five years, Isaac’s monthly Excel-Tip-Of-The-Month newsletter has been a personal favorite of mine. In an age where email overload is common, I always look forward to his email and many of my associates and team members around the world are part of his over 50,000 monthly recipients. This compilation is a must-have for any finance professional who wants to be a better business partner and truly add value in a more efficient manner!

Anthony N. Caspio, CMA
Vice President - Finance
Sealed Air Corporation

 

Excel has been one of the most powerful applications of recent times, but most users, unfortunately, only scratch its surface. Prof. Gottlieb’s book leverages his years of Excel workshops in the US, Europe and Asia, and he unleashes the tremendous potential and power of Excel. His to-the-point explanations and his innovative screenshots bring Excel alive to readers who may just have a working knowledge of the software. This amazing volume is an application-oriented book for Excel users who want answers fast, and who need to maximize the application’s awesome potential.

Prof. Farrokh Langdana, Ph.D.
Director, Rutgers Executive MBA
Professor, Rutgers Business School

If I should thank Microsoft for inventing Excel, then I would like to thank Dr. Isaac Gottlieb more for teaching me how to use it to solve the real problems in my real work. Keep going Isaac!

Wu Haowen
Director of International Programs
School of Management, Dalian University of Technology

Isaac Gottlieb’s Next Generation Excel is an invaluable resource. The fruit of many years of teaching Excel to university business students, Gottlieb’s book covers the topics that the Excel user needs to become more efficient and sophisticated. It is easy to read and follow. A wonderful book!

Simon Benninga
Professor of Finance, Faculty of Management, Tel Aviv University
Author of
Principles of Finance with Excel
 

As an avid user of Excel, several years ago I came across Isaac’s Excel-Tip-Of-The-Month newsletter. I quickly realized that Isaac exploits Excel to the “next usability level.” Like his monthly newsletters, Isaac has composed a book that is clear and concise similarly reflecting his teaching methods. This book helps intermediate users to rapidly acquire Excel-pro skills, while allowing advanced users to grasp concepts in one single pass-through. Furthermore, Isaac takes day-to-day challenges and provides elegant ease of use solutions.

Moshe Castiel
Manager, IT – Technology & Operations
TIAA-CREF

 

Next Generation Excel presents an interesting perspective on the resourcefulness of Microsoft Excel like never before. This book is an excellent and a much-needed resource to MBA students, educators and Excel enthusiasts. In reviewing this book, the principal criteria included content, organization and Excel add-on files. The book is neatly organized into sections; starting with basic Excel tools and functions, commonly used statistical tools, what-if-analysis and then moving on to advanced data features, solver-add ins and various other ToolPaks, nicely complemented with the Excel snapshots to provide a user friendly experience. As a result, one can jump directly to the relevant sections and use the Excel files provided to get a more hands-on experience. The right mix of theory and practice, is the unique selling point (USP) of this book!

Anirudha “Andy” Vaidya, MBA
CEO
AVS System

A Word from the Author.

Acknowledgments.

Introduction and Overview.

PART ONE: Using Excel Efficiently.

Chapter 1 AutoFill.

Chapter 2 Selecting Efficiently in Excel.

Chapter 3 Formulas, Functions, Relative and Absolute Addressing.

Chapter 4 Naming Cells and Ranges.

Chapter 5 Excel Charts.

PART TWO: If Functions and Text Manipulations.

Chapter 6 If Functions.

Chapter 7 Text Manipulation.

PART THREE: Statistical Tools.

Chapter 8 Descriptive Statistics.

Chapter 9 Frequency Distributions.

Chapter 10 Statistical Regression.

Chapter 11 Data Analysis-The Excel Easy to Use Statistics Add-in.

PART FOUR: What-if Analysis.

Chapter 12 Naming Cells-for Meaningful Decision Making and Modeling.

Chapter 13 What-if Analysis and Goal Seek.

Chapter 14 Sensitivity Analysis-One- and Two-way Data Tables.

Chapter 15 Using Scroll Bars for Sensitivity Analysis.

PART FIVE: Multi-Page Systems and Lookups.

Chapter 16 Multi-Page Budgets-Going to the Third Dimension.

Chapter 17 Lookup Tables.

PART SIX: The Data Menu and Ribbon.

Chapter 18 Sorting Data.

Chapter 19 AutoFilter.

Chapter 20 Data Forms and Features Eliminated in Excel 2007.

Chapter 21 Group and Outline Data.

Chapter 22 Subtotals.

Chapter 23 Pivot Tables.

Chapter 24 Data Mining Using Pivot Tables.

PART SEVEN: Excel Financial Tools.

Chapter 25 NV and IRR-Evaluating Capital Investments.

Chapter 26 Unconventional Financial Functions: XNPV and XIRR.

Chapter 27 Frequently Used Financial Functions.

Chapter 28 Amortization Tables.

Chapter 29 Accounting Depreciation Functions.

PART EIGHT: Using the Solver Add-In.

Chapter 30 Beyond the Goal Seek-More than One Changing Cell? Use the Solver.

Chapter 31 The Solver Add-In-Optimizer.

Index.

Isaac D. Gottlieb, Ph.D. is the Director of the International Executive MBA at Rutgers University Business School. He has been part of the teaching faculty for over 10 years, and is the recipient of a number of teaching excellence awards.

Over the last decade, he has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands of MBA and Executive MBA students at Rutgers, NYU and Columbia University.

He has also instructed Excel application in business settings to over 10,000 participants in corporate seminars, conferences and workshops. The participants are professionals from leading multinational companies as well as small private business corporations.

Dr. Gottlieb has an Excel-Tip-Of-The-Month newsletter which goes to over 50,000 recipients.

You may also be interested in these books:

The Hong Kong Company Secretary's Handbook: Practice and Procedure (11th Edition)
The Hong Kong Company Secretary's Handbook: Practice and Procedure (11th Edition)

List Price: HKD 551.00

HKD 534.47 Save HKD 16.53 (3%)

Hong Kong Tax & Accounting Practical Toolkit (Basic Package)
Hong Kong Tax & Accounting Practical Toolkit (Basic Package)
HKD 3,639.00
Hong Kong Listed Companies: Law and Practice, 2nd Edition
Hong Kong Listed Companies: Law and Practice, 2nd Edition

List Price: HKD 1,980.00

HKD 1,920.60 Save HKD 59.40 (3%)

KPMG's Insights into IFRS 2025/2026 (22nd Edition) (e-Book only)
KPMG's Insights into IFRS 2025/2026 (22nd Edition) (e-Book only)

List Price: HKD 2,172.00

HKD 2,106.84 Save HKD 65.16 (3%)

Hong Kong GAAP: A Master Guide to Financial Reporting Standards 2025 (18th Edition)
Hong Kong GAAP: A Master Guide to Financial Reporting Standards 2025 (18th Edition)

List Price: HKD 1,380.00

HKD 1,338.60 Save HKD 41.40 (3%)

Hong Kong Master Tax Guide 2025/26 (33rd Edition)
Hong Kong Master Tax Guide 2025/26 (33rd Edition)

List Price: HKD 1,450.00

HKD 1,406.50 Save HKD 43.50 (3%)

Japan Master Tax Guide 2025-26, 23rd Edition
Japan Master Tax Guide 2025-26, 23rd Edition

List Price: HKD 2,590.00

HKD 2,522.00 Save HKD 68.00 (3%)

Singapore Master Guide to BEPS 2.0 – Multinational Enterprise (Minimum Tax)
Singapore Master Guide to BEPS 2.0 – Multinational Enterprise (Minimum Tax)

List Price: HKD 1,050.00

HKD 1,028.20 Save HKD 21.80 (2%)

Malaysia Master Tax Guide 42nd Edition 2025
Malaysia Master Tax Guide 42nd Edition 2025

List Price: HKD 950.00

HKD 921.50 Save HKD 28.50 (3%)

Taxation in Hong Kong: A Practical Guide 2023-2024 (9th Edition)
Taxation in Hong Kong: A Practical Guide 2023-2024 (9th Edition)

List Price: HKD 1,380.00

HKD 1,338.60 Save HKD 41.40 (3%)

Hong Kong Company Secretary Checklist, 2nd Edition
Hong Kong Company Secretary Checklist, 2nd Edition

List Price: HKD 1,380.00

HKD 1,338.60 Save HKD 41.40 (3%)

Wiley IFRS 2023: Interpretation and Application of IFRS Standards
Wiley IFRS 2023: Interpretation and Application of IFRS Standards
HKD 1,250.00
A Concise Guide to Corporate Compliance Management (2nd Edition)
A Concise Guide to Corporate Compliance Management (2nd Edition)

List Price: HKD 680.00

HKD 476.00 Save HKD 204.00 (30%)

China Master GAAP Guide (12th Edition)
China Master GAAP Guide (12th Edition)

List Price: HKD 1,500.00

HKD 1,455.00 Save HKD 45.00 (3%)

Introduction to International Taxation
Introduction to International Taxation

List Price: HKD 920.00

HKD 892.40 Save HKD 27.60 (3%)

A Practical Guide to Company Secretarial Obligations in Singapore, 2nd Edition
A Practical Guide to Company Secretarial Obligations in Singapore, 2nd Edition

List Price: HKD 1,210.00

HKD 1,183.40 Save HKD 26.60 (2%)

Consolidated Financial Statements, 11th Edition
Consolidated Financial Statements, 11th Edition

List Price: HKD 740.00

HKD 688.70 Save HKD 51.30 (7%)

Hong Kong Financial Reporting Standards for SMEs (2nd Edition)
Hong Kong Financial Reporting Standards for SMEs (2nd Edition)

List Price: HKD 1,500.00

HKD 1,050.00 Save HKD 450.00 (30%)

Hong Kong Directors' Manual, 5th Edition
Hong Kong Directors' Manual, 5th Edition

List Price: HKD 1,380.00

HKD 966.00 Save HKD 414.00 (30%)

Singapore Income Tax Concise Casebook
Singapore Income Tax Concise Casebook

List Price: HKD 1,040.00

HKD 1,008.80 Save HKD 31.20 (3%)