{"id":4696,"date":"2021-02-06T11:55:52","date_gmt":"2021-02-06T16:55:52","guid":{"rendered":"https:\/\/www.kraftgrp.com\/?p=4696"},"modified":"2021-02-06T11:55:52","modified_gmt":"2021-02-06T16:55:52","slug":"microsoft-excel-getting-started-with-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/","title":{"rendered":"Microsoft Excel: Getting Started With Pivot Tables"},"content":{"rendered":"<h2>Microsoft Excel: Getting Started With Pivot Tables<\/h2>\n<p>Having trouble organizing data for your company? Pivot tables are a great way to analyze statistics for your business, without dealing with complicated, hard to use programs. In this video, we discuss how to get started using pivot tables, and how they can help you.<\/p>\n<p><center><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/0Mvjc5H2jFE\" width=\"650\" height=\"355\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/center><\/p>\n<h3>Understanding Pivot Tables<\/h3>\n<p>In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables. The data a table is based on is referred to as \u201csource data\u201d. A pivot table has four different areas: row labels, values, column labels, and the report filter. Each column represents a different category of data in the pivot table.<\/p>\n<h3>How To Prep Your Data<\/h3>\n<p>When creating a pivot table, you should first begin by preparing your data. The data should be organized into rows and columns, with no blank areas except for cells. Then put similar data in the same columns, so that it is grouped together. Format column headings differently than your data so that the system can tell which is which. Bolding or centering the column heading is a good way to do this. Finally, create a data island to separate unnecessary information from the data.<\/p>\n<h3>How To Create A Pivot Table<\/h3>\n<p>To create a pivot table, go to \u201cinsert\u201d, either \u201crecommended pivot tables\u201d or \u201cpivot table\u201d, confirm the range you are using, hit \u201cnew worksheet\u201d and then \u201cok\u201d. To build your pivot table further, go to \u201cpivot table fields\u201d and choose the fields to include. To pick the values that are shown, hover over a cell, right-click, select \u201cnumber format\u201d, choose the category, and make any changes you need. Here you can also change how data is represented.<\/p>\n<h3>More Helpful Tips<\/h3>\n<p>When a pivot table is open, two tabs will be shown in the ribbon (\u201cpivot table analyze\u201d and \u201cdesign\u201d). Here you can refresh the table, which is important because it keeps the data you are working with up to date. Be aware that refreshing does not happen automatically. To refresh, go to \u201cpivot table analyze\u201d and select \u201crefresh\u201d or use shortcut Alt + F5. If you are working with multiple tables, use \u201crefresh all\u201d.<\/p>\n<p>If your dataset changes often and you need to update the range, go to \u201cchange data source\u201d and change the range. Specific rows can also be extracted by double-clicking on a value. This will create a new pivot table.<\/p>\n<p>Groups are created when multiple values are in the pivot table. Next to each group, there will be the \u201c-\u201d option. This collapses and hides the details of the group. This can also be done by pressing \u201ccollapse field\u201d in the ribbon.<\/p>\n<p>In \u201cdesign\u201d you can change the way the pivot table looks. Here you can also change how totals are displayed.<\/p>\n<p>To filter through a pivot table, use the row or column dropdown and select the categories you would like to see. Right-clicking on a value and choosing what to include also filters the pivot table. Values that weren\u2019t included can still be used to filter.<\/p>\n<h3>How Will Using Pivot Tables Help You?<\/h3>\n<p>Are you ready to get started using pivot tables in Microsoft Excel? With this guide, you will be able to easily understand and analyze data from your business. If you have more questions about how to use pivot tables, reach out to us here at Kraft Technology Group. We have IT professionals who can assist you will all your Microsoft needs. Contact us by phone or online today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.<\/p>\n","protected":false},"author":1,"featured_media":4697,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_mbp_gutenberg_autopost":false,"footnotes":""},"categories":[17],"tags":[],"class_list":["post-4696","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.6 (Yoast SEO v24.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Excel: Getting Started With Pivot Tables | Nashville Training<\/title>\n<meta name=\"description\" content=\"In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.\" \/>\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.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel: Getting Started With Pivot Tables\" \/>\n<meta property=\"og:description\" content=\"In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"KTG\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/krafttechgroup\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-06T16:55:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1296\" \/>\n\t<meta property=\"og:image:height\" content=\"706\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brian Gray\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/krafttechgroup\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brian Gray\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\"},\"author\":{\"name\":\"Brian Gray\",\"@id\":\"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36\"},\"headline\":\"Microsoft Excel: Getting Started With Pivot Tables\",\"datePublished\":\"2021-02-06T16:55:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\"},\"wordCount\":606,\"publisher\":{\"@id\":\"https:\/\/www.kraftgrp.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\",\"url\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\",\"name\":\"Microsoft Excel: Getting Started With Pivot Tables | Nashville Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.kraftgrp.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png\",\"datePublished\":\"2021-02-06T16:55:52+00:00\",\"description\":\"In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\",\"url\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png\",\"contentUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png\",\"width\":1296,\"height\":706,\"caption\":\"Microsoft Excel Training In Nashville\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.kraftgrp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel: Getting Started With Pivot Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.kraftgrp.com\/#website\",\"url\":\"https:\/\/www.kraftgrp.com\/\",\"name\":\"KTG\",\"description\":\"Nashville IT Support &amp; IT Services\",\"publisher\":{\"@id\":\"https:\/\/www.kraftgrp.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.kraftgrp.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Organization\",\"Place\"],\"@id\":\"https:\/\/www.kraftgrp.com\/#organization\",\"name\":\"Kraft Technology Group\",\"url\":\"https:\/\/www.kraftgrp.com\/\",\"logo\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-organization-logo\"},\"image\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-organization-logo\"},\"address\":{\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-place-address\"},\"geo\":{\"@type\":\"GeoCoordinates\",\"latitude\":\"36.1941464\",\"longitude\":\"-86.807833\"},\"telephone\":[\"(615) 600-4411\"],\"openingHoursSpecification\":[{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Sunday\",\"Saturday\"],\"opens\":\"00:00\",\"closes\":\"00:00\"},{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\"],\"opens\":\"09:00\",\"closes\":\"17:00\"}],\"email\":\"info@kraftgrp.com\",\"faxNumber\":\"(615) 600-4411\",\"areaServed\":\"Tennessee\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36\",\"name\":\"Brian Gray\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.kraftgrp.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e3eaceb02afed3272df4bb81d899c9a0055da84e0f59e049a5167c8612b8fe8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e3eaceb02afed3272df4bb81d899c9a0055da84e0f59e049a5167c8612b8fe8?s=96&d=mm&r=g\",\"caption\":\"Brian Gray\"},\"description\":\"Brian Gray, MCP, is the President at Kraft Technology Group, LLC (KTG), an affiliate of KraftCPAs PLLC. Within his role, Brian is responsible for all aspects of service delivery to our clients. Brian has a decade of experience working for managed service providers. He has worked with clients in a variety of industries, including financial services, accounting, legal, healthcare, manufacturing, and retail.\",\"sameAs\":[\"https:\/\/www.facebook.com\/krafttechgroup\/\",\"https:\/\/www.instagram.com\/kraft.tech.group\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/krafttechgroup\",\"https:\/\/www.youtube.com\/channel\/UCtyhZQ69LpOjdaHg6HxNwQg\/videos\"]},{\"@type\":\"PostalAddress\",\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-place-address\",\"streetAddress\":\"555 Great Circle, Road Nashville\",\"addressLocality\":\"Nashville\",\"postalCode\":\"37228\",\"addressRegion\":\"TN\",\"addressCountry\":\"US\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-organization-logo\",\"url\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png\",\"contentUrl\":\"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png\",\"width\":504,\"height\":100,\"caption\":\"Kraft Technology Group\"}]}<\/script>\n<meta name=\"geo.placename\" content=\"Nashville\" \/>\n<meta name=\"geo.position\" content=\"36.1941464;-86.807833\" \/>\n<meta name=\"geo.region\" content=\"United States (US)\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft Excel: Getting Started With Pivot Tables | Nashville Training","description":"In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.","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.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel: Getting Started With Pivot Tables","og_description":"In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.","og_url":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/","og_site_name":"KTG","article_author":"https:\/\/www.facebook.com\/krafttechgroup\/","article_published_time":"2021-02-06T16:55:52+00:00","og_image":[{"width":1296,"height":706,"url":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png","type":"image\/png"}],"author":"Brian Gray","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/krafttechgroup","twitter_misc":{"Written by":"Brian Gray","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#article","isPartOf":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/"},"author":{"name":"Brian Gray","@id":"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36"},"headline":"Microsoft Excel: Getting Started With Pivot Tables","datePublished":"2021-02-06T16:55:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/"},"wordCount":606,"publisher":{"@id":"https:\/\/www.kraftgrp.com\/#organization"},"image":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png","articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/","url":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/","name":"Microsoft Excel: Getting Started With Pivot Tables | Nashville Training","isPartOf":{"@id":"https:\/\/www.kraftgrp.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage"},"image":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png","datePublished":"2021-02-06T16:55:52+00:00","description":"In Microsoft Excel, pivot tables allow users to organize and analyze large amounts of data, making it easier to understand. You can examine differences, similarities, highs, and lows in datasets with these tables.","breadcrumb":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage","url":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png","contentUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Training-In-Nashville.png","width":1296,"height":706,"caption":"Microsoft Excel Training In Nashville"},{"@type":"BreadcrumbList","@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.kraftgrp.com\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel: Getting Started With Pivot Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.kraftgrp.com\/#website","url":"https:\/\/www.kraftgrp.com\/","name":"KTG","description":"Nashville IT Support &amp; IT Services","publisher":{"@id":"https:\/\/www.kraftgrp.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kraftgrp.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Organization","Place"],"@id":"https:\/\/www.kraftgrp.com\/#organization","name":"Kraft Technology Group","url":"https:\/\/www.kraftgrp.com\/","logo":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-organization-logo"},"image":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-organization-logo"},"address":{"@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-place-address"},"geo":{"@type":"GeoCoordinates","latitude":"36.1941464","longitude":"-86.807833"},"telephone":["(615) 600-4411"],"openingHoursSpecification":[{"@type":"OpeningHoursSpecification","dayOfWeek":["Sunday","Saturday"],"opens":"00:00","closes":"00:00"},{"@type":"OpeningHoursSpecification","dayOfWeek":["Monday","Tuesday","Wednesday","Thursday","Friday"],"opens":"09:00","closes":"17:00"}],"email":"info@kraftgrp.com","faxNumber":"(615) 600-4411","areaServed":"Tennessee"},{"@type":"Person","@id":"https:\/\/www.kraftgrp.com\/#\/schema\/person\/d64e95076b360a71439fd86beec62c36","name":"Brian Gray","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kraftgrp.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e3eaceb02afed3272df4bb81d899c9a0055da84e0f59e049a5167c8612b8fe8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e3eaceb02afed3272df4bb81d899c9a0055da84e0f59e049a5167c8612b8fe8?s=96&d=mm&r=g","caption":"Brian Gray"},"description":"Brian Gray, MCP, is the President at Kraft Technology Group, LLC (KTG), an affiliate of KraftCPAs PLLC. Within his role, Brian is responsible for all aspects of service delivery to our clients. Brian has a decade of experience working for managed service providers. He has worked with clients in a variety of industries, including financial services, accounting, legal, healthcare, manufacturing, and retail.","sameAs":["https:\/\/www.facebook.com\/krafttechgroup\/","https:\/\/www.instagram.com\/kraft.tech.group\/","https:\/\/x.com\/https:\/\/twitter.com\/krafttechgroup","https:\/\/www.youtube.com\/channel\/UCtyhZQ69LpOjdaHg6HxNwQg\/videos"]},{"@type":"PostalAddress","@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-place-address","streetAddress":"555 Great Circle, Road Nashville","addressLocality":"Nashville","postalCode":"37228","addressRegion":"TN","addressCountry":"US"},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kraftgrp.com\/microsoft-excel-getting-started-with-pivot-tables\/#local-main-organization-logo","url":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png","contentUrl":"https:\/\/www.kraftgrp.com\/wp-content\/uploads\/2019\/11\/Nashville-IT-Company.png","width":504,"height":100,"caption":"Kraft Technology Group"}]},"geo.placename":"Nashville","geo.position":{"lat":"36.1941464","long":"-86.807833"},"geo.region":"United States (US)"},"_links":{"self":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/posts\/4696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/comments?post=4696"}],"version-history":[{"count":0,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/posts\/4696\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/media\/4697"}],"wp:attachment":[{"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/media?parent=4696"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/categories?post=4696"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kraftgrp.com\/wp-json\/wp\/v2\/tags?post=4696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}