{"id":134,"date":"2009-01-16T23:48:00","date_gmt":"2009-01-16T23:48:00","guid":{"rendered":""},"modified":"2018-12-11T12:33:50","modified_gmt":"2018-12-11T12:33:50","slug":"the-ultimate-excel-cheatsheet-at-your-fingertips","status":"publish","type":"post","link":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html","title":{"rendered":"The Ultimate Excel Cheatsheet At Your Fingertips"},"content":{"rendered":"<p>Excel has got to be one of the most complex software applications on the market.From keyboard shortcuts to functions and code snippets, the right Excel tricks are difficult to master, let alone find.<\/p>\n<p>If you\u2019ve ever had troubles getting around Excel or finding that perfect calculation tip, check out our latest article, <a href=\"https:\/\/www.investintech.com\/resources\/articles\/excelcheatsheet\/\">The Ultimate Excel Cheatsheet<\/a>.<\/p>\n<p>It\u2019s exactly what it says it is. You\u2019ll find a number of printable PDF cheatsheets and links that reference keyboard shortcuts, functions, command line switches, formulas and VBA code snippets.<\/p>\n<p>Just simply print, save or click and you\u2019ll be able to perform some of the most complex Excel functions around.<\/p>\n<p>Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel has got to be one of the most complex software applications on the market.From keyboard shortcuts to functions and code snippets, the right Excel tricks are difficult to master, let alone find. If you\u2019ve ever had troubles getting around Excel or finding that perfect calculation tip, check out our latest article, The Ultimate Excel &#8230; <a title=\"The Ultimate Excel Cheatsheet At Your Fingertips\" class=\"read-more\" href=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\" aria-label=\"More on The Ultimate Excel Cheatsheet At Your Fingertips\">Continue reading \u2192<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[137,230,231,232,228,229,136,45,85,204],"class_list":["post-134","post","type-post","status-publish","format-standard","hentry","category-3-diversions","tag-accounting","tag-banking","tag-cheatsheet","tag-data-analysis","tag-excel-formula","tag-excel-function","tag-finance","tag-ms-excel","tag-pdf-to-excel","tag-reference"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Ultimate Excel Cheatsheet At Your Fingertips<\/title>\n<meta name=\"description\" content=\"Can\u2019t remember a specific MS Excel formula or function? Our Microsoft Excel cheatsheets have them all. Download and print them up for easy reference.\" \/>\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.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Ultimate Excel Cheatsheet At Your Fingertips\" \/>\n<meta property=\"og:description\" content=\"Can\u2019t remember a specific MS Excel formula or function? Our Microsoft Excel cheatsheets have them all. Download and print them up for easy reference.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\" \/>\n<meta property=\"og:site_name\" content=\"PDF Blog | Investintech PDF Solutions\" \/>\n<meta property=\"article:published_time\" content=\"2009-01-16T23:48:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-12-11T12:33:50+00:00\" \/>\n<meta name=\"author\" content=\"Reena\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@able2extract\" \/>\n<meta name=\"twitter:site\" content=\"@able2extract\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\"},\"author\":{\"name\":\"Reena\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409\"},\"headline\":\"The Ultimate Excel Cheatsheet At Your Fingertips\",\"datePublished\":\"2009-01-16T23:48:00+00:00\",\"dateModified\":\"2018-12-11T12:33:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\"},\"wordCount\":119,\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"keywords\":[\"accounting\",\"banking\",\"cheatsheet\",\"data analysis\",\"Excel formula\",\"Excel function\",\"finance\",\"MS Excel\",\"PDF to Excel\",\"reference\"],\"articleSection\":[\"Diversions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\",\"name\":\"The Ultimate Excel Cheatsheet At Your Fingertips\",\"isPartOf\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\"},\"datePublished\":\"2009-01-16T23:48:00+00:00\",\"dateModified\":\"2018-12-11T12:33:50+00:00\",\"description\":\"Can\u2019t remember a specific MS Excel formula or function? Our Microsoft Excel cheatsheets have them all. Download and print them up for easy reference.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.investintech.com\/resources\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Ultimate Excel Cheatsheet At Your Fingertips\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#website\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"description\":\"Everything PDF\",\"publisher\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#organization\",\"name\":\"PDF Blog | Investintech PDF Solutions\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"contentUrl\":\"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp\",\"width\":270,\"height\":40,\"caption\":\"PDF Blog | Investintech PDF Solutions\"},\"image\":{\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/able2extract\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409\",\"name\":\"Reena\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g\",\"caption\":\"Reena\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Ultimate Excel Cheatsheet At Your Fingertips","description":"Can\u2019t remember a specific MS Excel formula or function? Our Microsoft Excel cheatsheets have them all. Download and print them up for easy reference.","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.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html","og_locale":"en_US","og_type":"article","og_title":"The Ultimate Excel Cheatsheet At Your Fingertips","og_description":"Can\u2019t remember a specific MS Excel formula or function? Our Microsoft Excel cheatsheets have them all. Download and print them up for easy reference.","og_url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html","og_site_name":"PDF Blog | Investintech PDF Solutions","article_published_time":"2009-01-16T23:48:00+00:00","article_modified_time":"2018-12-11T12:33:50+00:00","author":"Reena","twitter_card":"summary_large_image","twitter_creator":"@able2extract","twitter_site":"@able2extract","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html#article","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html"},"author":{"name":"Reena","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409"},"headline":"The Ultimate Excel Cheatsheet At Your Fingertips","datePublished":"2009-01-16T23:48:00+00:00","dateModified":"2018-12-11T12:33:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html"},"wordCount":119,"publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"keywords":["accounting","banking","cheatsheet","data analysis","Excel formula","Excel function","finance","MS Excel","PDF to Excel","reference"],"articleSection":["Diversions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html","url":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html","name":"The Ultimate Excel Cheatsheet At Your Fingertips","isPartOf":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#website"},"datePublished":"2009-01-16T23:48:00+00:00","dateModified":"2018-12-11T12:33:50+00:00","description":"Can\u2019t remember a specific MS Excel formula or function? Our Microsoft Excel cheatsheets have them all. Download and print them up for easy reference.","breadcrumb":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.investintech.com\/resources\/blog\/archives\/134-the-ultimate-excel-cheatsheet-at-your-fingertips.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.investintech.com\/resources\/blog\/"},{"@type":"ListItem","position":2,"name":"The Ultimate Excel Cheatsheet At Your Fingertips"}]},{"@type":"WebSite","@id":"https:\/\/www.investintech.com\/resources\/blog\/#website","url":"https:\/\/www.investintech.com\/resources\/blog\/","name":"PDF Blog | Investintech PDF Solutions","description":"Everything PDF","publisher":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.investintech.com\/resources\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.investintech.com\/resources\/blog\/#organization","name":"PDF Blog | Investintech PDF Solutions","url":"https:\/\/www.investintech.com\/resources\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","contentUrl":"https:\/\/www.investintech.com\/resources\/blog\/wp-content\/uploads\/2024\/12\/Investintech-apryse-logo-w270.webp","width":270,"height":40,"caption":"PDF Blog | Investintech PDF Solutions"},"image":{"@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/able2extract"]},{"@type":"Person","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/9d21ba7980d32dbd36069a4878f8e409","name":"Reena","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.investintech.com\/resources\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/aceff76f1b124f7ffb271de50b78f12a7599655c7087ea3a656b61cf9a89c376?s=96&d=mm&r=g","caption":"Reena"}}]}},"_links":{"self":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/comments?post=134"}],"version-history":[{"count":2,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/134\/revisions"}],"predecessor-version":[{"id":8769,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/posts\/134\/revisions\/8769"}],"wp:attachment":[{"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/media?parent=134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/categories?post=134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investintech.com\/resources\/blog\/wp-json\/wp\/v2\/tags?post=134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}