{"id":2509,"date":"2019-08-19T05:54:23","date_gmt":"2019-08-19T05:54:23","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=2509"},"modified":"2021-07-17T05:01:17","modified_gmt":"2021-07-17T05:01:17","slug":"excel-2019-functions-charts","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts","title":{"rendered":"Excel 2019 New Functions &#038; Charts You Must Learn!"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong>Microsoft Office 2019<\/strong> is just released, and among its applications, <strong>Excel 2019<\/strong> is the one having a wide collection of latest and developed features, and skills.<\/p>\n<p style=\"text-align: justify;\">Well, plenty of the improvements are within the features like <strong>Power Pivot and Get &amp; Transform. <\/strong>Despite this, many <strong>new functions and chart types<\/strong> are also available in Excel 2019 to make the work easier for the average users and <a href=\"https:\/\/www.repairmsexcel.com\/blog\/30-tips-to-master-ms-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>master Microsoft Excel<\/strong><\/a>.<\/p>\n<p style=\"text-align: justify;\">In this article, I am going to outlines some of the improved and latest Excel 2019 functions and chart types describe how to use them.<\/p>\n<p><!--more--><\/p>\n<p style=\"text-align: justify;\">So, without wasting time, let\u2019s dig out the <strong>latest Excel 2019 functions<\/strong> and use them like a Pro.<\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"color: #339966; text-decoration: underline;\"><strong>List of Excel 2019 Functions:<\/strong><\/span><\/span><\/h2>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline; color: #000000;\"><strong>Excel 2019 Text Functions<\/strong><\/span><\/h3>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">\u00a01: CONCAT<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This new Excel 2019 function is like <strong>CONCATENATE <\/strong>but better than that. This is <strong>shorter and also easy<\/strong> to type. It also supports range positions, to cell references.<\/p>\n<p>For Example:<\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 61px;\" width=\"337\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<th class=\"spreadsheet\">C<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet\">C:\\<\/td>\n<td class=\"spreadsheet\">Users\\<\/td>\n<td class=\"spreadsheet\">Teff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">By using the <strong>Concat function<\/strong> <strong>text strings<\/strong> in cells <strong>A1, B1 and C1 <\/strong>are joined together.<\/p>\n<p style=\"text-align: justify;\"><strong>=CONCAT(A1:C1 )<\/strong><\/p>\n<p style=\"text-align: justify;\">which gives the resulting text string <strong>C:\\Users\\Teff<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">2: TEXTJOIN<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This Excel 2019 function join multiple text ranges and each and every item is divided by a delimiter specified by you.<\/p>\n<p style=\"text-align: justify;\"><strong>For example:<\/strong><\/p>\n<table style=\"height: 127px;\" width=\"244\">\n<tbody>\n<tr>\n<td><strong>\u00a0<\/strong><\/td>\n<td><strong>A<\/strong><\/td>\n<td><strong>B<\/strong><\/td>\n<td><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>1<\/strong><\/td>\n<td>C:<\/td>\n<td>Workers<\/td>\n<td>Reff<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Using the Textjoin function, the text strings given in the above example are combined and separated by the delimiter \u201c\\\u201d.<\/p>\n<p style=\"text-align: justify;\"><strong>=TEXTJOIN( &#8220;\\&#8221;, TRUE, A1:C1 )<\/strong><\/p>\n<p style=\"text-align: justify;\">And the result is <strong><em>C:\\Workers\\Reff<\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline; color: #000000;\"><strong>Excel 2019 Statistical Functions<\/strong><\/span><\/h3>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">3: MAXIFS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">The <strong>MAXIFS <\/strong>function in the list gives the largest number from a range of number as per the given single or multiple criteria.<\/p>\n<p style=\"text-align: justify;\"><strong>Let describe it best with the given example:<\/strong><\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 297px;\" width=\"270\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<th class=\"spreadsheet\">C<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet\"><b>Students<\/b><\/td>\n<td class=\"spreadsheet\"><b>Set 1<\/b><\/td>\n<td class=\"spreadsheet\"><b>Score<\/b><\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">2<\/th>\n<td class=\"spreadsheet\">Tina<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">58%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">3<\/th>\n<td class=\"spreadsheet\">Alex<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">87%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">4<\/th>\n<td class=\"spreadsheet\">Henry<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">74%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">5<\/th>\n<td class=\"spreadsheet\">John<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">41%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">6<\/th>\n<td class=\"spreadsheet\">Johnson<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">79%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">7<\/th>\n<td class=\"spreadsheet\">Emmy<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">66%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">8<\/th>\n<td class=\"spreadsheet\">Jacob<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">90%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">9<\/th>\n<td class=\"spreadsheet\">George<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">73%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Using the Maxifs function, the maximum game scored in Set 1 is easily found.<\/p>\n<p style=\"text-align: justify;\"><strong>=MAXIFS (C2:C9, B2:B9, 1)<\/strong><strong>\u00a0<\/strong><\/p>\n<p style=\"text-align: justify;\">And the result is<strong> 79 %<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">4: MINIFS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This MINIFs function is similar to <strong>MAXIFs<\/strong>, but this is used to returns the smallest range number, as per one or more criteria.<\/p>\n<p style=\"text-align: justify;\"><strong>Describe it with the example: <\/strong><\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 297px;\" width=\"270\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<th class=\"spreadsheet\">C<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet\"><b>Students<\/b><\/td>\n<td class=\"spreadsheet\"><b>Set 1<\/b><\/td>\n<td class=\"spreadsheet\"><b>Score<\/b><\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">2<\/th>\n<td class=\"spreadsheet\">Tina<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">58%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">3<\/th>\n<td class=\"spreadsheet\">Alex<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">87%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">4<\/th>\n<td class=\"spreadsheet\">Henry<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">74%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">5<\/th>\n<td class=\"spreadsheet\">John<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">41%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">6<\/th>\n<td class=\"spreadsheet\">Johnson<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">79%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">7<\/th>\n<td class=\"spreadsheet\">Emmy<\/td>\n<td class=\"spreadsheet-num\">1<\/td>\n<td class=\"spreadsheet-num\">66%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">8<\/th>\n<td class=\"spreadsheet\">Jacob<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">90%<\/td>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">9<\/th>\n<td class=\"spreadsheet\">George<\/td>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet-num\">73%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">You can check the minimum game score recorded in set 2 by using the Minifs function<\/p>\n<p style=\"text-align: justify;\"><strong>=MINIFS( C2:C9, B2:B9, 2 )<\/strong><\/p>\n<p style=\"text-align: justify;\">You can see the result in <strong>73%<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"text-decoration: underline; color: #000000;\"><strong>Excel 2019 Logical Functions<\/strong><\/span><\/h3>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">5: IFS<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This is the newer version of the IF function. The <strong>IFS function<\/strong> allows the users to test the conditions in the specified order and returns result matching to the first condition that estimates to <strong>TRUE.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Let describe it best with the example<\/strong><\/p>\n<table style=\"height: 50px;\" width=\"262\">\n<tbody>\n<tr>\n<td><strong>\u00a0<\/strong><\/td>\n<td><strong>A<\/strong><\/td>\n<td><strong>B<\/strong><\/td>\n<td><strong>C<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>1<\/strong><\/td>\n<td>40<\/td>\n<td>0<\/td>\n<td>2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">The IFS function could be utilized for dividing the value in <strong>cell A1<\/strong> by the first <strong>non-zero value<\/strong> in cells <strong>B1-C1: =IFS (B1&lt;&gt;0, A1\/B1, C1&lt;&gt;0, A1\/C1)<\/strong><\/p>\n<p style=\"text-align: justify;\">This will give the result <strong>20.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">6: SWITCH<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This latest Excel 2019 function compares the number against the supplied values and returns the first matching result. And if no result matches, then \u201c<strong>else<\/strong>\u201d is returned<\/p>\n<p><strong>Let describe it best with the example:<\/strong><\/p>\n<table class=\"spreadsheet-centered\" style=\"height: 60px;\" width=\"267\">\n<tbody>\n<tr>\n<th class=\"spreadsheet-margin\"><\/th>\n<th class=\"spreadsheet\">A<\/th>\n<th class=\"spreadsheet\">B<\/th>\n<\/tr>\n<tr>\n<th class=\"spreadsheet\">1<\/th>\n<td class=\"spreadsheet-num\">2<\/td>\n<td class=\"spreadsheet\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Here the switch function is used for returning a fruit related to the number in cell A1<\/p>\n<p><strong>=SWITCH( A1, 1, &#8220;Apple&#8221;, 2, &#8220;Grapes&#8221;, 3, &#8220;Mango&#8221;, 4, &#8220;Strawberry &#8221; )<\/strong><\/p>\n<p>And the result in <strong>\u201cMango\u201d<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><span style=\"text-decoration: underline; color: #339966;\">Excel 2019 New Charts to Visual Display Data<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Just like the functions Excel 2019 had bought new charts also. So, learn <strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/use-dynamic-data-labels-create-interactive-excel-charts\" target=\"_blank\" rel=\"noopener noreferrer\">how to create interactive Excel charts <\/a><\/strong>and\u00a0present the data in a fresh way.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">1: Sunburst:<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2515\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-sunubrst-chart.jpg\" alt=\"Excel 2019 charts\" width=\"452\" height=\"340\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-sunubrst-chart.jpg 535w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-sunubrst-chart-300x225.jpg 300w\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" \/><\/p>\n<p style=\"text-align: justify;\">The Sunburst chart is a multi-level chart and displays hierarchical data. In this chart, the inner circle comprises top-level categories and the out circle shows subcategories and after that, the circle are so on.<\/p>\n<p style=\"text-align: justify;\">These charts are best to display the relationships among the main categories and subcategories.<\/p>\n<p style=\"text-align: justify;\"><strong>Here know how to create a Sunburst chart:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>On the spreadsheet assure the data is arranged in the hierarchical method.<\/li>\n<li>Then choose the all data range, with all labels levels.<\/li>\n<li>Next click <strong>Insert <\/strong>then<strong> Hierarchy Chart <\/strong>and next<\/li>\n<li>Now format the chart as you want<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">2: Treemap<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2517\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-treemap-chart.jpg\" alt=\"latest Excel 2019 charts\" width=\"437\" height=\"267\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-treemap-chart.jpg 535w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-treemap-chart-300x183.jpg 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/p>\n<p style=\"text-align: justify;\">The treemap chart generates hierarchical data view with the top categories <strong>(tree branches) <\/strong>display as rectangles including subcategories, presented as small rectangles grouped in the large ones.<\/p>\n<p style=\"text-align: justify;\">Therefore, it allows users to easily compare top-level categories and subcategories sizes at first glance.<\/p>\n<p style=\"text-align: justify;\"><strong>Steps to create a treemap chart:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Just like the sunburst, assure the data is arranged in a hierarchical manner on the spreadsheet<\/li>\n<li>Choose the complete data range, with entire levels of labels that you need to comprise.<\/li>\n<li>Next click Insert then <strong>Hierarchy Chart<\/strong> and<\/li>\n<li>And format chart as per your desire.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">3: Waterfall Charts<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2518\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-waterfall-chart.jpg\" alt=\"what's new in Excel 2019\" width=\"486\" height=\"309\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-waterfall-chart.jpg 535w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-waterfall-chart-300x191.jpg 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/p>\n<p style=\"text-align: justify;\">In Excel 2019, the waterfall chart is added to the demand of the users. Well, in earlier Excel version making this type of chart is really time taking and requires a workaround.<\/p>\n<p style=\"text-align: justify;\">But in Excel 2019, the waterfall is presented as a chart type and can be created easily in few clicks. This chart is best for presenting the growing result of higher and lower values.<\/p>\n<p style=\"text-align: justify;\"><strong>So here follow the steps to create the waterfall chart:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>To make it assure your data is arranged in the order as it should appear in the chart. So if required reorder it first<\/li>\n<li>Now choose the data to present in the chart, with the data labels.<\/li>\n<li>Click Insert then <strong>Insert Waterfall<\/strong>, <strong>Stock, Funnel, Surface, or Radar Chart<\/strong>.<\/li>\n<li>Then click Waterfall.<\/li>\n<li>And format the chart as you need it.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">4: Box and Whisker Charts<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2516\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-box-whisker-chart.jpg\" alt=\"Excel 2019 latest charts\" width=\"454\" height=\"295\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-box-whisker-chart.jpg 535w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-box-whisker-chart-300x195.jpg 300w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/p>\n<p style=\"text-align: justify;\">The <strong>box and whisker chart is like a histogram, presents <\/strong>frequencies in the data set. But is used for deep analysis than a histogram.<\/p>\n<p style=\"text-align: justify;\"><strong>Note:<\/strong> A quartile is one-quarter of a data points<\/p>\n<p style=\"text-align: justify;\">This pr\u00e9cises the data by breaking it into the quartiles. And the mid two quartiles (2 &amp; 3) are signified by a<strong> box<\/strong> and the above and lower quartiles (1 &amp; 4) are signified by <strong>Vertical lines<\/strong> named <strong>whiskers <\/strong>which is projected from the upper and bottom of the box.<\/p>\n<p style=\"text-align: justify;\"><strong>Now follow the steps to<\/strong><strong> create a box and whisker chart:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>In the spreadsheet organize the data sets in columns with a single column for each data set.<\/li>\n<li>Than place text labels showing the data sets above the data.<\/li>\n<li>And choose the <strong>data sets &amp; column labels.<\/strong><\/li>\n<li>Click <strong>Insert<\/strong> and <strong>Insert Statistic Chart<\/strong> then <strong>Box and Whisker.<\/strong><\/li>\n<li>And lastly, format the chart<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">And in this way, the Excel 2019 box and whisker chart is created easily.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">5: Filled Map Charts<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2519\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-filled-map.jpg\" alt=\"Excel 2019 charts\" width=\"535\" height=\"256\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-filled-map.jpg 535w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-filled-map-300x144.jpg 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p style=\"text-align: justify;\">In earlier Excel version, create a map with numeric data is very tough a time taking. Therefore Excel 2019 had made it easier for the users with the <strong>Filled map chart <\/strong>type.<\/p>\n<p style=\"text-align: justify;\">This is used to distinguish <strong>countries, states\/provinces, and postal codes<\/strong> in data labels, and shows the suitable map and suitable areas by placing the value on the map.<\/p>\n<p style=\"text-align: justify;\"><strong>Steps to create a filled map:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>On the spreadsheet place some data suing country or state names for data labels.<\/li>\n<li>Next, choose the <strong>data and labels<\/strong> &gt; click Insert and <strong>Maps<\/strong> then <strong>Filled Map.<\/strong><\/li>\n<li>Wait for the map to load<\/li>\n<li>Then format and resize it as per your requirement.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">6: Funnel Chart<\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2520\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-funnel-chart.jpg\" alt=\"Excel 2019 new features\" width=\"507\" height=\"304\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-funnel-chart.jpg 535w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-funnel-chart-300x180.jpg 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/><\/p>\n<p style=\"text-align: justify;\">This is the last latest Excel 2019 chart named <strong>funnel chart<\/strong>. The funnel chart displays every data point as a <strong>horizontal bar, <\/strong>with the long bars for higher values.<\/p>\n<p style=\"text-align: justify;\">All the <strong>bars <\/strong>are centered and arranged vertically. And if you sort data from higher to lowest, the overall result looks like a funnel.<\/p>\n<p style=\"text-align: justify;\"><strong>Follow the steps to create a funnel chart:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>First, type the <strong>labels and data <\/strong>&gt; then<strong> arrange them in the order you desire than to appear in the chart from upper to lower<\/strong><\/li>\n<li>Next, choose the <strong>labels and data<\/strong> &gt; click <strong>Insert <\/strong>&gt; <strong>Waterfall, Funnel, Stock, Surface, or Radar Chart<\/strong> &gt;<strong>Funnel.<\/strong><\/li>\n<li>And design the chart as per your desire.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">So, this is it, in this way you can create the funnel chart in Excel 2019.<\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">Conclusion:<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>Excel 2019<\/strong> is undoubtedly highly advanced and had lots of improvements in it. <strong>Various functions, formulas, charts, etc.<\/strong> are implemented in it to make the work easier for Excel users.<\/p>\n<p style=\"text-align: justify;\">But, with the latest improvements, it is equally important to know how to use them.<\/p>\n<p style=\"text-align: justify;\">So, in this article, I had listed the latest <strong>Excel 2019 functions<\/strong> and<strong> charts<\/strong> with ways to create it easily.<\/p>\n<p style=\"text-align: justify;\">Read the blog carefully to know about the <strong>Excel 2019 functions<\/strong> to simplify your calculation and formula editing experience.<\/p>\n<p style=\"text-align: justify;\">Also, know the 6 six <strong>new chart types to visualize<\/strong> and present the data and gain your audience insight.<\/p>\n<p style=\"text-align: justify;\">Despite this, if you are looking to become an <strong>Excel pro <\/strong>then learn <a href=\"https:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Advanced Excel guide <\/strong><\/a>and become master in Excel.<\/p>\n<p style=\"text-align: justify;\">Hope, you like the article, and if you are having any suggestion, queries, comments then feel free to share it with us in the comment section below.<\/p>\n<p style=\"text-align: justify;\">Good Luck!!!<\/p>\n<p><a href=\"https:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2310 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/05\/Excel_promo_img.jpg\" alt=\"learn Excel\" width=\"650\" height=\"325\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/05\/Excel_promo_img.jpg 650w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/05\/Excel_promo_img-300x150.jpg 300w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Microsoft Office 2019 is just released, and among its applications, Excel 2019 is the one having a wide collection of &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Excel 2019 New Functions &#038; Charts You Must Learn!\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#more-2509\" aria-label=\"Read more about Excel 2019 New Functions &#038; Charts You Must Learn!\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":2514,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[643,642,644,641],"class_list":["post-2509","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-excel-2019-latest-charts","tag-excel-2019-latest-features","tag-excel-2019-latest-functions","tag-whats-new-in-excel-2019","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel 2019 New Functions &amp; Charts You Must Learn!<\/title>\n<meta name=\"description\" content=\"Learn the latest Microsoft Excel 2019 functions and new charts to simplify your calculation and present data in a fresh way\u2026\" \/>\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.repairmsexcel.com\/blog\/excel-2019-functions-charts\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel 2019 New Functions &amp; Charts You Must Learn!\" \/>\n<meta property=\"og:description\" content=\"Learn the latest Microsoft Excel 2019 functions and new charts to simplify your calculation and present data in a fresh way\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-19T05:54:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-17T05:01:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-functions.png\" \/>\n\t<meta property=\"og:image:width\" content=\"654\" \/>\n\t<meta property=\"og:image:height\" content=\"391\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"Excel 2019 New Functions &#038; Charts You Must Learn!\",\"datePublished\":\"2019-08-19T05:54:23+00:00\",\"dateModified\":\"2021-07-17T05:01:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts\"},\"wordCount\":1468,\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/excel-2019-functions.png\",\"keywords\":[\"Excel 2019 latest charts\",\"Excel 2019 latest features\",\"Excel 2019 latest functions\",\"What\u2019s new in Excel 2019\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts\",\"name\":\"Excel 2019 New Functions & Charts You Must Learn!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/excel-2019-functions.png\",\"datePublished\":\"2019-08-19T05:54:23+00:00\",\"dateModified\":\"2021-07-17T05:01:17+00:00\",\"description\":\"Learn the latest Microsoft Excel 2019 functions and new charts to simplify your calculation and present data in a fresh way\u2026\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#primaryimage\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/excel-2019-functions.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/excel-2019-functions.png\",\"width\":654,\"height\":391,\"caption\":\"learn Excel 2019 functions & charts\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/excel-2019-functions-charts#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel 2019 New Functions &#038; Charts You Must Learn!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\\\/\\\/www.repairmsexcel.com\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/priyanka-sahu-2794a1242\"],\"url\":\"https:\\\/\\\/www.repairmsexcel.com\\\/blog\\\/author\\\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel 2019 New Functions & Charts You Must Learn!","description":"Learn the latest Microsoft Excel 2019 functions and new charts to simplify your calculation and present data in a fresh way\u2026","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.repairmsexcel.com\/blog\/excel-2019-functions-charts","og_locale":"en_US","og_type":"article","og_title":"Excel 2019 New Functions & Charts You Must Learn!","og_description":"Learn the latest Microsoft Excel 2019 functions and new charts to simplify your calculation and present data in a fresh way\u2026","og_url":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts","og_site_name":"Excel File Repair Blog","article_published_time":"2019-08-19T05:54:23+00:00","article_modified_time":"2021-07-17T05:01:17+00:00","og_image":[{"width":654,"height":391,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-functions.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"Excel 2019 New Functions &#038; Charts You Must Learn!","datePublished":"2019-08-19T05:54:23+00:00","dateModified":"2021-07-17T05:01:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts"},"wordCount":1468,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-functions.png","keywords":["Excel 2019 latest charts","Excel 2019 latest features","Excel 2019 latest functions","What\u2019s new in Excel 2019"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts","url":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts","name":"Excel 2019 New Functions & Charts You Must Learn!","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-functions.png","datePublished":"2019-08-19T05:54:23+00:00","dateModified":"2021-07-17T05:01:17+00:00","description":"Learn the latest Microsoft Excel 2019 functions and new charts to simplify your calculation and present data in a fresh way\u2026","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-functions.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2019\/08\/excel-2019-functions.png","width":654,"height":391,"caption":"learn Excel 2019 functions & charts"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/excel-2019-functions-charts#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Excel 2019 New Functions &#038; Charts You Must Learn!"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2509"}],"version-history":[{"count":0,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2509\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2514"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}