About this Course

An often overlooked area of Excel is its power to derive answers from the data entered. This takes Excel out of the realm of a mere spreadsheet and into the realm of a “modeller”. The ability to build analytical solutions and conclusions.

Objectives

Upon completion of this workshop, participants will be able to;

• This course aims to empower existing Excel users who wish to take their skills further and venture into the areas of data modelling, financial expositions, statistical summaries and scenario management.
  

Target Audience

This course would benefit anyone who needs to apply advanced analysis techniques to more complex data sets.

Duration

Two days

Methodologies

A good foundation in Excel is essential for this course. Participants should be familiar with absolute versus relative cell referencing, basic and conditional functions and formulae syntax, chart creation, as well as worksheet linking. Having attended an advanced course is advantageous.

A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course.

Experiential learning approach is adopted where the learners will be required to consider the experience as a learning process joined with critical reflection which further qualifies for this theory to be applied for this course because at each segment, the learners are introduced to some form of experience after which they are asked to reflect on these experiences before sharing with each other and putting ideas into practice.

Rate this course:

Log in to submit

Comments