Home > Store

Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition

Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition

eBook (Watermarked)

  • Your Price: $31.99
  • List Price: $39.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2019
  • Edition: 6th
  • eBook (Watermarked)
  • ISBN-10: 1-5093-0613-7
  • ISBN-13: 978-1-5093-0613-8

Master business modeling and analysis techniques with Microsoft Excel 2019 and Office 365 and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide helps you use Excel to ask the right questions and get accurate, actionable answers. New coverage ranges from Power Query/Get & Transform to Office 365 Geography and Stock data types. Practice with more than 800 problems, many based on actual challenges faced by working analysts. 

Solve real business problems with Excel—and build your competitive advantage:

  • Quickly transition from Excel basics to sophisticated analytics 
  • Use PowerQuery or Get & Transform to connect, combine, and refine data sources 
  • Leverage Office 365’s new Geography and Stock data types and six new functions 
  •  Illuminate insights from geographic and temporal data with 3D Maps 
  • Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts 
  • Use Excel trend curves, multiple regression, and exponential smoothing 
  • Delve into key financial, statistical, and time functions 
  • Master all of Excel’s great charts 
  • Quickly create forecasts from historical time-based data 
  • Use Solver to optimize product mix, logistics, work schedules, and investments—and even rate sports teams 
  • Run Monte Carlo simulations on stock prices and bidding models 
  • Learn about basic probability and Bayes’ Theorem 
  • Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook 
  • Automate repetitive analytics tasks by using macros

Downloads

Downloads

Follow the instructions to download this book's lesson files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download

Sample Content

Sample Pages

Download the sample pages (includes Chapter 4).

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership