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

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

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

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