Analyzing and forecasting data in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Excel 365 is a powerful tool for data management tasks, such as consolidating, analyzing, and forecasting. This course offers a deep dive into these advanced features of Excel 365 to optimize how to handle data from different sources and get useful insights. First, discover the different What-If Analysis tools to evaluate different scenarios. Learn how to use the Scenario Manager tool to compare different data outcomes and delve into What-If Analysis with data tables to perform sensitivity analysis. The course further explores Goal Seek for achieving specific data outcomes and employs the Solver add-in for solving complex optimization problems. Next, discover different tools to forecast data in Excel. For example, use the Forecast Sheet tool for visual predictions. Financial analysis is not overlooked, as the course covers estimating loan-related costs using Excel functions such as PMT, IPMT, and PPMT. Excel also provides two intelligent tools to get insights on how to analyze your data. Discover the Analyze Data feature for AI-powered analysis, and get to grips with the Copilot tool for advanced data insights through natural language processing. Lastly, discover how to consolidate data from various sources for streamlining the process of analysis and reporting. Explore Power Query, an essential part of Excel for data importation, transformation, and efficient data source management, including maintaining connections and automating data refreshes. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.