Financial modeling in Excel

• Conditional Formatting 

• Data Validation 

• Defined Names 

• Consolidation 

• What - if Analysis 

• Goal Seek 

• Pivot Table 

After completing the course you will be able to perform the following operations:

• Database processing, data comparison (inventory, salaries, etc.)

• Processing and analysis of purchases, debtors / creditors, accounting transactions

• Control over the terms of contracts and money laundering

• Warehouse and auto-park control

• Compilation of financial forms, cash flow statement, profit and loss statement and enterprise balance sheet

• Budget planning and execution control

• Creation and analysis of company structure and staff units

• Analysts

• Accountants

• Financial managers