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



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

Price$27.00 - $39.99
Rating
AuthorWayne Winston
PublisherMicrosoft Press
Published2019
Pages880
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509305882
ISBN-139781509305889
EBook Hardcover Paperback

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.


  1. (2 books)



Similar Books


Microsoft Excel 2010: Data Analysis and Business Modeling, 3rd Edition

Microsoft Excel 2010: Data Analysis and Business Modeling, 3rd Edition

by Wayne L. Winston

Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of...

Price:  $6.49  |  Publisher:  Microsoft Press  |  Release:  2011

Microsoft Excel 2013 Data Analysis and Business Modeling

Microsoft Excel 2013 Data Analysis and Business Modeling

by Wayne Winston

Master business modeling and analysis techniques with Microsoft Excel 2013, 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 ...

Price:  $6.29  |  Publisher:  Microsoft Press  |  Release:  2014

Databases for Small Business

Databases for Small Business

by Anna Manning

This book covers the practical aspects of database design, data cleansing, data analysis, and data protection, among others. The focus is on what you really need to know to create the right database for your small business and to leverage it most effectively to spur growth and revenue.Databases for Small Business is a practical handbook f...

Price:  $40.83  |  Publisher:  Apress  |  Release:  2015

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Pivot Table Data Crunching

by Bill Jelen, Michael Alexander

Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table befor...

Price:  $26.13  |  Publisher:  Microsoft Press  |  Release:  2019

Microsoft Excel 2019 Step by Step

Microsoft Excel 2019 Step by Step

by Curtis Frye

Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers - brisk lessons and detailed screenshots show you exactly what to do, step by step.Quickly set up workbooks, enter data, and format it for easier viewing; Perform calculations and find and correct errors; Create sophisticated forecast worksheets, key perfor...

Price:  $31.62  |  Publisher:  Microsoft Press  |  Release:  2018

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out

by Bill Jelen

Dive into Microsoft Excel 2019 - and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a comple...

Price:  $35.45  |  Publisher:  Microsoft Press  |  Release:  2018

Getting Started with Haskell Data Analysis

Getting Started with Haskell Data Analysis

by James Church

Every business and organization that collects data is capable of tapping into its own data to gain insights how to improve. Haskell is a purely functional and lazy programming language, well-suited to handling large data analysis problems. This book will take you through the more difficult problems of data analysis in a hands-on manner.Th...

Price:  $23.99  |  Publisher:  Packt Publishing  |  Release:  2018

Making Sense of Data I, 2nd Edition

Making Sense of Data I, 2nd Edition

by Glenn J. Myatt, Wayne P. Johnson

A proven go-to guide for data analysis, Making Sense of Data I: A Practical Guide to Exploratory Data Analysis and Data Mining, Second Edition focuses on basic data analysis approaches that are necessary to make timely and accurate decisions in a diverse range of projects. Based on the authors' practical experience in implementing data an...

Price:  $16.75  |  Publisher:  Wiley  |  Release:  2014