Microsoft Excel Data Analysis and Business Modeling, 7th Edition

Office 2021 and Microsoft 365



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

Price$34.87 - $39.50
Rating
AuthorWayne Winston
PublisherMicrosoft Press
Published2021
Pages1168
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-100137613660
ISBN-139780137613663
EBook Hardcover Paperback

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 coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts.

Solve real problems with Microsoft Exceland build your competitive advantage.

Quickly transition from Excel basics to sophisticated analytics; Use recent Power Query enhancements to connect, combine, and transform data sources more effectively; Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA; Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music; Build more sophisticated and compelling charts; Use the new XLOOKUP function to revolutionize your lookup formulas; Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries; Illuminate insights from geographic and temporal data with 3D Maps; Improve decision-making with probability, Bayes theorem, and Monte Carlo simulation and scenarios; Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics; Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook.


  1. (3 books)



Similar Books


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

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

by Wayne Winston

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 Qu...

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

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:  $4.54  |  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

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel

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

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:  $49.85  |  Publisher:  Apress  |  Release:  2015

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 da...

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

Data Mining and Business Analytics with R

Data Mining and Business Analytics with R

by Johannes Ledolter

Collecting, analyzing, and extracting valuable information from a large amount of data requires easily accessible, robust, computational and analytical tools. Data Mining and Business Analytics with R utilizes the open source software R for the analysis, exploration, and simplification of large high-dimensional data sets. As a result, rea...

Price:  $77.16  |  Publisher:  Wiley  |  Release:  2013