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
                                          Partners

                                          Not Available

                                          Add Comment

                                          CAPTCHA

                                          Realted Program

                                          LIBF Level 3 International Banking & Finance Certificate – Foundation (IBCF)

                                          The LIBF Level 3 International Banking & Finance Certificate– Foundation (IBCF) aims to develop an individual or team’s knowledge and understanding of banking and finance, as well as to equip them with the skills required to be a modern banker. IBCF will prepare individuals and teams with essential knowledge of the financial services environment, regulatory requirements, banking products and services.

                                          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

                                          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

                                          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

                                          Credit Risk Management for Mortgage Finance

                                          The issuance of the new Saudi Mortgage Law in 1442h, strengthened and boosted the real estate financing products for individuals in the Kingdom of Saudi Arabia, as it achieved the necessary guarantees when practicing Mortgage financing by setting measures that protect the creditor, debtor and guarantor in the credit process. Participants in this program learn about the knowledge and skills related to the credit cycle of Mortgage Financing, the relevant laws and regulations, as well as the practical application of quantitative analysis in the measurement of risk.

                                          Details

                                          Anti-Money Laundering and Terrorist Financing- Intermediate Level

                                          Laws and regulations for combating money laundering and terrorist financing have been enacted at the international and local levels, to enhance the ability of financial institutions to prevent the occurrence of these financial crimes. This program explains the standards related to combating money laundering and terrorist financing, as well as local and international legislation and relevant best practices. It also shows the role of the board of directors and the executive management in financial and non-financial institutions and non-profit organizations in supporting the anti-money laundering and terrorist financing program.

                                          Details

                                          Insurance Broking Fundamentals (I10)- Cert. CII

                                          The Certificate in Insurance is a core qualification for staff working across all sectors of insurance. This Certificate develops core knowledge of the key disciplines needed through covering basic general insurance principles including the regulatory environment, key disciplines of underwriting and claims, in addition to popular insurance products. Insurance Broking Fundamentals (I10) counts towards achieving the Certificate in Insurance, which provides participants with the required knowledge and skills for the roles and responsibilities of insurance broking organizations, including Their interaction with insurers and clients; in addition to regulatory and financial issues affecting them.

                                          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

                                          Fundamentals of Analyzing Real Estate Investments

                                          The Kingdom of Saudi Arabia views real estate as one of the most preferred investments, which is characterized by a high degree of stability compared to other investments, also real estate investments are known for their attractive profits and long-term capital appreciation. In this training program, participants will become familiar with real estate investments, professional methods for assessing investment opportunities, as well as the techniques that make a profitable and successful investment possible.

                                          Details

                                          Preparation Program for Certified Fraud Examiner (CFE)

                                          This training program aims to prepare participants and provide them with the knowledge and skills needed to pass the professional exam and obtain the Certified Fraud Examiner (CFE) certification, which is awarded by the Association of Certified Fraud Investigators (ACFE), one of the largest anti-fraud training and education bodies in the world. This program is designed to impart knowledge of complex financial transactions and understanding of forensic and forensic methods and sciences, how to spot fraud allegations, as well as technical report writing skills.

                                          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

                                          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

                                          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

                                          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
                                          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!