Publisher |
PHI Learning Pvt. Ltd. |
Publication Year |
2019 |
ISBN-13 |
9789389347180 |
ISBN-10 |
9789389347180 |
Binding |
Paperback |
Edition |
Second |
Number of Pages |
879 Pages |
Language |
(English) |
Dimensions (Cms) |
20 X 14 X 4 |
Weight (grms) |
1290 |
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
Wayne L. Winston
Wayne L. Winston is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business, where he won 40+ teaching awards. He developed spreadsheet modeling coursework for Harvard Business School Publishing, and has taught or consulted on using Excel to improve decision-making at Microsoft, Cisco, Morgan Stanley, Pfizer, Verizon, the U.S. Navy, U.S. Army, and many other organizations. A two-time Jeopardy! Champion, he co-developed the Dallas Mavericks’ player tracking and rating system.
Wayne L. Winston
PHI Learning Pvt. Ltd.