{"id":8308,"date":"2018-08-29T06:43:57","date_gmt":"2018-08-29T06:43:57","guid":{"rendered":"http:\/\/www.nurturetechacademy.in\/?p=8308"},"modified":"2018-08-29T06:43:57","modified_gmt":"2018-08-29T06:43:57","slug":"sparkline-function-ms-excel","status":"publish","type":"post","link":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/sparkline-function-ms-excel\/","title":{"rendered":"Sparkline Function In MS Excel"},"content":{"rendered":"<p><strong>How to use Sparkline in Excel?<\/strong><\/p>\n<p>Charts are the Graphical visualization in excel which help us to understand the weekly, monthly performance and consolidated report of entire data, However if we have a data in to tabular form and we need to visualize our data next to each row and if we apply charts it became very complicated and hard to understand the values. This task can easily be done using \u201cSparklines\u201d.<\/p>\n<p>Sparkline has been introduced in Office Version 2010. \u201cSparkline\u201d option is not only limited to \u201cline\u201d but can also show data into \u201cColumn\u201d and \u201cWin\/Loss\u201d.<\/p>\n<p>Below screenshot draw exact outcome, what Sparkline can do.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8309\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-1-3.jpg\" alt=\"Pic-1\" width=\"855\" height=\"257\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-1-3.jpg 855w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-1-3-600x180.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-1-3-300x90.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-1-3-768x231.jpg 768w\" sizes=\"auto, (max-width: 855px) 100vw, 855px\" \/><\/p>\n<p><strong>How to apply Sparkline-<\/strong><\/p>\n<p>As you can see in above image, we have drawn the monthly performance graph of each and every FSM.<\/p>\n<p><em>Note: Make sure you are using Ms-office 2010 or upper version.<\/em><\/p>\n<ul>\n<li>Go to Insert Tab<\/li>\n<li>Sparkline group<\/li>\n<\/ul>\n<p>Select Line, Column, Win\/Loss. Here we are using the Line option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8310\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-2-5.jpg\" alt=\"Pic-2\" width=\"1022\" height=\"165\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-2-5.jpg 1022w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-2-5-600x97.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-2-5-300x48.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-2-5-768x124.jpg 768w\" sizes=\"auto, (max-width: 1022px) 100vw, 1022px\" \/><\/p>\n<p>When you click on any \u201cSparkline\u201d option, it will open a dialogue box \u201cCreate Sparklines\u201d. There are two options-<\/p>\n<ol>\n<li>Data Range- The data range it will use to create \u201cSparkline\u201d. Select the first range E.g. B5:H5<\/li>\n<li>Location Range-: The cell where it will insert the \u201cSparkline\u201d. As it\u2019s asking, \u201cchoose where you want to Sparkline\u2019s to be placed\u201d define it E.g. I5<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8311\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-3-2.png\" alt=\"Pic-3\" width=\"1268\" height=\"277\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-3-2.png 1268w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-3-2-600x131.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-3-2-300x66.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-3-2-768x168.png 768w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-3-2-1024x224.png 1024w\" sizes=\"auto, (max-width: 1268px) 100vw, 1268px\" \/><\/p>\n<ul>\n<li>When you define the range and location. Simply click on Ok<\/li>\n<li>You will get the Sparkline\u2019s in given range, now just drag it down and you will get Sparklines for all.<\/li>\n<\/ul>\n<p>Refer the screenshot below-<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8312\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-4.png\" alt=\"Pic-4\" width=\"1083\" height=\"327\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-4.png 1083w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-4-600x181.png 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-4-300x91.png 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-4-768x232.png 768w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-4-1024x309.png 1024w\" sizes=\"auto, (max-width: 1083px) 100vw, 1083px\" \/><\/p>\n<p><strong><u>Formatting of Sparkline\u2019s-<\/u><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8313\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-5-5.jpg\" alt=\"Pic-5\" width=\"787\" height=\"214\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-5-5.jpg 787w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-5-5-600x163.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-5-5-300x82.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-5-5-768x209.jpg 768w\" sizes=\"auto, (max-width: 787px) 100vw, 787px\" \/><\/p>\n<p>Let\u2019s understand the \u201cDesign\u201d tab to format the data:<\/p>\n<ul>\n<li><strong>Edit Data-<\/strong> Once you have created the Sparkline\u2019s and you want to edit the range, Go to Sparkline\u2019s Design tab and click on Edit data.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8314\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-6-4.jpg\" alt=\"Pic-6\" width=\"389\" height=\"176\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-6-4.jpg 389w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-6-4-300x136.jpg 300w\" sizes=\"auto, (max-width: 389px) 100vw, 389px\" \/><\/p>\n<ul>\n<li><strong>Edit Group Location &amp; Data<\/strong>&#8211; This option will help you to edit both option range and location.<\/li>\n<li><strong>Edit single Sparkline\u2019s data<\/strong>&#8211; This option will help you to edit only range.<\/li>\n<li><strong>Hidden &amp; Empty Cells<\/strong>&#8211; There are two segments \u2013\n<ol>\n<li><strong>The empty cells<\/strong>&#8211; There are three options available.\n<ol>\n<li><strong>Gaps<\/strong>-it will show \u201cgap\u201d for empty cells.<\/li>\n<li><strong>Zero-<\/strong> you can choose to show zero for empty cells.<\/li>\n<li><strong>Connect data points with line<\/strong>&#8211; to Ignore zero you can directly connect data points with line.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<ol>\n<li><strong>Show data in hidden rows and columns<\/strong> &#8211; If you select this option Sparkline\u2019s to hide row and column.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8315\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-7-2.jpg\" alt=\"Pic-7\" width=\"305\" height=\"146\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-7-2.jpg 305w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-7-2-300x144.jpg 300w\" sizes=\"auto, (max-width: 305px) 100vw, 305px\" \/><\/p>\n<ul>\n<li>There are three types of Sparkline\u2019s available, in below mention screenshot you can see all of them-\n<ol>\n<li>Line-<\/li>\n<li>Column<\/li>\n<li>Win\/Loss<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8316\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-8-1.jpg\" alt=\"Pic-8\" width=\"668\" height=\"156\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-8-1.jpg 668w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-8-1-600x140.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-8-1-300x70.jpg 300w\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" \/><\/p>\n<ul>\n<li>In the group of \u201c<strong>Show<\/strong>\u201d, there are several options which help us to highlight the movement of data-\n<ol>\n<li>High point- if you want to show the high point<\/li>\n<li>Low Point- this option will helps us to show the minimum point of performance.<\/li>\n<li>Negative points- to show negative data points.<\/li>\n<li>First point- it will show the starting point of the data.<\/li>\n<li>Last point- it will show the ending point of the data.<\/li>\n<li>Markers- It will mark every data point.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8317\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-9.jpg\" alt=\"Pic-9\" width=\"955\" height=\"227\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-9.jpg 955w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-9-600x143.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-9-300x71.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-9-768x183.jpg 768w\" sizes=\"auto, (max-width: 955px) 100vw, 955px\" \/><\/p>\n<ul>\n<li><strong>Style<\/strong>&#8211; you can select the different type and colours of Sparkline\u2019s.<\/li>\n<li><strong>Sparkline&#8217;s Colour and Marker Colours<\/strong> &#8211; with the helpof these two points, You can modify the view of Sparkline&#8217;s.\u00a0Like you can select and change the colour of points.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8318\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-10-1.jpg\" alt=\"Pic-10\" width=\"780\" height=\"312\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-10-1.jpg 780w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-10-1-600x240.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-10-1-300x120.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-10-1-768x307.jpg 768w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><\/p>\n<ul>\n<li><strong>Axis-<\/strong> This section gives you an option to change scaling and visibility details of horizontal and vertical axis of Sparkline.<\/li>\n<\/ul>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Types of Sparklines-<\/strong><\/p>\n<ul>\n<li><strong>Line-<\/strong> This option draws a simple line. You can change the formatting as explained above.<\/li>\n<li><strong>Column-<\/strong> These Sparkline\u2019s are displayed in the form of vertical bars. For the positive value bars will be shown above the axis and if any value is negative then it will show below of the axis bar. If any value is zero then it will not show anything on axis bar.<\/li>\n<li><strong>Win\/Loss-<\/strong> These Sparkline\u2019s are displayed in the form of \u201cColumn\u201d, however this will be useful when we have positive as well as negative values e.g. profit and loss data. For profit value bar will show on the above of axis bar and for loss it will show below of the axis bar.<\/li>\n<\/ul>\n<p><strong>How to Group\/ Ungroup Sparkline\u2019s \u2013<\/strong><\/p>\n<p>If you wish to apply multiple Sparkline\u2019s on your data then you can use option <strong>Group.<\/strong><\/p>\n<ul>\n<li>Select the more than one cell by holding the control key<\/li>\n<li>Design tab then click on group<\/li>\n<li>Change the Sparkline\u2019s format<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8319\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-11-1.jpg\" alt=\"Pic-11\" width=\"790\" height=\"327\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-11-1.jpg 790w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-11-1-600x248.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-11-1-300x124.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-11-1-768x318.jpg 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/p>\n<p>Grouping option gives us the advantage of having different formatting for different groups(refer screenshot below):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8320\" src=\"http:\/\/www.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-13.jpg\" alt=\"Pic-13\" width=\"860\" height=\"238\" srcset=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-13.jpg 860w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-13-600x166.jpg 600w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-13-300x83.jpg 300w, https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/uploads\/2018\/08\/Pic-13-768x213.jpg 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/p>\n<p><strong>Clear Sparkline\u2019s: &#8211;<\/strong><\/p>\n<p>If you wish to remove the Sparklines, go to design tab -&gt; click on clear. You will get two options.<\/p>\n<ul>\n<li>Clear selected Sparkline\u2019s<\/li>\n<li>Clear selected Sparkline\u2019s group.<\/li>\n<\/ul>\n<p>First option will clear the entire Sparkline\u2019s format from the selected cells and second option will clear the Sparkline\u2019s group.<\/p>\n<p>&nbsp;<\/p>\n<p>Hope this post will help you to prepare a dynamic report with the help of Sparkline\u2019s.<\/p>\n<p>Stay Connected.<\/p>\n<p>Happy Learning\ud83d\ude0a<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8308\" class=\"pvc_stats all  \" data-element-id=\"8308\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>How to use Sparkline in Excel?<br \/>\nCharts are the Graphical visualization in excel which help us to understand the weekly, monthly performance and consolidated report of entire data, However if we have a data in to tabular form and we <\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_8308\" class=\"pvc_stats all  \" data-element-id=\"8308\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":8321,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[56],"tags":[265,266,263,243,264,257,260,259,249,256,248,297,298,296,299,295,293,294,244,250,252,245,253,254,246,251,267,255,262,258,247,261],"class_list":["post-8308","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-corporate-training-companies","tag-corporate-training-companies-in-delhi","tag-corporate-training-courses","tag-corporate-training-in-delhi","tag-corporate-training-programs","tag-excel-course-online","tag-excel-courses-online","tag-excel-online-course","tag-excel-online-training","tag-excel-training-in-delhi","tag-excel-training-online","tag-how-can-i-use-sparkline-function","tag-how-can-i-use-sparkline-function-in-excel","tag-how-can-we-use-sparkline-function","tag-how-to-use-sparkline-function","tag-how-to-use-sparkline-function-in-excel","tag-how-to-use-sparkline-function-in-microsoft-excel","tag-how-to-use-sparkline-function-in-ms-excel","tag-learn-microsoft-excel","tag-learn-ms-excel-online","tag-learning-excel-online","tag-learning-microsoft-excel","tag-microsoft-excel-course","tag-microsoft-excel-online-training","tag-microsoft-excel-training","tag-ms-excel-learning","tag-ms-excel-online-training","tag-ms-excel-training-in-delhi","tag-online-corporate-training","tag-online-excel-course","tag-online-excel-training","tag-online-excel-training-courses"],"_links":{"self":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8308","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/comments?post=8308"}],"version-history":[{"count":1,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8308\/revisions"}],"predecessor-version":[{"id":8322,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/posts\/8308\/revisions\/8322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media\/8321"}],"wp:attachment":[{"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/media?parent=8308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/categories?post=8308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nurturetechacademy.in\/dev.nurturetechacademy.in\/wp-json\/wp\/v2\/tags?post=8308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}