PowerPivot and Power BI came with their powerful DAX formulas (Data Analysis Expressions). You will be surprised of what these expressions can do to your data compared to those that are standard in Excel. You will learn the basics of DAX expressions then we are going to move up the ladder swiftly until you are able to create KPI dashboards (Key Performance Indicators) that can be shared with your colleagues. When you go through the outline, you will realize how considerable the details and practical examples we will cover.

Risk Management and Control has become a key function with highly demanding skills not only within the Financial Institute. The wake-up call from the 2008 crisis has only reinforced the demand for related technical skills in Finance. An investment professional with globally recognized designations will not only separate himself from the competition but also set his career path for a better future. In addition to the CFA charter, the FRM charter has become one of the most recognized designations in the Risk Management industry and is the only tr...

Development of a profound understanding of the rationales for private equity investment, underlying strategies, participants and processes. Students will gain a thorough appreciation of the drivers behind private equity, as it translates into value creation (or not), through strategies and efficiencies. Crafting of financial forecasts and scenarios will impart real life experience to students.

This intensive five-days workshop offers in-depth and practical analysis of the different valuation techniques that can be used to value different entities. It will also examine the use of real options modeling that are used to value patents, contracts, natural resources and for various other applications. The workshop will focus on the framework that can be used to pick the right model for any task and it will also extensively expose delegates to the modeling of various real life valuation cases. Companies are valued for the purposes of invest...

Every participant in the event will receive a copy of a leading textbook in the real estate investment. The course will lead participants form the basics of the real estate industry all the way to the very advanced topics. The presenter, Hamed Behairy, has international reputation in conducting very practical and in-depth training programs. Above all, most of the knowledge will be delivered through actual Excel models that top professionals in this market utilize.

With attending this program you will understand that you do not value Insurers like Retailers, Property Companies etc., and the limitations of historical Risk Free Returns & Equity Risk Premiums in Portfolio planning today. You will appreciate how how Risk is both measured & managed in a Portfolio and understand how Investor psychology impacts onto decision making.

This course includes corporate and international real estate investment and presents the essential concepts, principles, and tools necessary to analyze incomeproducing commercial real estate from an investment perspective. The course integrates relevant aspects of urban and financial economics to provide delegates with a fundamental analytical understanding and application of real estate investments. The course also explores international real estate investments, both opportunistically and structurally, by outlining elements for developing and ...

With this program you will learn about the function of the financial services industry in the economy: transferring funds between individuals, businesses and government; risk management. Every attendant will recognize the role of the main institutions/ organisations: retail banks; investment banks; pension funds; fund managers; stockbrokers; custodians; global custodians.

With the CFB you will gain confident knowledge foundation in FinTech, CryptoCurrencies, and other Digital Assets. All participants to this course will have interactive experience with Blockchain technology in real-world scenario. They will aslo maintain awareness of legal, technical, and business risks with emerging financial technologies.