The best tool available today for exploring real-life questions of quantity and change!!
What this training 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 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:
July 23 to 25, 2023
Kathmandu – Nepal
Registration Deadline:
July 18, 2023
Training Fee:
- Local Organizations (Nepal Based) $190
- International Organizations (NepalBased) $240
- Other Countries $440
Residential Package:
A Residential Package is available at the venue hotel on payment of required charges.
Discount Policy: Group Discount (from the same organisation):
On every three paid nominations from the 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 a CRSM representative at +92 321 55 65 072 or +977 98 106 3599 or mail to registration@crsmconsulting.net
For Further Information, Please Contact:
Email:registration@crsmconsulting.net
Tel: +92 321 55 65 072 or +977 98 106 3599
