Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills)

Microsoft Excel 2019 Data Analysis and Business Modeling (Business Skills)

<p>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. </p> <p>Solve real business problems with Excel-and build your competitive advantage:</p> <p> </p> <ul> <li>Quickly transition from Excel basics to sophisticated analytics </li> <li>Use PowerQuery or Get & Transform to connect, combine, and refine data sources </li> <li>Leverage Office 365's new Geography and Stock data types and six new functions </li> <li> Illuminate insights from geographic and temporal data with 3D Maps </li> <li>Summarize data with pivot tables, descriptive statistics, histograms, and Pareto charts </li> <li>Use Excel trend curves, multiple regression, and exponential smoothing </li> <li>Delve into key financial, statistical, and time functions </li> <li>Master all of Excel's great charts </li> <li>Quickly create forecasts from historical time-based data </li> <li>Use Solver to optimize product mix, logistics, work schedules, and investments-and even rate sports teams </li> <li>Run Monte Carlo simulations on stock prices and bidding models </li> <li>Learn about basic probability and Bayes' Theorem </li> <li>Use the Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook </li> <li>Automate repetitive analytics tasks by using macros</li> </ul> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p>