Business Analysis

Business Analysis

Updated Jul 22, 2024

What you'll learn

  • Learn the Excel basics you'll need to be a brilliant Business Analyst
  • Learn to test your spreadsheets for errors and create simulated Excel models
  • Learn to use Dynamic Ranges and Logical Functions to manage and manipulate your data
  • Understand which chart, graph, or table you need to communicate your analysis effectively
  • Learn to create charts from large datasets and learn about dynamic charts
  • Master Pivot Tables and learn to use Slicers, Filters and Pivot Charts
  • Learn to compare various business scenarios and learn to use the Scenario Manager in Excel
  • Learn to forecast using curve fitting, trendlines, smoothing data and regression
Course Description

Successful enterprises make the most out of the information available to them. They derive value from the numbers driving their business – and this course presents a wide range of practical skills in managing these numbers.
The Business Analysis course will take you through a proven, structured process to improve your ability to collect, analyze and forecast information to generate valuable insights and make well-supported business decisions.

This course combines practical Excel tutorials with real-world business scenarios to help you develop your skills in business analysis, data analysis, and financial forecasting. 

Course Prerequisites
This Business Analysis course assumes you have a basic understanding of Microsoft Excel, including basic data handling, spreadsheet structure, and spreadsheet formatting. 

Course Details
This Business Analysis course uses a combination of text, bitesize videos, downloadable practice exercises and interactive knowledge checks.