Question Title

* 1. Essential IT-Insights for Financial Professionals

The Enterprise Information Systems contain ERP, BI, CPM and Analytics systems.
Are you familiar with their basic principles, objectives and reporting capabilities of these systems?

Question Title

* 2. Automation is together with Analytics and Artificial Intelligence the leading trends that will transform the finance functions tomorrow. Can you imagine how Automation will influence yourself, your team and your organization?

Question Title

* 3. Would you find interesting to watch a showcase of great Excel and MS-SQL apps that have automated less value added financial tasks in other companies?

Question Title

* 4. Complex Formulas - SumUp

The screenshot contains a table with the product sales per country, where the combination of product and country may appear more than once.

Please read the formulas and select the expression that matches your profile at best:

Question Title

* 5. Complex Formulas - LookUp

The screenshot contains the following tables:
Table 1 (columns A:B) with the account descriptions and their balance
Table 2 (columns D:E) with the account IDs and their descriptions
Table 3 (column G:H) with the Account ID where you have to deliver their balance amounts

Please check the formula and select the expression that matches your profile at best:

Question Title

* 6. Complex Formulas - Sort

The screenshot contains the following three tables:
Table 1 (columns A:B) with dates and their amounts
Table 2 (columns D:E) with formulas that identify the time position of each date on ascending (column D) and descending (column E) order
Table 3 (column G:I) with formulas that hide a date that appears more than once and identify its time position (as in table 2)

Please try to think how known formulas can solve these requirements and select the expression that matches your profile at best:

Question Title

* 7. The screenshot contains a simple VBA code in the sub routine “Macro1” which automates a small manual process.

Please read the VBA code shortly and select the expression that matches your profile at best:

Question Title

* 8. Video Reporting

The video below contains a reporting which runs exclusively in MS-Excel.  

Please watch the video (27 sec.) and select the expression that matches your profile at best:

Question Title

* 9. Your company email:

T