{"id":25487,"date":"2016-01-15T21:01:43","date_gmt":"2016-01-15T13:01:43","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=25487"},"modified":"2022-03-21T14:48:04","modified_gmt":"2022-03-21T06:48:04","slug":"excel-tricks","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/","title":{"rendered":"Awesome Excel Tricks to Impress Your Boss [Infographic]"},"content":{"rendered":"<p>For many, Excel is the go-to program for <strong>charting graphs for labwork results<\/strong> or for data entry and accounting. Its formula-based auto-calculations help us save time and in many jobs, it is a requirement to know how to work Excel before you even get the job. However, unknown to some, the program has plenty of tricks and shortcuts that you can use to get tedious, boring work done much, much faster.<\/p>\n<p>This infographic by <strong>microsofttraining.net<\/strong> will show you some of these tricks you can use to <strong>speed up or skip mundane and repetitive tasks<\/strong>. For instance, to flash-fill cells with content in the right case (upper or lower) all you need to do is fill the first cell in the format that you want, and <span class=\"key\">Ctrl<\/span> + <span class=\"key\">E<\/span> to auto fill the rest of the column.<\/p>\n<div class=\"ref-block ref-block--post\" id=\"ref-post-1\">\n\t\t\t\t\t<a href=\"https:\/\/www.hongkiat.com\/blog\/microsoft-excel-artworks\/\" class=\"ref-block__link\" title=\"Read More: 30 Geeky Artworks Created Using Microsoft Excel\" rel=\"bookmark\"><span class=\"screen-reader-text\">30 Geeky Artworks Created Using Microsoft Excel<\/span><\/a>\n<div class=\"ref-block__thumbnail img-thumb img-thumb--jumbo\" data-img='{ \"src\" : \"https:\/\/assets.hongkiat.com\/uploads\/thumbs\/250x160\/microsoft-excel-artworks.jpg\" }'>\n\t\t\t\t\t\t\t<noscript>\n<style>.no-js #ref-block-post-13743 .ref-block__thumbnail { background-image: url(\"https:\/\/assets.hongkiat.com\/uploads\/thumbs\/250x160\/microsoft-excel-artworks.jpg\"); }<\/style>\n<\/noscript>\n\t\t\t\t\t\t<\/div>\n<div class=\"ref-block__summary\">\n<h4 class=\"ref-title\">30 Geeky Artworks Created Using Microsoft Excel<\/h4>\n<p class=\"ref-description\">\n\t\t\t\t\t\tMicrosoft Excel, my boss loves it, I hate it to bits. It's deadly effective as a tool to...\t\t\t\t\t\t<span>Read more<\/span><\/p>\n<\/div>\n<\/div>\n<p>There are a few other tips included, such as how to pivot tables, apply conditional formatting, retrieve data from complex data piles and more.<\/p>\n<p>Check out the infographic to find the how-to\u2019s you need.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg\" width=\"720\" height=\"6293\"><\/figure>\n<p>If you have your own Excel trick that you\u2019d like to share with us, tell us in the comments section.<\/p>","protected":false},"excerpt":{"rendered":"<p>For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us save time and in many jobs, it is a requirement to know how to work Excel before you even get the job. However, unknown to some, the program has plenty of&hellip;<\/p>\n","protected":false},"author":41,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3397],"tags":[1544,55,3701,978],"topic":[4521],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Awesome Excel Tricks to Impress Your Boss [Infographic] - Hongkiat<\/title>\n<meta name=\"description\" content=\"For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us\" \/>\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.hongkiat.com\/blog\/excel-tricks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Awesome Excel Tricks to Impress Your Boss [Infographic]\" \/>\n<meta property=\"og:description\" content=\"For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2016-01-15T13:01:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-21T06:48:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg\" \/>\n<meta name=\"author\" content=\"Singyin Lee\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Singyin Lee\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/\"},\"author\":{\"name\":\"Singyin Lee\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/8bb3e8d1cb49b3298ea203885023b811\"},\"headline\":\"Awesome Excel Tricks to Impress Your Boss [Infographic]\",\"datePublished\":\"2016-01-15T13:01:43+00:00\",\"dateModified\":\"2022-03-21T06:48:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/\"},\"wordCount\":203,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/excel-tricks\\\/excel-tricks.jpg\",\"keywords\":[\"Infographics\",\"Microsoft\",\"Microsoft Excel\",\"Productivity Tips\"],\"articleSection\":[\"Desktop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/\",\"name\":\"Awesome Excel Tricks to Impress Your Boss [Infographic] - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/excel-tricks\\\/excel-tricks.jpg\",\"datePublished\":\"2016-01-15T13:01:43+00:00\",\"dateModified\":\"2022-03-21T06:48:04+00:00\",\"description\":\"For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/excel-tricks\\\/excel-tricks.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/excel-tricks\\\/excel-tricks.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/excel-tricks\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Awesome Excel Tricks to Impress Your Boss [Infographic]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/8bb3e8d1cb49b3298ea203885023b811\",\"name\":\"Singyin Lee\",\"description\":\"Singyin is Senior Editor and Writer for Hongkiat. She is allergic to poor Wifi and spun articles, and has been told that she drinks too much coffee. Her sense of humor has been damaged by the Internet.\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/sy\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Awesome Excel Tricks to Impress Your Boss [Infographic] - Hongkiat","description":"For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us","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.hongkiat.com\/blog\/excel-tricks\/","og_locale":"en_US","og_type":"article","og_title":"Awesome Excel Tricks to Impress Your Boss [Infographic]","og_description":"For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us","og_url":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2016-01-15T13:01:43+00:00","article_modified_time":"2022-03-21T06:48:04+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg","type":"","width":"","height":""}],"author":"Singyin Lee","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Singyin Lee","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/"},"author":{"name":"Singyin Lee","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/8bb3e8d1cb49b3298ea203885023b811"},"headline":"Awesome Excel Tricks to Impress Your Boss [Infographic]","datePublished":"2016-01-15T13:01:43+00:00","dateModified":"2022-03-21T06:48:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/"},"wordCount":203,"commentCount":4,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg","keywords":["Infographics","Microsoft","Microsoft Excel","Productivity Tips"],"articleSection":["Desktop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/","url":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/","name":"Awesome Excel Tricks to Impress Your Boss [Infographic] - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg","datePublished":"2016-01-15T13:01:43+00:00","dateModified":"2022-03-21T06:48:04+00:00","description":"For many, Excel is the go-to program for charting graphs for labwork results or for data entry and accounting. Its formula-based auto-calculations help us","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/excel-tricks\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/excel-tricks\/excel-tricks.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/excel-tricks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Awesome Excel Tricks to Impress Your Boss [Infographic]"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/8bb3e8d1cb49b3298ea203885023b811","name":"Singyin Lee","description":"Singyin is Senior Editor and Writer for Hongkiat. She is allergic to poor Wifi and spun articles, and has been told that she drinks too much coffee. Her sense of humor has been damaged by the Internet.","url":"https:\/\/www.hongkiat.com\/blog\/author\/sy\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-6D5","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/25487","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=25487"}],"version-history":[{"count":3,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/25487\/revisions"}],"predecessor-version":[{"id":55691,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/25487\/revisions\/55691"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=25487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=25487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=25487"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=25487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}