Microsoft Excel 2019 Data Analysis and Business Modeling ( Business Skills ) (6TH ed.)

Winston, Wayne (

  • 出版商: MicroSoft
  • 出版日期: 2019-04-28
  • 定價: $1,750
  • 售價: 9.5$1,663
  • 貴賓價: 9.0$1,575
  • 語言: 英文
  • 頁數: 880
  • 裝訂: paperback
  • ISBN: 1509305882
  • ISBN-13: 9781509305889
  • 相關分類: Excel資料科學

立即出貨 (庫存 < 3)

商品描述

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