Performing data analysis and forecasting in Excel 365

IN THIS COURSE

• 1.  Overview: Performing data analysis and forecasting in Excel 365
  50s
  This video outlines the key content covered in this Microsoft 365: Performing data analysis and forecasting in Excel 365 course, including how to consolidate data, use formulas to estimate loan-related costs, and how to manage data sources using the Power Query tool. FREE ACCESS
• 2.  Consolidating data
  3m 22s
  Excel 365's powerful Consolidate feature enables you to extract data that's spread across multiple worksheets or workbooks and combine it all into a single table. You can also decide what calculation to perform during the data consolidation. In this video, you will discover how to consolidate your data in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.4.1 Summarize data from multiple ranges by using the Consolidate feature. FREE ACCESS
• 3.  Using data tables for what-if analysis
  3m 25s
  Data tables are a great way of testing different what-if scenarios when analyzing data. You can use data tables to create calculations using one or two variables and once the data table has been created, you can adjust the values and change the calculation options. In this video, you will explore how to use data tables for what-if analysis in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.4.2 Perform what-if analysis by using Goal Seek and Scenario Manager. FREE ACCESS
• 4.  Using formulas to estimate loan-related costs
  4m 10s
  If you have taken out a loan, Excel 365 can help you to estimate and manage your repayments. For example, you can calculate your total repayments per period, interest repayments, and loan repayments. In this video, you will explore how to use the PMT, IPMT, and PPMT functions to estimate loan-related costs in Excel 365. This video aligns with MOS MO-201 / Excel Expert Certification exam objective: 3.4.4 Calculate financial data by using the PMT() function. FREE ACCESS
• 5.  Using the forecast tool
  3m 38s
  In Excel 365, you can use one-click forecasting to make predictions based on historical data. You can also adjust the timeline and seasonality settings, and make changes to the forecasted data once the sheet has been inserted. In this video, you will explore how to use the Forecast tool in Excel 365. FREE ACCESS
• 6.  Forecasting data with formulas
  4m 48s
  If you need to calculate how many months it would take you to reimburse a loan according to a fixed monthly payment and an interest rate, you can use the NPER function. You can combine the NPER function with the IF and AND functions and forecast data that meets one or more criteria. In this video, you will explore how to forecast data with formulas in Excel 365. This video aligns with the MOS MO-201 / Excel Expert Certification exam objective: 3.4.3 Forecast data by using the AND(), IF(), and NPER() functions. FREE ACCESS
• 7.  Performing analyses with Analyze Data
  3m 32s
  The Analyze Data tool in Excel 365 can perform an analysis of a dataset to look for patterns in the data to make clever, personalized recommendations for you. In this video, you will explore how to use the Analyze Data tool in Excel 365. FREE ACCESS
• 8.  Querying data sources with Power Query
  4m 16s
  With Power Query in Excel 365, you can import or connect to an external data source, such as a database, and then shape that data in ways that meet your needs to load it into a query in Excel to create charts and reports. In this video, you will explore how to use Power Query in Excel 365. FREE ACCESS
• 9.  Managing data sources with Power Query
  4m 9s
  In Excel 365, Power Query is a powerful tool that allows you to import data and then transform and reshape it as needed. You can change a column’s data type, delete and add columns; and even combine data from two different sources, in order to get a fresh analytical view. In this video, you will explore how to manage data sources with Power Query in Excel. FREE ACCESS