--- title: Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data description: Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data image: https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/microsoft-excel-1.jpg --- [Skip to the main content.](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#main-content) [![OTT powerd by VN big](https://ontimetech.valeonetworks.com/hs-fs/hubfs/OTT%20powerd%20by%20VN%20big.png?width=500&height=175&name=OTT%20powerd%20by%20VN%20big.png "OTT powerd by VN big")](https://ontimetech.valeonetworks.com) [![OTT powerd by VN big](https://ontimetech.valeonetworks.com/hs-fs/hubfs/OTT%20powerd%20by%20VN%20big.png?width=500&height=175&name=OTT%20powerd%20by%20VN%20big.png "OTT powerd by VN big")](https://ontimetech.valeonetworks.com) - [Services](https://ontimetech.valeonetworks.com/our-services/) - [Managed It Services](https://ontimetech.valeonetworks.com/our-services/managed-it/) - [Cybersecurity](https://ontimetech.valeonetworks.com/our-services/cybersecurity/) - [Cloud Solutions](https://ontimetech.valeonetworks.com/our-services/cloud-solutions/) - [Compliance](https://ontimetech.valeonetworks.com/our-services/compliance/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources](https://ontimetech.valeonetworks.com/resources/) - [Blog](https://ontimetech.valeonetworks.com/blog) - [About](https://ontimetech.valeonetworks.com/about/) - [Client Testimonials](https://ontimetech.valeonetworks.com/testimonials/) [415-294-5250](tel:4152945250) [Client Portal](https://portal.Valeonetworks.com) Toggle Menu Toggle Menu [415-294-5250](tel:4152945250) [Client Portal](https://portal.Valeonetworks.com) - [Services *Toggle Menu*](https://ontimetech.valeonetworks.com/our-services/) - [Managed It Services](https://ontimetech.valeonetworks.com/our-services/managed-it/) - [Cybersecurity](https://ontimetech.valeonetworks.com/our-services/cybersecurity/) - [Cloud Solutions](https://ontimetech.valeonetworks.com/our-services/cloud-solutions/) - [Compliance](https://ontimetech.valeonetworks.com/our-services/compliance/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources *Toggle Menu*](https://ontimetech.valeonetworks.com/resources/) - [Blog](https://ontimetech.valeonetworks.com/blog) - [About *Toggle Menu*](https://ontimetech.valeonetworks.com/about/) - [Client Testimonials](https://ontimetech.valeonetworks.com/testimonials/) - Example Link - Example Link - Example Link [*Facebook*](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#0) [*Instagram*](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#0) [*LinkedIn*](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#0) [*Twitter*](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#0) [*Youtube*](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#0) [*Medium*](https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data#0) 2 min read # Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Aug 15, 2014, 1:33:28 PM [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) ![Microsoft Excel](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Blog%20Images/Imported_Blog_Media/microsoft-excel-1.jpg?width=200&name=microsoft-excel-1.jpg)**The latest version of Microsoft Excel is a great addition to any office as it is now more efficient, functional and intuitive than ever before. ** Excel’s table tools make it easy to link charts and cells, perform searches, and create dynamically updated reports. In this sense, it functions somewhat like a relational database. **A relational database is essential for working with large amounts of business data.** They are structured to recognize relations among stored items of information. They allow you to quickly retrieve and search for specific info, view the same data set in multiple ways, and reduce data errors and redundancy. **In this article, we will show you how to make two tables: the master table and the detail table.** The master table will show the salespersons’ information, and the detail table will provide their total sales. To begin, open up a new, blank worksheet on Excel. **Create the Master Table** 1. Double-click *Sheet1* at the bottom of the screen and type, *Master* 2. In cell A1 type Master. 3. In cells A3 – F3 type these column headers: *Sales ID, Sales Person, Address, City, State, Zip Code.* 4. In cells A4 – A13 type the sales ID numbers – for experimental purposes type *101 – 110*. 5. Now continue by filling in names, addresses, cities, state, and zip codes in the remaining fields. In order to find the highest sales by city, make sure type the same city in multiple cells. 6. Once all the data is entered, highlight the table, and from the Styles group, select *Format as Table.* From the dropdown menu, choose the color and format you’d like. When the dialog box appears, make sure that *My table has headers* is checked. 7. With the table still highlighted, select the *Design* tab. On the far left, type *Master* in the Table Name box. **Create the Detail Table** 1. At the bottom of the screen beside the Master tab, click the plus (+) symbol to insert a new sheet. Double click the tag line at the bottom left that says Sheet2, and make it say *Sales.* 2. In cell A1 type, *Total Sales for 2014.* In cells A3 – E3, type *Sales ID, Quarter 1, Quarter 2, Quarter 3, Quarter 4.* 3. In cells A4 – A13 type the sales ID numbers: *101 – 110*. 4. In B4 – E13, enter 40 random numbers that represent sales dollars 5. Once the data is entered, highlight cells *A3 – E13.* Select *Format as Table, and* choose the colour and format you want from the dropdown menu. When the dialog box appears, ensure that *My table has headers* is checked. 6. With the table still highlighted, type *Sales* in the Table Name section on the left. With these tips your office is on its way to a more organized and efficient recording of data. Excel is a great tool to present and list important data in a clear and easy-to-understand way. **For more information on relational databases in Excel, please feel free to contact our team. You can reach us at {phone} or send us an email at {email}. Here at {company}, we want to ensure the organization and success of your company.** - [Tweet](https://twitter.com/share) #### ![BusinessOwnerGuidetoM&A-1](https://ontimetech.valeonetworks.com/hs-fs/hubfs/BusinessOwnerGuidetoM%26A-1.png?width=303&height=209&name=BusinessOwnerGuidetoM%26A-1.png) #### Download our eBook*THE ULTIMATE ROADMAP TO CMMC COMPLIANCE* by filling out the form below! [![Yahoo Data Theft –A Good Reason to Regularly Change Passwords](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/ThinkstockPhotos-481827264-1.jpg)](https://ontimetech.valeonetworks.com/blog/yahoo-data-theft-good-reason-to-regularly-change-passwords) #### [Yahoo Data Theft –A Good Reason to Regularly Change Passwords](https://ontimetech.valeonetworks.com/blog/yahoo-data-theft-good-reason-to-regularly-change-passwords) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Sep 24, 2016, 1:31:13 PM In case you needed another reason for regularly changing your passwords, the recently-uncovered Yahoo hack of 500 million accounts is probably the... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/yahoo-data-theft-good-reason-to-regularly-change-passwords) [![Top Reasons Why Businesses Should Backup Their Data](https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/ThinkstockPhotos-469932880-1-1.jpg)](https://ontimetech.valeonetworks.com/blog/top-reasons-why-businesses-should-backup-their-data) 1 min read #### [Top Reasons Why Businesses Should Backup Their Data](https://ontimetech.valeonetworks.com/blog/top-reasons-why-businesses-should-backup-their-data) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Oct 27, 2016, 11:39:51 AM Data is the information backbone of any given business venture or organization, and as such should really be treated like the Holy Grail that it is.... [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/top-reasons-why-businesses-should-backup-their-data) #### [Data Backup & Recovery](https://ontimetech.valeonetworks.com/blog/video-library/data-backup-and-recovery) [Lance Stone](https://ontimetech.valeonetworks.com/blog/author/ulisticadmin) : Apr 24, 2014, 5:17:43 AM [Managed IT Services](https://ontimetech.valeonetworks.com/blog/tag/managed-it-services) [Read More](https://ontimetech.valeonetworks.com/blog/video-library/data-backup-and-recovery) ![OTT White logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/VN%20-%20Division%20Logos/OTT%20Logo/OTT%20White%20logo.png?width=524&height=140&name=OTT%20White%20logo.png)   ##### About About On Time Tech is an IT Support and Computer Services company serving California. We provide services to the areas in and around We know businesses like yours need technology support in order to run highly-effective organizations. Leverage pro-growth technology services for your company now. ##### Explore On Time Time Explore On Time Time - [Our Services](https://ontimetech.valeonetworks.com/our-services/) - [Industries](https://ontimetech.valeonetworks.com/industries/) - [Resources](https://ontimetech.valeonetworks.com/resources/) - [About](https://ontimetech.valeonetworks.com/about/) - [Contact](https://ontimetech.valeonetworks.com/contact/) ##### Contact Contact **San Francisco:** 1717 Fifth Ave San Rafael, CA 94901 [415-294-5250](tel:4152945250) Business Hours: M-F: 8AM-9PM - [Privacy Policy](https://ontimetech.valeonetworks.com/privacy-policy/) © 2026 On Time Tech [*Facebook*](https://www.facebook.com/ontimetechsf/)[*Twitter*](https://twitter.com/on_time_tech?lang=en)[*LinkedIn*](https://www.linkedin.com/company/ontimetech/)[*YouTube*](https://www.youtube.com/channel/UCubqs9PU_WWF-RFhfK9xNpw) [![Alura White logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/VN%20-%20Division%20Logos/Alura%20White%20logo.png?width=295&height=115&name=Alura%20White%20logo.png)](https://alura.valeonetworks.com/) [![Next.I.T._White-Logo](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Next.I.T._White-Logo.png?width=328&height=136&name=Next.I.T._White-Logo.png)](https://next-it.net/) [![White-OTT-Logo-1-768x253](https://ontimetech.valeonetworks.com/hs-fs/hubfs/White-OTT-Logo-1-768x253.png?width=313&height=103&name=White-OTT-Logo-1-768x253.png)](https://www.ontimetech.com/) [![Valeo-Logo-White (1)](https://ontimetech.valeonetworks.com/hs-fs/hubfs/Valeo-Logo-White%20(1).png?width=288&height=123&name=Valeo-Logo-White%20(1).png)](https://valeonetworks.com/) *Return to Top* ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Lance Stone", "url" : "https://ontimetech.valeonetworks.com/blog/author/ulisticadmin" }, "dateModified" : "2024-01-10T16:29:53.728Z", "datePublished" : "2014-08-15T17:33:28.000Z", "headline" : "Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data", "image" : [ "https://ontimetech.valeonetworks.com/hubfs/Blog%20Images/Imported_Blog_Media/microsoft-excel-1.jpg" ], "mainEntityOfPage" : { "@id" : "https://ontimetech.valeonetworks.com/blog/tech-tips/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://ontimetech.valeonetworks.com/hubfs/OTT%20-%20Color%20Logo.png" }, "name" : "Valeo Networks" } } ```