Description

Book Synopsis
Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables–and how to effectively build a relational data source inside an Excel workbook.

Table of Contents
  • Chapter 1 Basic spreadsheet modeling
  • Chapter 2 Range names
  • Chapter 3 Lookup functions
  • Chapter 4 The INDEX function
  • Chapter 5 The MATCH function
  • Chapter 6 Text functions
  • Chapter 7 Dates and date functions
  • Chapter 8 Evaluating investment by using net present value criteria
  • Chapter 9 Internal rate of return
  • Chapter 10 More Excel financial functions
  • Chapter 11 Circular references
  • Chapter 12 IF statements
  • Chapter 13 Time and time functions
  • Chapter 14 The Paste Special command
  • Chapter 15 Three-dimensional formulas and hyperlinks
  • Chapter 16 The auditing tool
  • Chapter 17 Sensitivity analysis with data tables
  • Chapter 18 The Goal Seek command
  • Chapter 19 Using the Scenario Manager for sensitivity analysis
  • Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
  • Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
  • Chapter 22 The OFFSET function
  • Chapter 23 The INDIRECT function
  • Chapter 24 Conditional formatting
  • Chapter 25 Sorting in Excel
  • Chapter 26 Tables
  • Chapter 27 Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes
  • Chapter 28 The analytics revolution
  • Chapter 29 An introduction to optimization with Excel Solver
  • Chapter 30 Using Solver to determine the optimal product mix
  • Chapter 31 Using Solver to schedule your workforce
  • Chapter 32 Using Solver to solve transportation or distribution problems
  • Chapter 33 Using Solver for capital budgeting
  • Chapter 34 Using Solver for financial planning
  • Chapter 35 Using Solver to rate sports teams
  • Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines
  • Chapter 37 Penalties and the Evolutionary Solver
  • Chapter 38 The traveling salesperson problem
  • Chapter 39 Importing data from a text file or document
  • Chapter 40 Validating data
  • Chapter 41 Summarizing data by using histograms and Pareto charts
  • Chapter 42 Summarizing data by using descriptive statistics
  • Chapter 43 Using PivotTables and slicers to describe data
  • Chapter 44 The Data Model
  • Chapter 45 Power Pivot
  • Chapter 46 Power View and 3D Maps
  • Chapter 47 Sparklines
  • Chapter 48 Summarizing data with database statistical functions
  • Chapter 49 Filtering data and removing duplicates
  • Chapter 50 Consolidating data
  • Chapter 51 Creating subtotals
  • Chapter 52 Charting tricks
  • Chapter 53 Estimating straight-line relationships
  • Chapter 54 Modeling exponential growth
  • Chapter 55 The power curve
  • Chapter 56 Using correlations to summarize relationships
  • Chapter 57 Introduction to multiple regression
  • Chapter 58 Incorporating qualitative factors into multiple regression
  • Chapter 59 Modeling nonlinearities and interactions
  • Chapter 60 Analysis of variance: One-way ANOVA
  • Chapter 61 Randomized blocks and two-way ANOVA
  • Chapter 62 Using moving averages to understand time series
  • Chapter 63 Winters method
  • Chapter 64 Ratio-to-moving-average forecast method
  • Chapter 65 Forecasting in the presence of special events
  • Chapter 66 An introduction to probability
  • Chapter 67 An introduction to random variables
  • Chap

Microsoft Excel 2019 Data Analysis and Business

    Product form

    £32.29

    Includes FREE delivery

    RRP £37.99 – you save £5.70 (15%)

    Order before 4pm tomorrow for delivery by Fri 26 Jun 2026.

    A Paperback / softback by Wayne Winston

    20 in stock

      Trusted by thousands of customers. See 2,385+ Customer Reviews

      View other formats and editions of Microsoft Excel 2019 Data Analysis and Business by Wayne Winston

      Publisher: Microsoft Press,U.S.
      Publication Date: 22/04/2019
      ISBN13: 9781509305889, 978-1509305889
      ISBN10: 1509305882
      Also in:
      Computing Spreadsheet software

      Description

      Book Synopsis
      Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables–and how to effectively build a relational data source inside an Excel workbook.

      Table of Contents
      • Chapter 1 Basic spreadsheet modeling
      • Chapter 2 Range names
      • Chapter 3 Lookup functions
      • Chapter 4 The INDEX function
      • Chapter 5 The MATCH function
      • Chapter 6 Text functions
      • Chapter 7 Dates and date functions
      • Chapter 8 Evaluating investment by using net present value criteria
      • Chapter 9 Internal rate of return
      • Chapter 10 More Excel financial functions
      • Chapter 11 Circular references
      • Chapter 12 IF statements
      • Chapter 13 Time and time functions
      • Chapter 14 The Paste Special command
      • Chapter 15 Three-dimensional formulas and hyperlinks
      • Chapter 16 The auditing tool
      • Chapter 17 Sensitivity analysis with data tables
      • Chapter 18 The Goal Seek command
      • Chapter 19 Using the Scenario Manager for sensitivity analysis
      • Chapter 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
      • Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
      • Chapter 22 The OFFSET function
      • Chapter 23 The INDIRECT function
      • Chapter 24 Conditional formatting
      • Chapter 25 Sorting in Excel
      • Chapter 26 Tables
      • Chapter 27 Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes
      • Chapter 28 The analytics revolution
      • Chapter 29 An introduction to optimization with Excel Solver
      • Chapter 30 Using Solver to determine the optimal product mix
      • Chapter 31 Using Solver to schedule your workforce
      • Chapter 32 Using Solver to solve transportation or distribution problems
      • Chapter 33 Using Solver for capital budgeting
      • Chapter 34 Using Solver for financial planning
      • Chapter 35 Using Solver to rate sports teams
      • Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines
      • Chapter 37 Penalties and the Evolutionary Solver
      • Chapter 38 The traveling salesperson problem
      • Chapter 39 Importing data from a text file or document
      • Chapter 40 Validating data
      • Chapter 41 Summarizing data by using histograms and Pareto charts
      • Chapter 42 Summarizing data by using descriptive statistics
      • Chapter 43 Using PivotTables and slicers to describe data
      • Chapter 44 The Data Model
      • Chapter 45 Power Pivot
      • Chapter 46 Power View and 3D Maps
      • Chapter 47 Sparklines
      • Chapter 48 Summarizing data with database statistical functions
      • Chapter 49 Filtering data and removing duplicates
      • Chapter 50 Consolidating data
      • Chapter 51 Creating subtotals
      • Chapter 52 Charting tricks
      • Chapter 53 Estimating straight-line relationships
      • Chapter 54 Modeling exponential growth
      • Chapter 55 The power curve
      • Chapter 56 Using correlations to summarize relationships
      • Chapter 57 Introduction to multiple regression
      • Chapter 58 Incorporating qualitative factors into multiple regression
      • Chapter 59 Modeling nonlinearities and interactions
      • Chapter 60 Analysis of variance: One-way ANOVA
      • Chapter 61 Randomized blocks and two-way ANOVA
      • Chapter 62 Using moving averages to understand time series
      • Chapter 63 Winters method
      • Chapter 64 Ratio-to-moving-average forecast method
      • Chapter 65 Forecasting in the presence of special events
      • Chapter 66 An introduction to probability
      • Chapter 67 An introduction to random variables
      • Chap

      Recently viewed products

      © 2026 Book Curl

        • American Express
        • Apple Pay
        • Diners Club
        • Discover
        • Google Pay
        • Maestro
        • Mastercard
        • PayPal
        • Shop Pay
        • Union Pay
        • Visa

        Login

        Forgot your password?

        Don't have an account yet?
        Create account