Program Brief

n light of the huge amount of data that organizations need to manage and analyze, it has become necessary for today's organizations to master the basic skills necessary to deal with Microsoft Excel as a flexible tool in dealing with equations and statistics professionally. It is considered one of the most important pillars of the work of accountants, data analysts and administrators alike. This training program is designed to provide participants with the knowledge and skills they need to comprehend organizational intelligence through the ability to deal with functions, analyzing vast amounts of data, extracting accurate, actionable information, and presenting that to decision makers.

Program Topic
  • Artificial Intelligence and Data Management
Job Families
Program Goals

At the end of the training program, the participant should be able to:

  • Accurately perform calculations using advanced functions and formulas.
  • Sorting, filtering and querying the data skillfully, which helps in facilitating and accelerating the work performance.
  • Create and format tables appropriately to ensure data consistency and presentation.
  • Display data clearly and attractively with graphs.
  • Analyze data with pivot tables and pivot charts to reach the best decision.
Program Agenda
Module 1: Working with Functions
  • 1 Define Cell Ranges and Reference Them in Formulas

    • 2 Perform Conditional Calculations

      • 3 Carry Out Logical and Specialized Functions

        • 4 Work with Date and Time Functions

          • 5 Understand and Execute Text Functions

            Module 2: Working with Lists
            • 1 Sort and Filter Data

              • 2 Learn the Capabilities of Database Functions

                • 3 Query Data with Database Functions

                  • 4 Outline and Subtotal Data

                    Module 3: Analyzing Data
                    • 1 Build and Modify Tables

                      • 2 Create Formatting Rules

                        • 3 Apply Conditional Formatting to Alter Groups of Cells

                          Module 4: Charts
                          • 1 Organize and Represent Data with Charts

                            • 2 Modify and Format Charts

                              • 3 Search for and Replace Data.

                                • 4 Discover and Implement Advanced Chart Features

                                  Module 5: Analyzing Data With Pivot Tables and Pivot Charts
                                  • 1 Create a Pivot Table

                                    • 2 Analyze Pivot Table Data

                                      • 3 Present Data with Pivot Charts

                                        • 4 Filter Data Using Timelines and Slicers

                                          Program Requirements
                                          • Availability of a computer for practical application.

                                          .

                                          • Familiar with navigating the Windows interface.

                                          .

                                          • Basic knowledge of Excel 2016 including: formulas, functions, workbooks, and worksheet formatting.

                                          .

                                          Program Path

                                          Names of the training programs that are integrated (enriched) with the training program:

                                          • Not Available

                                          Names of the training programs that after the training program:

                                          • Not Available
                                          Program Method
                                          • Lecture
                                          • Practical Implementation
                                          • Exercises and assignments
                                          Evaluation Method
                                          • Pre Exam
                                          • Post Exam
                                          Training Type
                                          • In Class Training
                                          • Online Training
                                          Partners

                                          Not Available

                                          Add Comment

                                          CAPTCHA

                                          Realted Program

                                          Professional Certificate for Certified Compliance Officer (CCO)

                                          This training program aims to prepare the participants with the knowledge and skills necessary to pass the Certified Compliance Officer professional exam (CCO). Participants in this training program will learn how to effectively perform the duties of a compliance officer and methods for managing non-compliance risks, as well as implement risk-based anti-money laundering programs and develop relevant internal control mechanisms.

                                          Details

                                          Insurance Claims Handling (WCA)- Cert. CII

                                          The Insurance Claims Handling Program focuses on providing participants with a comprehensive understanding of claims management. The program covers the fundamental principles of claims handling, an understanding of insurance products and related services, as well as the considerations and procedures involved in claims management. It also addresses the structure of the claims function, effective settlement methods, and the management of associated expenses. The objective is to enhance participants' ability to apply best practices in claims management, ensuring efficiency and fairness in processing and settlement. The program includes: • Registration fees and membership in the Chartered Insurance Institute (CII) • A preparatory program • Professional examination fees

                                          Details

                                          Investment Funds-Management and Operations

                                          This program is designed to expose participants to investment funds, their types and how to form, organize, manage and invest in the operations of such funds. As well as how to manage risks and adhere to the regulations of investment funds, and manage risks of investment funds of all kinds.

                                          Details

                                          Customer Relationship Management

                                          Customers are the cornerstone of the survival and growth of profitable business segments, and customer relationship management (CRM) is one of the most important tools to support and grow the organization; the real wealth of the organization to maintain continuity in the market is its customers. Successful work depends on communicating with customers effectively, understanding them better, and meeting their expectations. This training program is designed to provide participants with the knowledge and skills necessary to manage customer relationships, develop the concept of relationship marketing, identify relevant strategies to achieve sustainable results, and know the relationships between systems to create effectiveness between customer relationships and improve them in the future, in addition to familiarity with customer types, and apply a customer relationship management system that works efficiently and effectively.

                                          Details

                                          Change Management

                                          Globalization, automation, digitalization and changes in workforce patterns over the past five years, and most recently due to the COVID-19 pandemic, have made rapid business transformation a necessity for organizations to change the way they think and act to keep pace with developments. In this training program, participants obtain the skills necessary to manage change by developing critical skills and familiarizing themselves with the tools to implement change accurately and smoothly, thus positively impacting the organization's growth and success, as well as its ability to remain competitive in the field of business.

                                          Details

                                          Customer Orientation

                                          Customers are the real wealth and capital of business organizations today. The real competitive advantage in the market is how many customers you own and your ability to maintain them. Therefore, customer centricity has become of paramount importance through customer service and excellent communication with them professionally. The program focuses on fostering a customer-centric culture by understanding customer needs and expectations aiming to make appropriate changes and thereby exceeding their expectations, delivering an outstanding customer experience and creating a long-term relationship, along with understanding the benefits of customer centric performance.

                                          Details

                                          Combating Commercial Concealment

                                          The "Commercial Concealment Prevention" program provides an opportunity to enhance the knowledge and skills of banking sector employees in combating commercial concealment, enabling them to effectively handle the challenges of this field and address the associated risks. This training program is distinguished by its focus on several key topics, including understanding the concept of commercial concealment, accurately distinguishing between criminal acts and violations, identifying the material element, and using appropriate investigative methods to uncover commercial concealment crimes. Additionally, it emphasizes the role of good faith in classifying actions and offers in-depth insights into the social, economic, and security implications of these activities. Throughout the "Commercial Concealment" program, participants will acquire the knowledge and skills required to take effective action against commercial concealment, including understanding detection controls, enforcement measures, and the legal procedures for reporting violations.

                                          Details

                                          Insurance Claims Practices

                                          This training program provides participants with knowledge and skills related to the insurance claims department and its functions, claims philosophy, various types of reserves, as well as a review of methods for combating fraud in insurance claims, unwarranted overpayments of claims amounts, estimating the claims provision, as well as describing the role of reinsurance in managing catastrophic claims.

                                          Details

                                          Microsoft Excel- Intermediate Level

                                          n light of the huge amount of data that organizations need to manage and analyze, it has become necessary for today's organizations to master the basic skills necessary to deal with Microsoft Excel as a flexible tool in dealing with equations and statistics professionally. It is considered one of the most important pillars of the work of accountants, data analysts and administrators alike. This training program is designed to provide participants with the knowledge and skills they need to comprehend organizational intelligence through the ability to deal with functions, analyzing vast amounts of data, extracting accurate, actionable information, and presenting that to decision makers.

                                          Details

                                          Negotiation and Persuasion Skills

                                          Negotiation is inevitable as many aspects of our lives are a series of negotiating situations. Negotiation and persuasion skills are one of the keys to success and one of the most important skills that any person must possess, whether in practical or personal life, since negotiation is necessary to reach mutual gain through the best possible solutions. This training program is designed to provide participants with modern methods and basic concepts of the negotiation process, in addition to familiarizing them with the main features of successful negotiation, negotiation stages, how to prepare for negotiation and making a good impression, as well as developing their ability to overcome the objection stage to reach a successful closure and mutual gain for all parties.

                                          Details

                                          Advanced Business Writing

                                          Are you familiar with the basics of business writing? Can you simplify complex ideas? Would you like to improve your technical writing and reporting skills? Professional writing skills improve relationships and performance between employees and stakeholders, thus contributing to the credibility and professionalism of a business. Through this training program, participants will develop business writing skills that will allow them to communicate effectively with each other through learning and using various electronic methods, as well as acquiring the skills necessary to efficiently prepare formal letters and technical reports.

                                          Details

                                          Introduction to Block Chain

                                          You've probably heard of the term "Block chain", right? but you don't really know how it works? What are its applications? Many people refer to Block chain technology as the "The Internet of Money", also it has been one of the fastest growing information technologies of the past decade. Therefore, this training program is designed to cover the fundamentals of Block Chain and its applications, as well as the challenges and risks involved with its various applications.

                                          Details

                                          Outstanding Sales and Negotiation Skills- B2B

                                          It is a well-known fact that the Great Depression of 1929 was one of the most serious economic crises of the 20th century. With time, this has led to the emergence of new concepts for B2B competition, as well as the separation of B2B sales from other sales activities. Therefore, the development of sales personnel for the corporate sector has become a must for any organization. This training program focuses on developing the sales experience and improving the experience of corporate sales customers, studying and analyzing the marketing mix and recognizing its relationship to increasing market shares and its impact on the total sales volume, in addition to providing participants with effective negotiation skills to deal with B2B sales and achieve the desired corporate goals.

                                          Details

                                          Anti-Fraud in Financial Institutions

                                          To combat Fraud threats, laws and regulations have been enacted that make financial services responsible for preventing those threats. This program is designed to provide candidates with a proper understanding of fraud, its types, its indicators, methods of Fraud detection, investigation and prevention, different tools available to counter fraud in financial Sectors.

                                          Details
                                          We value your feedback

                                          Dear visitor, we hope that you will participate in improving and developing the services provided by the academy on the website.

                                          Was it easy to find what you were looking for on the Academy's website?
                                          Was the information presented on the Academy’s website sufficient and useful?
                                          Please share with us your suggestions for developing the website
                                          Thank you!