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

  • What is Virtual Classroom?
    • Virtual Classroom is Instructor-led training delivered to dispersed students on specific dates and times. Students attend using a computer and Internet connection. Learn More.
  • What is On Demand?
    • On Demand allows students to learn at their own pace on their own time with the support from our instructors. Learn More.
  • Do you provide training for groups?
    • Group training is an option across all of the titles we teach.
  • Can it also be done at our location?
    • Yes, we have trainers available for onsite as well.
  • What if our team is dispursed across the country or globe?
    • Satellite classrooms can be set up across our 3,000+ worldwide locations. Learn More
  • What if we don't need to be trained on all of the content in the standard outlines?
    • All of our titles can be tailored to accomodate your organizational learning objectives.
  • Can the students be tested and monitored as part of the training objectives?
    • Yes, we have a Learning Mangement System (LMS) as part of our suite of learning management solutions. Learn More.
  • Check all of our FAQ's