Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition
- 作者
- 出版社 Microsoft Press
- 出版时间 2019年4月
- ISBN 9781509305889
内容简介
MasterbusinessmodelingandanalysistechniqueswithMicrosoftExcel2019andOffice365andtransformdataintobottom-lineresults.Writtenbyaward-winningeducatorWayneWinston,thishands-on,scenario-focusedguidehelpsyouuseExceltoasktherightquestionsandgetaccurate,actionableanswers.NewcoveragerangesfromPowerQuery/Get&TransformtoOffice365GeographyandStockdatatypes.Practicewithmorethan800problems,manybasedonactualchallengesfacedbyworkinganalysts.SolverealbusinessproblemswithExcel—andbuildyourcompetitiveadvantage:QuicklytransitionfromExcelbasicstosophisticatedanalyticsUsePowerQueryorGet&Transformtoconnect,combine,andrefinedatasourcesLeverageOffice365’snewGeographyandStockdatatypesandsixnewfunctionsIlluminateinsightsfromgeographicandtemporaldatawith3DMapsSummarizedatawithpivottables,descriptivestatistics,histograms,andParetochartsUseExceltrendcurves,multipleregression,andexponentialsmoothingDelveintokeyfinancial,statistical,andtimefunctionsMasterallofExcel’sgreatchartsQuicklycreateforecastsfromhistoricaltime-baseddataUseSolvertooptimizeproductmix,logistics,workschedules,andinvestments—andevenratesportsteamsRunMonteCarlosimulationsonstockpricesandbiddingmodelsLearnaboutbasicprobabilityandBayes’TheoremUsetheDataModelandPowerPivottoeffectivelybuildanduserelationaldatasourcesinsideanExcelworkbookAutomaterepetitiveanalyticstasksbyusingmacros
在售商品
2家店有售 新书0家
￥150.00起
综合价格品相店铺 只看全新
— END —