Source: dzone.com
Use COVID-19 as an Opportunity to Replace ExcelCategory: Database, Data, Microsoft
by However, now that we’ve been forced into this situation, we might as well take the chance to fix lingering problems in our organizational operations.
The only way to add information to an Excel file is – type it in. Say, if you want data from a customer, the only way to do this is to send the customer the Excel file to fill it in, or you ask them for the information, and you fill it in yourself.
You just add it to your site, and people fill it in in their own time.
If you keep running into these problems, much as you love Excel and pride yourself at your pivot table and macro writing skills, it is time to move to online database apps for information management.
The only way to add information to an Excel file is – type it in. Say, if you want data from a customer, the only way to do this is to send the customer the Excel file to fill it in, or you ask them for the information, and you fill it in yourself.
You just add it to your site, and people fill it in in their own time.
If you keep running into these problems, much as you love Excel and pride yourself at your pivot table and macro writing skills, it is time to move to online database apps for information management.
Related Articles
Community Partners
DevOps Careers