{"id":611,"date":"2021-11-23T09:00:00","date_gmt":"2021-11-23T14:00:00","guid":{"rendered":"https:\/\/figartconsulting.com\/wordpress\/?p=611"},"modified":"2021-11-18T13:03:17","modified_gmt":"2021-11-18T18:03:17","slug":"excel-intermediate-and-problems-with-zip-codes","status":"publish","type":"post","link":"https:\/\/figartconsulting.com\/wordpress\/2021\/11\/23\/excel-intermediate-and-problems-with-zip-codes\/","title":{"rendered":"Excel Intermediate and Problems with Zip Codes"},"content":{"rendered":"\n<p><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/11\/111821_1623_ExcelInterm1.png?w=525&#038;ssl=1\" alt=\"\" align=\"left\">I was once hired to set up an email list for a wildlife rehabilitation center in New England.<\/p>\n\n\n\n<p>Excel list? Check.<\/p>\n\n\n\n<p>Mail Merge for printing the labels? Check.<\/p>\n\n\n\n<p>Quick job. Easy turn-around. No problem<\/p>\n\n\n\n<p>*grin*<\/p>\n\n\n\n<p>Until\u2026<\/p>\n\n\n\n<p>I printed out <em>thousands<\/em> of (okay I stopped the job after a couple of sheets\u2026) of Northern New England zip codes with only FOUR digits instead of five.<\/p>\n\n\n\n<p>How did that happen? The zip codes were correct in the spreadsheet!<\/p>\n\n\n\n<p>In session two, we&#8217;ll be learning how to avoid errors like this easily as well as other custom masks, advanced formatting themes, merging, and transposition tricks that make the spreadsheet not only useful but easily readable.<\/p>\n\n\n\n<p>Sign up and learn!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Excel Intermediate<\/h2>\n\n\n\n<p>This will be a six-week course starting:<\/p>\n\n\n\n<p>Tuesday, January 4, 2022<\/p>\n\n\n\n<p>7:00-8:00 pm EST<\/p>\n\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-white-color has-vivid-purple-background-color has-text-color has-background\" href=\"https:\/\/figartconsulting.com\/wordpress\/courses-offered\/excel-intermediate\/\" target=\"_blank\" rel=\"https:\/\/figartconsulting.com\/wordpress\/courses-offered\/excel-intermediate\/ noopener\">Sign Me Up!!!!<\/a><\/div>\n<\/div>\n\n\n\n<p>.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was once hired to set up an email list for a wildlife rehabilitation center in New England. Excel list? Check. Mail Merge for printing the labels? Check. Quick job. Easy turn-around. No problem *grin* Until\u2026 I printed out thousands of (okay I stopped the job after a couple of sheets\u2026) of Northern New England &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/figartconsulting.com\/wordpress\/2021\/11\/23\/excel-intermediate-and-problems-with-zip-codes\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel Intermediate and Problems with Zip Codes&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14],"tags":[],"class_list":["post-611","post","type-post","status-publish","format-standard","hentry","category-computer-instruction"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pLg3p-9R","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/611","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/comments?post=611"}],"version-history":[{"count":3,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/611\/revisions"}],"predecessor-version":[{"id":614,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/611\/revisions\/614"}],"wp:attachment":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/media?parent=611"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/categories?post=611"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/tags?post=611"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}