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
 
 

Business Foundation

Learn more about COD

Need Onsite, Group or Tailored Training?

FAQ's

  • What is the difference between On Demand and Virtual Classroom?
    • On demand is learn at your own pace on your schedule while virtual classroom is instructor-led at set time and dates.
  • With On Demand, do I have access 24/7?
    • Yes, you can login and work with the material and labs anytime you like.
  • Do I need any special software?
    • A browser and an Internet connection is all you need.
  • For Virtual Classroom, is it taught by a live instructor?
    • Yes
  • Are the courses monitored by experts?
    • Yes, we only work with subject matter experts with many years of consulting and training.
  • Can I ask follow up questions with the Instructor?
    • Yes, that's why we are here.
  • How long do I have access after I sign up?
    • Most courses are 90 days but some of the bundles are one year.
  • Can I take both On Demand and attend a Virtual Classroom session for a discount?
    • Yes, just talk to one of our COD representatives and they can provide bundle discounts and pricing.
  • How long does it take after I sign up?
    • Usually within 24 hrs or less.
  • Check all of our FAQ's