Data Management, Manipulation And Analysis Using Excel

Course details

1. Enable participants to create financial reports to conduct financial analysis, and the use of modern tools such as mathematical and statistical methods.

2. Provide participants with modern tools to predict future financial performance and report on the success or failures of organizations.

3. To provide participants with the skills to perform financial analysis Applied to a number of companies, including participants can make a realistic assessment of financial performance, according to the practice of the process for a number of companies representing different sectors of the economy.

4. Activate the performance of the participants in the preparation and presentation reports the results of the financial analysis According to the methodology relies on mathematical and statistical tools to date.

Who should attend:

1. Financial Managers
2. Accountants
3. Financial analysts in the public sector organizations and private
4. Internal and external auditors for the various sectors

Daily Outlines:

Unit one: Introduction to Excel program and financial uses:

1. The characteristics and features of Excel program

2. Basic functions and specialized functions in Exce

3. Analysis of financial data analysis using the properties of SORT-FILTER-SUPTOTALS-SCENARIOS

4. Models to query the financial statements using SUMIF-V-H –LOOKUP

5. Estimate the financial statements using the Forecast - Trend

6. Prepare graphs using CHARTS

Unit tow: Designing Financial Reports using Excel

1. The financial statements i according to the latest amendments in the accounting standards.

2. Designing Balance Sheet using computer

3. Design of comprehensive income using computer

4. Design statement of cash flows using Computer

• Unit three: assessing the financial position of an entity using Excel

1.The concept of financial analysis

2. Professional requirements profession of financial analysis

3. Principles of Financial Analysis

4. Financial analysis methods of traditional and modern

5. Remodeling financial reporting for a financial analytical

• Unit four: financial analysis ratios and financial indicators using Excel

1. Analysis Horizontal and vertical analysis of financial statements

2. Benchmarking reference

3. Financial analysis using indicators for assessing performance

• the rate of return on investment ROI

• cash rate on investment COI

• internal rate of return IRR

• Unit five: modern and advanced methods in analysis using Excel

1. Using regression in predicting the financial failure

• Form Altman Z-Score

• model Comport Z-Score

• model Kida

• model Sherrod

2. Using correlation to find financial fraud in the financial statements