BUSINESS DATA ANALYSIS & MODELING WITH EXCEL

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