{"id":28658,"date":"2014-08-15T10:28:00","date_gmt":"2014-08-15T15:28:00","guid":{"rendered":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/"},"modified":"2014-08-15T10:28:00","modified_gmt":"2014-08-15T15:28:00","slug":"use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data","status":"publish","type":"post","link":"https:\/\/ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/","title":{"rendered":"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data"},"content":{"rendered":"

\"MicrosoftThe latest version of Microsoft Excel is a great addition to any office as it is now more efficient, functional and intuitive than ever before. <\/strong><\/p>\n

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.<\/p>\n

A relational database is essential for working with large amounts of business data.<\/strong><\/p>\n

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.<\/p>\n

In this article, we will show you how to make two tables: the master table and the detail table.<\/strong><\/p>\n

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.<\/p>\n

Create the Master Table<\/strong><\/p>\n

    \n
  1. Double-click Sheet1<\/em> at the bottom of the screen and type, Master<\/em><\/li>\n
  2. In cell A1 type Master.<\/li>\n
  3. In cells A3 – F3 type these column headers: Sales ID, Sales Person, Address, City, State, Zip Code.<\/em><\/li>\n
  4. In cells A4 – A13 type the sales ID numbers – for experimental purposes type 101 – 110<\/em>.<\/li>\n
  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.<\/li>\n
  6. Once all the data is entered, highlight the table, and from the Styles group, select Format as Table. <\/em>From the dropdown menu, choose the color and format you’d like. When the dialog box appears, make sure that My table has headers<\/em> is checked.<\/li>\n
  7. With the table still highlighted, select the Design <\/em>tab. On the far left, type Master<\/em> in the Table Name box.<\/li>\n<\/ol>\n

    Create the Detail Table<\/strong><\/p>\n

      \n
    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.<\/em><\/li>\n
    2. In cell A1 type, Total Sales for 2014.<\/em> In cells A3 – E3, type Sales ID, Quarter 1, Quarter 2, Quarter 3, Quarter 4.<\/em><\/li>\n
    3. In cells A4 – A13 type the sales ID numbers: 101 – 110<\/em>.<\/li>\n
    4. In B4 – E13, enter 40 random numbers that represent sales dollars<\/li>\n
    5. Once the data is entered, highlight cells A3 – E13. <\/em>Select Format as Table, and <\/em>choose the colour and format you want from the dropdown menu. When the dialog box appears, ensure that My table has headers<\/em> is checked.<\/li>\n
    6. With the table still highlighted, type Sales <\/em>in the Table Name section on the left.<\/li>\n<\/ol>\n

      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.

      \nFor 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.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

      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…<\/p>\n","protected":false},"author":5,"featured_media":59475,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[53],"tags":[],"class_list":["post-28658","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-techtips"],"acf":[],"yoast_head":"\nUse These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data - IT Services in Virginia<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data - IT Services in Virginia\" \/>\n<meta property=\"og:description\" content=\"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…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/\" \/>\n<meta property=\"og:site_name\" content=\"IT Services in Virginia\" \/>\n<meta property=\"article:published_time\" content=\"2014-08-15T15:28:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blogfeed.ulistic-projects.com\/wp-content\/uploads\/2014\/08\/microsoft-excel.jpg\" \/>\n<meta name=\"author\" content=\"Steve West\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Steve West\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/\",\"url\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/\",\"name\":\"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data - IT Services in Virginia\",\"isPartOf\":{\"@id\":\"https:\/\/www.ntegrait.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2014\/08\/microsoft-excel-1.jpg\",\"datePublished\":\"2014-08-15T15:28:00+00:00\",\"dateModified\":\"2014-08-15T15:28:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#primaryimage\",\"url\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2014\/08\/microsoft-excel-1.jpg\",\"contentUrl\":\"https:\/\/ntegrait.com\/wp-content\/uploads\/2014\/08\/microsoft-excel-1.jpg\",\"width\":414,\"height\":414},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ntegrait.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ntegrait.com\/#website\",\"url\":\"https:\/\/www.ntegrait.com\/\",\"name\":\"IT Services in Virginia\",\"description\":\"Ntegra IT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ntegrait.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79\",\"name\":\"Steve West\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.ntegrait.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g\",\"caption\":\"Steve West\"},\"description\":\"Ntegra IT is devoted to providing reliable Computer Support to businesses that want to improve productivity and profitability. We deliver custom designed Network Services that better map to your business, so you can stop worrying about your technology and get back to achieving your business goals.\",\"url\":\"https:\/\/ntegrait.com\/author\/swestntegrait-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data - IT Services in Virginia","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/","og_locale":"en_US","og_type":"article","og_title":"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data - IT Services in Virginia","og_description":"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…","og_url":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/","og_site_name":"IT Services in Virginia","article_published_time":"2014-08-15T15:28:00+00:00","og_image":[{"url":"http:\/\/blogfeed.ulistic-projects.com\/wp-content\/uploads\/2014\/08\/microsoft-excel.jpg","type":"","width":"","height":""}],"author":"Steve West","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Steve West","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/","url":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/","name":"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data - IT Services in Virginia","isPartOf":{"@id":"https:\/\/www.ntegrait.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#primaryimage"},"image":{"@id":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#primaryimage"},"thumbnailUrl":"https:\/\/ntegrait.com\/wp-content\/uploads\/2014\/08\/microsoft-excel-1.jpg","datePublished":"2014-08-15T15:28:00+00:00","dateModified":"2014-08-15T15:28:00+00:00","author":{"@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79"},"breadcrumb":{"@id":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#primaryimage","url":"https:\/\/ntegrait.com\/wp-content\/uploads\/2014\/08\/microsoft-excel-1.jpg","contentUrl":"https:\/\/ntegrait.com\/wp-content\/uploads\/2014\/08\/microsoft-excel-1.jpg","width":414,"height":414},{"@type":"BreadcrumbList","@id":"https:\/\/www.ntegrait.com\/use-these-relational-databases-in-excel-to-accelerate-the-recording-of-your-important-business-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ntegrait.com\/"},{"@type":"ListItem","position":2,"name":"Use These Relational Databases in Excel to Accelerate the Recording of Your Important Business Data"}]},{"@type":"WebSite","@id":"https:\/\/www.ntegrait.com\/#website","url":"https:\/\/www.ntegrait.com\/","name":"IT Services in Virginia","description":"Ntegra IT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ntegrait.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/33156c118f002b88019c3fc70441bf79","name":"Steve West","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.ntegrait.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cc273f166c78aca895198956663df42?s=96&d=mm&r=g","caption":"Steve West"},"description":"Ntegra IT is devoted to providing reliable Computer Support to businesses that want to improve productivity and profitability. We deliver custom designed Network Services that better map to your business, so you can stop worrying about your technology and get back to achieving your business goals.","url":"https:\/\/ntegrait.com\/author\/swestntegrait-com\/"}]}},"_links":{"self":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts\/28658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/comments?post=28658"}],"version-history":[{"count":0,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/posts\/28658\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/media\/59475"}],"wp:attachment":[{"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/media?parent=28658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/categories?post=28658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ntegrait.com\/wp-json\/wp\/v2\/tags?post=28658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}