Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
|Price||$27.00 - $39.99
|Format||Paper book / ebook (PDF)|
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.
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
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
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
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
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
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
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
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