Performing data analysis and forecasting in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 9 videos | 32m 10s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)
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.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this performing data analysis and forecasting in excel 365 course
    Use the consolidate feature in excel 365
    Use data tables for what-if analysis in excel 365
    Use the pmt, ipmt, and ppmt functions to estimate loan-related costs in excel 365
    Use the forecast tool in excel 365
  • Forecast data with formulas in excel 365
    Use the analyze data tool in excel 365
    Use the power query tool in excel 365
    Manage data sources using the power query tool in excel 365

IN THIS COURSE

  • 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
  • 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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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
  • Locked
    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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Rating 4.5 of 2813 users Rating 4.5 of 2813 users (2813)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 163 users Rating 4.4 of 163 users (163)
Rating 4.4 of 201 users Rating 4.4 of 201 users (201)
Rating 4.4 of 438 users Rating 4.4 of 438 users (438)