Program Brief

One of the basic skills needed to carry out daily tasks professionally is the ability to use Microsoft Excel to manage and create equations and statistics. This training program is designed to provide participants with the knowledge and skills necessary to use advanced technologies in Excel efficiently and effectively.

Program Goals

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

  • Use excel functions for Building sophisticated financial models.
  • Analyze data effectively using in-demand functions and formulas.
  • Work more efficiently by using key excel tips and tricks necessary for day-to-day jobs.
Program Agenda
Module 1: Introduction to Excel Formatting
  • 1 Cell styles

    • 2 Pasting values, formulas, and formats with Paste Special

      • 3 Formatting Cells

        • 4 Highlight key data with Excel Conditional Formatting

          • 5 Filter by color

            • 6 Recording Macros - The perfect way to avoid repetitions

              Module 2: Key Shortcuts and Quick Navigation Tools
              • 1 The secret of fast scrolling: navigation and keyboard shortcuts

                • 2 Fix the top row of your Excel tables

                  • 3 Split Screens - Use multiple screens simultaneously

                    • 4 Excel formulas

                      • 5 Creating drop-down menus in Excel

                        • 6 F keys (F1 to F12) - Using Excel's function keys

                          • 7 How to select visible cells only

                            Module 3: Excel Mechanics – a Collection of Indispensable Tools
                            • 1 Fixing cell references properly

                              • 2 Grouping Excel rows and columns

                                • 3 Working on multiple sheets at the same time

                                  • 4 Find

                                    • 5 Create easily printable documents by using Set Print Area

                                      • 6 What Are Circular References in Excel?

                                        • 7 Trace precedents - Display the relationship between formulas and cells

                                          Module 4: Advanced Excel Functions
                                          • 1 Nested function

                                            • 2 Sum; Sumif; Sumifs

                                              • 3 Round functions

                                                • 4 Iferror

                                                  • 5 Vlookup

                                                    • 6 Index; Match; Index

                                                      • 7 Offset; Offset

                                                        • 8 Financial functions: FV and PV

                                                          • 9 Discounting Cash flows and calculating Net Present Value (NPV)

                                                            • 10 Financial functions: IRR

                                                              • 11 Financial functions: PMT and building a complete loan schedule

                                                                • 12 Date functions

                                                                  Module 5: Excel Tips
                                                                  • 1 Excel tips

                                                                    Module 6: Financial modeling fundamentals
                                                                    • 1 Financial modeling Don'ts - Worst practices we should avoid

                                                                      • 2 Financial modeling Do's - This is what solid modelers do

                                                                        • 3 The different types of models

                                                                          • 4 What is the right level of detail in a financial model?

                                                                            Module 7: Forecasting Future Financials
                                                                            • 1 Forecasting guidelines: apply these principles when forecasting financials

                                                                              • 2 How to build a complete model?

                                                                                • 3 Forecasting Income statement financials

                                                                                  • 4 Forecasting Balance sheet financials

                                                                                    Module 8: Building a Complete Statement Models
                                                                                    • 1 Create a mapping of financials

                                                                                      • 2 Building an output P

                                                                                        • 3 Filling in the output P

                                                                                          • 4 Calculating percentage variances and applying conditional formatting

                                                                                            • 5 Building an output Balance sheet

                                                                                              • 6 Adding the forecast period

                                                                                                Module 9: Building a Flexible Model with Multiple Scenarios
                                                                                                • 1 Calculating historical percentage ratios and use Index and Match for scenarios

                                                                                                  • 2 Building a flexible model with Vlookup

                                                                                                    • 3 Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %

                                                                                                      • 4 Building a Fixed asset roll forward

                                                                                                        • 5 Building a Financial liabilities schedule

                                                                                                          • 6 Building an Equity schedule

                                                                                                            • 7 Preparing a Cash flow structure

                                                                                                              • 8 Calculating Cash flows and completing the model

                                                                                                                Program Requirements
                                                                                                                • Basic knowledge in Microsoft Excel

                                                                                                                -

                                                                                                                • Attending a training program in accounting or finance (for those without a financial accounting background)

                                                                                                                -

                                                                                                                • Availability of a computer for practical application

                                                                                                                -

                                                                                                                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

                                                                                                                Microsoft Excel- Basic Level

                                                                                                                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. This training program is designed to provide participants with the knowledge and skills needed to organize, analyze and present data, by learning how to perform calculations, use functions, and manage workbooks efficiently and effectively.

                                                                                                                Details

                                                                                                                Credit Analysis and Decision-Making Mechanisms

                                                                                                                Choosing the right credit decision is the first line of defense for preserving lenders' capital, protecting creditors, and maximizing profitability for the bank. In this program, the participant gets familiar with the stages of credit decision-making according to the approved credit policy, the latest strategies for analyzing and calculating credit risks, local and international controls and standards, to be able to make a correct and successful credit decision that controls the expected risks.

                                                                                                                Details

                                                                                                                CMA Advance Qualification Examination in Compliance

                                                                                                                This training program is to provide participants with knowledge and skills necessary to pass the Advanced Qualification Exam in Compliance, presented by the CMA and TFA. The exam is tailored for CMA-licensed compliance and AML officers. This program is designed to familiarize participants with the regulatory environment for financial services as well as local and international regulations, as well as to promote compliance & governance culture, understanding of risks, and shows how to establish an effective compliance function, in addition to identifying key skills in combating main financial crimes.

                                                                                                                Details

                                                                                                                Fundamentals of Internal Auditing

                                                                                                                The internal audit contributes to verifying that the establishment is committed to implementing the internal control systems represented by the policies and procedures established by the management; in order to protecting the assets of the facility and ensuring that it achieves its operational objectives. This program provides participants with the fundamental requirements of internal auditing, starting with the modern concept of internal audit, then standards and procedures for carrying out audit tasks, preparing the plan, designing worksheets, selecting samples, collecting evidences and documentation, and then preparing internal audit reports.

                                                                                                                Details

                                                                                                                Risk Based Internal Audit Preparation Plan

                                                                                                                This program provides participants with the best practices and tools for Risk Based Audit planning aligned with the organization's strategic objectives. Participants will be exposed to international best practices for internal control systems assessment. In addition, this program will enable participants to prepare internal audit reports according to related international standards to improve the effectiveness of the control operations.

                                                                                                                Details

                                                                                                                Microsoft Excel- Advanced Level

                                                                                                                One of the basic skills needed to carry out daily tasks professionally is the ability to use Microsoft Excel to manage and create equations and statistics. This training program is designed to provide participants with the knowledge and skills necessary to use advanced technologies in Excel efficiently and effectively.

                                                                                                                Details

                                                                                                                IPO Masterclass for Professionals

                                                                                                                A company's IPO is one of the biggest strategic decisions it can make during its financial lifespan and is considered the best way to raise capital and expand in the future. Due to the rapid growth of the financial markets، private companies were able to obtain liquidity، expand their shareholder base، and introduce radical structural and operational changes through public offerings. This training program aims to prepare participants with the knowledge، skills، and tools necessary to originate & execute IPOs. This training program aims to prepare participants with the knowledge، skills، and tools necessary to originate & execute IPOs.

                                                                                                                Details

                                                                                                                Risk Based Internal Audit Plan Execution and Reporting

                                                                                                                This program provides participants with the best professional practices for audit engagement planning and execution in an efficient and effective manner where the participants will be exposed to modern audit’s engagement planning and execution tools that are integrated with risk-based audit planning as well as how to utilize technology the enhance the audit activities. Also, the participants will learn about assurance reports, their types, and characteristics while focusing on preparation of internal audit reports in accordance with the international standards and how to perform follow-up activities to ensure the highest value added for organizations and their strategic objectives.

                                                                                                                Details

                                                                                                                Portfolio Management

                                                                                                                Investment opportunities in the financial markets allow you to choose between the shares of many companies listed in the financial markets, and they are usually exposed to different levels of risk and varying levels of returns. Given that the investment options available to the investor are many and different and may reach dozens of stocks and investment funds; This program has been designed to build and manage investment portfolios in line with the types and requirements of investors in the financial market according to the different models for managing the risks related to them to achieve the targeted returns for investors.

                                                                                                                Details

                                                                                                                Strategies for Optimizing Capital Structure and Maximizing Shareholder Value

                                                                                                                In contemporary corporate and project finance the optimisation of entities’ capital structures is a critical process in financial risk management as well as in maximising investor value. Firms’ target capital structure can potentially comprise funding from a number of sources across equity, sukuk, conventional debt including bonds, and in some instances, mezzanine finance in the form of preferred shares and subordinated debt. The capital optimisation process is complex: in addition to its basis in comprehensive capital budgeting assessment of current and expected future availability of appropriate financing in the required form (and acceptable pricing) is required to sustainably support the pursuit of new business opportunities, as well as maintaining existing capital assets, through the cycle. This comprehensive, applied programme covers the key issues and considerations in capital structuring and – via a number of case studies – examines the specific challenges across different sectors and project finance types as well as the dynamic nature of entities’ funding requirements as they evolve.

                                                                                                                Details

                                                                                                                Islamic Treasury Management

                                                                                                                This program is designed to manage treasury in Islamic Banking using the basic principles of investment by Sharia-compliant solutions in line with the business needs to be linked to the treasury of Islamic banks, and to manage the financial risks of treasury operations by applying advanced financial solutions that are compatible with Islamic Sharia, and transforming them into opportunities commensurate with global market variables.

                                                                                                                Details

                                                                                                                Property Insurance

                                                                                                                Providing the participant, the technical knowledge of property insurance to all the people working in the Property insurance department in the insurance company. During this tailor-made course in property insurance, the candidates will be given a detailed overview of different types of property insurance (Fire and allied perils and All Risk), Business Interruption, and the related reinsurance function.

                                                                                                                Details

                                                                                                                Anti-Money Laundering and Terrorist Financing- Advanced Level

                                                                                                                Fighting money laundering and terrorist financing is a priority for the international community; since these financial crimes threaten the integrity and stability of the financial system and the economy in general, they can also affect the integrity and stability of financial institutions, discourage foreign investment, and distort international flows. As a result, the affected country experiences dire financial instability and poor economic performance. This program deeply explains AML & CTF standards and respective risk management in financial institutions. The program also explains pertinent local and international legislations and leading practices, as well as, the preparation and implementation of ML and TF risk-based programs, including “Know Your Customer” and “Customer Due Diligence” requirements.

                                                                                                                Details

                                                                                                                Derivative Contracts and its Governance and Regulations

                                                                                                                Derivatives in finance are contracts that derives its value from the performance of an underlying asset, that could be an equity, interest rate, currencies, credit instrument, market indices or commodity It is used for the purpose of hedging or speculation. This training program covers the basic principles of financial derivatives and their different types, the underlying assets, the risks associated with them and their mechanism of action. In addition to the governance of derivatives and the related regulations and rules, and the extent of the impact of derivative contracts on the financial market, positively or negatively.

                                                                                                                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!