Answer:
The main advantage of using the the excel that help in navigating the databases and helps in data analytics. It basically exploring huge information and databases are predominantly the information purging methods in exceed expectations which aides in preparing information in an expedient and proficient way.
The information purging procedure incorporate VBA macros or rotate tables, mapping instruments, report causing utilizing progressed to exceed expectations devices and furthermore has the upside of reconciliation with different virtual products.
The disadvantage are as follows:
- It is difficult for sharing the spreadsheet in the system.
- It also face difficulty while observing the any type of the regular tends in the given data.