Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed. Solve real business problems with Excel—and build your competitive advantage Quickly transition from Excel basics to sophisticated analyticsSummarize data by using PivotTables and Descriptive StatisticsUse Excel trend curves, multiple regression, and exponential smoothingMaster advanced functions such as OFFSET and INDIRECTDelve into key financial, statistical, and time functionsLeverage the new charts in Excel 2016 (including box and whisker and waterfall charts)Make charts more effective by using Power ViewTame complex optimizations by using Excel SolverRun Monte Carlo simulations on stock prices and bidding modelsWork with the AGGREGATE function and table slicersCreate PivotTables from data in different worksheets or workbooksLearn about basic probability and Bayes’ TheoremAutomate repetitive tasks by using macros  
Les mer
Chapter 1 Basic spreadsheet modeling                                    Chapter 2 Range names                                                        Chapter 3 Lookup functions                                                   Chapter 4 The INDEX function Chapter 5 The MATCH function                                             Chapter 6 Text functions                                                      Chapter 7 Dates and date functions Chapter 8 Evaluating investment by using net present value criteria       Chapter 9 Internal rate of return                                           Chapter 10 More Excel financial functions                               Chapter 11 Circular references                                             Chapter 12 IF statements                                                     Chapter 13 Time and time functions                                      Chapter 14 The Paste Special command                   
Les mer
Master business modeling and analysis techniques with Microsoft Excel 2016: solve real business problems, and transform data into profits Hands-on, scenario-focused, and 100% practicalUpdated for Excel 2016's newest functionality: new charts, FORECAST capability, PowerMap, and moreNew spreadsheet models help beginner-to-intermediate Excel users move to more advanced techniquesAdds 150+ new problems with solutions
Les mer
This edition has been fully updated for Excel 2016's latest innovations, including new charts, the FORECAST capabilities, and Power Map. It adds 150+ new problems with solutions, plus a new first chapter to help inexperienced Excel users transition to more advanced techniques. \\   Chapters have been added on macros and on sensitivity analysis with more than two variables. This edition also adds features skipped in previous editions, including UNICODE, Using AGGREGATE function with Table Slicers, creating many PivotTables from a filter, HYPERLINKS, and ISFORMULA.
Les mer

Produktdetaljer

ISBN
9781509304219
Publisert
2016
Utgave
5. utgave
Utgiver
Vendor
Microsoft Press
Vekt
1437 gr
Høyde
229 mm
Bredde
190 mm
Dybde
44 mm
Aldersnivå
P, 06
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
864

Forfatter

Biographical note

WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the US Navy, and the US Army how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time  Jeopardy! champion.