Module: Excel

Scenarios

Please choose a scenario to start simulation.

Calculation of sums according to the categories
Calculation of sums according to the categories

John has a table of data exported from sales information system. In each row of the table provided Company name, order date, order value and country. Company has shopping centres in four countries. What actions you could choose in order to see each counties sales and compare with each other? John wants to calculate subtotals without using any formulas.

Start
Rankings
Colouring cells that have certain values
Colouring cells that have certain values

John has a table of data exported from the sales information system. In each row of the table provided order No, company name, country, order date, manager and order value. Company has shopping centres in four countries. What actions John could choose in order to colour cells that have order values between 100€ and 500€? John wants that cell change colour automatically, when order values are changed.

Start
Rankings
Calculate the sum of the values in a cell range
Calculate the sum of the values in a cell range

Adam has a table of data exported from the sales information system. In each row of the table provided order No, company name, country, order date, manager and order value. Company has shopping centres in four countries. What actions Adam should make in order to calculate the sum of the values of Laura's orders in Lithuania?

Start
Rankings
Analise big table data
Analise big table data

Adam has huge table of data exported from the sales information system. In each row of the table provided order No, company name, country, order date, manager and order value. Adam would like to compare sales data according to managers by months in each country and identify which managers did best sales. What actions Adam should make in order to summarise and analyse data in easy way?

Start
Rankings