text.skipToContent text.skipToNavigation
  1. Home
  2. Business & Economics
  3. FT Press
  4. Microsoft Excel 2013 Data Analysis and Business Modeling

Microsoft Excel 2013 Data Analysis and Business Modeling, 1st edition

  • Wayne Winston

Published by Microsoft Press (January 15th 2014) - Copyright © 2014

1st edition

Chosen format
View all
Microsoft Excel 2013 Data Analysis and Business Modeling

ISBN-13: 9780735681071

Includes: Unassigned

This product is not available in your country

What's included

  • Unassigned

Overview

Table of contents

  • Introduction
  • Chapter 1: Range names
  • Chapter 2: Lookup functions
  • Chapter 3: INDEX function
  • Chapter 4: MATCH function
  • Chapter 5: Text functions
  • Chapter 6: Dates and date functions
  • Chapter 7: Evaluating investments by using net present value criteria
  • Chapter 8: Internal rate of return
  • Chapter 9: More Excel financial functions
  • Chapter 10: Circular references
  • Chapter 11: IF statements
  • Chapter 12: Time and time functions
  • Chapter 13: The Paste Special command
  • Chapter 14: Three-dimensional formulas
  • Chapter 15: The Auditing tool and Inquire add-in
  • Chapter 16: Sensitivity analysis with data tables
  • Chapter 17: The Goal Seek command
  • Chapter 18: Using the Scenario Manager for sensitivity analysis
  • Chapter 19: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
  • Chapter 20: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
  • Chapter 21: The OFFSET function
  • Chapter 22: The INDIRECT function
  • Chapter 23: Conditional formatting
  • Chapter 24: Sorting in Excel
  • Chapter 25: Tables
  • Chapter 26: Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes
  • Chapter 27: The analytics revolution
  • Chapter 28: Introducing optimization with Excel Solver
  • Chapter 29: Using Solver to determine the optimal product mix
  • Chapter 30: Using Solver to schedule your workforce
  • Chapter 31: Using Solver to solve transportation or distribution problems
  • Chapter 32: Using Solver for capital budgeting
  • Chapter 33: Using Solver for financial planning

For teachers

All the material you need to teach your courses.

Discover teaching material