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 course will take you through a proven, structured process to improve your ability to collect, analyse and forecast information to generate valuable insights and make well-supported business decisions.

Employing exercises and solutions easily adaptable for your own workplace, this course employs a combination of written materials, screenshots, videos and over 60 professional spreadsheet models (especially developed for Excel 2007/2010/2013).

Business Foundation-Business Analysis

 

Module 1: Introduction

1.1- Turning Numbers into Better Business Decisions

Module 2: The Business Analyst's Excel Toolbox

2.1- Essential Excel for Business Analysis
2.2- Professional Tools for Business Analysts

Module 3: Collecting and Managing Business Data

3.1- Importing and Exporting Data
3.2- Power Functions for Managing Business Data

Module 4: Communicating Your Message

4.1-Your Stakeholders and Their Needs
4.2- Data Presentation Formats That Work

Module 5: Winning Charts for Business Communication

5.1- Professional Charting
5.2- Dynamic Charts
5.3- Some Special Charts for Business Analysis

Module 6: Looking Inside Your Data (Analysis)

6.1- Analysing Data with Pivot Tables
6.2 - Managing Pivot Tables Output

Module 7: Comparing Business Scenarios

7.1- Decision Making with Compared Scenarios
7.2- The Scenario Manager

Module 8: Looking Outside Your Data (Forecasting)

8.1- Time Series and Forecasting
8.2- Working with Moving Averages
8.3- Introduction to Regression
 
 

Need Onsite, Group or Tailored Training?

Business Foundation

Let's get started



FAQ's

  • Do you provide training for groups?
    • Group training is an option across all of the titles we teach.
  • Can the training be done virtually?
    • Yes, all of our titles can be delivered virtually where the student and instructor are in different locations.
  • Can it also be done at our location?
    • We have trainers available for onsite as well.
  • What if our team is dispursed across the country or globe?
    • Satellite locations and virtual classrooms can be set up across our 3,000+ location of classrooms.
  • What if we don't need to be trained on all of the content in the standard agendas?
    • All of our titles can be tailored to accomodate the organizational learning objectives.
  • Can the students learn even if they cannot attend a live session?
    • Yes, many of our titles are available On Demand which means 24/7 access to learning content.
  • Can the students get help if they have questions?
    • Our team of learning professionals are always available to answer questions or provide assistance..
  • Check all of our FAQ's