Data Analysis and Business Modelling with Excel

Course Objectives

  • Demonstrate technical expertise with summarizing, reporting, and analyzing data in Excel.
  • Build analytic models to increase profits, reduce cost, and manage operations.
  • Evaluate investments using net present value criteria and interest rate of return.
  • Work with advanced functions for sensitivity analysis, including data tables and scenario manager.
  • Demonstrate technical expertise with Solver to determine optimal product mix, schedule work teams, solve transportation or distribution issues, for capital budgeting and financial planning.

Course Modules

Module 1: Working with Range Names
Module 2: Financial and Conditional Functions
Module 3: Three Dimensional Formulas and Auditing
Module 4: Sensitivity Analysis
Module 5: Solver
Module 6: Evolutionary Solver
Module 7: Importing and Validating Data
Module 8: Consolidating Data
Module 9: Analysis of Variance
Module 10: Random Variables
Module 11: Using Resampling to Analyze Data

Get To Know The Trainer

Trainer Shabenah

 4.5

Shabenah  is  an  experienced  corporate  trainer,  facilitator  and  consultant with  deep  knowledge  in  the field of IT, soft skills, leadership and communication. She has a great passion for training,  learning and development,  and  is  able  to  work  effectively  with  people  of  all  levels.  Shabenah is also an active participant in local community and social activities.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM1,999/DAY

RRP RM2,860/DAY   SAVE RM861

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

No review yet.

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?