Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
| Price | $23.99 - $27.00
|
| Rating |   |
| Author | Wayne Winston |
| Publisher | Microsoft Press |
| Published | 2019 |
| Pages | 880 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1509305882 |
| ISBN-13 | 9781509305889 |
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.
- Wayne Winston (3 books)
4 5 28
Similar Books
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: $4.54 | Publisher: Microsoft Press | Release: 2011
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
Microsoft Excel Data Analysis and Business Modeling, 7th Edition
by Wayne Winston
Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winstons hands-on, scenario-focused guide helps you use todays Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new covera...
Price: $34.87 | Publisher: Microsoft Press | Release: 2021
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 ...
Price: $29.06 | Publisher: Microsoft Press | Release: 2019
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 c...
Price: $19.40 | Publisher: Microsoft Press | Release: 2018
Microsoft Excel 2019 Formulas and Functions
by Paul McFedries
Expert Paul McFedries helps you master key Excel 2019 and Office 365 tools for building more powerful spreadsheets. Use Excel 2019 and Office 365 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and funct...
Price: $17.27 | Publisher: Microsoft Press | Release: 2019
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: $49.85 | Publisher: Apress | Release: 2015
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
by Chris Sorensen
Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. ...
Price: $31.97 | Publisher: Microsoft Press | Release: 2018