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:

Risk Management Professional – RMP

Advanced Excel Skills - AES 5

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: