The best tool available today for exploring real-life questions of quantity and change!!

What this course is about:

In today’s increasingly data-driven world, MS Excel makes it easy and intuitive to view and analyze data. It is a powerful and widely used tool that helps people analyze information to make more informed decisions. Using MS Excel, you can share and manage your analysis and insight with coworkers, customers, and partners with greater confidence. Find the tools you want when you need them using the results-oriented office fluent user interface in MS Excel. Based on the job you need to accomplish, whether it’s creating a table or writing a formula, MS Excel presents the appropriate commands when you need them.

Scope of the training

This course encompasses intermediate to advanced level features in Microsoft Excel. In this course, we will cover inserting a variety of formulas and functions, charts, paste special, scenario formulas auditing, and locking and security. This training will also enable the participants to learn the data analysis, import & consolidate the data, sort & advance filter options, use of pivot tables & charts, create dashboards, and form controls.

Course contents

• Inserting Formula
• Advanced financial functions
• Advanced statistical & mathematical functions
• Advanced logical and reference functions
• Advanced date & time functions
• Advanced tools for database management
• Conditional formatting
• Goal seek functions
• Pivot table and Chart
• Formula auditing
• Scenarios
• Data validation
• Import data
• Consolidate function
• Multiple “if”
• Macro Basics
• Dashboard Functions

Methodology of training

The mixed-method approach will be used to inculcate the adult learning principles for the training. To make it highly innovative, the trainer will use lectures, demonstrations, individual assignments, and exercises. The training will be conducted in a friendly environment where the participants will be encouraged to bring forward their queries and share their thoughts and opinions. Participative practical activities will reinforce individual and group learning. The training will be evaluated at every day’s end to know the shortcomings/lacking and will be improved for the next day.

Who should participate?

• Humanitarian professionals including managers, supervisors/officers.
• Existing Excel users looking to improve their skill base.
• Self-taught learners looking to improve Excel working knowledge.

Medium of Instruction:

English

Duration & Venue:       

May 11 to 12, 2023

Kathmandu- Nepal

Registration Deadline:   

May 10, 2023

Training Fee:

Local Organizations  (Nepal Based)                               $140

International Organizations (Nepal Based)                  $190

Other Countries                                                                  $240

Residential Package: 

Residential Package is available at the venue hotel on payment of required charges.

Discount Policy: Group Discount (from same organisation):

On every three paid nominations from same organisation, one person (i.e fourth one) will be free of charge.

In-House Training:

CRSM also offers this training for your organisation as an in-house event. This will be cost effective and customised for your organisation’s specific needs.

To discuss this, please contact CRSM representative at +92 321 55 65 072 or +92 316 58 87 783 or mail to registration@crsmconsulting.net

For Further Information, Please Contact:

Email: registration@crsmconsulting.net

Tel: +92 321 55 65 072 or +92 316 58 87 783