IT AND DIGITAL TRANSFORMATION

1.MS Excel – Basic & Advance

Course Objectives:

This Basic & Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

What will be covered?

Recording and Running Macros in Excel
Introduction to the Excel VBA Editor
Creating Procedures and Functions
Working with the Excel Object Model
Controlling Program Flow
Advanced Procedures
Advanced Variables
Interacting with Office Applications
Debugging and Error Traps
Creating Custom User Forms
Workbook and Worksheet Events

Who should attend?

Information workers

Training Methodology:

Classroom Training

Prerequisites (if any):

Experience installing PC hardware and devices.
Basic understanding of TCP/IP and networking concepts.
Basic Windows and Active Directory knowledge.
The skills to map network file shares.
Experience working from a command prompt.
Basic knowledge of the fundamentals of applications. For example, how client computer applications communicate with the server.
Basic understanding of security concepts such as authentication and authorization.
An understanding of the fundamental principles of using printers.

Language:

Arabic/English

Competencies covered:

Worksheets using Microsoft Excel 2016.
Perform calculations in an Excel worksheet.
Modify an Excel worksheet.
Modify the appearance of data within a worksheet.
Manage Excel workbooks.
Print the content of an Excel worksheet.
Use handy features new in 2016.

2.MS Excel 2013 – Dashboard & Report Analysis

Course Objectives:

By the end of the course, participants will be able to:

Use their Excel expertise in data slicing and dicing, data massaging, data aggregation, data integration with Access, web, text, SQL, and other databases using pivot tables
Perform advanced and dynamic data validations
Design outstanding visualization charts, dashboards, scorecards, and flash reports
Develop master-level report solutions using advanced form controls and buttons
Record, write and edit powerful macros that will perform routine tasks in no-time

What will be covered?

Essential reporting requirement skills

The 19 rules of pivot tables and pivot charts
Slicer techniques
Advanced pivot charts techniques
Multiple consolidation ranges
Retrieving external data using Microsoft query
Importing text files using MS query
Connecting to access databases
Connecting to SQL databases
Importing from data connection wizard
Importing from Microsoft query
Customizing connections properties

Advanced data structuring techniques

Custom and advanced data validation
Creating and managing innovative conditional formatting

Charting and visualization techniques

Creating dynamic labels
Using the camera tool
Working with formula-driven visualizations
Using fancy fonts
Leveraging symbols in formulas
Working with sparklines
Creating unconventional style charts
Fancy thermometer charts
Colored chart bars

Building report solutions

Conceptualizing and understanding report solutions
Developing a report solution
Configuring spreadsheet report data options
Enabling background refresh
Refreshing data when opening the file
Combo-box data modeling tool
List-box data modeling tool
Form controls data modeling tools
Spinner
Option-button modeling
Check-box data models
Combo and group-box

Macro charged reporting

Recording, editing, testing VBA macros
Building a macro driven reconciliation program
Building budget variance reporting program
Building a vendor and invoice analysis report

Who should attend?

Business professionals, accountants, finance analysts, senior and junior accountants, business analysts, accounting and finance professionals, research professionals, marketing and sales, administrative staff, supervisors, general staff from any function who need to learn and apply state-of-the-art techniques to their daily business reporting, reconciliations, and analysis. Pre-requisite: Intermediate-level Excel knowledge or attendance of ABH’s Next Generation Excel course.

Training Methodology:

Classroom

Prerequisites (if any):

None

Language:

Arabic/English

Competencies covered:

Reporting, analyzing, and reconciling
Data modeling
Integration with external data sources
Report structuring techniques
Automation and macros
Charting & visualization techniques

3.MS PowerPoint 2013

Course Objectives:

This course provides the basis for participant to demonstrate competence in using presentation tools on a personal computer. The participant shall be able to accomplish basic tasks such as creating, formatting and preparing presentations for distribution and display. The participant shall demonstrate the ability to create a variety of presentations for different target audiences or situations. The candidate shall demonstrate the ability to accomplish basic operations with graphics and charts and to use various slide show effects.

What will be covered?

Module 1. Exploring PowerPoint
Module 2. Using Basic Presentation Skills
Module 3. Working with Presentations
Module 4. Using the Outline Tab
Module 5. Editing and Proofing Text
Module 6. Formatting Presentation Text
Module 7. Formatting Bullets and Numbers
Module 8. Using Graphic Images
Module 9. Using Smart Art
Module 10. Using Slide Sorter View
Module 11. Using Slide Show View
Module 12. Working with Drawing Objects
Module 13. Creating Basic Charts
Module 14. Adding Special Effects
Module 15. Printing

Who should attend?

Highly recommended for anyone with limited knowledge of Microsoft PowerPoint and seeking a solid foundational understanding of the programme’s functions to create dynamic presentations.

Training Methodology:

Classroom

Prerequisites (if any):

An understanding of Windows / MS PowerPoint 2003/2007 will be an added advantage

Language:

Arabic/English

Competencies covered:

Enter Text and use basic text formatting
Use Themes and modify Templates
Create a PowerPoint presentation
Add, modify and adjust Pictures
Create and edit Shapes and Smart Art

4.Comp TIA+ Cyber security Analyst (CSA+™)

Chapter 1 Defending Against Cybersecurity Threats

Cybersecurity Objectives
Evaluating Security Risks
Building a Secure Network
Secure Endpoint Management
Penetration Testing
Reverse Engineering
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 2 Reconnaissance and Intelligence Gathering

Footprinting
Passive Footprinting
Gathering Organizational Intelligence
Detecting, Preventing, and Responding to Reconnaissance
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 3 Designing a Vulnerability Management Program

Identifying Vulnerability Management Requirements
Configuring and Executing Vulnerability Scans
Developing a Remediation Workflow
Overcoming Barriers to Vulnerability Scanning
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 4 Analyzing Vulnerability Scans

Reviewing and Interpreting Scan Reports
Validating Scan Results
Common Vulnerabilities
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 5 Building an Incident Response Program

Security Incidents
Phases of Incident Response
Building the Foundation for Incident Response
Creating an Incident Response Team
Coordination and Information Sharing
Classifying Incidents
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 6 Analyzing Symptoms for Incident Response

Analyzing Network Events
hellodigi.ir
Handling Network Probes and Attacks
Investigating Host Issues
Investigating Service and Application Issues
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 7 Performing Forensic Analysis

Building a Forensics Capability
Understanding Forensic Software
Conducting a Forensic Investigation
Forensic Investigation: An Example
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 8 Recovery and Post-Incident Response

Containing the Damage
Incident Eradication and Recovery
Wrapping Up the Response
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 9 Policy and Compliance

Understanding Policy Documents
Complying with Laws and Regulations
Adopting a Standard Framework
Implementing Policy-Based Controls
Security Control Verification and Quality Control
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 10 Defense-in-Depth Security Architectures

Understanding Defense in Depth
Implementing Defense in Depth
Analyzing Security Architecture
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 11 Identity and Access Management Security

Understanding Identity
Threats to Identity and Access
Identity as a Security Layer
Understanding Federated Identity and Single Sign-On
Review Questions

Chapter 12 Software Development Security

Understanding the Software Development Life Cycle
Designing and Coding for Security
Software Security Testing
Summary
Exam Essentials
Lab Exercises
Review Questions

Chapter 13 Cybersecurity Toolkit

Host Security Tools
Monitoring and Analysis Tools
Scanning and Testing Tools
hellodigi.ir
Network Security Tools
Web Application Security Tools
Forensics Tools
Summary

5.Certified Ethical Hacking

The purpose of this training is to provide in-depth and specialised knowledge on penetration testing and vulnerability assessment. Trainees will be introduced to Ethical Hacking and the concept of offensive security with tools and research-informed delivery. Trainees will learn how to look for weaknesses in a target system to test the security posture for exploits in a lawful and legitimate way. This requires a skill set that includes but not limited to computer networks, operating systems but also aspects of psychology and human behaviour.

What You’ll Learn

Footprinting
Network scanning
Enumeration
Packet sniffing
Social Engineering
DoS/DDoS attacks
Session hijacking
Webserver and web application attacks and countermeasures
SQL injection attacks
Wireless encryption
Cloud computing threats
Cryptography ciphers
Penetration testing
Hacking challenges on steroids
Emerging attack vectors
Malware reverse engineering
Operation technology
WPA3

Course Outline

Module 01: Introduction to Ethical Hacking
Module 02: Footprinting and Reconnaissance
Module 03: Scanning Networks
Module 04: Enumeration
Module 05: Vulnerability Analysis
Module 06: System Hacking
Module 07: Malware Threats
Module 08: Sniffing
Module 09: Social Engineering
Module 10: Denial-of-Service
Module 11: Session Hijacking
Module 12: Evading IDS, Firewalls, and Honeypots
Module 13: Hacking Web Servers
Module 14: Hacking Web Applications
Module 15: SQL Injection
Module 16: Hacking Wireless Networks
Module 17: Hacking Mobile Platforms
Module 18: IoT Hacking
Module 19: Cloud Computing
Module 20: Cryptography

6.Google Analytics Tool

Course Objectives:

Google Analytics course is a comprehensive web analytics course that covers topics from basic setup and configuration, to advanced tracking features. The course comprises of 3 modules:

Analytics 101 introduces the basics of web analytics such as tracking referral sources, improving web design and content, and identifying visitor preferences. Participants will also be shown how to apply these Google Analytics skills to their own websites.

Analytics 201 expands on the fundamentals, and gives a deeper understanding on the metrics behind web analytics, advanced tools, and best practices to improve advertising and marketing ROI, measuring visitors’ engagement and creating advanced goals.

Analytics 301 helps participants to uncover more details and insights in their Google Analytics data by tackling topics like customised tracking code, filtering analytics data, setting up goals and funnels, and tracking interactive elements.

What will be covered?

Analytics 101
Analytics 201
Analytics 301

Who should attend?

Marketers, senior managers and business owners, or executives with responsibilities in the areas of marketing, business analysis, web development and sales will benefit from this intensive course.

Training Methodology:

Prerequisites (if any):

Participants are deemed to have some practical knowledge of Google Analytics and use this in their daily work. For those who do not use Google Analytics on a regular basis, pre-reading resources will be sent to you prior to the workshop to equip you with the basics.

Language:

Arabic/English

Competencies covered:

Using Google Analytics
The metrics behind web analytics
Goals and e-commerce tracking
Analytics filters for clean data
Analytics to improve advertising & marketing ROI
Advanced segments and customized tracking codes

7.Adobe Illustrator – Basic/Intermediate

Course Objectives:

ABH is focused on providing high-quality training courses for your professional development. We provide regularly scheduled small group courses along with private or customized training.In this introductory Adobe Illustrator course you’ll learn how to use Adobe Illustrator to create high-quality illustrations, logos, and other custom artwork. This class is for anyone who needs to understand the workspace, tools, and drawing features that are available in Adobe Illustrator

What will be covered?

Lesson 1: Using the workspace Exploring the interface Choosing a workspace Opening a file Using artboards Changing your view Zooming and scrolling Using tools and panels Exploring the Control panel Working with panels and the dock

Lesson 2: Learning essential skills Using the shape tools Repositioning and resizing shapes The Transform panel Constraining a shape Entering exact dimensions Selecting artwork Using the shape and transform tools Introducing layers Cutting and pasting objects Repeating transformations

Lesson 3: Adding color Exploring the Appearance panel Changing colors Adding effects Using Live Paint Adding a symbol Saving swatches Selecting the same color Creating a color group Using the Color panel Adding Pantone colors

Lesson 4: Using the drawing tools Understanding the Pen tool Straight, curved and hinged lines Tracing images Creating a tracing template Working with Image Trace Using the Line, Pencil and Eraser tools Editing existing paths Adding and removing points Cutting and joining paths The Shape Builder

Lesson 5: Additional color options Adding tonal values with gradients Customizing an existing gradient Saving a gradient Using the Gradient panel Updating a gradient Creating a pattern Applying a pattern Editing a pattern Locating existing patterns Using the Color Guide

Lesson 6: Adding and formatting text Formatting text Paragraph formatting Using paragraph and character styles Editing styles Putting text on a path Warping text Putting text in a shape Creating outlines Checking spelling Using Find and Replace

Lesson 7: Using layers Getting to know the Layers panel Using layers to organize an illustration Selecting using the Layers panel Creating new layers Showing and hiding layers Locking and unlocking layers Rearranging layers Moving items between layers Remembering layers when pasting Creating a template layer

Who should attend?

This introductory Adobe Illustrator course is designed for media professionals with little to no prior knowledge of using Adobe Illustrator. Experienced Illustrator users with no formal training will also benefit from this class as tips, tricks, keyboard shortcuts and essential foundation skills are covered throughout this class. Users include fashion illustrators, graphic designers, user experience designers, video, and multimedia professionals, and more.

Training Methodology:

This class is taught on PC running Windows

Prerequisites (if any):

None

Language:

Arabic/English

Competencies covered:

Essential Illustrator tools and panels
Working with color
Using the drawing tools
Gradients and additional color options
Adding and formatting text
Placing text on a path
Working with layers

8.COBIT 5 – Framework for the Governance & Management of Enterprise IT

Course Objectives:

This COBIT 5 course is designed as an introduction to COBIT 5 and enables you to understand how an integrated business framework for the governance and management of enterprise IT can be utilized to achieve IT business integration, cost reductions and increased productivity. The syllabus areas that this course is designed to cover are:

How IT management issues are affecting organizations
The need for an effective framework to govern and manage enterprise IT
How COBIT meets the requirement for an IT governance framework
How COBIT is used with other standards and best practices
The functions that COBIT provides and the benefits of using COBIT
The COBIT Framework and all the components of COBIT
How to apply COBIT in a practical situation

What will be covered?

COBIT 5 OVERVIEW AND KEY FEATURES
THE FIVE COBIT 5 PRINCIPLES
THE SEVEN COBIT 5 ENABLERS
COBIT IMPLEMENTATION
THE COBIT 5 PROCESS CAPABILITY MODEL

Who should attend?

Although there is no mandatory requirement, ideally candidates should have at least two year’s professional experience working in an IT Services environment

Training Methodology:

Classroom

Language:

Arabic/English

Competencies covered:

High quality information to support business decisions
Effective and innovative use of IT
Operational excellence through reliable, efficient application of technology
Maintaining IT-related risk at an acceptable level
Optimizing the cost of IT services and technology
Compliance with relevant laws, regulations, contractual agreements and policies

9.Artificial Intelligence

Course Objectives:

To have an appreciation for and understanding of both the achievements of AI and the theory underlying those achievements.
To have an appreciation for the engineering issues underlying the design of AI systems.
To have a basic proficiency in a traditional AI language including an ability to write simple to intermediate programs and an ability to understand code written in that language.
To have an understanding of the basic issues of knowledge representation and blind and heuristic search, as well as an understanding of other topics such as minimax, resolution, etc. that play an important role in AI programs.

What will be covered?

What is Artificial Intelligence (AI)? A broad overview of terms and technology
What is reinforcement learning?
What has lead us to this point?
What are the predictions for the future?
Who should be involved in an AI project?
Examining team culture, capabilities and readiness
What are the 5 misconceptions regarding implementing emerging technologies?
How could AI impact on my business unit – both negatively and positively?
What happens to executives and businesses that misunderstand disruption?
AI – accelerating disruption: opportunities or crisis?

Who should attend?

Professionals for relevant industry

Training Methodology:

The course will be primarily delivered through three activities:

Lectures
Tutorials
Assignments

Prerequisites (if any):

Industry experience

Language:

Arabic/English

Competencies covered:

Knowledge of “Artificial” Intelligence
Identify systems with Artificial Intelligence.
Artificial Intelligence capabilities
Artificial Intelligence techniques implementation
Artificial Intelligence techniques Application
Limitations of current Artificial Intelligence techniques.

10.Big Data

Course Objectives:

The course focuses on the basics of Big Data and Hadoop. It further provides an overview of the commercial distributions of Hadoop as well as the components of the Hadoop ecosystem.

What will be covered?

Introduction to Course; Data & Data Science; Relational Databases & SQL; and Data Cleansing & Preparation
Building a Data Model in Power BI; Data Summarization & Visualization; and Descriptive Statistics & Correlation
Association Analysis and Cluster Analysis
Principles of Classification; Decision Trees; and Linear Classifiers
Neural Networks and R

Who should attend?

Professionals who intend to gain a basic understanding of Big Data and Hadoop. It is ideal for professionals in senior management who requires a theoretical understanding of how Hadoop can solve their Big Data problem.

Training Methodology:

Analytics portfolio assignments, Preparation quizzes

Prerequisites (if any):

Language:

Arabic/English

Competencies covered:

Engage customers one-on-one in real time
Reputation management
Testing different variations of CAD
Predictive analysis

11.Block Chain

Course Objectives:

Blockchain Course is designed to introduce you to the concept of Blockchain and explain the fundamentals of Blockchain and its implementation. As a beginner, you will be learning the importance of consensus in transactions, how transactions are stored on Blockchain, the history of Bitcoin and how it’s used. In addition, you will be taught about the Ethereum development platform and be able to setup your own private Blockchain environment using Ethereum. Furthermore, you will develop and deploy smart contracts from web and console. Consecutively, you will learn to deploy a business network using Hyperledger Composer and learn to set up a private Blockchain using Multichain platform. Towards the end of the course, we will be discussing various practical use cases of Blockchain to enhance your learning experience