Skip links

MS Excel Intermediate to Advance Level


Venue:                  Erbil – Iraq                                                           Registration Deadline:      October 13, 2022

Training Date:      October 23 to 25, 2022                                        Register before:                October 03, 2022 to get 10% Discount

“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:       

October 23 to 25, 2022

Erbil – Iraq

Registration Deadline:   

October 13, 2022

Early Bird Discount:  

10 % discount will be offered if registered before October 03, 2022.

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

Format

  • In-Person

Category

  • Training/Workshop

Themes

  • MS Office/ MS Excel

Course language

  • English

Mr. Wasi Haider

Trainer

Email: wasi@crsmcunsulting.com

Clear

Format

  • In-Person

Category

  • Training/Workshop

Themes

  • Project Manager

Course language

  • English
For Custom Training Request Register Here
Arabic Arabic English English Turkish Turkish