Performing data analysis and forecasting in Excel 365

Excel Microsoft 365 (2021)    |    Expert
  • 9 Videos | 32m 10s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 1 Likes 1
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.

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

  • Playable
    1. 
    Overview: Performing data analysis and forecasting in Excel 365
    50s
    UP NEXT
  • Playable
    2. 
    Consolidating data
    3m 22s
  • Locked
    3. 
    Using data tables for what-if analysis
    3m 25s
  • Locked
    4. 
    Using formulas to estimate loan-related costs
    4m 10s
  • Locked
    5. 
    Using the forecast tool
    3m 38s
  • Locked
    6. 
    Forecasting data with formulas
    4m 48s
  • Locked
    7. 
    Performing analyses with Analyze Data
    3m 32s
  • Locked
    8. 
    Querying data sources with Power Query
    4m 16s
  • Locked
    9. 
    Managing data sources with Power Query
    4m 9s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.