DYS544 - Making Predictions with Data

Enter your quote details

In order to execute the most informed business analyses, we need the right tools for making predictions from data. Excel provides powerful predictive analytic tools that let the user forecast trends and make predictions with historical data.

In this course, you will conduct financial analyses by comparing loan scenarios using financial functions, identifying what values are needed to achieve a desired result, and quickly identifying how changes in your data will impact outcomes. You will leave this course with the ability to leverage reliable historical data to generate simulations and make predictions.

Learning Objectives

1. Analyze financial data using Excel
2. Forecast and predict data using Excel analytics
3. Create variable data tables
4. Understand basic analytic simulations

Content Delivery Method


HRD Corp Certified Course


Duration and Language

Self Paced, English

Target Audience

• Anyone who manages functional or financial data to inform business decisions
• Managers and executives responsible for resource allocation and reporting
• Analysts interested in developing a business management mindset to make their
analyses and data visualizations more meaningful to stakeholders
• New analysts or people interested in moving into an analyst role
• Individuals and entrepreneurs who need to visualize data or want a refresher on
using a modern version of Excel
• People in office support roles, administrative and executive assistants
• People providing support at any level

Key Skillset Addressed

Forecast trends, predictive analytics, spreadsheet modeling