• Home
  • About Us
    • Who We Are
    • Clients
    • Careers
      • Vacancies
      • Upload Resume
    • Contact Us
    • Alumni
      • Registration
  • Services
  • Research Portal
  • Learning
    • COO’s Welcome
    • In-Class Courses
      • Faculties
        • Faculty of Management & Administration
        • Faculty of Business Technology
        • Faculty of Governance Risk & Compliance
        • Faculty of Finance
        • Faculty of Enterprise & Entrepreneurship
        • Faculty of Environmental Management
    • Blog
      • Thought Leadership
  • News & Events
    • News
    • Gallery
    • Newsletter
    • Communique
  • CSR
    • Activities
CREM Nigeria

CREM is a service provider in the areas of Research, Enterprise, workforce management training delivery across Nigeria and West Africa. CREM is set to equip organization’s human resources with skills, competences and change creating capacities.

    • Home
    • About Us
      • Who We Are
      • Clients
      • Careers
        • Vacancies
        • Upload Resume
      • Contact Us
      • Alumni
        • Registration
    • Services
    • Research Portal
    • Learning
      • COO’s Welcome
      • In-Class Courses
        • Faculties
          • Faculty of Management & Administration
          • Faculty of Business Technology
          • Faculty of Governance Risk & Compliance
          • Faculty of Finance
          • Faculty of Enterprise & Entrepreneurship
          • Faculty of Environmental Management
      • Blog
        • Thought Leadership
    • News & Events
      • News
      • Gallery
      • Newsletter
      • Communique
    • CSR
      • Activities
  • info@cremnigeria.org
Login / Register
Apply
CREM Nigeria
CREM Nigeria
  • Home
  • About Us
    • Who We Are
    • Clients
    • Careers
      • Vacancies
      • Upload Resume
    • Contact Us
    • Alumni
      • Registration
  • Services
  • Research Portal
  • Learning
    • COO’s Welcome
    • In-Class Courses
      • Faculties
        • Faculty of Management & Administration
        • Faculty of Business Technology
        • Faculty of Governance Risk & Compliance
        • Faculty of Finance
        • Faculty of Enterprise & Entrepreneurship
        • Faculty of Environmental Management
    • Blog
      • Thought Leadership
  • News & Events
    • News
    • Gallery
    • Newsletter
    • Communique
  • CSR
    • Activities
Apply

BUSINESS DATA ANALYSIS & MODELING WITH EXCEL

  • May 15, 2018
  • CREM Nigeria
  • 0

Overview

This course is designed to provide participants the skills in developing and mastering the more powerful features of Excel. Knowledge of these tools can increase efficiency and provide participants with improved methods and approaches towards managing and analyzing data and business problems.

Participants will learn practical steps to analyzing business data, which will help them optimize current operations and determine the outcomes of their decisions.

 

KEY LEARNING OBJECTIVES

Upon successful completion of this course, participant should be able to:

  • Create data tables
  • Sort and filter data
  • Group and outline structured data
  • Use Excel’s data analysis tools
  • Use and apply data validation
  • Create and work with charts

 

COURSE OUTLINE

  • Spreadsheet Modelling
  • Basic Optimization Modelling
  • Advanced Optimization Modelling
  • Decision Tree Modelling
  • Simulation Modelling
  • Building Models
  • Masking, Range Names and Absolute References
  • Array Formulae
  • Cashflow Calculations
  • Investment Appraisal
  • If and LOOKUP functions
  • Advanced Formulae Tricks
  • Scenarios, Goal Seeking
  • Data Tables
  • Budget variance
  • Budgeting and Control
  • Flexible budget model
  • Fixed budget model

 

TARGET PARTICIPANT

  • Finance & Account Officers
  • Admin Officers
  • Business Development officers
  • Data Officers
  • Inventory Managers

 

 

Course Duration: 3 days

facebookShare on Facebook
TwitterTweet
FollowFollow us
  • Previous DELIVERING POWERFUL PRESENTATION WITH MS POWERPOINT
  • Next MICROSOFT OFFICE SUITE
CREM Nigeria

Subscribe to Newsletter

CREM Nigeria

Address

  • 3, Tina Chris Street, Beside Ejigbo Mini Stadium, Ejigbo-Isolo, Lagos.
  • (+234) 901 323 4481
  • info@cremnigeria.org

Learning

  • Profile
  • Login/Register
  • Blog

Recent Posts

A Panacea to loss of Human Capital in Nigeria
  • March 21, 2023
Dealing with Consumer Pain Points
  • March 3, 2023

© 2022 CREM Nigeria. All Rights Reserved.

Designed by NSG