Program Brief

With the huge amount of data that must be handled and analyzed every day, it is imperative that you learn how to use a flexible tool to handle equations and statistics professionally, and Microsoft Excel is the most popular tool for doing so. Training will 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

                                          Not Available

                                          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

                                          Add Comment

                                          CAPTCHA

                                          Realted Program

                                          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

                                          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

                                          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

                                          Preparation Program of Compliance for Financing Companies Sector Professional Exam

                                          This training program aims to prepare participants with the knowledge and skills necessary to pass the Professional Exam of Compliance for Financing Companies Sector. This program is designed to enable participants to efficiently and effectively undertake the duties of the compliance officer in finance companies, following an understanding of the compliance function’s role, the risks of non-compliance, and the procedures, controls, and relevant regulations.

                                          Details

                                          Finance for Non-Financial

                                          "Finance for Non-Finance Professionals" is an extensive 4-day program, with condensed and engaging sessions totalling 7 hours each day, specifically oriented towards degree-educated professionals from varied industries, the programme is ideal for those in non-financial positions and who seek to bolster their financial literacy. This comprehensive program is meticulously designed to demystify the world of finance for participants, fostering a proficiency that enables them to decipher and utilise financial information for strategic advantage. Over the course of these four days, participants will engage with financial principles and analysis techniques tailored to extend their expertise beyond their specific specialties, thereby equipping them with the understanding crucial for holistic and informed decision-making processes.

                                          Details

                                          Wealth Management and Financial Advice

                                          Wealth management is an art based on the quality of financial advice provided by qualified advisors who can develop and implement the most appropriate strategy for each client based on their needs, future expectations, and risk tolerance. This training program is designed to develop participants' skills in financial planning and setting investment objectives for managing clients' assets, in addition to financial consulting skills to analyze investments and investment products available in the market and provide the most appropriate solutions and products to meet clients' needs, their future expectations, and attain their financial goals.

                                          Details

                                          Preparation Program for Combating Financial Crime Certificate Exam- from CISI

                                          This training program aims to prepare participants with the knowledge and skills necessary to pass the Combating Financial Crime Certificate Exam. Combating Financial Crime, developed in collaboration with QCo, provides a global view of transnational crime. It illustrates practical defenses, includes the Bribery Act (2010) and focuses on how laws, regulations and best practice continue to evolve across the entire spectrum of associated activities. It covers the background and nature of financial crime, money laundering, terrorist financing, and corruption; combating financial crime, bribery and the role of the private sector.

                                          Details

                                          Collection & Follow-up of Debts for Financial Leasing Contracts

                                          Due to the special features of financing contracts related to credit risk, collectors need to be proficient in using credit loss forecasting tools to categorize customer debts according to international standards. This program presents the most important principles, tools, and methods for collecting financial receivables and debts before they become faltering, and the collection strategy when they turn into distressed debts. Moreover, it covers the behavioral and negotiating skills collectors need, as well as the steps and methods of debt collection associated with the field of financial leasing contracts.

                                          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

                                          Reading and Analyzing Financial Statements and Reports

                                          Since the financial statements provide us with historical information and aggregate figures, the decision maker needs tools that enable him to enter into the details of this information and the indicators that show the relationship between them. This program provides the participants with basic knowledge required to analyze the financial statements and how to use the extracted indicators in evaluating the firms performance, making decisions, and drawing up future plans and policies .

                                          Details

                                          LIBF Level 3 Certificate in International Trade and Finance (CITF)

                                          The Certificate in International Trade and Finance (CITF) provides participants, as a trade, export and commodity specialists, with a thorough understanding of international trade procedures, practices and legislation. CITF® develops the appropriate technical knowledge and skills required to enable participants to apply that knowledge to situations within the workplace. The qualification provides a core understanding of the products, documents, trade terms, roles and responsibilities that underpin international trade and finance. In addition to this core knowledge, CITF® helps participants to develop a basic understanding of fraud prevention and risk in terms of trade finance. The qualification also develops an understanding of contemporary international trade and finance topics such as sustainability, digital disruption and innovation, ensuring that students have relevant and up-to-date knowledge for the industry.

                                          Details

                                          Excellent Customer Service through Effective Communication

                                          Customer service is very important to business success as it requires knowing yourself before knowing the customer as well as knowing the processes and techniques to build strong customer relationships. Excellent customer service is not an optional thing but an urgent necessity. When you deal with your customers exceptionally, they become an effective marketing tool for business. The program focuses heavily on the behaviors and social aspects of customer service through the practice of communication skills techniques in addition to understanding and using different aspects of behavior and body language to ensure positive and successful customer interaction.

                                          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

                                          Tele-Sales Skills

                                          Marketing concepts have developed rapidly, this development has given great interest to the promotional and sales tools that support them. With the development of communication technology, the focus was on the phone as a sales tool to achieve an increase in the volume of sales. The Tele sales Skills Program focuses on the practical aspects of how to use the telephone as a sales tool to achieve the marketing objectives of organizations. The program also addresses the best technical practices in using the telephone and important commandments to improve the performance of tele sales operators.

                                          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!