Advanced Excel Skills – AES

Advanced Excel Skills - AES 2

Advanced Excel Skills - AES

Participants will learn to use functions moving from average to advanced level in Excel to improve work productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work. They will apply visual elements and advanced formulas to worksheets to display data in various formats.

Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s functionality to simplify and streamline their day-to-day work.

Upon completion of the training program, participants will be able to:

  • Calculate with advanced functions & formulas
  • Organize worksheet and table data using multiple techniques
  • Create and modify charts & graphs
  • Analyze data using Pivot Tables and Pivot Charts
  • Insert graphic objects
  • Customize and enhance workbooks and the Microsoft Excel environment

Participants will also learn how to deploy Advanced Excel techniques to increase productivity and improve efficiency by streamlining the workflow, collaborate with others using workbooks, audit worksheets, analyze data, Work with multiple worksheets & workbooks, Import and export data in Excel.

  • Excel is the most popular and preferred spreadsheet software
  • It is a hands-on tool for businesses to generate memos, track sales trends and other business data and to do financially-related activities
  • It is used by individuals to organize their information
  • Business professionals
  • Developers
  • Data analysts
  • Project managers
  • IT professionals

Objectives:

This training course aims to give a hand to the participants in mastering:

  • Building great charts
  • Using conditional formatting
  • Identifying trends
  • Having an online access to Excel
  • Collecting, verifying and analyzing business data
  • Administrating and managing duties
  • Accounting and budgeting
  • Reporting and visualizations
  • Forecasting

Topics:

  • Creating Your First Custom Format
  • Understanding the Date & Time Format Strings
  • Using Date & Time Custom Format
  • Understanding Conditional Formatting
  • Assigning Names to Groups of Cells
  • Managing Named Range
  • Using Names in Formulas
  • Understanding Formulas & Functions
  • Create a Relative & Absolute Reference
  • Working with Logic Functions
  • Working with Text Functions
  • Using More Text Function
  • Working with Lookup Functions
  • Understanding VLOOKUP Function
  • Understanding HLOOKUP Function
  • Challenge Using Formulas & Functions
  • Create and Modify Tables
  • Sorting and Filtering Data in a Table
  • Build an Advanced Filter
  • Getting Summary Information in a Table
  • Calculate Total Row in a Table
  • Display Special Formatting for First or Last Column
  • Summing with Subtotals & Grand Totals
  • Validating Data During Entry
  • Working with Database Functions
  • Challenge 04: Organizing Worksheet & Table Data
  • Summarizing Data Visually Using Charts
  • Customizing Chart Data
  • Format Chart Legend and Titles
  • Changing the Chart Body
  • Saving the Chart as a Template
  • Creating a Pie Chart
  • Creating Combination Charts
  • Challenge 05: Working with Chart
  • What is a Pivot Table
  • Anatomy of a Pivot Table
  • How does a Pivot Table Works
  • Create a Basic Pivot Table Report
  • Rearranging a Pivot Table Report
  • Customizing a Pivot Table
  • Changing Summary Calculations
  • Adding and Removing Subtotals
  • Sorting in a Pivot Table
  • Filtering in a Pivot Table
  • Working in a Group Environment
  • Commenting in Cells
  • Tracking Changes in Workbooks
  • Turn on Track Changes
  • Accepting or Rejecting Changes
  • Review Changes
  • Keeping a Backup of your Changes
  • Create a Change History
  • Linking to Other Workbook
  • Create a Link to Other Workbooks
  • Consolidating Multiple Sets of Data
  • Consolidate Multiple Worksheets
  • Protecting Your Worksheet
  • Protect a Worksheet
  • Unprotect a Worksheet
  • Allowing Access to Parts of a Worksheet – I
  • Allowing Access to Parts of a Worksheet – II
  • Protecting Your Formulas
  • Protecting Your Workbook
  • Save Your Workbook with Password
  • Encrypting your Workbook
  • Recording & Testing a Macro
  • Using the Developer Tab
  • Create a Macro
  • Relative and Absolute Recording
  • Testing the Macro
  • Running and Deleting Macros
  • Using the Macro dialog box
  • Using a Shortcut key
  • Placing a Macro on the Quick Access Toolbar
  • Delete a Macro
  • Saving a Workbook with a Macro
  • Saving a Macro to the XLSM Workbook
  • Saving a Macro to the Personal Macro Workbook
  • Macro Security
  • Creating Practical Macros
  • Inserting a Header
  • Participants should have some knowledge about the basic data warehousing and data modeling concepts.
  • Participants are also preferred to have some working knowledge with Excel.
To learn more fill the following form (English or Arabic) and a training consultant will call you:

Palestine Mentors eBook

Palestine Mentors is an initiative that promotes the concept of mentorship among Palestinians.

Visit us on Facebook at: https://www.facebook.com/Palestinementors/

DOWNLOAD below our 2019 e-BOOK:

50 Questions & Answers by Palestinian Mentors and Mentees

Palestine Mentors eBook 5
[This graphic above will be replaced with the cover of the real book]

For more information we can be reached at: palestinementor@gmail.com

Risk Management Professional – RMP

Risk Management Professional - RMP 7

Risk Management Professional - RMP

Projects by their nature always carry uncertainty (risk). Effective risk management is a key contributor to project success. This training highlights your ability in the specialized area of assessing and identifying project risks while mitigating threats and capitalizing on opportunities. In this capacity, you enhance and protect the needs of your organization.

  • Understand the risk concepts and risk management process
  • Learn tools and techniques to manage the risk effectively
  • Inspire to implement the management of risk into practice
  • Provide an understanding of the theory and practice of risk management in projects
  • Develop an approach risk management for any project
  • Conduct a formal risk assessment and develop your own risk management plan
  • Improve the identification of risk on your types of projects
  • Access the risk: define the scale and understand the exposure
  • Prepare the realistic responses
  • Use the tools to manage the risk effectively
  • Develop strategies for responding to identified risks
  • Control and monitor risks throughout the project

Anyone involved in the management of projects.

Objectives:

RMP aims to:

  • Understand the risk concepts and risk management process
  • Learn tools and techniques to manage the risk effectively
  • Inspire to implement the management of risk into practice
  • Provide an understanding of the theory and practice of risk management in projects
  • Develop an approach risk management for any project
  • Conduct a formal risk assessment and develop your own risk management plan
  • Improve the identification of risk on your types of projects
  • Access the risk: define the scale and understand the exposure
  • Prepare the realistic responses
  • Use the tools to manage the risk effectively
  • Develop strategies for responding to identified risks
  • Control and monitor risks throughout the project

Topics:

  • Definition of Project Risk Management
  • Uncertainty
  • Roles and Objectives
  • Critical Success Factors
  • Definition of Project Risk
  • Individual Risks and Overall Project Risk
  • Types of Risk
  • Risk Factors
  • Stakeholders Risk Attitudes
  • Risk Appetite, Tolerance, and Threshold
  • Plan Risk Management
  • Identify Risks
  • Perform Qualitative Risk Analysis
  • Perform Quantitative Risk Analysis
  • Plan Risk Responses
  • Monitor & Control Risks

The process of defining how to conduct risk management activities for a project:

  • Critical Success Factors
  • Creating a Risk Management Plan
  • Risk Categories
  • Risk Breakdown Structure (RBS)
  • Definitions of Risk Probability and Impact

The process of determining which risks may affect the project and documenting their characteristics:

  • Risks Identification
  • Critical Success Factors
  • Methods of Documenting Risks
  • Information Gathering Techniques
  • Checklist Analysis
  • Diagraming Techniques
  • Developing a Risk Register
  • The process of periodizing risks for future analysis or action by assessing and combining their probability of occurrence and impact:

    • Critical Success Factors
    • Probability & Impact Scales
    • Determining Risk Ranking within the Project and Between Projects
    • Project Risk Score
    • Probability & Impact Matrix
    • Risk Data Quality Assessment
    • Risk Urgency Assessment
    • Analytics Hierarchy Process (AHP)

The process of numerically analyzing the effect of identified risks on overall project objectives:

    • The Purpose of Quantitative Risk Analysis
    • Critical Success Factors
    • Data Gathering and Representative Techniques
    • Probability Distribution
    • Three Point Estimating
    • Quantitative Risk Analysis and Modeling Techniques
    • Sensitivity Analysis
    • Tornado Diagram
    • Expected Monetary Value (EMV)
    • Decision Tree
    • Modeling and Simulation
    • Monte Carlo Simulation

The process of developing actions to enhance opportunities and to reduce threats to project objectives:

  • Critical Success Factors
  • Risk Response Strategies for Threats and Opportunities
  • Residual Risks
  • Secondary Risks
  • Contingent Response Strategies
  • Contingency Planning and Fallback Planning
  • Reserves
  • Creating a Budget
  • Multi-Criteria Selection Technique
  • Scenario Analysis

The process of implementing risk response plans, tracking identified risks, monitoring residual risks, identifying new risks, and evaluating risk process effectiveness throughout the project:

  • The purpose of Monitor & Control Risks
  • Risk Reassessment
  • Risk Audits and Risk Reviews
  • Variance and Trend Analysis
  • Reserve Analysis
  • Workarounds
  • Exam Content Outline
  • Practice Exam

Prerequisites

Have a good basic understanding of and experience in the project environment.

To learn more fill the following form (English or Arabic) and a training consultant will call you:

Certified International Purchasing Manager – CIPM

Certified International Purchasing Manager – CIPM 11

Certified International Purchasing Manager – CIPM

Certified International Purchasing Manager – CIPM 12

The Certified International Purchasing Manager (CIPM) is a new program for current and future purchasing & supply chain professionals and managers, reflecting levels of understanding and of competence needed to assume responsibility for managing purchasing & supply chain operations at the international level. It is based on a Learning System (LS) developed by the International Trade Centre (ITC), and conducted by the prestigious International Purchasing and Supply Chain Management Institute.

  • Learn further about procurement processes in different sectors
  • Understand the international standards and best practices for purchasing and procurement
  • Identify supply chain trends

This program is specially designed for professionals, managers, and executives who are involved in purchasing and/or supply chain management at the international level. It is also suitable for those who are planning to venture into this field of specialization.

Objectives:

CIPM aims to:

  • Identify purchasing and supply management
  • Actively engage participants to analyze the strategies of sourcing
  • Define the operations and structure of purchasing
  • Follow the non-lecture style demonstrating strategic sourcing processes
  • Explain the critical elements of the supply chain
  • Provide relevant material for each participant

Topics:

  • Introduction to Purchasing and Supply Chain Management.
  • The Purchasing Process
  • Purchasing Policy and Procedures.
  • Purchasing and Supplier Integration for Competitive
  • Advantage. Purchasing and Supply Chain Organization
  • Purchasing and Category/Commodity Strategy Development
  • Supplier Evaluation and Selection
  • Supplier Quality Management
  • Supplier Management and Development: Creating a World-Class Supply Base
  • Worldwide Sourcing
  • Strategic Cost Management
  • Purchasing and Supply Chain Analysis: Tools and Techniques
  • Effective Negotiations: Preparation and Execution
  • Contracting: Developing and Managing Effective
  • Purchasing Law and Ethics
  • Contract Administration: Getting the Goods and Services You Ordered, As You Ordered Them (And Supplier Development), Purchasing Services
  • Supply Chain Information and E-Systems
  • Sourcing and Supply Performance Measurement and Evaluation
  • Purchasing and Supply Chain Changes and Trends

Prerequisites

None

To learn more fill the following form (English or Arabic) and a training consultant will call you:

Certified Internal Auditor (CIA) – Parts I, II & III

Certified Internal Auditor (CIA) - Parts I, II & III 14

Certified Internal Auditor (CIA) – Parts I, II & III

Certified Internal Auditor (CIA) - Parts I, II & III 15

The CIA is the only globally accepted designation for internal auditors and the standard by which individuals demonstrate their professionalism in internal auditing. Moreover, earning the CIA designation is more than just proof of what you know and what you’ve achieved — it’s the best way for auditing professionals to communicate to the world that they are prepared to meet today’s challenges.

Earning the CIA designation is a valuable accomplishment and a professional advantage for auditors at all stages of their careers, including chief audit executives, audit managers, audit staff, and risk management staff, as well as students enrolled in an accounting or other business or financial degree program.

  • Certified Internal Auditor® (CIA®) is the optimum way to communicate knowledge, skills, and competencies to effectively carry out professional responsibilities for any audit, anywhere. 
  • Adding the CIA credential to your resume, LinkedIn profile, and business card will help you stand out and demonstrate you are a true expert who understands and can apply the International Standards for the Professional Practice of Internal Auditing.
  • As a CIA holder, you are stronger, more competent professional who is knowledgeable in organizational governance.
  • Makes you more committed to the profession of internal auditing and equipped for career-advancing opportunities.
  • Auditors
  • Bankers
  • Accountants

Objectives:

Upon completion, the trainee will be better able to:
  • To prepare for the CIA in the most efficient way
  • To learn about the tips of passing the exam
  • To manage time in order to cove the material
  • To prepare practically for the exam

Topics:

125 questions | 2.5 Hours (150 minutes)

The revised CIA exam Part 1 is well aligned with The IIA’s International Professional Practices Framework (IPPF) and includes six domains covering the foundation of internal auditing; independence and objectivity; proficiency and due professional care; quality assurance and improvement programs; governance, risk management, and control; and fraud risk. Part One tests candidates’ knowledge, skills, and abilities related to the International Standards for the Professional Practice of Internal Auditing, particularly the Attribute Standards (series 1000, 1100, 1200, and 1300) as well as Performance Standard 2100.​

The CIA exam Part 1 topics tested include:

  1. Foundations of Internal Auditing (15%)
  2. Independence and Objectivity (15%)
  3. Proficiency and Due Professional Care (18%)
  4. Quality Assurance and Improvement Program (7%)
  5. Governance, Risk Management, and Control (35%)
  6. Fraud Risks (10%)

100 questions | 2.0 Hours (120 minutes)

The CIA exam Part 2 includes four domains focused on managing the internal audit activity, planning the engagement, performing the engagement, and communicating engagement results and monitoring progress. Part 2 tests candidates’ knowledge, skills, and abilities particularly related to Performance Standards (series 2000, 2200, 2300, 2400, 2500, and 2600) and current internal audit practices.​

Domains   

  1. Managing the Internal Audit Activity (20%)
  2. Planning the Engagement (20%)
  3. Performing the Engagement (40%)
  4. Communicating Engagement Results and Monitoring Progress (20%)

100 questions | 2.0 Hours (120 minutes)

The CIA exam Part 3 includes four domains focused on business acumen, information security, information technology, and financial management. Part 3 is designed to test candidates’ knowledge, skills, and abilities particularly as they relate to these core business concepts. Domains           

  1. Business Acumen (35%)
  2. Information Security (25%)
  3. Information Technology (20%)
  4. Financial Management (20%)

Prerequisites

  1. Candidates must hold a bachelor’s degree or its equivalent from an accredited university or college.
  2. A CIA candidate must obtain a minimum of 24 months of internal auditing experience or its equivalent.
To learn more fill the following form (English or Arabic) and a training consultant will call you:

Advocacy and Lobbying (A&L)

Advocacy and Lobbying (A&L) 17

Advocacy and Lobbying (A&L)

Advocacy and Lobbying (A&L) 18

Following an overview of the New Tactics 5 Steps to Strategic Effectiveness Method, the information in the toolkit is divided into the following sections:
1 – Identify the Problem
2 – Create a Vision
3 – Map the Terrain
4 – Explore Tactics
5 – Take Action

  • Identify A&L concepts and tools.
  • Learn about the advocacy and lobbying process in an organization
  • Career growth and better job opportunities.
  1. Humanitarian NGOs and CBOs
  2. Individuals working in human rights

Objectives:

Upon completion, the trainee will be better able to:
  • Understand RBM in n a changing development context
  • Understand relevant methodologies and tools for results-based planning, monitoring and evaluation.
  • Learn how develop a results framework and design and use indicators

Topics:

Advocacy and Lobbying (A&L) 19

Trainer Bader Al Hudhud

Bader Al Hudhud is a certified trainer in Advocacy and Lobbying with over 12 years of experience. He produced the Social Entrepreneurship Training Manual, and is active in Leadership and civic engagement. He is also a certified trainer in PTS (Life and Employability skills), Adult education and Advocacy training. Al Hudhud is talented in delivering youth engagement training; he trained more than 1500 youth from different universities and marginalized areas locally and in the region. Mr. Al Hudhud effectively contributed in establishing Partners for Sustainable Development organization in 2009, where, as the Program Director, he is leading the PSD community learning and development centers (CLDCs) and working on several initiatives related to education and ICT, youth development, Women’s Economic development, after-school programs and community development initiatives. Mr. Al Hudhud also coordinates a microcredit project for women in South Hebron where he leads the creation of a women’s business network that links businesses in the southern and northern West Bank to each other. Al Hudhud is experienced in designing creative ideas for community development and has developed proposals for various issue areas, including economic, social and educational programs targeting children, youth and women. Mr. Al Hudhud is the author of “Positive Extracts in Youth Rising” book. Mr. Al Hudhud holds BA in Information and Communication Technology- minor Management from the Arab American University in Jenin (AAUJ).

To learn more fill the following form (English or Arabic) and a training consultant will call you:

Results-Based Management (RBM)

Results-Based Management (RBM) 21

Results-Based Management (RBM)

Results-Based Management (RBM) 22

Results-Based Management (RBM) is currently the standard framework utilized by the majority of local and international organizations. RBM methodologies and tools are used for project planning, monitoring, evaluation and learning in order to track progress and capture impact.

This training will develop knowledge of the RBM approach and understand its methodologies and tools. In addition, you will have the opportunity to practice the learning using practical examples.

  • Identify RBM concepts and tools.
  • Learn about the monitoring and evaluation process in an organization
  • Career growth and better job opportunities.
  • Project/ program coordinators/ managers,
  • M&E officers responsible for project/ program implementation and improve M&E practices at their organizations.

Objectives:

Upon completion, the trainee will be better able to:
  • Understand RBM in n a changing development context
  • Understand relevant methodologies and tools for results-based planning, monitoring and evaluation.
  • Learn how develop a results framework and design and use indicators

Topics:

  • RBM in changing contexts
  • The project/ program cycle
  • Development of project/ intervention objectives
  • Logical framework/ Theory of change (ToC)
  • Developing indicators
  • Work plans
  • Project monitoring approaches tools and methods
  • Planning for project monitoring
  • Data collection and analysis
  • Monitoring as a management tool
  • Project evaluation approaches, tools, and methods
  • Incorporating evaluation in project design
  • Developing evaluation plans
  • Results-based reporting (preparation – implementation)
  • Good practices in reporting
  • How to use the information for decision- making/ policy and advocacy activities/ exist, scaling up

Prerequisite(s)

Interested participants must complete a survey to identify their needs and expectations prior to the training. In addition, a pre and post surveys will be designed to assess the knowledge of participants before and after the training.

To learn more fill the following form (English or Arabic) and a training consultant will call you:

Palestine Mentors

Palestine Mentors 23

منكِ نستفيد

تقوم مؤسسة أصوات حيوية كل عام بإطلاق حملة مسير سنوية بمناسبة يوم المرأة العالمي من خلال مشاركات شاركن في برامج المؤسسة من حول العالم في السنوات الماضية وتهدف هذه المبادرة إلى بناء علاقات مهنية بين السيدات ليرشدن بعضهن في معترك الأعمال.

رِتَاج تكرم مُدربيهَا أثناء جلسة التّخطيط لِعام 2019

English below.

رِتَاج تكرم ِمُدربيهَا أثناء جلسة التّخطيط لِعام 2019

رِتَاج تكرم مُدربيهَا أثناء جلسة التّخطيط لِعام 2019 25

أشارت المدير العام لشركة رتاج للحلول الإدارية إلى: “إنّ الأفكار التي نتجت من خلال إشراك مُدَربينا تُؤكّد عَلى دورههم الجَوهري في نقل المعرفة لخدمة التّنمية الاقتصادية بشكل عام والتنمية الفردية على وجه الخصوص”

(رام الله -30 كانون الأول 2018)
قدمت شركة رتاج للحلول الإدارية، وهي شركة تدريب رائدة مقرها رام الله، رسالة شُكر تُعرب فيها عن تقديرها لمُدربيها كجزء من جلسة التخطيط لعام 2019 الذين اختاروا التدريب سبيلا لنقل المعرفة. تعمل رتاج مع مجموعة من المدربين من قطاعات متنوعة لطرح برامج تدريبية تؤهّل الحصول على شهادات معتمدة دُوليّاً، بالإضافة إلى طرح برامج تدريبية لتطوير القدرات الشخصية والمهنية
تركز شركة رتاج على قطاعي الأعمال والتنمية، حيث جمع هذا اللقاء مختلف المدربين ممن عملوا مع رتاج أو ممن يحتمل التعاقد معهم مستقبلا للتشاور في البرامج التدريبية الأكثر صِلة بتطور دولة فلسطين، لا سيما في ظل الظروف الاقتصادية الراهنة
المُدَربُون الذين تم تقديرهم هم: السيد بهجت لدادوة، خبير في إدارة المشاريع، والسيد فراس أبو قطيش، خبير في التدقيق المالي، والسيد وجيه الرفاعي، خبير في تكنولوجيا المعلومات، والسيد محمود بيضون، خبير في الصحة النفسية، والسيد بدر الهدهد، خبير في الريادة وتنمية الشباب، والسيدة ربا مصلح، خبيرة في بناء القدرات وتنمية الشباب، والسيد سمير بيضون، خبير في التخطيط الاستراتيجي، والسيد سائد كرزون، خبير في الإعلام الرقمي، والسيد محمد برغوثي، خبير في إدارة الموارد البشرية، والسيد طارق درابيع، خبير في المحاسبة، والسيدة رانية فلفل، خبيرة في اللغات والترجمة، والسيد وحيد زهران، خبير في الإدارة، والسيد وحيد جبران، خبير في التدريب، والسيد محمود خويص، خبير في إدارة المشتريات، والسيد رياض جمعة، خبير في الريادة والإدارة
وتَرأّست هذه الجلسة السيّدة نسرين مُصلح، المدير العام لشركة رتاج للحلول الإدارية. حيث أشارت إلى ” إنّ الأفكار التي نتجت من خلال إشراك مُدَربينا تُؤكّد عَلى دورههم الجَوهري في نقل المعرفة لخدمة التّنمية الاقتصادية بشكل عام والتنمية الفردية على وجه الخصوص”

Ritaj Appreciates its Trainers in a 2019 Planning Session

رِتَاج تكرم مُدربيهَا أثناء جلسة التّخطيط لِعام 2019 25

Ritaj’s Managing Director: “The insights gained by engaging our trainers reaffirms their key role in transferring knowledge for the sake of our overall economic and personal development.

(Ramallah – 30/12/2018) – Ritaj Managerial Solutions, a leading training company based in Ramallah, offered a token of their appreciation to their trainers today as part of a 2019 planning session. Ritaj works with a pool of trainers in all fields of international certification training, as well as personal and professional development training.

Ritaj focuses on the business and development sectors and met with existing trainers and prospective trainers to plan which trainings are most relevant to Palestine’s development, especially given the difficult market conditions.

Those trainers who were appreciated during the event were: Mr. Bahjat Ladadweh, expert in project management; Mr. Firas Abu Qtaish, expert in financial auditing; Mr. Wajih al Refai, expert in IT; Dr. Mahmoud Baidoun, expert in psychological health; Mr. Bader Al hudhud, expert in entrepreneurship and youth development; Ms. Ruba Musleh, expert in capacity building and youth development; Dr. Samir Baidoun, expert in strategic planning; Mr. Saed Karzoun, expert in digital media; Mr. Mohammad Barghouthi, expert in human resources; Mr. Tarek Drabea, expert in accounting; Dr. Rania Filfil, expert in translation; Mr. Wahid Zahran, expert in management; Mr. Wahid Jubran, expert in training; Mr. Mahmoud Khweis, expert in procurement; and Mr. Riyad Joma, expert in entrepreneurship and management.

Moderating the event was Ms. Nisreen Musleh, Managing Director of Ritaj Managerial Solutions, Ms. Musleh, noted that “The insights gained by engaging our trainers reaffirms their key role in transferring knowledge for the sake of our overall economic and personal development.”