Pages Menu
Categories Menu

Posted by on Jan 13, 2021 in Information Management, What's new | 0 comments

Designing a good Excel Database quickly: a few tips for increased efficiency

Designing a good Excel Database quickly: a few tips for increased efficiency

In the context of a sudden crisis, such as the COVID-19 crisis, there are often a lot of surveys and hence databases that are created and launched in a hurry to assess the populations’ needs and address them quickly in the field. This means that there will be many Excel files being sent around, with different versioning and privacy levels. A component at stake here becomes the size and performance of the database, and the potential analysis file, due to a rather common lack of or the bad quality of the internet connection in the field. The need for it to be sent, reviewed and finalized involves a lot of steps, for which the file should be at its best performance and minimal size.

This tutorial will help you undertake a few changes in your process, in order to improve the performance of your Excel databases and facilitate analysis when you need rapid insights. Implementing these reflexes within your organization may take some time at first since it will force you to think through your whole process but, in the end, you should gain a lot of time. Those changes are simple and easy enough to implement, and it will help your organization harmonize its practices and get more efficient.

You can read the document by downloading it in PDF format by clicking here or by clicking on the image.

Whether you have found this resource useful or not, we would love to hear back from you 😊 Please take one minute to fill in this 5-question survey ( to help improve the guidance we will continue producing in the context of this project!

– – – – – – – –

This project was co-funded by the French Development Agency (AFD) and the H2H Network’s H2H Fund, the latter supported by UK aid from the UK government. Nevertheless, the ideas and opinions presented in this document do not necessarily represent those of the H2H Network, UK aid and AFD.

Post a Reply

Your email address will not be published. Required fields are marked *

🚚 📦 We're moving!

[French below]

The content of the CartoBlog was transferred to the Information Management Resource Portal in May 2021:

Please note that the CartoBlog will be decommissioned in early 2022. From now on, we warmly encourage you to consult the tutorials, benchmarking studies and other resources directly onto the new portal.

Thank you!

🚚 📦 On déménage !

Le contenu du CartoBlog a été transféré sur l’IM Resource Portal en mai 2021 :

Veuillez noter que le CartoBlog sera désactivé au début de l’année 2022. Nous vous invitons, dès à présent, à prendre l’habitude de consulter les tutoriels, benchmarkings et autres ressources directement sur le nouveau portail.

Merci !