{"id":3634,"date":"2014-07-31T21:30:49","date_gmt":"2014-07-31T21:30:49","guid":{"rendered":"http:\/\/affirmativeaction.com\/news\/?p=3634"},"modified":"2020-08-09T09:42:04","modified_gmt":"2020-08-09T16:42:04","slug":"excel-tutorial-filters","status":"publish","type":"post","link":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/","title":{"rendered":"Excel Tutorial: Filters"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft  wp-image-3605\" src=\"\/blog\/wp-content\/uploads\/2014\/07\/excel.png\" alt=\"Excel Tips and Tutorials\" width=\"90\" height=\"90\">This is the third video in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan.<\/p>\n<p>In previous episodes, we showed you how to <a title=\"Excel Tutorial: Removing Blank Spaces\" href=\"\/news\/excel-tutorial-removing-blank-spaces\/\">remove blank spaces<\/a>&nbsp;in your data and how to use Excel&#8217;s &nbsp;&#8220;<a title=\"Excel Tutorial: Freeze Panes\" href=\"\/news\/excel-tutorial-freeze-panes\/\">Freeze Panes<\/a>&#8221; option. Today\u2019s video goes over using filters to quickly organize your information.<\/p>\n<p><!--more--><\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/OEfGkumYL-w?rel=0\" width=\"640\" height=\"480\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the third video in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan. In previous episodes, we showed you how to remove blank spaces&nbsp;in your data and how to use Excel&#8217;s &nbsp;&#8220;Freeze Panes&#8221; option. Today\u2019s video [&hellip;]<\/p>\n","protected":false},"author":101026,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[11],"tags":[184,55],"class_list":{"0":"post-3634","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-training","7":"tag-data-preparation","8":"tag-excel","9":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel Tutorial: Filters &#187; Biddle Consulting Group News<\/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:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Tutorial: Filters &#187; Biddle Consulting Group News\" \/>\n<meta property=\"og:description\" content=\"This is the third video in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan. In previous episodes, we showed you how to remove blank spaces&nbsp;in your data and how to use Excel&#8217;s &nbsp;&#8220;Freeze Panes&#8221; option. Today\u2019s video [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/\" \/>\n<meta property=\"og:site_name\" content=\"Biddle Consulting Group News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-31T21:30:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-08-09T16:42:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2014\/07\/excel.png\" \/>\n<meta name=\"author\" content=\"Jeff Davies, M.A.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@BiddleCG\" \/>\n<meta name=\"twitter:site\" content=\"@BiddleCG\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Davies, M.A.\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/\"},\"author\":{\"name\":\"Jeff Davies, M.A.\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/person\\\/e60b7ef3c24a54fa39bd0f3a8f0342e7\"},\"headline\":\"Excel Tutorial: Filters\",\"datePublished\":\"2014-07-31T21:30:49+00:00\",\"dateModified\":\"2020-08-09T16:42:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/\"},\"wordCount\":71,\"publisher\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\"},\"keywords\":[\"data preparation\",\"excel\"],\"articleSection\":[\"Training\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/\",\"name\":\"Excel Tutorial: Filters &#187; Biddle Consulting Group News\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#website\"},\"datePublished\":\"2014-07-31T21:30:49+00:00\",\"dateModified\":\"2020-08-09T16:42:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/2014\\\/07\\\/31\\\/excel-tutorial-filters\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Tutorial: Filters\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\",\"name\":\"Biddle Consulting Group News\",\"description\":\"EEO, Affirmative Action, Pay Equity &amp; Employee Testing Solutions\",\"publisher\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/biddle.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#organization\",\"name\":\"Biddle Consulting Group, Inc.\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/biddle.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/logo-biddle.png\",\"contentUrl\":\"https:\\\/\\\/biddle.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/logo-biddle.png\",\"width\":154,\"height\":48,\"caption\":\"Biddle Consulting Group, Inc.\"},\"image\":{\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/pages\\\/Biddle-Consulting-Group-Inc\\\/283128085965\",\"https:\\\/\\\/x.com\\\/BiddleCG\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/biddle-consulting-group\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/biddletube01\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/biddle.com\\\/blog\\\/#\\\/schema\\\/person\\\/e60b7ef3c24a54fa39bd0f3a8f0342e7\",\"name\":\"Jeff Davies, M.A.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g\",\"caption\":\"Jeff Davies, M.A.\"},\"description\":\"Jeff Davies is an EEO\\\/AA Consultant at Biddle Consulting Group. He assists federal contractors in developing and maintaining compliant Affirmative Action Plans and navigating OFCCP audits. Jeff also manages all AAP software clients at Biddle and routinely presents on various industry topics.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Tutorial: Filters &#187; Biddle Consulting Group News","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:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/","og_locale":"en_US","og_type":"article","og_title":"Excel Tutorial: Filters &#187; Biddle Consulting Group News","og_description":"This is the third video in a series of Excel tutorials. These tutorials share tips on how to use Excel to better prepare your data for use in an Affirmative Action Plan. In previous episodes, we showed you how to remove blank spaces&nbsp;in your data and how to use Excel&#8217;s &nbsp;&#8220;Freeze Panes&#8221; option. Today\u2019s video [&hellip;]","og_url":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/","og_site_name":"Biddle Consulting Group News","article_publisher":"https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965","article_published_time":"2014-07-31T21:30:49+00:00","article_modified_time":"2020-08-09T16:42:04+00:00","og_image":[{"url":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2014\/07\/excel.png","type":"","width":"","height":""}],"author":"Jeff Davies, M.A.","twitter_card":"summary_large_image","twitter_creator":"@BiddleCG","twitter_site":"@BiddleCG","twitter_misc":{"Written by":"Jeff Davies, M.A."},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/#article","isPartOf":{"@id":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/"},"author":{"name":"Jeff Davies, M.A.","@id":"https:\/\/biddle.com\/blog\/#\/schema\/person\/e60b7ef3c24a54fa39bd0f3a8f0342e7"},"headline":"Excel Tutorial: Filters","datePublished":"2014-07-31T21:30:49+00:00","dateModified":"2020-08-09T16:42:04+00:00","mainEntityOfPage":{"@id":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/"},"wordCount":71,"publisher":{"@id":"https:\/\/biddle.com\/blog\/#organization"},"keywords":["data preparation","excel"],"articleSection":["Training"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/","url":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/","name":"Excel Tutorial: Filters &#187; Biddle Consulting Group News","isPartOf":{"@id":"https:\/\/biddle.com\/blog\/#website"},"datePublished":"2014-07-31T21:30:49+00:00","dateModified":"2020-08-09T16:42:04+00:00","breadcrumb":{"@id":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/biddle.com\/blog\/2014\/07\/31\/excel-tutorial-filters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/biddle.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel Tutorial: Filters"}]},{"@type":"WebSite","@id":"https:\/\/biddle.com\/blog\/#website","url":"https:\/\/biddle.com\/blog\/","name":"Biddle Consulting Group News","description":"EEO, Affirmative Action, Pay Equity &amp; Employee Testing Solutions","publisher":{"@id":"https:\/\/biddle.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/biddle.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/biddle.com\/blog\/#organization","name":"Biddle Consulting Group, Inc.","url":"https:\/\/biddle.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/biddle.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2017\/09\/logo-biddle.png","contentUrl":"https:\/\/biddle.com\/blog\/wp-content\/uploads\/2017\/09\/logo-biddle.png","width":154,"height":48,"caption":"Biddle Consulting Group, Inc."},"image":{"@id":"https:\/\/biddle.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pages\/Biddle-Consulting-Group-Inc\/283128085965","https:\/\/x.com\/BiddleCG","https:\/\/www.linkedin.com\/company\/biddle-consulting-group","https:\/\/www.youtube.com\/user\/biddletube01"]},{"@type":"Person","@id":"https:\/\/biddle.com\/blog\/#\/schema\/person\/e60b7ef3c24a54fa39bd0f3a8f0342e7","name":"Jeff Davies, M.A.","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cbbe5d37acc3e7cfc9291cbf01ccf6b17836bc3c7407e9cc4c1e3212dc20f7dc?s=96&d=mm&r=g","caption":"Jeff Davies, M.A."},"description":"Jeff Davies is an EEO\/AA Consultant at Biddle Consulting Group. He assists federal contractors in developing and maintaining compliant Affirmative Action Plans and navigating OFCCP audits. Jeff also manages all AAP software clients at Biddle and routinely presents on various industry topics."}]}},"_links":{"self":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/users\/101026"}],"replies":[{"embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/comments?post=3634"}],"version-history":[{"count":1,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3634\/revisions"}],"predecessor-version":[{"id":5010,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/posts\/3634\/revisions\/5010"}],"wp:attachment":[{"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/media?parent=3634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/categories?post=3634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biddle.com\/blog\/wp-json\/wp\/v2\/tags?post=3634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}