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 cur …
