{"id":1486,"date":"2017-11-24T12:09:47","date_gmt":"2017-11-24T12:09:47","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=1486"},"modified":"2021-07-17T06:06:47","modified_gmt":"2021-07-17T06:06:47","slug":"analyze-trends-using-pivot-tables-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel","title":{"rendered":"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends"},"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>Excel is the very popular application of <strong>Microsoft Office suite<\/strong>, but this is very tricky also. And we all know the fact that how complex is it.<\/p>\n<p style=\"text-align: justify;\">However, there are many features in Excel that makes it less complex and easily perform certain tasks. One of the most powerful Excel features is the Pivot Tables.<\/p>\n<p style=\"text-align: justify;\">A Pivot table allows you to extract the impact from a detailed, large data set. This helps you to quickly sum up and categorize many table records into a single report.<\/p>\n<p><!--more--><\/p>\n<p style=\"text-align: justify;\">With the help of pivot table, it is possible to spot sales trends and examine the underlying data fast, for example: on regions or product, particular years.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1507\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-performance.png.pagespeed.ce_.mDj8zAah3R.png\" alt=\"\" width=\"323\" height=\"181\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-performance.png.pagespeed.ce_.mDj8zAah3R.png 323w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-performance.png.pagespeed.ce_.mDj8zAah3R-300x168.png 300w\" sizes=\"auto, (max-width: 323px) 100vw, 323px\" \/><\/p>\n<p style=\"text-align: justify;\">The pivot table is very intelligent and very well knows to compare selected expanded quarters or months.<\/p>\n<p style=\"text-align: justify;\">So today in this article I\u2019ll show you how to use Pivot table to analyze trends. But before moving further here I have something for you.<\/p>\n<p style=\"text-align: justify;\">If you want to become more productive in Excel and want to learn Pivot Table the powerful Excel feature, then visit <strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\">Learn Advance Excel<\/a> Easily.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #339966;\">Know Learn How to Analyze Trends Using Pivot Tables<\/span><\/h3>\n<p>&nbsp;<\/p>\n<h3>1. Create a Pivot Table<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Very firstly, you need to create a Pivot table in Excel. Then know how to analyze trends using pivot tables.<\/p>\n<p style=\"text-align: justify;\">Here follow the steps to do so:<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>In the table click any Cell<\/li>\n<li>Then, go to &#8220;Insert&#8221; tab<\/li>\n<li>After that click &#8220;Pivot table&#8221; button<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1506\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xcreate-pivot-table.png.pagespeed.ic_.P_PHTRj5nm.png\" alt=\"\" width=\"399\" height=\"289\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xcreate-pivot-table.png.pagespeed.ic_.P_PHTRj5nm.png 399w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xcreate-pivot-table.png.pagespeed.ic_.P_PHTRj5nm-300x217.png 300w\" sizes=\"auto, (max-width: 399px) 100vw, 399px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Lastly, click OK<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\">2. Group Data<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Your pivot table looks like the below-given diagram.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>Then click &gt; hold on <strong>Date in Pivot table field list<\/strong><\/li>\n<li>And drag &gt; release &#8220;<strong>Row Labels&#8221;<\/strong> area<\/li>\n<li>Now in the pivot table right click on any date<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1504\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table.png.pagespeed.ic_.8nSUNCpvA0.png\" alt=\"\" width=\"167\" height=\"340\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table.png.pagespeed.ic_.8nSUNCpvA0.png 167w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table.png.pagespeed.ic_.8nSUNCpvA0-147x300.png 147w\" sizes=\"auto, (max-width: 167px) 100vw, 167px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>Click <strong>Group<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1503\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table1.png.pagespeed.ic_.dMB8vH-zDt.png\" alt=\"\" width=\"239\" height=\"303\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table1.png.pagespeed.ic_.dMB8vH-zDt.png 239w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table1.png.pagespeed.ic_.dMB8vH-zDt-237x300.png 237w\" sizes=\"auto, (max-width: 239px) 100vw, 239px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>Choose <strong>months, quarters and Years<\/strong> &gt; <strong>OK<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1502\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table2.png.pagespeed.ic_.H9P-nO05YB.png\" alt=\"\" width=\"667\" height=\"527\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table2.png.pagespeed.ic_.H9P-nO05YB.png 667w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xgroup-dates-in-a-pivot-table2.png.pagespeed.ic_.H9P-nO05YB-300x237.png 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/p>\n<p style=\"text-align: justify;\">Well, in this way you can group the data, know follow the ways how to analyze data with a Pivot table.<\/p>\n<p>&nbsp;<\/p>\n<h3>3. Analyze Data (Pivot Table)<\/h3>\n<ul>\n<li>First add \u201c<strong>Amount<\/strong>\u201d to the Pivot table.<\/li>\n<li>Then click &gt; in the pivot table field list hold &#8220;<strong>Amount<\/strong>&#8220;.<\/li>\n<li>And drag &gt; release over <strong>Values area<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1501\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xvisualize-sales-in-a-pivot-table.png.pagespeed.ic_.m1LQL35d-H.png\" alt=\"\" width=\"667\" height=\"529\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xvisualize-sales-in-a-pivot-table.png.pagespeed.ic_.m1LQL35d-H.png 667w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xvisualize-sales-in-a-pivot-table.png.pagespeed.ic_.m1LQL35d-H-300x238.png 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/p>\n<p style=\"text-align: justify;\">Now the entire sales in each year are shortened.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1500\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-year.png.pagespeed.ic_.2aIz44kd-f.png\" alt=\"\" width=\"225\" height=\"260\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">And click on any <strong>+<\/strong> sign to expand the particular year data. Well as you grouped data into years, quarters and months, the next \u201c<strong>level\u201d<\/strong> is quarters.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1499\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-quarter.png.pagespeed.ic_.6Pv_nCOX4h.png\" alt=\"\" width=\"225\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-quarter.png.pagespeed.ic_.6Pv_nCOX4h.png 225w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-quarter.png.pagespeed.ic_.6Pv_nCOX4h-212x300.png 212w\" sizes=\"auto, (max-width: 225px) 100vw, 225px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Again click <strong>+ sign<\/strong> on a quarter and you can see the months are displayed.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1498\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-expand-collapse-entire-field.png.pagespeed.ic_.VFrauqxUUu.png\" alt=\"\" width=\"335\" height=\"342\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-expand-collapse-entire-field.png.pagespeed.ic_.VFrauqxUUu.png 335w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-expand-collapse-entire-field.png.pagespeed.ic_.VFrauqxUUu-294x300.png 294w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-expand-collapse-entire-field.png.pagespeed.ic_.VFrauqxUUu-300x306.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-expand-expand-collapse-entire-field.png.pagespeed.ic_.VFrauqxUUu-65x65.png 65w\" sizes=\"auto, (max-width: 335px) 100vw, 335px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">After that you can collapse and expand the entire fields with one click. Now right click on any data &gt; choose \u201c<strong>Expand Entire Field\u201d.<\/strong><\/li>\n<\/ul>\n<p><strong>Also Read:<\/strong><\/p>\n<ul>\n<li><strong><a class=\"row-title\" href=\"https:\/\/www.repairmsexcel.com\/blog\/filter-out-excel-data-to-get-accurate-results\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"\u201c8 Easy Excel Filters To Save Time, Money and Get Accurate Data\u201d (Edit)\">8 Easy Excel Filters To Save Time, Money and Get Accurate Data<\/a><\/strong><\/li>\n<li><strong><a class=\"row-title\" href=\"https:\/\/www.repairmsexcel.com\/blog\/underused-excel-functions\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"\u201c7 Underrated Excel Functions That I Wish Knew Before\u201d (Edit)\">7 Underrated Excel Functions That I Wish Knew Before<\/a><\/strong><\/li>\n<li><strong><a class=\"row-title\" href=\"https:\/\/www.repairmsexcel.com\/blog\/excel-skills-to-succeed-at-office\" target=\"_blank\" rel=\"noopener noreferrer\" aria-label=\"\u201c16 Advanced Excel Skills To Succeed at Office\u201d (Edit)\">16 Advanced Excel Skills To Succeed at Office<\/a><\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>4. Compare Performance, year to year, quarter to quarter (previous year), month to month (previous year)<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Now add the pivot table field \u201c<strong>Amount<\/strong>\u201d to the Values as done in step 3 and follow the below given steps.<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>First click on &#8220;<strong>Sum of Amount&#8221;<\/strong> field &gt; &#8220;<strong>Values<\/strong>&#8221; area<\/li>\n<li>Then, click &#8220;<strong>Value Field Settings<\/strong>&#8221; &gt; go to &#8220;<strong>Show Values As<\/strong>&#8221; tab<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1497\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-change-Value-field-settings.png.pagespeed.ic_.YtQn5pBu6R.png\" alt=\"\" width=\"365\" height=\"325\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-change-Value-field-settings.png.pagespeed.ic_.YtQn5pBu6R.png 365w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-change-Value-field-settings.png.pagespeed.ic_.YtQn5pBu6R-300x267.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>Choose Show values as &#8220;<strong>Difference From<\/strong>&#8221; &gt; choose <strong>Years in Base field<\/strong><\/li>\n<li>Select (<strong>previous<\/strong>) in Base item &gt; <strong>OK<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1496\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-difference-from.png.pagespeed.ic_.NQ-nTZW1L7.png\" alt=\"\" width=\"317\" height=\"180\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-difference-from.png.pagespeed.ic_.NQ-nTZW1L7.png 317w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-difference-from.png.pagespeed.ic_.NQ-nTZW1L7-300x170.png 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">You can see a sharp decline in<strong> sales in 2011 &gt; expand 2011<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1495\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-examine-a-year.png.pagespeed.ic_.H4hcH-parP.png\" alt=\"\" width=\"309\" height=\"259\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-examine-a-year.png.pagespeed.ic_.H4hcH-parP.png 309w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-examine-a-year.png.pagespeed.ic_.H4hcH-parP-300x251.png 300w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Note there are <strong>no +\/- <\/strong>values in the quarters, because one year is expanded. Now compare it with the year 2010 and expand year 2010.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1494\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-compare-year-to-year1.png\" alt=\"\" width=\"279\" height=\"321\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-compare-year-to-year1.png 279w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-compare-year-to-year1-261x300.png 261w\" sizes=\"auto, (max-width: 279px) 100vw, 279px\" \/><\/li>\n<li style=\"text-align: justify;\">You can see the sales were good in the first three quarters but the fourth quarter was poor. You can now compare sales to year <strong>2009 and collapse 2010 and expand 2009<\/strong><\/li>\n<li style=\"text-align: justify;\">Sales were pretty good in the three first quarters but the fourth quarter was terrible. You can quickly compare sales to <strong>year 2009 &gt; collapse 2010 and expand 2009.<\/strong><\/li>\n<li style=\"text-align: justify;\">You can see the values in the <strong>+\/- column<\/strong> are changed! And compare the 2011 quarters to quarters 2009.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>5. Product Trends<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Here know which products show decline in 4<sup>th<\/sup> quarter sales in 2011.<\/p>\n<p style=\"text-align: justify;\"><strong>Follow the steps:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>First, click &#8220;<strong>arrow<\/strong>&#8221; near &#8220;<strong>Row Labels&#8221;<\/strong><\/li>\n<li>Then choose the year <strong>2010 and 2011 only<\/strong><\/li>\n<li>Now remove <strong>&#8220;Sum of Amount&#8221;<\/strong> in Values <strong>&#8220;Field&#8221;<\/strong><\/li>\n<li>And drag the products from Pivot table field list to Column area.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1493\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-year-to-year2.png.pagespeed.ic_.RtUk0ZX92j.png\" alt=\"\" width=\"315\" height=\"341\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-year-to-year2.png.pagespeed.ic_.RtUk0ZX92j.png 315w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-year-to-year2.png.pagespeed.ic_.RtUk0ZX92j-277x300.png 277w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-year-to-year2.png.pagespeed.ic_.RtUk0ZX92j-300x325.png 300w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">You can easily see that \u201c<strong>Access points<\/strong>\u201d and \u201c<strong>Modems\u201d<\/strong> are having the largest declines in 4<sup>th<\/sup> quarter sales in 2011.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>6. Region Trends<\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">This is the time to calculate<strong> %<\/strong> difference from same quarter last year. Do the entire market have same sales decline.<\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>In the values area first click on <strong>&#8220;+\/-&#8220;.<\/strong><\/li>\n<li>Then on Value Field Settings &gt;\u00a0 change custom name to <strong>&#8220;%&#8221;<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1491\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-compare-region-sales-from-year-to-year.png\" alt=\"\" width=\"365\" height=\"325\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-compare-region-sales-from-year-to-year.png 365w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/pivot-table-compare-region-sales-from-year-to-year-300x267.png 300w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<ol style=\"text-align: justify;\">\n<li style=\"list-style-type: none;\">\n<ul style=\"text-align: justify;\">\n<li>And change Show values as: <strong>% Difference From<\/strong><\/li>\n<li>Click<strong> OK<\/strong> &gt; remove <strong>Products from Column Labels area<\/strong><\/li>\n<li>Lastly, <strong>Add Region to Column Labels area<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1490\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-region-sales-from-year-to-year1.png.pagespeed.ic_.0yIYkdTt_1.png\" alt=\"\" width=\"576\" height=\"241\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-region-sales-from-year-to-year1.png.pagespeed.ic_.0yIYkdTt_1.png 576w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/xpivot-table-compare-region-sales-from-year-to-year1.png.pagespeed.ic_.0yIYkdTt_1-300x126.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">You can see the entire markets show a decline in sales.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Well, this is the whole process to use Excel Pivot Table for analyzing trends.<\/p>\n<p style=\"text-align: justify;\">Apart from the there are many other uses of the <strong>powerful pivot table<\/strong>.<\/p>\n<p style=\"text-align: justify;\">In our <a href=\"https:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Advance Excel courses<\/strong><\/a>, we offer the users to know more about the Pivot Table.<\/p>\n<p style=\"text-align: justify;\">Here you can learn the way to use <strong>Pivot Table techniques<\/strong> to become more creativity and do a lot more with your data. Some of them are given below:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>You can use Pivot Tables as the calculation engine behind the management reports.<\/strong><\/li>\n<li><strong>Learn the Pivot Tables trick to do more with your data.<\/strong><\/li>\n<li><strong>Know to create flexible reports by making use of GETPIVOTDATA() and CUBE formulae<\/strong><\/li>\n<li><strong>Slicers and Timelines in Excel 2010 and 2013 \u00a0&#8211; you can make your PivotTables more interactive and advance<\/strong><\/li>\n<li><strong>Learn working with Pivot Charts<\/strong><\/li>\n<li><strong>By making use of PivotTables and Slicers know how to build interact dashboard.<\/strong><\/li>\n<li><strong>Know the calculated fields and calculated items.<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: center;\"><span style=\"color: #339966;\">Conclusion:<\/span><\/h3>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\">Well, this is all about the Excel Pivot table and how you can use it to analyze trends.<\/p>\n<p style=\"text-align: justify;\">Here I have listed the complete ways of analyzing trends using Pivot Table with the help of example.<\/p>\n<p style=\"text-align: justify;\">Pivot Table is very powerful as well as useful Excel features and this can be used in many ways to become more productive and creative in this complex application.<\/p>\n<p style=\"text-align: justify;\">So, if you are interested to learn more about Excel Pivot tables than no need to go here there as I have done this for you as well.<\/p>\n<p style=\"text-align: justify;\">Just visit Learn Advance Excel and become master in Excel.<\/p>\n<p style=\"text-align: justify;\"><em>That\u2019s it&#8230;<\/em><\/p>\n<p><a href=\"https:\/\/www.repairmsexcel.com\/blog\/master-excel\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1511\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/Excel_promo_img.jpg\" alt=\"\" width=\"650\" height=\"325\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/Excel_promo_img.jpg 650w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/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>Excel is the very popular application of Microsoft Office suite, but this is very tricky also. And we all know &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#more-1486\" aria-label=\"Read more about 6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":1508,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[410,408,411,409],"class_list":["post-1486","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-analyze-trends-using-pivot-tables","tag-how-to-use-pivot-tables","tag-use-pivot-tables","tag-utilize-pivot-tables-for-analyzing-trends","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &amp; Yearly Trends<\/title>\n<meta name=\"description\" content=\"Learn the complete ways to use pivot tables for Analyzing Quarterly, Monthly &amp; Yearly Trends and as well know more pivot tables in Excel\" \/>\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\/analyze-trends-using-pivot-tables-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &amp; Yearly Trends\" \/>\n<meta property=\"og:description\" content=\"Learn the complete ways to use pivot tables for Analyzing Quarterly, Monthly &amp; Yearly Trends and as well know more pivot tables in Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-24T12:09:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-17T06:06:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends\",\"datePublished\":\"2017-11-24T12:09:47+00:00\",\"dateModified\":\"2021-07-17T06:06:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel\"},\"wordCount\":1045,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png\",\"keywords\":[\"analyze trends using pivot tables\",\"How to use Pivot Tables\",\"use Pivot Tables\",\"utilize Pivot Tables for analyzing trends\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel\",\"name\":\"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly & Yearly Trends\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png\",\"datePublished\":\"2017-11-24T12:09:47+00:00\",\"dateModified\":\"2021-07-17T06:06:47+00:00\",\"description\":\"Learn the complete ways to use pivot tables for Analyzing Quarterly, Monthly & Yearly Trends and as well know more pivot tables in Excel\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png\",\"width\":1024,\"height\":576,\"caption\":\"use-pivot-table\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends\"}]},{\"@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:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"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":"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly & Yearly Trends","description":"Learn the complete ways to use pivot tables for Analyzing Quarterly, Monthly & Yearly Trends and as well know more pivot tables in Excel","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\/analyze-trends-using-pivot-tables-in-excel","og_locale":"en_US","og_type":"article","og_title":"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly & Yearly Trends","og_description":"Learn the complete ways to use pivot tables for Analyzing Quarterly, Monthly & Yearly Trends and as well know more pivot tables in Excel","og_url":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2017-11-24T12:09:47+00:00","article_modified_time":"2021-07-17T06:06:47+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends","datePublished":"2017-11-24T12:09:47+00:00","dateModified":"2021-07-17T06:06:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel"},"wordCount":1045,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png","keywords":["analyze trends using pivot tables","How to use Pivot Tables","use Pivot Tables","utilize Pivot Tables for analyzing trends"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel","name":"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly & Yearly Trends","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png","datePublished":"2017-11-24T12:09:47+00:00","dateModified":"2021-07-17T06:06:47+00:00","description":"Learn the complete ways to use pivot tables for Analyzing Quarterly, Monthly & Yearly Trends and as well know more pivot tables in Excel","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/11\/use-pivot-table.png","width":1024,"height":576,"caption":"use-pivot-table"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/analyze-trends-using-pivot-tables-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"6 Ways to Use Pivot Table to Analyze Quarterly, Monthly &#038; Yearly Trends"}]},{"@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:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","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\/1486","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=1486"}],"version-history":[{"count":0,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1486\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/1508"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=1486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=1486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=1486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}