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

Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
分享
扫描下方二维码分享到微信
打开微信,点击右上角”+“,
使用”扫一扫“即可将网页分享到朋友圈。
作者:
出版社: Microsoft Press
2019-04
ISBN: 9781509305889
装帧: 其他
页数: 880页
  • 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 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.
  • 内容简介:
    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 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.
查看详情
相关图书 / 更多
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftPublisher2013
Elizabeth Eisner Reding 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftPublisher2013Comprehensive
Joy L. Starks 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftOffice2013IllustratedProjects
Carol Cram 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
Microsoft 365+Power Platform企业数字化转型全攻略
王凤辉
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftPowerBI数据建模与可视化快速上手
王国平
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftExcel2013forMedicalProfessionals
Elizabeth Reding 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
Microsoft Power BI商业数据分析与案例实战
王国平
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
Microsoft: Introductory
Pasewark/Pasewark、Robin M. Romer、Jessica Evans、Katherine T. Pinard、Rachel Biheller Bunin 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftWord2013forMedicalProfessionals
Jennifer Duffy、Carol M. Cram 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
MicrosoftOffice2013ThirdCourse
Carol Cram、Lisa Friedrichsen、Lynn Wermers 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
Microsoft Systems Management Server 2.0 管理员指南
Microsoft 公司 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
Microsoft Windows 2000 Directory Sernices 基础结构设计
[美]Microsoft 公司 著
您可能感兴趣 / 更多
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
飞行动力学与飞行控制
Wayne Durham 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
TheLordOfTheRings:AReader’SCompanion[指环王:读者指南]
Wayne G. Hammond、Christina Scull 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
VisualGuidetoElliottWaveTrading(BloombergFinancial)
Wayne Gorman、Jeffrey Kennedy 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
WayneRooney:MyDecadeinthePremierLeague
Wayne Rooney 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
WayneRooney:MyDecadeinthePremierLeague
Wayne Rooney 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
In the Service of His Korean Majesty:William Nelson Lovatt, the Pusan Customs, and Sino-korean Relations, 1876-1888
Wayne Patterson
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
INVESTMENT MANAGEMENT: MEETING THE NOBLE CHALLENGES OF FUNDING PENSIONS DEFICITS AND GROWTH
Wayne H. Wagner、Ralph A. Rieves 编
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
WayneRooney:TheWayItIs
Wayne Rooney 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
TheDoorWithin
Wayne Thomas Batson 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
AmericanArt:HistoryandCulture,RevisedFirstEdition
Wayne Craven 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
AtlasoftheHumanSkull
Wayne H. Sampson 著
Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
TheQuotableLewis
Wayne Martindale 著