There are several areas where companies will have to rethink their approaches to analytics and use of data, and some of them will potentially overlap.
Last week, we learned how to use SQL and query data inside Excel. Once we have found the last row we then select the next empty cell below that and paste our data then.
Applications that make use of analytics will grow 65 per cent faster than apps without this kind of functionality, according to the firm.
This allows us to paste data onto separate sheets within the same workbook.
Many companies try to consolidate the data themselves, using Excel, for example.
But do-it-yourself solutions can compound the problems, turning highly paid business professionals into data gatherers who spend a lot of time cleaning and massaging data and reconciling results.
One of the workbooks (the one called ‘Products.xlsx’) contains sample product data from a company that sells furniture.
In this case, I have made it very simple for you and the data consist of a column with a product number (column A) and a column with a product name (column B).