Data Mining in Excel through Macros
What Is Data Mining? Data mining is also known as knowledge discovery, and if we have mountains of data to sift through, it can be a daunting task to make sense of it. How do you analyze so many numbers to look for patterns? How do we better understand our customers and our business based on sales data? You might assume that data mining would be something large companies with sophisticated databases would use, but there’s an excellent tool for small-to-medium sized businesses – Microsoft Excel. Read: SAP training in Delhi Excel is a piece of spreadsheet software developed by Microsoft over 25 years ago and is available on Windows, Mac OS, Android, and iOS platforms. A spreadsheet is basically a grid of rows and columns with cells that store data, and you can perform a wide variety of arithmetic and other functions on the information. Many people use Excel to ‘crunch numbers’ but it can also be used like a database to store and organize informa...