{"id":7762,"date":"2018-03-21T19:30:44","date_gmt":"2018-03-21T14:00:44","guid":{"rendered":"http:\/\/ivyproschool.com\/blog\/?p=7762"},"modified":"2021-06-25T16:47:13","modified_gmt":"2021-06-25T11:17:13","slug":"advanced-excel-cheat-sheet-part-1","status":"publish","type":"post","link":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/","title":{"rendered":"Advanced Excel Cheat Sheet &#8211; Part 1"},"content":{"rendered":"<p>&nbsp;<br \/>\n<a href=\"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/\"><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7763\" src=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/top-20mobileapps.png\" alt=\"\" width=\"560\" height=\"315\" srcset=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/top-20mobileapps.png 560w, https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/top-20mobileapps-300x169.png 300w\" sizes=\"auto, (max-width: 560px) 100vw, 560px\" \/><br \/>\n<\/a><br \/>\nMS EXCEL, the most wanted skill set in the industry irrespective of your academic background. With an easy User Interface, this tool is popular across every segment of the business. It allows a wide array of activities ranging from bringing data together to extracting information from it using a variety of functions at your disposal to visualising the extracted information and deriving the best possible outlook.<\/p>\n<p>So is it that you know Excel well?<\/p>\n<p>With this Excel Series to come we make sure that you not only gain an insight into its properties but also gain in-depth knowledge about them.<\/p>\n<p><strong>DATABASE FUNCTION<\/strong><\/p>\n<p>You are well aware of functions like SUMIFS, COUNTIFS, AVERAGEIFS etc that help compute when your problem involves numerous AND conditions. Have you ever thought what if we have combinations of both AND and OR conditions?<\/p>\n<p>Well, DATABASE FUNCTIONS come to your rescue at exactly this point. It has the added advantage of letting you compute and get specific information when you face multiple AND and OR conditions.<\/p>\n<p><strong>TYPES <\/strong><\/p>\n<table width=\"0\">\n<tbody>\n<tr>\n<td width=\"82\"><strong><em>DSUM <\/em><\/strong><\/td>\n<td width=\"532\">Allows you to add data based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DAVERAGE<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to average data based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DMAX<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to find max based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DMIN<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to find min based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DCOUNT<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to count numeric values based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DCOUNTA<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to count non-blank values based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DGET<\/em><\/strong><\/td>\n<td width=\"532\">Used to <strong>return a single field of data <\/strong>from a column of a database that matches conditions you specify<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DSTDEV<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to find std. deviation based on set criteria<\/td>\n<\/tr>\n<tr>\n<td width=\"82\"><strong><em>DVAR<\/em><\/strong><\/td>\n<td width=\"532\">Allows you to find variance based on set criteria<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>Each Database function has the same 3 arguments:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7764 size-full\" src=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel-c1.png\" alt=\"\" width=\"578\" height=\"326\" srcset=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel-c1.png 578w, https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel-c1-300x169.png 300w\" sizes=\"auto, (max-width: 578px) 100vw, 578px\" \/><\/p>\n<p>Find an example below of how to work with these functions:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7765 size-full\" src=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel2.png\" alt=\"\" width=\"599\" height=\"211\" srcset=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel2.png 599w, https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel2-300x106.png 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>A<\/strong><strong>dvanced Filtering<\/strong><\/p>\n<p>Well, keeping in tune with conditions based setups, an important feature that Excel provides is Filtering whereby we can extract rows of information based on some criteria. The only drawback is that this allows filtering stepwise such that at each step of filtering lesser data is available. Advanced Filtering is a step ahead by allowing its users to apply multiple filtering criteria at once.<\/p>\n<p>All you need to mention are these 3 options:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7766\" src=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel3.png\" alt=\"\" width=\"579\" height=\"324\" srcset=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel3.png 579w, https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/excel3-300x168.png 300w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Let\u2019s have a look at an example:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7767\" src=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg\" alt=\"\" width=\"601\" height=\"339\" srcset=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg 601w, https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet-300x169.jpg 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/><\/p>\n<p>Advanced filtering not only provides you with the option to copy-paste your output to some other location and also has the option whereby you can extract Unique Records only without requiring removing duplicates separately!<\/p>\n<p><a href=\"http:\/\/ivyproschool.com\/\">Ivy Pro School<\/a> is the best Data Science Training institute since 2007 with campuses in Bangalore, New Delhi, Pune and Kolkata. Ivy&#8217;s flagship program &#8211;<a href=\"https:\/\/ivyproschool.com\/our-courses\/big-data-and-analytics\/data-science-machine-learning-artificial-intelligence-deep-learning-certification-course\/\" rel=\"noopener noreferrer\" target=\"_blank\"> Data Science<\/a> and <a href=\"https:\/\/ivyproschool.com\/our-courses\/big-data-and-analytics\/machine-learning-python-certification\/\" rel=\"noopener noreferrer\" target=\"_blank\">Machine Learning <\/a>Certification has created a benchmark in the Analytics Training Industry. Call\/Whatsapp us at 9748441111 for more details.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; MS EXCEL, the most wanted skill set in the industry irrespective of your academic background. With an easy User Interface, this tool is popular across every segment of the business. It allows a wide array of activities ranging from bringing data together to extracting information from it using a variety of functions at your disposal to visualising the extracted information and deriving the best possible outlook. So is it that you know Excel well? With this Excel Series to come we make sure that you not only gain an insight into its properties but also gain in-depth knowledge about them. DATABASE FUNCTION You are well aware of functions like SUMIFS, COUNTIFS, AVERAGEIFS etc that help compute when your problem involves numerous AND conditions. Have you ever thought what if we have combinations of both AND and OR conditions? Well, DATABASE FUNCTIONS come to your rescue at exactly this point. It has the added advantage of letting you compute and get specific information when you face multiple AND and OR conditions. TYPES DSUM Allows you to add data based on set criteria DAVERAGE Allows you to average data based on set criteria DMAX Allows you to find max based on [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":7767,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[851,5,881,715],"tags":[893,56,76,230,467,504],"class_list":["post-7762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-analytics","category-data-analytics","category-data-science","category-machine-learning-ai","tag-advanced-excel","tag-big-data-analytics","tag-business-analytics","tag-data-analytics","tag-data-science","tag-machine-learning"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Advanced Excel Cheat Sheet - 1 | Official Blog | Ivy Pro School<\/title>\n<meta name=\"description\" content=\"In this article, we will discuss about the advanced Excel Cheat Sheet - 1. Learn and Grow with Ivy Pro School. Read more to know.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Excel Cheat Sheet - 1 | Official Blog | Ivy Pro School\" \/>\n<meta property=\"og:description\" content=\"In this article, we will discuss about the advanced Excel Cheat Sheet - 1. Learn and Grow with Ivy Pro School. Read more to know.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"R vs Python: Which Analytics Tool Should You Choose for Data Science?\" \/>\n<meta property=\"article:author\" content=\"https:\/\/facebook.com\/ivyproschool\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-21T14:00:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-25T11:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"601\" \/>\n\t<meta property=\"og:image:height\" content=\"339\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ivy Professional School\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ivyproschool\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ivy Professional School\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/\"},\"author\":{\"name\":\"Ivy Professional School\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/#\\\/schema\\\/person\\\/31fdab8559dd3db99173764bfb60215d\"},\"headline\":\"Advanced Excel Cheat Sheet &#8211; Part 1\",\"datePublished\":\"2018-03-21T14:00:44+00:00\",\"dateModified\":\"2021-06-25T11:17:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/\"},\"wordCount\":469,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/08\\\/Excel-Cheat-Sheet.jpg\",\"keywords\":[\"Advanced Excel\",\"Big Data analytics\",\"business analytics\",\"data analytics\",\"data science\",\"machine learning\"],\"articleSection\":[\"Business Analytics\",\"Data Analytics\",\"Data Science\",\"Machine Learning &amp; AI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/\",\"url\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/\",\"name\":\"Advanced Excel Cheat Sheet - 1 | Official Blog | Ivy Pro School\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/08\\\/Excel-Cheat-Sheet.jpg\",\"datePublished\":\"2018-03-21T14:00:44+00:00\",\"dateModified\":\"2021-06-25T11:17:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/#\\\/schema\\\/person\\\/31fdab8559dd3db99173764bfb60215d\"},\"description\":\"In this article, we will discuss about the advanced Excel Cheat Sheet - 1. Learn and Grow with Ivy Pro School. Read more to know.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/08\\\/Excel-Cheat-Sheet.jpg\",\"contentUrl\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/08\\\/Excel-Cheat-Sheet.jpg\",\"width\":601,\"height\":339,\"caption\":\"Advanced Excel 1 - Ivy Pro School\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/advanced-excel-cheat-sheet-part-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Excel Cheat Sheet &#8211; Part 1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/\",\"name\":\"Ivy Professional School | Official Blog\",\"description\":\"Confused between R and Python for your data science journey? Discover the key differences in data visualization, handling capabilities, speed, and ease of learning.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/#\\\/schema\\\/person\\\/31fdab8559dd3db99173764bfb60215d\",\"name\":\"Ivy Professional School\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/866b09293f13d461b399bb9a40607e85623ede13d844f763bf665689cb0d1452?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/866b09293f13d461b399bb9a40607e85623ede13d844f763bf665689cb0d1452?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/866b09293f13d461b399bb9a40607e85623ede13d844f763bf665689cb0d1452?s=96&d=mm&r=g\",\"caption\":\"Ivy Professional School\"},\"sameAs\":[\"http:\\\/\\\/www.ivyproschool.com\",\"https:\\\/\\\/facebook.com\\\/ivyproschool\",\"https:\\\/\\\/instagram.com\\\/ivyproschool\",\"https:\\\/\\\/x.com\\\/ivyproschool\",\"https:\\\/\\\/youtube.com\\\/ivyproschool\"],\"url\":\"https:\\\/\\\/ivyproschool.com\\\/blog\\\/author\\\/prateek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Excel Cheat Sheet - 1 | Official Blog | Ivy Pro School","description":"In this article, we will discuss about the advanced Excel Cheat Sheet - 1. Learn and Grow with Ivy Pro School. Read more to know.","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:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Excel Cheat Sheet - 1 | Official Blog | Ivy Pro School","og_description":"In this article, we will discuss about the advanced Excel Cheat Sheet - 1. Learn and Grow with Ivy Pro School. Read more to know.","og_url":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/","og_site_name":"R vs Python: Which Analytics Tool Should You Choose for Data Science?","article_author":"https:\/\/facebook.com\/ivyproschool","article_published_time":"2018-03-21T14:00:44+00:00","article_modified_time":"2021-06-25T11:17:13+00:00","og_image":[{"width":601,"height":339,"url":"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg","type":"image\/jpeg"}],"author":"Ivy Professional School","twitter_card":"summary_large_image","twitter_creator":"@ivyproschool","twitter_misc":{"Written by":"Ivy Professional School","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#article","isPartOf":{"@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/"},"author":{"name":"Ivy Professional School","@id":"https:\/\/ivyproschool.com\/blog\/#\/schema\/person\/31fdab8559dd3db99173764bfb60215d"},"headline":"Advanced Excel Cheat Sheet &#8211; Part 1","datePublished":"2018-03-21T14:00:44+00:00","dateModified":"2021-06-25T11:17:13+00:00","mainEntityOfPage":{"@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/"},"wordCount":469,"commentCount":0,"image":{"@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg","keywords":["Advanced Excel","Big Data analytics","business analytics","data analytics","data science","machine learning"],"articleSection":["Business Analytics","Data Analytics","Data Science","Machine Learning &amp; AI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/","url":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/","name":"Advanced Excel Cheat Sheet - 1 | Official Blog | Ivy Pro School","isPartOf":{"@id":"https:\/\/ivyproschool.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#primaryimage"},"image":{"@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg","datePublished":"2018-03-21T14:00:44+00:00","dateModified":"2021-06-25T11:17:13+00:00","author":{"@id":"https:\/\/ivyproschool.com\/blog\/#\/schema\/person\/31fdab8559dd3db99173764bfb60215d"},"description":"In this article, we will discuss about the advanced Excel Cheat Sheet - 1. Learn and Grow with Ivy Pro School. Read more to know.","breadcrumb":{"@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#primaryimage","url":"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg","contentUrl":"https:\/\/ivyproschool.com\/blog\/wp-content\/uploads\/2015\/08\/Excel-Cheat-Sheet.jpg","width":601,"height":339,"caption":"Advanced Excel 1 - Ivy Pro School"},{"@type":"BreadcrumbList","@id":"https:\/\/ivyproschool.com\/blog\/advanced-excel-cheat-sheet-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ivyproschool.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Advanced Excel Cheat Sheet &#8211; Part 1"}]},{"@type":"WebSite","@id":"https:\/\/ivyproschool.com\/blog\/#website","url":"https:\/\/ivyproschool.com\/blog\/","name":"Ivy Professional School | Official Blog","description":"Confused between R and Python for your data science journey? Discover the key differences in data visualization, handling capabilities, speed, and ease of learning.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ivyproschool.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ivyproschool.com\/blog\/#\/schema\/person\/31fdab8559dd3db99173764bfb60215d","name":"Ivy Professional School","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/866b09293f13d461b399bb9a40607e85623ede13d844f763bf665689cb0d1452?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/866b09293f13d461b399bb9a40607e85623ede13d844f763bf665689cb0d1452?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/866b09293f13d461b399bb9a40607e85623ede13d844f763bf665689cb0d1452?s=96&d=mm&r=g","caption":"Ivy Professional School"},"sameAs":["http:\/\/www.ivyproschool.com","https:\/\/facebook.com\/ivyproschool","https:\/\/instagram.com\/ivyproschool","https:\/\/x.com\/ivyproschool","https:\/\/youtube.com\/ivyproschool"],"url":"https:\/\/ivyproschool.com\/blog\/author\/prateek\/"}]}},"_links":{"self":[{"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/posts\/7762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/comments?post=7762"}],"version-history":[{"count":2,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/posts\/7762\/revisions"}],"predecessor-version":[{"id":10760,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/posts\/7762\/revisions\/10760"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/media\/7767"}],"wp:attachment":[{"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/media?parent=7762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/categories?post=7762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ivyproschool.com\/blog\/wp-json\/wp\/v2\/tags?post=7762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}