Performing data analysis and forecasting in Excel 365

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 Resources section.