Awasome Make A Database In Excel References. Use charts, graphs, and pivot tables to get a better understanding of your data. You may also look at these useful functions in excel:
Doing so opens the access template page. Building a customer database in excel may not be easy, but hey, we did it! Create your fields as column headers.