Module 4: Using Excel to Support Decisions

This module explores how Excel can be used to support simple business decisions. Businesses regularly use spreadsheets to compare figures, review budgets, monitor performance, and identify trends within data.

The focus of this module is understanding what spreadsheet results mean and how Excel outputs can help support everyday operational and financial decisions.

For example, a business may compare monthly sales figures to identify periods of strong or weak performance. Excel allows this information to be organised clearly so that trends and patterns are easier to recognise.

Businesses may also use spreadsheets to:
- review expenses
- compare costs
- monitor stock levels
- analyse sales performance
- track budgets against actual spending

Worked Example:

A business notices that office supply costs increased over three consecutive months. By reviewing spreadsheet data in Excel, the manager identifies that printing expenses are rising faster than expected.

Based on this information, the business decides to reduce unnecessary printing and introduce digital alternatives to lower costs.

This example demonstrates how spreadsheets can support practical decision-making using organised business data.

Excel is especially useful because it allows information to be updated quickly and reviewed efficiently without requiring complex software systems.

By the end of this module, you will be able to review spreadsheet outputs and use simple Excel data to support basic business decisions.

Activity:

Review your spreadsheet data and consider what the numbers show. Identify any trends, such as:
- higher costs
- lower sales
- changes over time
- products generating higher revenue

Then write down one simple business decision that could be made based on the information.

Examples may include:
- reducing costs
- increasing stock levels
- changing pricing
- improving budgeting

This activity highlights how Excel outputs support practical business decision-making and improve understanding of operational data.

Reflection Question:

Why is organised and accurate spreadsheet data important when businesses make decisions?

Last modified: Tuesday, 26 May 2026, 11:37 AM