• Home
  • About Us
    • Who We Are
    • Management Team
    • Our Customers
    • Careers
      • Vacancies
      • Upload Resume
    • Take Video Tour of CREM’s Facility
    • News & Event
    • CREM Gallery
  • Services
  • e-Learning
  • Research Portal
    • Articles
    • Insights
  • Training
    • 2025 Open Training Calendar
    • Training Registration
  • CREM Alumni
    • Registration
  • Contact Us
    • FAQs
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
      • Management Team
      • Our Customers
      • Careers
        • Vacancies
        • Upload Resume
      • Take Video Tour of CREM’s Facility
      • News & Event
      • CREM Gallery
    • Services
    • e-Learning
    • Research Portal
      • Articles
      • Insights
    • Training
      • 2025 Open Training Calendar
      • Training Registration
    • CREM Alumni
      • Registration
    • Contact Us
      • FAQs
  • info@cremnigeria.org
CONTACT US
CREM Nigeria
CREM Nigeria
  • Home
  • About Us
    • Who We Are
    • Management Team
    • Our Customers
    • Careers
      • Vacancies
      • Upload Resume
    • Take Video Tour of CREM’s Facility
    • News & Event
    • CREM Gallery
  • Services
  • e-Learning
  • Research Portal
    • Articles
    • Insights
  • Training
    • 2025 Open Training Calendar
    • Training Registration
  • CREM Alumni
    • Registration
  • Contact Us
    • FAQs
CONTACT US

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

  • 1, Adebayo Oyelana Street, beside Ejigbo Mini Stadium, Ejigbo Isolo Lagos
  • (+234) 901 323 4481
  • info@cremnigeria.org

Learning

  • e-Learning Portal
  • Login/Register
  • Blog

Recent Posts

Key Account Management
Key Account Management
  • April 8, 2025
UBA
UBA
  • April 8, 2025

© 2024 CREM Nigeria. All Rights Reserved.

Designed by NSG