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.
- 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
- 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:
Duration & Venue:
April 23 to 25, 2023
April 09, 2023
Local Organizations (Nepal Based) $190
International Organizations (Nepal Based) $240
Other Countries $440
Early Bird Discount:
10 % discount will be offered if registered before March 31, 2023.
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.
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 firstname.lastname@example.org
For Further Information, Please Contact:
Tel: +92 321 55 65 072 or +92 316 58 87 783