{"id":14994,"date":"2021-02-05T10:50:11","date_gmt":"2021-02-05T18:50:11","guid":{"rendered":"https:\/\/www.bcnetworks.com\/?p=14994"},"modified":"2023-06-07T11:32:50","modified_gmt":"2023-06-07T15:32:50","slug":"microsoft-excel-getting-started-with-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.bcnetworks.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>In Microsoft Excel, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall. In this video, we discuss how to get started using pivot tables, so that your company\u2019s data can be more organized.<\/p>\n<p><center><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/wmw2DkRkOUw\" 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>Through the use of pivot tables, you can analyze large amounts of data, making it easier to understand and keep track of your business. You can examine differences, similarities, highs, and lows in datasets. Here are a couple of things you should know before getting started with pivot tables. \u201cSource data\u201d is the data that the pivot table is based on. A pivot table has four different areas: row labels, values, column labels, and the report filter. Each column in a pivot table represents a different category of data.<\/p>\n<h3>How To Prep Your Data<\/h3>\n<p>Before making a pivot table, you should always prepare your data. It should be organized into rows and columns, with no blank areas except for cells. Similar data should be placed in the same columns so that it is grouped together. Column headings should be formatted differently than your data so that the system can tell it apart. To do this, try bolding or centering the column heading. Also, make sure to 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. How data is represented can also be changed in this area.<\/p>\n<h3>More Helpful Tips<\/h3>\n<p>Two tabs will be shown in the ribbon (\u201cpivot table analyze\u201d and \u201cdesign\u201d) when a pivot table is open. You can also refresh the table, which is important because it keeps your data updated if any changes are made.. 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. If you need to update the range, go to \u201cchange data source\u201d and change the range. You can extract specific rows by double-clicking on a value. This will create a new pivot table.<\/p>\n<p>When multiple values are in the pivot table, groups are created. Next to each group, there will be the \u201c-\u201d option. This hides the details of the group by collapsing them. This can also be done by pressing \u201ccollapse field\u201d in the ribbon. In \u201cdesign\u201d you can change the appearance of the pivot table and 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. You can also filter by right-clicking on a value and choosing what to include. Values that weren\u2019t included can still be used to filter.<\/p>\n<h3>How Will Using Pivot Tables Help You?<\/h3>\n<p>Pivot tables are a useful feature for anyone looking to better organize their data. The analysis becomes easy when you have pivot tables to work with. If you have more questions about these tables or Microsoft Excel in general, please contact us. At BC Networks, we are prepared to assist with all your technology needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Microsoft Excel, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.<\/p>\n","protected":false},"author":5,"featured_media":14995,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-14994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.1 (Yoast SEO v24.8.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Excel: Getting Started With Pivot Tables<\/title>\n<meta name=\"description\" content=\"In Microsoft Excel, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.\" \/>\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.bcnetworks.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, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"BC Networks\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-05T18:50:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-07T15:32:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png\" \/>\n\t<meta property=\"og:image:width\" content=\"643\" \/>\n\t<meta property=\"og:image:height\" content=\"354\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Dave Brewer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dave Brewer\" \/>\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.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/\"},\"author\":{\"name\":\"Dave Brewer\",\"@id\":\"https:\/\/www.bcnetworks.com\/#\/schema\/person\/65b25b5c8d6c2a6c8c737cbad275251a\"},\"headline\":\"Microsoft Excel: Getting Started With Pivot Tables\",\"datePublished\":\"2021-02-05T18:50:11+00:00\",\"dateModified\":\"2023-06-07T15:32:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/\"},\"wordCount\":622,\"publisher\":{\"@id\":\"https:\/\/www.bcnetworks.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/\",\"url\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/\",\"name\":\"Microsoft Excel: Getting Started With Pivot Tables\",\"isPartOf\":{\"@id\":\"https:\/\/www.bcnetworks.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png\",\"datePublished\":\"2021-02-05T18:50:11+00:00\",\"dateModified\":\"2023-06-07T15:32:50+00:00\",\"description\":\"In Microsoft Excel, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage\",\"url\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png\",\"contentUrl\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png\",\"width\":643,\"height\":354,\"caption\":\"Microsoft Excel Pivot Tables\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bcnetworks.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel: Getting Started With Pivot Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bcnetworks.com\/#website\",\"url\":\"https:\/\/www.bcnetworks.com\/\",\"name\":\"BMC Networks\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.bcnetworks.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bcnetworks.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.bcnetworks.com\/#organization\",\"name\":\"BMC Networks\",\"url\":\"https:\/\/www.bcnetworks.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bcnetworks.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/06\/BCNetworks_Logo-1.png\",\"contentUrl\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/06\/BCNetworks_Logo-1.png\",\"width\":242,\"height\":115,\"caption\":\"BMC Networks\"},\"image\":{\"@id\":\"https:\/\/www.bcnetworks.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.bcnetworks.com\/#\/schema\/person\/65b25b5c8d6c2a6c8c737cbad275251a\",\"name\":\"Dave Brewer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bcnetworks.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/10\/dave-braver-img-150x150.jpeg\",\"contentUrl\":\"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/10\/dave-braver-img-150x150.jpeg\",\"caption\":\"Dave Brewer\"},\"description\":\"When it comes to IT services and solutions, it's crucial to have a knowledgeable and passionate partner who can help clients achieve sustainable growth using proven IT solutions. Our CEO, Dave, is deeply committed to assisting clients in enhancing their technology to gain a competitive advantage in their respective industries. At BC Networks, Dave Brewer leads a team of dedicated professionals who are focused on delivering outstanding IT services and solutions. With his vast expertise and practical experience, Dave ensures that clients receive top-notch support and guidance for their IT initiatives. You can rely on BC Networks to elevate your business systems and stay ahead in today's fiercely competitive business environment.\",\"url\":\"https:\/\/www.bcnetworks.com\/author\/ulisticadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft Excel: Getting Started With Pivot Tables","description":"In Microsoft Excel, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.","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.bcnetworks.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, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.","og_url":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/","og_site_name":"BC Networks","article_published_time":"2021-02-05T18:50:11+00:00","article_modified_time":"2023-06-07T15:32:50+00:00","og_image":[{"width":643,"height":354,"url":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png","type":"image\/png"}],"author":"Dave Brewer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dave Brewer","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#article","isPartOf":{"@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/"},"author":{"name":"Dave Brewer","@id":"https:\/\/www.bcnetworks.com\/#\/schema\/person\/65b25b5c8d6c2a6c8c737cbad275251a"},"headline":"Microsoft Excel: Getting Started With Pivot Tables","datePublished":"2021-02-05T18:50:11+00:00","dateModified":"2023-06-07T15:32:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/"},"wordCount":622,"publisher":{"@id":"https:\/\/www.bcnetworks.com\/#organization"},"image":{"@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png","articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/","url":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/","name":"Microsoft Excel: Getting Started With Pivot Tables","isPartOf":{"@id":"https:\/\/www.bcnetworks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage"},"image":{"@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png","datePublished":"2021-02-05T18:50:11+00:00","dateModified":"2023-06-07T15:32:50+00:00","description":"In Microsoft Excel, there are many tools that can save you time and effort. But one of the best features is pivot tables. With pivot tables, you can easily analyze data from your business so that you can keep track of how you are doing overall.","breadcrumb":{"@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#primaryimage","url":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png","contentUrl":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2021\/02\/Microsoft-Excel-Pivot-Tables.png","width":643,"height":354,"caption":"Microsoft Excel Pivot Tables"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bcnetworks.com\/microsoft-excel-getting-started-with-pivot-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bcnetworks.com\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel: Getting Started With Pivot Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.bcnetworks.com\/#website","url":"https:\/\/www.bcnetworks.com\/","name":"BMC Networks","description":"","publisher":{"@id":"https:\/\/www.bcnetworks.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bcnetworks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bcnetworks.com\/#organization","name":"BMC Networks","url":"https:\/\/www.bcnetworks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bcnetworks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/06\/BCNetworks_Logo-1.png","contentUrl":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/06\/BCNetworks_Logo-1.png","width":242,"height":115,"caption":"BMC Networks"},"image":{"@id":"https:\/\/www.bcnetworks.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bcnetworks.com\/#\/schema\/person\/65b25b5c8d6c2a6c8c737cbad275251a","name":"Dave Brewer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bcnetworks.com\/#\/schema\/person\/image\/","url":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/10\/dave-braver-img-150x150.jpeg","contentUrl":"https:\/\/www.bcnetworks.com\/wp-content\/uploads\/2023\/10\/dave-braver-img-150x150.jpeg","caption":"Dave Brewer"},"description":"When it comes to IT services and solutions, it's crucial to have a knowledgeable and passionate partner who can help clients achieve sustainable growth using proven IT solutions. Our CEO, Dave, is deeply committed to assisting clients in enhancing their technology to gain a competitive advantage in their respective industries. At BC Networks, Dave Brewer leads a team of dedicated professionals who are focused on delivering outstanding IT services and solutions. With his vast expertise and practical experience, Dave ensures that clients receive top-notch support and guidance for their IT initiatives. You can rely on BC Networks to elevate your business systems and stay ahead in today's fiercely competitive business environment.","url":"https:\/\/www.bcnetworks.com\/author\/ulisticadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/posts\/14994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/comments?post=14994"}],"version-history":[{"count":0,"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/posts\/14994\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/media\/14995"}],"wp:attachment":[{"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/media?parent=14994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/categories?post=14994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bcnetworks.com\/wp-json\/wp\/v2\/tags?post=14994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}