* All fees are exclusive of vat
** PREMIUM - Customize your learning experience
Course Description
This course will advance your data massaging, modeling, integration and automation skills to new levels. You will also master normalization and massaging of noisy data, preparation of reports, analysis, and reconciliation.
This is an Excel-based course allowing you to develop a new level of expertise and adding immediate value to your job.
What Do Participants Learn?
Apply Excel reporting expertise in business, finance, and accounting by enhancing data slicing and dicing, data massaging, and data analysis skills
Use pivot tables and pivot charts to perform automated report writing, analysis and reconciliation most efficiently
Develop special flash and management reports by linking-up Excel with Access, web, text, SQL, and other databases
Repeat tasks and generate reports efficiently by recording, running and editing macros
Acquire numerous tips and tricks that will improve working efficiency
Who Should Attend?
Business, finance, and accounting professionals, senior and junior accountants, business analysts, research professionals, marketing and sales professionals, administrative staff, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliation, and analysis.
What Will the Learning Experience Include?
Phase: 1
Introduce
- Comprehensive pre-program activities include:
- Web-based information forms & surveys completed by attendee.
- Direct consultation with the attendee about the expectations.
- During the training, participants engage in data, activities, and conversations that lead to insight and knowledge.
- Participants learn from expert trainers who have both academic and business experiences.
- Highly applicable training content & instructive activities for adding depth to training topics.
- **A half-day site visit for integrating the experience & plan next steps. Opportunities to provide connections, ideas & support.
Phase: 2
Explore & Practice
Phase: 3
Apply
- Apply & sustain the learning experience by using this ongoing support:
- To ensure participant has new skills or behavior progress.
- Optional, fee-based mentoring & coaching with the trainer.
- Training materials & additional documents (e-books, pdf files, presentations and articles)
- Evaluate your training experience by giving us feedbacks and help us to reach our organizational goals.
- Participant's Evaluation
- Trainer's Evaluation
Phase: 4
EVALUATE
Day 1:
Data massaging: tools and techniques
Consolidating data from separate files and sheets
Advanced data validation using lists, dates and custom validation
Cell management tools: left, right, mid, concatenate, value
Naming, editing, and managing cells and ranges.Subtotal, Sumif, Sumifs, Sumproduct, Count, Countif, Countifs
Looking-up data, texts, and values using Vlookup .The incredible table-tools technique
Slicing dates into day names, weeks, week numbers, month names, years and quarters
Text to columns and dynamic trimming using Trim, Len
Managing texts and numbers using replace, find and substitute
Text change functions
Day 2:
Reporting, analysis, and reconciliations using pivot tables
The 20 must learn rules
Creating pivot tables
Number formatting techniques Designing report layout
Sorting in ascending, descending and more sort options
Filtering labels and values
Expanding and collapsing reports
Summarize data by sum, average, minimum, maximum, count
Show values as % of total and % of
Pivot table options
Drill down option
Showing report filter pages
Inserting formulas
Date analysis
Copying pivot tables
Creating pivot charts
Dynamic chart labeling
Mastering the slicer
Linking pivot tables and pivot graphs with PowerPoint
Conditional formatting with pivot tables
Designing reports using GetPivotData
Day 3:
Modeling and integration techniques
Perform 'what-if' analysis using spinner
Checkbox data modeling with 'if' function
Option button data modeling with 'if' function
List box data modeling with 'Choose' function
Linking Excel with text files
Linking Excel with databases (Access)
Linking Excel with multiple Excel files and SQL
Linking Excel with internet
Linking Excel with Excel
Scenario manager
Day 4:
Introduction to learning the ultimate tool in Excel: ''Macros''
Macro basics
Planning a macro
Designing your control board
Recording macro
Testing macro
Editing macro
Macro workshops
Advanced filter with macro
Day 5:
Tips and tricks in Excel
Data entry form
Custom list
Camera tool
Text to speech
Protecting worksheets and workbooks
Related Trainings
Enterprise Supply Chain Management Training
Fundamentals of Railway Systems
Railway Metro Systems Design and Installation
Principles of Railway Operations
Rolling Stock & Railways Noise Control
Certified Lead Auditor for ISO 55000:2018
HSE - Occupational Health and Safety for Administrators
MS Word, MS Excel, MS Outlook,MS Power Point
Derailment Investigation
Bridge Inspection
Creative Thinking
Light Transit Rail Maintenance and Operations
HVAC Fundamentals
Utility Protection for Railway Systems
Creating Dashboards with Excel Masterclass: Data Visualization for Business Reporting
Building and Facilities Maintenance Management
Optimising Equipment Maintenance & Replacement Decisions
Fundamentals of Autodesk Revit MEP (BIM) and Computational Fluid Dynamics (CFD)
Knowledge of Rail Systems
MEP, MEP Systems, MEP Services, Buildings and Construction Management
Laboratory Data Analysis
ISO 55001: Asset Management in Railways
Design Thinking and the Art of Creativity and Innovation Training
Exploring Data Analytics to Monitor Organisational Performance
Storytelling
Gamification, Motivation 4.0 & Behaviour Engineering
Industry 4.0
Digital Transformation
Artificial Intelligence
Mindfulness
Himsen Engines Operation and Maintenance
Global Supply Chain Management Skills Training
Auditing Corporate Governance
Qms Audit And IFRS for Oil & Gas Industry
Simplification of Work Processes and Procedures
Applying Statistical Process Control (SPC), Process & Performance Capability and 7 Quality control tools
Cybersecurity Law and Regulation
Java-Object Oriented Programming (OOP)
Artificial Intelligence (AI) Deep Learning
Modeling & Simulation (M&S) Basics
PC Configuration and Troubleshooting
IT Auditing and IT Fraud Detection
Cloud Management and Security: Principles and Best Practice
IT Distatser Recovery Planning
Advanced Digital marketing
Microsoft Technologies
DBA – MySQL – SQL Server
SAS – Statistical Analysis System
Construction Claims - Master Foundation Course
FIDIC Contracts Management: Practical Use of FIDIC Contracts
Certificate In Human capital Planning
Fundamentals of Blockchain
Financial Data Analysis
Fast Closing Monthly and Year-End Accounts
Cost Analysis to Support Strategic Decisions
Auditing in the Oil and Gas Industry Training
Cost Analysis, Control and Optimization
Advanced Financial Analysis
Advanced Excel: Power Query and Power Pivots
Accounts Receivable and Credit Policies Management
Accounts Payable: Accounting and Management Best Practices
Advanced Generator Maintenance Training
Advance Electrical Troubleshooting, Repairs and Isolations Techniques Training
Advanced Power Transmission Technologies Training
Oil and Gas Contracts Training
International Petroleum Management Training
International Gas Business Management Training
Essential Skills for Oil and Gas Managers and Supervisors Training
Mastering Maintenance Audits
Governance, Risk and Compliance (GRC)
Data Governance, Protection and Compliance Management
Credit Risk Assessment, Modelling and Management
Root Cause Failure Analysis
Process Plant Optimization Technology and Continual Improvement
Modern Maintenance Technologies
Materials of Construction for Process Equipment and Piping Systems
Fluid Flow and Heat Transfer in Industrial Applications
Maintenance and Reliability Best Practices
Machinery Failure, Vibration and Predictive Maintenance
Construction Supervision Skills
Well Completion Design
Production Operations
Basic Petroleum Technology Principles: ONLINE
Basic Petroleum Technology
Basic Drilling, Completion and Workover Operations – BDC
Basic Drilling Technology
Basic Drilling, Completion and Workover Operations
Influence and Persuasion in Project Management
Project Management for Transport Infrastructure
Ethics In Project Management
Integration Management
Managing Projects In Controlled Environment (PRINCE)
Feasibility Studies: Preparation, Analysis, Evaluation
Responsible Risk Taking
Project Management in IT Security (PMITS)
Maintenance of Drilling Rig
Maintenance of Electromechanical Machinery
Drilling Engineering
Post Occupancy Evaluation
Telecommunication Numbering Management Fundamentals
Project Contracts Management and Resolving Issues
Revenue and Operations Accounting
Principles of Asset Management
Introduction to Oil and Gas Industry
Alternative Dispute Resolution (ADR), Legal Mediation and Arbitration
Health and Safety and CDM Regulations
Lean Construction Principles and Methods
Balanced Scorecards
Financial Statements Analysis, Interpretation and Fixed Assets
Communication Strategy Design
Retail Business Management
Designated Project Knowledge
Systems Thinking
Developing, Monitoring & Reviewing Projects
Public Outreach & Engagement
Management Of Standards & Procedures
Procurement Analysis
Monitoring Trends In The Job Market
Data Storage System Management
Corporate Governance
General Ledger: Chart of Accounts
Claims, Arbitration and Dispute Management
Quality Assurance & Management System
Certified Quality Manager
Basics Of Sustainability In Facility Management
IOSH Certified - Working Safely
Basics of Concrete Laboratory
Marine Electricals: Generator Maintenance
DAIHATSU (OEM) Diesel Engine Operations & Maintenance
Certified Maintenance & Reliability Professional (CMRP)
ISO 9001, ISO 14001 and ISO 45001 Lead Auditor Training
Giving and Receiving Effective Feedback
Leading in a Time of Crisis: Communication Tactics
Project Leadership, Management and Communications During Pandemic
Mastering Entrepreneurship: From Creativity & Innovation to Business Strategy
HR Professionals as Coaches for Managers
Stakeholder Management: Influencing & Negotiating Skills
Creative Problem Solving and Decision Making Tactics
Digital Transformation Masterclass: Innovate, Digitize, Transform
Leadership and Innovation Management
Being a Successful Compensation and Benefits Professional
Leading with Effective Communication
Marketing Management
Administration and Office Management
Managing People and Team Leadership
Strategic Communication in the Digital World
Budgeting and Forecasting
Empowering Employee Engagement through Strategic Decisions
Creating a Successful Digital HR Strategy
Mastery of Human Resource Management
Mastering Finance Course For Non-Financials
The Power of Delegation Skills
HR Management in a Post-Pandemic World
Advanced Effective Communication Skills
Essentials of Collaboration & Teamwork
Strategic Planning and Business Plan Development
Problem Solving and Decision Making
Employee Relations: Motivation Power, Grievances and Attitude
Leadership Effectiveness for Managers
Marketing Communications & Brand Management
Stress Management
Managing Multiple Tasks, Priorities and Deadlines
Performance Management: Setting Objectives and KPIs
Job Evaluation & Analysis
Excellence in Leadership
Budgeting, Reporting and Fixed Assets
Stress Management
Effective Management
Time Management Planning and Stress Control
Creative Problem Solving and Decision Making
Emotional Intelligence (EQ)
Employee Well-being and Resilience
Agile Mindset Fundamentals
Plant Maintenance Instrumentation
Roller Press Plus Ball Mill System
Pyroprocess Operation and Process Simulation
Physical and Chemical Testing Using British Standards
Maintenance of MV Switchgears
Ball Mill Mechanical Maintenance
Gas Analyzer
Condition Monitoring Techniques in the Cement Industry
Cement and Clinker Microscopy
Cement Kiln Refractories
Bag Filters and Maintenance in Cement Industry
UPS and Battery Chargers
Negotiation and Influencing Skills (3 Days)
Financial Fundamentals
Maintenance Management, Audit and Evaluation
Business Etiquette and Protocol
Linking Training to Organizational Goals
Efficient Administration Skills
Performance Management & Career Path
HR Administration Skills
Financial Accounting, Reporting and Analysis
Sales & Sales Management for Professionals
The Complete Program of Marketing, Communications and Media Planning
Certified Lead Auditor for ISO 18295:2017 (CC)
IOSH Health and Safety/Managing Safely
Roads Safety in Design and on Site
Electrical and Designing
Illuminance Based Highway Lighting Design
Contract Preparation Essentials
Analysis of change orders and handling contract claims and disputes
Leadership Excellence
Roads Safety Audits
Internal Audit Performance Skills
ITS Engineering
Certified Lead Auditor for ISO 31000:2018 (Risk Management)
Certified Lead Auditor for ISO41001:2018 (Facilities Management)
Project Control, Cost Management
Human Resources KPIs
Governmental Accounting
Business Planning Fundamentals
VMware vSphere: Install, Configure, Manage [V6.7]
Executive Secretarial and Office Management
Certified Lead Auditor Training Course ISO 45001:2018
Health and Safety Advanced Site Based First Aid
Civil Engineering Standard of Measurement (CESMM 4)
Work Ethics
Organizing Meeting Skills
Information Security SEC 566
Engineering Ethics Advanced Level
Road Maintenance Management
Information Security ICS 410
Apple Deployment Workshop
Skills of Dealing with Superiors and Subordinates
Apple Deployment Essentials
Capital Project Budgeting
ArcGIS Pro
Lead Auditor ISO 9001
Accountability
Health and Safety: Lock Out Tagout
Teamwork
New Graduate Program
Interpersonal Skills
Management and Soft Skills
Customer Service
Planning, Organizing and Time Management
Communication Skills
HSE Occupational Health and Safety for Engineers
Financial Analysis
Project Management in Banking Industry
Financial Analysis (Skilled Level)
Compensation and Benefit Management
Supply Chain Risk Management
Financial Accounting and Detecting Fraud
International Financial Reporting Standards (IFRS)
Advanced Business and Financial Reporting - Next Generation Excel
Advanced Public Sector Financial Reporting and Analysis
F.M.M. Financial Modeling Master - Using Excel & VBA
Fraud Detection
Currency Management (Risk, Strategy & Asset Management)
Governmental Financial Issues
Financial Investment
Fault Detection and Maintenance of Diesel Engine
PLC Control Electrical Malfunctions Planning
Operation & Maintenance of Hydraulic & Pneumatic Power System
Operation & Maintenance of Hydraulic & Pneumatic Power System
Introduction to SCADA
First Aid
Cloud Computing Overview
ACI Concrete Technical Manager
Asset Integrity Management
Advanced Budgeting & Forecasting
Evaluating Performance & Quality Control on Employees
Building Code in Construction of Metro and Rail Works
Basic Railway
Cost Benefit Analysis (Transport Economics)
Performance Management
KPI Development
Health & Property Insurance
Claims Preparation and Dispute Management
Systems Thinking and Engineering Management
Revenue Recognition and Accounting Controls
Oil Refinery Process and Safety
Virtual Switching System VSS 1440/4T
Configuring Cisco Nexus 7000 Switches
Data Analytics for Internal Auditors
Bridge Maintenance and Inspection
Budgeting & Cost Control for the Oil & Gas Industry
Fiberglass Reinforced Plastic (GRP) Pipes and GRP Pipe System
Instrument & Control In A Water Utility System
Corrosion Control In Water Distribution Systems
Water Audits And Loss Control Programs
Trenchless Technology for Infrastructure Projects
Aviation Security Management
Subsurface Planning, Production Operations and Artificial Lift
Safety Features in Railway Systems
Dynamics 365 for Finance and Operations Apps Developer (MB-500T00)
General Insurance Claims Management
Strategic Alliances: Effective Communication and Protocols
Policy and Procedures for Document Management
The Advanced Executive Secretary Program
Migrating from ArcMap to ArcGIS Pro
Project Communications, Risk & Procurement Management
Healthcare Financial and Accounting Management Skills
Implementing Cisco Multicast
WMUAPI Replaced with MENPI
Billing and Credit Policy
Advanced Project Management (Operations Management)
Market Driving Strategies
FTTH Technology Training
Securing Networks with CISCO Firepower Threat Defense (Firepower200)
Implementing Cisco Catalyst 6500 Series Switches
ASR9KE (Replacement for ASR1K)
Organizational Behavior: Managing People at Work
Installation and Welding of GRP Pipe System
Effective Planning, Organizing & Delegating
Materials Quality Control & Testing, Technical Specification
Inspection Analysis & Technical Report Writing
Office Management Specialist
Improving Service Level Agreements
Internal Web Designing
Social Media Management
Efficient Finance and Accounting Operations - Best Practices and Updates
Safety Management in the Laboratory
Administration and Time Management
Data Analysis and Business Reporting
Project Management Life Cycle
Strategic Planning and Business Plan Development
Industrial Automation and Control
Industrial Instrumentation and Modern Control Systems
Asset Management in Drainage Operations
Decision Analysis for Operation & Maintenance
Risk Management, Control and Compliance
Managing Tenders, Specifications and Contracts
Operational Risk Management & Mitigation
Internal and External Payments in Oil and Gas
Certificate of Third Party Inspection
Leadership in Nursing
SharePoint Overview
Patient Safety
Strategic Branding
Talent Management - Developing Key Personnel
Generator Excitation Systems - New
Emergency Response Planning
Managing Multiple Tasks, Priorities and Deadlines
Diesel Pumps Maintenance and Inspection
Road Safety Management
Risk Analysis and Risk Management in Process Safety
Risk Management and Quality Assurance
Project Management Compliance: Scheduling, Planning and Controlling
Rapid Assessment and Recovery of Troubled Projects
Communicate with Influence
Logistics and Port Management
Effective Communication and Influence
Security Information and Event Management Training & Certification (SIEM)
Brand Positioning and Branding Mix
Intro to FIDIC: Red vs Yellow vs Silver Books
Fiscal Policy in Practice
Advanced Project Planning & Execution
Application of GIS in Construction Management
Strategic Procurement
Project Contract Administration & Close - Out, Dispute Analysis & Assessment
Mastering Entrepreneurship: From Creativity & Innovation to Business Strategy
Contracts Management
Machinery Failure, Vibration and Predictive Maintenance
Leadership Effectiveness for Managers
Advanced Claims Management
Managing Project Stakeholders
Effective Communication and Inspirational Presentations
Planning and Organizing
Communication Skills
ITIL Service Capability: Operational Support and Analysis (OSA)
Editorial Skills in Business (Intermediate)
Building Effective Employee Rewards and Recognition Skills
SEC401: Security Essentials Bootcamp Style
Managing and Leading Innovation
Odor Control Units (Introduction to Odor Regulation, Assessment and Control)
Employee Relations & Engagement
Managing Vendor Qualification Performance & Contract Compliance
Advanced Office Management & Effective Administrative Skills
Executive Secretary Skills
Advanced Pumps and Valve Technology
Mini MBA in Technologies for Telecommunications
Building and Evolving a Project Management Office
Improvement on Communication: English Writing & Speaking Skills
Project Management Fundamentals
Strategic Human Resources Management
Construction Management, Procedures And Implementation
Analytical Troubleshooting Complex Electrical Systems
Surge Arrester Application
Optimal Design of Solar Thermal (ST) and Photovoltaic Thermal (PVT) Systems
NEBOSH International General Training for Health and Safety
IOSH Certified - Managing Safely
Managing Employee Performance, Behaviour & Attitudes
Public Relations and Communication Skills (10 Days)
The Customer Service & Public Relations (10 Days)
Strategic International Relations Management
Technical Report Writing
Public Relations and Exhibition Management
The Art of Impactful Presentation
Advanced Public Relations Management
Public Relations and Communication Skills
Advanced Business Writing
Advanced Effective Communication Skills
Planning and Managing PR Campaigns
Business Writing and Internal Communication
Event Management
Organizational and Departmental Communication
Successful Business Report Writing
Public Speaking and Professional Presentation Skills
Public Relations, Marketing and Internal Communication
Managing Service Quality & Customer Satisfaction
Public Relations & Corporate Communications
Public Relations Management
Strategic Marketing, Brand Management & Public Relations
Problem Solving for Supervisors
Problem Solving for Managers and Leaders
Project Management using 6 Sigma
Lean Six Sigma for Managers
Cost reduction Using 6 Sigma Methodology
Lean Sigma for Supervisors
EFQM for Beginners
Managing Service Quality & Customer Satisfaction
Audits and External Quality Assessment in the Laboratory
Six Sigma Green Belt Training
Six Sigma Black Belt Training
Kaizen- Continuous Improvement
Strategic Planning Using the Balanced Scorecard: Turning Strategy into Reality
Business Improvement & Quality Techniques
Essentials of Quality Assurance
Quality Assurance & Control
Quality Assurance in Practice
Quality and Assurance and Management System (10 Days)
Benchmarking: Comparing Your Performance with the Best
EFQM: Leaders for Excellence
Process Mapping and Improvement
Strategic Quality Management
Business Process Analysis
Business Process Management And Quality
Lean Six Sigma
Managing Quality And Innovation
Total Quality Management (TQM)
Communication Skills Set Tips & Tactics
Rumor, Managing ‘Hot Air’ in Internal Communications and Corporate Apology
Strategic Communication Management and Tactics in New Digital World
Reputation Management in New Digital World
Reputation Management
Crisis Communication Management and Tactics
Digital Marketing and Social Media Management
Sales & Marketing in New Social Media
The Customer Service and Public Relations (10 Days)
Strategic Marketing, Brand Management & Public Relations
Strategic Marketing for Entrepreneurs
Retail Customer Service
ScrumMaster Workshop
SCRUM Product Owner
Introduction to SCRUM Methodology
Agile Project Management
HR for Innovation
HR Analytics
Personalization in HR
Training Trends and Technologies
Organizational Development
Change Management
Coaching Skills for HR Professionals or Line Managers
How to increase job satisfaction - Happy work environments
Strategic Human Resources Management and People Analytics Strategy
Employer Branding Management
Total Airport Management
Advanced Skills Customer Service and Revenue Generation
Sales Management Best Practices
Planning and Managing PR Campaigns
Mastering Sales and Marketing in the Age of New Social Media
Beyond Customer Service: Service Quality and Excellence
Measuring and Managing Customer Satisfaction
Channel Management: Maximizing Market Presence
The Strategic Marketing Plan
Managing Service Quality & Customer Satisfaction
Service Quality and Excellence: Beyond Customer Service
Customer Focused Management
Customer Relationship Management (CRM)
Customer Profiling Techniques
Customer Relations and Business Development Skills
Marketing Communications & Brand Management
Service Quality and Customer Satisfaction
Customer Service Management
Customer Service Excellence
Developing & Implementing Strategic Marketing Plans
Measuring Marketing Effectiveness & ROI
Marketing Channels
Marketing Management
Project Management in Telecommunications
Project Management Professional and Interpersonal Skills
Managing Multiple Projects
Portfolio Management Professional
Scheduling, Planning and Controlling
Construction Project Management
Construction Project Management (10 Days)
Construction Project and Risk Management (10 days)
Advanced Project Management
Financial Management for Project Development
Scheduling and Cost Control
Quality for Project Management
Project Management Applications
Introduction to Project Management
Project Planning Analysis and Control
Project Leadership, Management and Communications
Project Time and Cost Management
Mini MBA in Contracts & Project Management
Project Management and Implementation
Succession Planning and Career Development
Train the Trainer
Administrative Learning and Development
Total Reward Strategy, Policy and Procedure
The Art of Recruiting, Interviewing and Selecting Employees
Managing and Measuring Training, Learning and Development
Linking Training to Organisational Goals
HR as a Strategic Partner
Writing Effective Policies and Procedures
Leading Strategic HR Transformation
Managing Employee Performance, Behaviour & Attitudes
Competency-Based Management
The HR Essential Skills
Manpower Planning: Strategy Development, Execution & Assessment
Workplace Diversity and Talent Management
Training Needs Analysis & Training Evaluation
Employee Development & Empowerment
Linking Training to Organisational Goals
Performance Management: Setting Objectives and KPIs
Workforce Planning and Recruitment
Employee Relations: Motivation, Grievances and Discipline
Job Evaluation & Analysis
Human Resources Management
Environmental Impact Assessment
Solid Waste Management
Environment, Energy and Sustainability Management
Construction Project Managament
Construction Project Management (10 Days)
Construction Project and Risk Management (10 Days)
Land Acquisition, Resettlement and Social Sustainability
Road Design and Traffic Management
Hydraulic Fluid Power Fundamentals
Concrete Quality Control on Hot Climate
Foundation Design
Infrastructure Asset Management: A Strategic Approach Toward Sustainability
Non-Destructive Testing of Concrete Structures
Successfully Selecting Contractors and Consultants
Flood Control, Land Drainage and Stormwater Management
Construction Management - Common Mistakes Owners & Contractors Make That Cause Claims
Design and Analysis of Stormwater Management Ponds
Advanced Concrete Technology for Durable and Sustainable Civil Infrastructure
Building Condition Assessment
Structural Design of Industrial Buildings
Traffic Signal Design and Operation
Welding Design and Metal Fatigue for Structural Engineers
Structural Engineering for Non-Structural Engineers
Construction Management
Pavement Design & Construction of Municipal Roadways
GPS General Training And Software Applications
Construction Management And Supervising Multiple Projects
Construction Supervision Skills
Engineering Materials For Buildings And Bridges
Construction Quality Control On Site
Durability Of Reinforced Concrete Structures Assessment And Repair
Damage Assessment And Rehabilitation Of Concrete Structures
Assessment Of Defects In Concrete Structures and Infrastructure
Structural Design and Analysis
PLC, Telemetry & SCADA Technologies
Variable Frequency Drives (VFDs)
Diesel Generator Operation and Maintenance Technical Training
Training SLD design – Single Line Diagrams, Electrical Design
Electrical Engineering for Non-Electrical Engineers
Power System Analysis for Industrial Application
Introduction to LED Lighting and Luminaires
Lightning Protection and Transient Overvoltage
Electrical Engineering for Non-Electrical Engineers
Testing, Commissioning and Maintenance of Electrical Systems
Fundamentals of Electrical Distribution Systems
Fundamentals of Modern Substation Equipment, Protection and
Modern Power System Protective Relaying
Electrical Protection
Electrical Equipment & Control Systems
Generator Excitation Systems
Electrical Drawings and Control Circuits
Transmission Lines Design and Installation
AC Electrical Motors & Drives
ARC Flash Hazard Analysis: Impact, Control & Safety
Modern Electrical Power Systems
Electrical Circuits and Wiring Systems
Circuit Breakers and Switchgears
UPS Systems Operations and Maintenance
Smart Grid
SCADA Systems
IEEE Standards for Electric Power Systems in Buildings
Maintenance Planning, Scheduling & Work control
Electrical Installation Techniques, Testing, Operation & Maintenance
Electrical Transmission Lines – Design, Operation & Protection
Electricity Distribution Network Design
Electrical Faults and Troubleshooting
Fundamentals of Electrical Circuits
Site Acquisition and Asset Protection
Occupational Safety and Health Administration (OSHA)
HSE Management System
Fire & Explosion Hazard Management
Firefighting and Emergency Evacuation
Building and Facilities Security
Principles of Radiation Protection
Risk Management For Project Leaders
Respiratory Protection
Security Management, Planning & Asset Protection
Critical Incident Investigation
Risk Reporting
Risk Management: Understanding Risk Assessments, Risk Registers & the MATA Approach
Fundamentals of Risk Management (FoRM)
Advanced Safety Leadership
Developing an Effective Safety Culture
Contractor Safety Management
OSHA: Occupational Safety & Health Administration Standards
Safety and Protection of Corporate Facilities (10days)
Warehouse Safety Procedures and Safety Handling
Process Safety Management (LOPA & SIL)
Building and Facilities Security - Guard Officer
Safety and Protection of Corporate Facilities
Risk Based Process Safety Management (RBPS)
Safety Engineering and Hazard Control
Safety in Process Design
Safety Technology & Risk Management
Safety Audit & Site Inspection
Health & Safety Management
Safety Management Systems (SMS)
Financial Strategies & Management for Telecom Executives
Management Accounting in Telecommunications
Finance for Non-Financial Managers in Telecommunications
Budgeting in Telecommunication
Procure-to-Pay (P2P) Best Practices
Governmental Accounting, Financial Reporting and Budgeting
Claims and Counterclaims Preparation, Analysis, Assessment and Successful Settlement of Disputes
Financial Modeling
Budget Accounting and Cost Controlling
Budgeting, Planning and Management Reporting
Effective Audit Committees
CFO Strategy and Leadership Program
Internal Audit Advanced
Advanced Strategic Internal Auditing
Financial Analysis (Financial Acumen & Budgeting)
Risk Based Internal Auditing
Anti Money Laundering
Audit Universe & Process Auditing
Financial Management & Auditing
Internal Audit Basics
Review of Financial Accounting & Detecting Fraud
International Financial Reporting Standards (IFRS)
The Effective Accountant
Finance for Non-Financial Managers
Cost Analysis to Support Strategic Decisions
Financial Management for Projects & Contracts
Financial Analysis, Modelling & Forecasting
Cost Management, Financial Management, Budgeting and Cost Control
Cost Analysis and Negotiation Techniques
Insurance Principles
Cost Estimating
Islamic Finance
Financial Risk: Problems Analysis and Solving
Financial Accounting & Reporting
Treasury and Cash Management
Strategic Financial Planning & Implementation
International Public Sector Accounting Standards
Setting & Controlling Budgets
Understanding Finance to Influence Strategic Decisions
Accounting for Non-Accountants
Budgeting & Cost Control
Business Financial & Accounting Skills
Fast Closing Month-end & Year-end Accounts
Certfified Ethical Hacking
Certified Network Defense [CND]
CCISO
CCNA (CIVND2) Training
CCNA - Part 1 CIVND1e Training - Averest
Cisco Certified Network Associate Collaboration (CCNA)- Implementing Cisco Collaboration Devices (CICD)
Cisco Certified Design Associate (CCDA)
Implementing Cisco Cybersecurity Operations (SECOPS) Training
CCNA Understanding SECFND Training
CCNA IMINS2 Training
Cisco Certified Network Associate Data Center (CCNA Data Center) - Introducing Cisco Data Center Technologies (DCICT)
Cisco Certified Network Associate Data Center (CCNA Data Center)- Introducing Cisco Data Center Networking (DCICN)
Cisco Certified Network Associate Security (CCNA Security) - Implementing Cisco Network Security v3.0 (IINS)
Cisco Certified Network Associate Cloud (CCNA) CLOUD - Interconnecting Cisco Network Devices Part 1, Version (ICND2)
Cisco Certified Network Associate Cloud (CCNA) CLOUD - Interconnecting Cisco Network Devices Part 1, Version (ICND1)
Cisco Certified Network Associate Cloud (CCNA) CLOUD - Introducing Cisco Cloud Administration (CLDADM)
Cisco Certified Network Associate Cloud (CCNA) CLOUD - Understanding Cisco Cloud Fundamentals (CLDFND)
CCNA Routing and Switching
Data Center Infrastructure Expert (DCIE)®
Software Quality Management
Big Data Analytics
Certified Network Defender Program Course
Configuring Cisco Nexus 5000 Series Switches, DCNX5K v3.1
Implementing Core Cisco ASA Security (SASAC)
Information Security Management
Cyber Security Vulnerabilities and Risk Management
GIS Data Formats, Design and Quality Fundamentals
Geographic Information Systems Professional Concentration
Red Hat System Administration
Ethical Hacking
Information Security Management
CCNA Security
MCSA Training
Penetration Testing and Ethical Hacking (6 Days)
Cloud Computing & Virtualization
IT Risk Management
ITIL Foundation version 3
IT Data Storage Networks
Electronic Document and Record Management
Effective Business Decisions Using Data Analysis
IT Project Management
Airside Safety
Managing Weather Impacts: Aviation Safety & Flight Performance
Air Transport Engineering
Airport Terminal Management
Airport Ramp Management
Air Transportation Management
Management of Civil Aviation Quality and Service
GPON FTTx Training
Sponsorship Management
Business Process Improvement
Inventory Analysis and Stock Control Techniques
Warehouse Operations and Management
First Steps Towards Entrepreneurship
E-Procurement Course
Effective Events Management
Service Level Agreements
Empowerment in the Professional World
Corporate Social Responsibility
Leadership Training Course
Assertiveness and Confidence Building
Inspiring Leadership Through Emotional Intelligence
Problem Solving and Decision Making
Effective Time Management
Corporate Leadership and Management Skills
Intelligence in Communication and Negotiation
Leadership and Communication
Building and Managing Strategic Relationships and Partnership
Developing High-Performing Teams
Lead Conflict Management
Effective Delegation Skills for All Levels
Creating a Path towards Employee Engagement
Personal Leadership Development
Strategic Thinking & Business Planning
Professional Planning Specialist Skills
Leading & Change Management
Effective Development of Business Strategy
Leadership - Masterclass
Management - Masterclass
Stakeholder Management
Strategic Planning
Management & Leadership Development
Time Management & Stress Reduction
Creative Strategic Planning & Leadership
Leadership Development: Self-awareness, Skills & Strategies
Facilities Management
Technical Writing Guideline & Specification
Fundamental Negotiation Skills
Administration and Office Management
Logistics & Supply Chain Management
Fundamental Etiquette for Managers
Decision Making & Emergency Management
Corporate Leadership and People Management
Dynamic Leadership Skills
Leadership & Professional Development
Change Management and Operational Excellence
The Leadership Challenge
SS7 in Mobile Networks
SIP Advanced
5G Slicing
TCP / IP
SS7 Signalling in Mobile Networks
GSM UMTS LTE System Overview
VoLTE Overview
SIP Fundamentals
IMS VoLTE Training
5G System Overview
LNG Value Chain
LNG (Liquidify Natural Gas)
GSM Network Technology (10 Days)
Land Acquisition, Resettlement and Social Sustainability
Data Centre for Telecommunication
Fiber Optics Technique
CRM in Telecommunications
Telecom Technologies for Business
Beyond Regulation Stimulating Telecom Competition
Telecom Regulation for Today`s World
Petroleum Project Economics
Petroleum Refinery Processing
Oil & Gas Field Operations
International Oil Supply, Transportation, Refining & Trade
Understanding Success Factors in Oil & Gas Industry
Oil & Gas Commercial Contracts & Negotiation Skills
Finance & Accounting for the Oil & Gas Industry
Petroleum Engineering
Fundamentals of Oil and Gas Industry
Risk Management for Oil & Gas Projects
Oil & Gas Gravity Separation
Natural Gas Liquids Recovery (NGLs)
Natural Gas Dehydration Technology
Basic Instrumentation For Process Operators
Test Shadi
Download Brochure
Certification
Averest Training Certificate of Completion or delegates who attend and complete the training course
This course is certified by:
On-Site Training
This Course can be customized delivered to a group at your facility saving time and money.