fb noscript

PHI Learning

Helping Teachers to Teach and Students to Learn

Helping Teachers to Teach and Students to Learn

loading image

PHI Learning
Microsoft Excel 2019 : Data Analysis and Business Modeling

Share on
Share on TwitterShare on MailShare on LinkedInPinterestShare on Other Networks


Rating : Full StarFull StarFull StarFull StarFull Star5.0
Pages : 879

Print Book ISBN : 9789389347180
Binding : Paperback
Print Book Status : Available
Print Book Price : 995.00  796
You Save : (199)


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


Your digital content includes: All the book’s practice and solution files— ready to download at


Review the Book

Book ISBN :
Title :
Author :
Name :
Affiliation :
Contact No.
Email :
Correspondence Address :
Review :
Rate :
Empty StarEmpty StarEmpty StarEmpty StarEmpty Star
Enter your membership number.

loading image