Performing data analysis and forecasting in Excel 365

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Explore how to make the most of your Excel 365 content by understanding the potential for data analysis and forecasting. Key concepts in this course include how to use formulas to estimate loan-related costs, and manage repayments. Learn how to insert a forecast worksheet to display trends and make predictions based on available historical data. You will find out how to combine the NPER function with the IF and OR functions to forecast data that meets one or more criteria; and observe how to use what-if, variable-based scenarios that, once created, let you adjust values and change your calculation options. Additionally, you will explore how to use the Analyze Data tool to analyze a dataset to look for patterns in the data and how to use the Power Query tool to import or connect to an external data source, such as a database. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.