EAN: 9780137613663

MICROSOFT EXCEL DATA ANALYSIS AND BUSINESS MODE...

Master business modeling and analysis techniques with Microsoft Excel 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. A lot has changed in Office 365 since the previous edition. This
new edition covers new functions (STOCKHISTORY  LET  LAMBDA  XLOOKUP) and new array functions.
It also covers the new Data types that have been added. Finally  we've increased the coverage
of Power Pivot   Macros  and Power Query. Practice with more than 800 problems  many based on
actual challenges faced by working analysts. Solve real business problems with ExcelGÇö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 investmentsGÇö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

Aktuelle Preise zur EAN 9780137613663

Produktinformationen zur 9780137613663