{"id":1348,"date":"2022-04-05T06:40:06","date_gmt":"2022-04-05T06:40:06","guid":{"rendered":"https:\/\/irtecnology.ir\/?p=1348"},"modified":"2022-04-05T06:40:10","modified_gmt":"2022-04-05T06:40:10","slug":"%d9%85%d8%b9%d8%b1%d9%81%db%8c-pivottables","status":"publish","type":"post","link":"https:\/\/irtecnology.ir\/?p=1348","title":{"rendered":"\u0645\u0639\u0631\u0641\u06cc PivotTables"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbg50u-19a079ea3dd9f41271ffbd18d43500e3\">\n#top .av-special-heading.av-l1kbg50u-19a079ea3dd9f41271ffbd18d43500e3{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-l1kbg50u-19a079ea3dd9f41271ffbd18d43500e3 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-l1kbg50u-19a079ea3dd9f41271ffbd18d43500e3 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-l1kbg50u-19a079ea3dd9f41271ffbd18d43500e3 av-special-heading-h3 blockquote modern-quote modern-centered  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag '  itemprop=\"headline\"  >\u0645\u0639\u0631\u0641\u06cc PivotTables \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n<section  class='av_textblock_section av-l1kbhtiz-7e030996212f2beb7a456e7c13634f68 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h5><span><span class=\"goog-text-highlight\">\u0645\u0639\u0631\u0641\u06cc<\/span><\/span><\/h5>\n<p><span>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u06af\u0627\u0647\u06cc \u0627\u0648\u0642\u0627\u062a \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0647\u0645\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 \u06a9\u0627\u0631\u0628\u0631\u06af \u0634\u0645\u0627 \u062f\u0634\u0648\u0627\u0631 \u0627\u0633\u062a.\u00a0<\/span><strong><span>PivotTables<\/span><\/strong><span>\u00a0\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0627\u00a0<\/span><strong><span>\u062e\u0644\u0627\u0635\u0647<\/span><\/strong><span>\u00a0\u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0627\u0645\u06a9\u0627\u0646\u00a0<\/span><strong><span>\u062f\u0633\u062a\u06a9\u0627\u0631\u06cc<\/span><\/strong><span>\u00a0\u0622\u0646\u200c\u0647\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u06a9\u0627\u0631\u0628\u0631\u06af\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0631\u0627 \u0642\u0627\u0628\u0644 \u0645\u062f\u06cc\u0631\u06cc\u062a\u200c\u062a\u0631 \u06a9\u0646\u062f.<\/span><\/p>\n<p class=\"moreInfo\"><span>\u0627\u062e\u062a\u06cc\u0627\u0631\u06cc:\u00a0<\/span><a href=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/workfile\/24%20excel_intropivottables_practice.xlsx\"><span>\u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u062a\u0645\u0631\u06cc\u0646\u06cc<\/span><\/a><span>\u00a0\u0645\u0627 \u0631\u0627 \u062f\u0627\u0646\u0644\u0648\u062f \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<h6><span><span class=\"goog-text-highlight\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 PivotTables \u0628\u0631\u0627\u06cc \u067e\u0627\u0633\u062e \u0628\u0647 \u0633\u0648\u0627\u0644\u0627\u062a<\/span><\/span><\/h6>\n<p><span>\u0645\u062b\u0627\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f.\u00a0\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u06cc\u0645 \u0628\u0647 \u0627\u06cc\u0646 \u0633\u0648\u0627\u0644 \u067e\u0627\u0633\u062e \u062f\u0647\u06cc\u0645\u00a0<\/span><strong><span>\u06a9\u0647 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0647\u0631 \u0641\u0631\u0648\u0634\u0646\u062f\u0647 \u0686\u0642\u062f\u0631 \u0627\u0633\u062a\u061f\u00a0<\/span><\/strong><span>\u067e\u0627\u0633\u062e \u062f\u0627\u062f\u0646 \u0628\u0647 \u0622\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0632\u0645\u0627\u0646 \u0628\u0631 \u0648 \u062f\u0634\u0648\u0627\u0631 \u0628\u0627\u0634\u062f.\u00a0\u0647\u0631 \u0641\u0631\u0648\u0634\u0646\u062f\u0647 \u062f\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0631\u062f\u06cc\u0641 \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0645\u0627 \u0628\u0627\u06cc\u062f \u062a\u0645\u0627\u0645 \u0633\u0641\u0627\u0631\u0634\u0627\u062a \u0645\u062e\u062a\u0644\u0641 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u06a9\u0646\u06cc\u0645.\u00a0\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u00a0<\/span><strong><span>Subtotal<\/span><\/strong><span>\u00a0\u0628\u0631\u0627\u06cc \u06a9\u0645\u06a9 \u0628\u0647 \u06cc\u0627\u0641\u062a\u0646 \u06a9\u0644 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0641\u0631\u0648\u0634\u0646\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u060c \u0627\u0645\u0627 \u0647\u0646\u0648\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631 \u06a9\u0631\u062f\u0646 \u062f\u0627\u0631\u06cc\u0645.<\/span><\/p>\n<div class=\"centerImage\"><\/div>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbi3a1-c1c0fecd3e53a4c9949138b2af965e0d\">\n#top .hr.hr-invisible.av-l1kbi3a1-c1c0fecd3e53a4c9949138b2af965e0d{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbi3a1-c1c0fecd3e53a4c9949138b2af965e0d hr-invisible  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-v155ec-08b7e3484bd8817990d6184f1a773c60 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png\" alt=\"\u0633\u0648\u0627\u0644 \u0634\u06cc\u062a\" width=\"660\" height=\"373\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbi85f-df4ca74974ffc8a2d0ba71cb2a946bc4\">\n#top .hr.hr-invisible.av-l1kbi85f-df4ca74974ffc8a2d0ba71cb2a946bc4{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbi85f-df4ca74974ffc8a2d0ba71cb2a946bc4 hr-invisible  avia-builder-el-4  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbimx3-8afeda542334e486f94700b2befbdf31 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u062e\u0648\u0634\u0628\u062e\u062a\u0627\u0646\u0647\u060c \u06cc\u06a9 PivotTable \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0641\u0648\u0631\u0627\u064b \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647\u200c\u06af\u0648\u0646\u0647\u200c\u0627\u06cc\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0645\u062d\u0627\u0633\u0628\u0647<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u0648\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u062e\u0644\u0627\u0635\u0647<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u06a9\u0646\u062f \u06a9\u0647 \u062e\u0648\u0627\u0646\u062f\u0646 \u0622\u0646 \u0631\u0627 \u0628\u0633\u06cc\u0627\u0631 \u0622\u0633\u0627\u0646\u200c\u062a\u0631 \u06a9\u0646\u062f.\u00a0<\/span>\u0648\u0642\u062a\u06cc \u06a9\u0627\u0631\u0645\u0627\u0646 \u062a\u0645\u0627\u0645 \u0634\u062f\u060c PivotTable \u0686\u06cc\u0632\u06cc \u0634\u0628\u06cc\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbivgq-c9ef2a2389c26c8765b4c3efed8fdbd4\">\n#top .hr.hr-invisible.av-l1kbivgq-c9ef2a2389c26c8765b4c3efed8fdbd4{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbivgq-c9ef2a2389c26c8765b4c3efed8fdbd4 hr-invisible  avia-builder-el-6  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-ti54j8-8945dbf4436e60f1d22b53eb55dd62c7 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/492%20pivot_question_salesperson.png\" alt=\"\u0633\u0648\u0627\u0644 \u0641\u0631\u0648\u0634\u0646\u062f\u0647\" width=\"335\" height=\"221\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbj0h4-a7ee7fa83288e8f4cbbf505d35db37c2\">\n#top .hr.hr-invisible.av-l1kbj0h4-a7ee7fa83288e8f4cbbf505d35db37c2{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbj0h4-a7ee7fa83288e8f4cbbf505d35db37c2 hr-invisible  avia-builder-el-8  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbjjzf-52f6361929f61c22e598975bf66b8e5d '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 PivotTable \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u067e\u0627\u0633\u062e \u062f\u0627\u062f\u0646 \u0628\u0647 \u0633\u0624\u0627\u0644\u0627\u062a \u0645\u062e\u062a\u0644\u0641 \u0628\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0631\u062f\u0646 \u0645\u062c\u062f\u062f \u06cc\u0627\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0686\u0631\u062e\u0627\u0646\u062f\u0646<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.\u00a0<\/span>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc \u062e\u0648\u0627\u0633\u062a\u06cc\u0645 \u067e\u0627\u0633\u062e\u00a0<\/span><strong><span>\u062f\u0647\u06cc\u0645 \u06a9\u0644 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0647\u0631 \u0645\u0627\u0647 \u0686\u0642\u062f\u0631 \u0627\u0633\u062a\u061f\u00a0<\/span><\/strong><span>\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 PivotTable \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645:<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbjs70-86ac82c4ee12063a336796ce04a90fb7\">\n#top .hr.hr-invisible.av-l1kbjs70-86ac82c4ee12063a336796ce04a90fb7{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbjs70-86ac82c4ee12063a336796ce04a90fb7 hr-invisible  avia-builder-el-10  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-r40rvo-9b319ee616ca59d9db3d914c60ddafc6 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/493%20pivot_question_month.png\" alt=\"\u0633\u0648\u0627\u0644 \u0645\u0627\u0647\" width=\"335\" height=\"111\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbjx44-dadc62b122a0a3c2a160e03b59fd471c\">\n#top .hr.hr-invisible.av-l1kbjx44-dadc62b122a0a3c2a160e03b59fd471c{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbjx44-dadc62b122a0a3c2a160e03b59fd471c hr-invisible  avia-builder-el-12  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbkbbd-54053bc24cf0fa25677075a773f28dc4 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h6><span><span class=\"goog-text-highlight\">\u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 PivotTable:<\/span><\/span><\/h6>\n<ol class=\"numbered-list\">\n<li><span>\u062c\u062f\u0648\u0644\u00a0\u06cc\u0627\u00a0<strong>\u0633\u0644\u0648\u0644<\/strong> \u0647\u0627\u06cc\u06cc (\u0627\u0632 \u062c\u0645\u0644\u0647 \u0633\u0631\u0635\u0641\u062d\u0647 \u0647\u0627\u06cc \u0633\u062a\u0648\u0646) \u0631\u0627 \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631 PivotTable \u062e\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f<\/span><strong><span>.<\/span><\/strong><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbkjh8-7b926abd4178d074e901256efbbf8079\">\n#top .hr.hr-invisible.av-l1kbkjh8-7b926abd4178d074e901256efbbf8079{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbkjh8-7b926abd4178d074e901256efbbf8079 hr-invisible  avia-builder-el-14  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-pk4dw4-b120e97f11dbd8263daf224165b90141 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/494%20pivot_create_cells.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f \u0633\u0644\u0648\u0644\" width=\"660\" height=\"373\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbko9f-8dfe5d1f28f376df229e3e0d42a37fea\">\n#top .hr.hr-invisible.av-l1kbko9f-8dfe5d1f28f376df229e3e0d42a37fea{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbko9f-8dfe5d1f28f376df229e3e0d42a37fea hr-invisible  avia-builder-el-16  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbl3m2-7bf3240690aeaddd078d1a9652b47038 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 2. \u0627\u0632 <\/span><span class=\"goog-text-highlight\">\u062a\u0628\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">Insert \u0631\u0648\u06cc \u062f\u0633\u062a\u0648\u0631\u00a0<\/span><\/span><\/strong><strong><span><span class=\"goog-text-highlight\">PivotTable<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\"> \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/span><\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kblcd8-6fb523c7dfdaff6e6b416737a1503fea\">\n#top .hr.hr-invisible.av-l1kblcd8-6fb523c7dfdaff6e6b416737a1503fea{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kblcd8-6fb523c7dfdaff6e6b416737a1503fea hr-invisible  avia-builder-el-18  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-nhccb8-e2011049195d49680db19cb755e36e06 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/495%20pivot_create_command.png\" alt=\"\u062f\u0633\u062a\u0648\u0631 \u0627\u06cc\u062c\u0627\u062f pivot\" width=\"660\" height=\"256\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kblj4d-5e8312412f4ef69a022684e6e8159798\">\n#top .hr.hr-invisible.av-l1kblj4d-5e8312412f4ef69a022684e6e8159798{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kblj4d-5e8312412f4ef69a022684e6e8159798 hr-invisible  avia-builder-el-20  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbm31p-e19bb27feee4522a310afff2ece4b157 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"\">\u00a0 \u00a0 \u00a0 3. \u06a9\u0627\u062f\u0631 <\/span><span class=\"\">\u0645\u062d\u0627\u0648\u0631\u0647 \u0627\u06cc\u00a0<\/span><\/span><strong><span><span class=\"\">Create PivotTable \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.\u00a0<\/span><\/span><\/strong><span>\u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u062e\u0648\u062f \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f\u060c \u0633\u067e\u0633 \u0631\u0648\u06cc\u00a0<\/span><strong><span>OK<\/span><\/strong><span> \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u062e\u0648\u062f\u060c \u0627\u0632\u00a0<\/span><strong><span>Table1<\/span><\/strong><span>\u00a0\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062f\u0627\u062f\u0647 \u0645\u0646\u0628\u0639 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 PivotTable \u0631\u0627 \u062f\u0631 \u06cc\u06a9\u00a0<\/span><strong><span>\u06a9\u0627\u0631\u0628\u0631\u06af \u062c\u062f\u06cc\u062f<\/span><\/strong><span> \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u06cc\u0645.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbmbgm-c1818e322adb122c502759dcd5d75631\">\n#top .hr.hr-invisible.av-l1kbmbgm-c1818e322adb122c502759dcd5d75631{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbmbgm-c1818e322adb122c502759dcd5d75631 hr-invisible  avia-builder-el-22  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-m5536c-b5016906d0313979d7b1d311ee16e77f '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/496%20pivot_create_dialog.png\" alt=\"\u06a9\u0627\u062f\u0631 \u0645\u062d\u0627\u0648\u0631\u0647 \u0627\u06cc \u0627\u06cc\u062c\u0627\u062f piovt\" width=\"387\" height=\"346\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbmfr8-2aa8b097ad9ee7ef67de4854d51e9946\">\n#top .hr.hr-invisible.av-l1kbmfr8-2aa8b097ad9ee7ef67de4854d51e9946{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbmfr8-2aa8b097ad9ee7ef67de4854d51e9946 hr-invisible  avia-builder-el-24  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbmyg1-5f7e7d78aa13a66b8a09994b57dd6e1e '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 4.<\/span><strong><span><span class=\"goog-text-highlight\"> \u06cc\u06a9 PivotTable<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u0648\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0644\u06cc\u0633\u062a \u0641\u06cc\u0644\u062f<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u062e\u0627\u0644\u06cc\u00a0<\/span><span class=\"goog-text-highlight\">\u062f\u0631 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631\u06af \u062c\u062f\u06cc\u062f \u0638\u0627\u0647\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/span><\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbn79d-119b0c95067c7ac4d9007fd1c8306e11\">\n#top .hr.hr-invisible.av-l1kbn79d-119b0c95067c7ac4d9007fd1c8306e11{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbn79d-119b0c95067c7ac4d9007fd1c8306e11 hr-invisible  avia-builder-el-26  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-k1i6hg-6138d34083e5dbe07abf3f5cf31c56e1 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/497%20pivot_create_blank2.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f \u062e\u0627\u0644\u06cc\" width=\"671\" height=\"607\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbndzz-5d729be5d27df5943fa320033c1f95af\">\n#top .hr.hr-invisible.av-l1kbndzz-5d729be5d27df5943fa320033c1f95af{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbndzz-5d729be5d27df5943fa320033c1f95af hr-invisible  avia-builder-el-28  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbozgt-0adadd5e12eab14521e0bce5b033ddbd '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 5. \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 PivotTable \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u062a\u0635\u0645\u06cc\u0645 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u06a9\u062f\u0627\u0645 <\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0641\u06cc\u0644\u062f\u0647\u0627<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.\u00a0<\/span>\u0647\u0631 \u0641\u06cc\u0644\u062f \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u06cc\u06a9 \u0633\u0631\u00a0<\/span><strong><span>\u0633\u062a\u0648\u0646<\/span><\/strong><span>\u00a0\u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u0646\u0628\u0639 \u0627\u0633\u062a.\u00a0\u062f\u0631 \u0644\u06cc\u0633\u062a\u00a0<\/span><strong><span>PivotTable\u00a0<\/span><\/strong><strong><span>Fields<\/span><\/strong><span>\u060c \u06a9\u0627\u062f\u0631 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0647\u0631 \u0641\u06cc\u0644\u062f\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f \u0639\u0644\u0627\u0645\u062a \u0628\u0632\u0646\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0644\u00a0<\/span><strong><span>\u0645\u0628\u0644\u063a<\/span><\/strong><span>\u00a0\u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0647\u0631\u00a0<\/span><strong><span>\u0641\u0631\u0648\u0634\u0646\u062f\u0647<\/span><\/strong><span>\u00a0\u0631\u0627 \u0628\u062f\u0627\u0646\u06cc\u0645\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u00a0<\/span><strong><span>\u0641\u06cc\u0644\u062f\u0647\u0627\u06cc<\/span><\/strong><span><strong> Salesperson<\/strong> \u0648 <strong>Order Amount<\/strong><\/span>\u00a0<span>\u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbp8cv-eca7173070cdaa0a74cbc409c97bdab9\">\n#top .hr.hr-invisible.av-l1kbp8cv-eca7173070cdaa0a74cbc409c97bdab9{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbp8cv-eca7173070cdaa0a74cbc409c97bdab9 hr-invisible  avia-builder-el-30  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-jb418k-ed1ed7f63ea1d10302af4d8c9493ebf3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/498%20pivot_create_fields.png\" alt=\"\u0627\u06cc\u062c\u0627\u062f \u0641\u06cc\u0644\u062f\u0647\u0627\" width=\"318\" height=\"288\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbpdhf-52ef19bf86ab55c1ff1e67816e991ede\">\n#top .hr.hr-invisible.av-l1kbpdhf-52ef19bf86ab55c1ff1e67816e991ede{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbpdhf-52ef19bf86ab55c1ff1e67816e991ede hr-invisible  avia-builder-el-32  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbpzyw-de6424327dad57aad457aab89fdc1e04 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 6. \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0628\u0647 \u06cc\u06a9\u06cc \u0627\u0632 \u0686\u0647\u0627\u0631 \u0646\u0627\u062d\u06cc\u0647 \u0632\u06cc\u0631 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f. <\/span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c \u0642\u0633\u0645\u062a\u00a0<\/span><strong><span>Salesperson<\/span><\/strong><span>\u00a0\u0628\u0647 \u0642\u0633\u0645\u062a\u00a0<\/span><strong><span>Rows<\/span><\/strong><span>\u00a0\u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647\u00a0<\/span><strong><span>Order Amount<\/span><\/strong><span>\u00a0\u0628\u0647\u00a0<\/span><strong><span>Values<\/span><\/strong><span> \u200b\u200b\u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.\u00a0\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f\u00a0\u0641\u06cc\u0644\u062f\u0647\u0627 \u0631\u0627 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u062f\u0631 \u0646\u0627\u062d\u06cc\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\u00a0<\/span><strong><span>\u0628\u06a9\u0634\u06cc\u062f\u00a0<\/span><\/strong><strong><span>\u0648 \u0631\u0647\u0627 \u06a9\u0646\u06cc\u062f.<\/span><\/strong><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbq9ch-070a366938cf126a681a37882758611a\">\n#top .hr.hr-invisible.av-l1kbq9ch-070a366938cf126a681a37882758611a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbq9ch-070a366938cf126a681a37882758611a hr-invisible  avia-builder-el-34  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-guyles-121032c8078663029f2a61720f27edeb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/499%20pivot_create_drag.png\" alt=\"\u0631\u0647\u0627 \u06a9\u0631\u062f\u0646 \u0648 \u0627\u06cc\u062c\u0627\u062f\" width=\"318\" height=\"612\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbqeau-ec3fac615a5b9c4be22920d25b66a44a\">\n#top .hr.hr-invisible.av-l1kbqeau-ec3fac615a5b9c4be22920d25b66a44a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbqeau-ec3fac615a5b9c4be22920d25b66a44a hr-invisible  avia-builder-el-36  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbqw4r-5266fe731b5dc414cff3bc44335a0a62 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 7. PivotTable \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0648 \u062e\u0644\u0627\u0635\u0647 \u0645\u06cc \u06a9\u0646\u062f. <\/span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c PivotTable\u00a0<\/span><strong><span>\u0645\u0642\u062f\u0627\u0631 \u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0647\u0631 \u0641\u0631\u0648\u0634\u0646\u062f\u0647<\/span><\/strong><span> \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbr6yj-0e2c2d0e8b99168911c0def64ea668d1\">\n#top .hr.hr-invisible.av-l1kbr6yj-0e2c2d0e8b99168911c0def64ea668d1{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbr6yj-0e2c2d0e8b99168911c0def64ea668d1 hr-invisible  avia-builder-el-38  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-g6t944-061a86be4a664a53977291fc388a34b5 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/500%20pivot_create_table.png\" alt=\"\u0627\u06cc\u062d\u0627\u062f \u062c\u062f\u0648\u0644\" width=\"730\" height=\"607\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbrcxx-629339796b03f9720fdf0a96518e0703\">\n#top .hr.hr-invisible.av-l1kbrcxx-629339796b03f9720fdf0a96518e0703{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbrcxx-629339796b03f9720fdf0a96518e0703 hr-invisible  avia-builder-el-40  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbs06c-e44a16764e35ff469f662e729c736c42 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u062f\u0631\u0633\u062a \u0645\u0627\u0646\u0646\u062f \u0635\u0641\u062d\u0627\u062a \u06af\u0633\u062a\u0631\u062f\u0647 \u0645\u0639\u0645\u0648\u0644\u06cc\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 PivotTable \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">Sort &#038; Filter<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u062f\u0631 \u0628\u0631\u06af\u0647 Home \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u062f.\u00a0<\/span>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0647\u0631 \u0646\u0648\u0639\u00a0<\/span><strong><span>\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0639\u062f\u062f\u06cc<\/span><\/strong><span>\u00a0\u0631\u0627 \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f.\u00a0\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0642\u0627\u0644\u0628 \u0634\u0645\u0627\u0631\u0647 \u0631\u0627 \u0628\u0647\u00a0<\/span><strong><span>\u0627\u0631\u0632<\/span><\/strong><span> \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.\u00a0\u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0648\u0642\u062a\u06cc PivotTable \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u062f\u0647\u06cc\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0631\u062e\u06cc \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u0646\u0627\u067e\u062f\u06cc\u062f \u0634\u0648\u0646\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbs9hm-3701cb5c4cbc45e8ba1e8dff707d3c7a\">\n#top .hr.hr-invisible.av-l1kbs9hm-3701cb5c4cbc45e8ba1e8dff707d3c7a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbs9hm-3701cb5c4cbc45e8ba1e8dff707d3c7a hr-invisible  avia-builder-el-42  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-dw6i2c-0d5737f6e039d3ba01355469a507967d '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/501%20pivot_create_formatting.png\" alt=\"\u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc\" width=\"335\" height=\"221\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbseyr-5ae74a926af36017170cf4b54988aff8\">\n#top .hr.hr-invisible.av-l1kbseyr-5ae74a926af36017170cf4b54988aff8{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbseyr-5ae74a926af36017170cf4b54988aff8 hr-invisible  avia-builder-el-44  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbu7lm-de74c961fb6cb8f6a6d59657bb578764 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p class=\"attention\"><span><span class=\"goog-text-highlight\">\u0627\u06af\u0631 \u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06af \u0645\u0646\u0628\u0639 \u062e\u0648\u062f \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f\u060c PivotTable\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0628\u0647 \u0631\u0648\u0632 \u0646\u0645\u06cc \u0634\u0648\u062f<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">.\u00a0<\/span>\u0628\u0631\u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u062f\u0633\u062a\u06cc \u0622\u0646\u060c PivotTable \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u0648 \u0633\u067e\u0633 \u0628\u0647\u00a0<\/span><strong><span>Analyze > Refresh<\/span><\/strong><span> \u0628\u0631\u0648\u06cc\u062f.<\/span><\/p>\n<h5><span>\u0686\u0631\u062e\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627<\/span><\/h5>\n<p><span>\u06cc\u06a9\u06cc \u0627\u0632 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0686\u06cc\u0632\u0647\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f PivotTables \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0633\u0631\u0639\u062a \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0634\u0645\u0627 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u0646\u062f &#8211; \u06cc\u0627\u00a0<\/span><strong><span>\u0633\u0627\u0632\u0645\u0627\u0646\u062f\u0647\u06cc<\/span><\/strong><span>\u00a0\u0645\u062c\u062f\u062f \u06a9\u0646\u0646\u062f \u0648 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u0646\u062f \u06a9\u0627\u0631\u0628\u0631\u06af \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f.\u00a0\u0686\u0631\u062e\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u06a9\u0646\u062f \u0628\u0647\u00a0<\/span><strong><span>\u0633\u0624\u0627\u0644\u0627\u062a \u0645\u062e\u062a\u0644\u0641 \u067e\u0627\u0633\u062e<\/span><\/strong><span>\u00a0\u062f\u0647\u06cc\u062f \u0648 \u062d\u062a\u06cc\u00a0\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0634\u0641 \u0631\u0648\u0646\u062f\u0647\u0627 \u0648 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u00a0<\/span><strong><span>\u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f.<\/span><\/strong><\/p>\n<h6><span><span class=\"\">\u0628\u0631\u0627\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0633\u062a\u0648\u0646 \u0647\u0627:<\/span><\/span><\/h6>\n<p><span>\u062a\u0627 \u06a9\u0646\u0648\u0646\u060c PivotTable \u0645\u0627 \u062a\u0646\u0647\u0627\u00a0<\/span><strong><span>\u06cc\u06a9 \u0633\u062a\u0648\u0646<\/span><\/strong><span>\u00a0\u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0647\u0631 \u0632\u0645\u0627\u0646 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.\u00a0\u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634\u00a0<\/span><strong><span>\u0686\u0646\u062f\u06cc\u0646 \u0633\u062a\u0648\u0646<\/span><\/strong><span>\u060c \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u0628\u0647 \u0642\u0633\u0645\u062a\u00a0<\/span><strong><span>\u0633\u062a\u0648\u0646\u200c\u0647\u0627<\/span><\/strong><span> \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<ol class=\"numbered-list\">\n<li><span>\u0641\u06cc\u0644\u062f\u06cc \u0631\u0627 \u0627\u0632\u00a0<\/span><strong><span>\u0644\u06cc\u0633\u062a<\/span><\/strong><span>\u00a0\u0641\u06cc\u0644\u062f\u0647\u0627 \u0628\u0647 \u0642\u0633\u0645\u062a\u00a0<\/span><strong><span>\u0633\u062a\u0648\u0646 \u0647\u0627<\/span><\/strong><span> \u0628\u06a9\u0634\u06cc\u062f.\u00a0\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627 \u0627\u0632\u00a0\u0641\u06cc\u0644\u062f\u00a0<\/span><strong><span>Month \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/span><\/strong><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbug4n-ab729cf2c34f048dd7fc76077dac56c5\">\n#top .hr.hr-invisible.av-l1kbug4n-ab729cf2c34f048dd7fc76077dac56c5{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbug4n-ab729cf2c34f048dd7fc76077dac56c5 hr-invisible  avia-builder-el-46  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-19ejms-c0b539d4328ac945fe91649a5238fc80 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/502%20pivot_column_add2.png\" alt=\"\u0627\u0636\u0627\u0641 \u06a9\u0631\u062f\u0646 \u0633\u062a\u0648\u0646\" width=\"339\" height=\"613\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbumnw-ef0f44bc980692ecaab70028a150a33a\">\n#top .hr.hr-invisible.av-l1kbumnw-ef0f44bc980692ecaab70028a150a33a{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbumnw-ef0f44bc980692ecaab70028a150a33a hr-invisible  avia-builder-el-48  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbw82e-767a9d8ecd2a9bb77316880d36df3dc3 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 2. PivotTable \u0634\u0627\u0645\u0644 \u0686\u0646\u062f\u06cc\u0646 \u0633\u062a\u0648\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. <\/span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c \u0627\u06a9\u0646\u0648\u0646 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0628\u0631\u0627\u06cc\u00a0<\/span><strong><span>\u0641\u0631\u0648\u0634 \u0645\u0627\u0647\u0627\u0646\u0647 (monthly sales)<\/span><\/strong><span>\u00a0\u0647\u0631 \u0641\u0631\u062f\u060c \u0639\u0644\u0627\u0648\u0647 \u0628\u0631\u00a0<\/span><strong><span>\u06a9\u0644 (grand total)<\/span><\/strong><span>\u00a0\u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbwgzz-c91fed170e96364d2315f799319edbc0\">\n#top .hr.hr-invisible.av-l1kbwgzz-c91fed170e96364d2315f799319edbc0{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbwgzz-c91fed170e96364d2315f799319edbc0 hr-invisible  avia-builder-el-50  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-aahnd0-ad6109e793111a41d3fbb8bc2831cfcc '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/503%20pivot_column_table.png\" alt=\"\u0633\u062a\u0648\u0646 \u062c\u062f\u0648\u0644\" width=\"760\" height=\"555\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbwm04-b39acdd31e52633ab617ad744b8eb8d1\">\n#top .hr.hr-invisible.av-l1kbwm04-b39acdd31e52633ab617ad744b8eb8d1{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbwm04-b39acdd31e52633ab617ad744b8eb8d1 hr-invisible  avia-builder-el-52  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbxwsu-bbb05ffe4196edb4e0c0d34c125b7792 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h6><span><span class=\"goog-text-highlight\">\u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0633\u0637\u0631 \u06cc\u0627 \u0633\u062a\u0648\u0646:<\/span><\/span><\/h6>\n<p><strong><span>\u062a\u063a\u06cc\u06cc\u0631<\/span><\/strong><span>\u00a0\u06cc\u06a9 \u0633\u0637\u0631 \u06cc\u0627 \u0633\u062a\u0648\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062f\u06cc\u062f\u06af\u0627\u0647\u06cc \u06a9\u0627\u0645\u0644\u0627 \u0645\u062a\u0641\u0627\u0648\u062a \u062f\u0631 \u0645\u0648\u0631\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u062a\u0627\u0646 \u0628\u0647 \u0634\u0645\u0627 \u0628\u062f\u0647\u062f.\u00a0\u062a\u0646\u0647\u0627 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0641\u06cc\u0644\u062f \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627\u00a0<\/span><strong><span>\u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f<\/span><\/strong><span>\u060c \u0633\u067e\u0633 \u0622\u0646 \u0631\u0627 \u0628\u0627 \u0641\u06cc\u0644\u062f \u062f\u06cc\u06af\u0631\u06cc\u00a0<\/span><strong><span>\u062c\u0627\u06cc\u06af\u0632\u06cc\u0646<\/span><\/strong><span>\u00a0\u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<ol class=\"numbered-list\">\n<li><span>\u0641\u06cc\u0644\u062f\u06cc \u0631\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f \u0627\u0632\u00a0<\/span><strong><span>\u0646\u0627\u062d\u06cc\u0647 \u0641\u0639\u0644\u06cc<\/span><\/strong><span> \u0622\u0646 \u0628\u06a9\u0634\u06cc\u062f.\u00a0\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f\u00a0<\/span><strong><span>\u0639\u0644\u0627\u0645\u062a<\/span><\/strong><span>\u00a0\u06a9\u0627\u062f\u0631 \u0645\u0646\u0627\u0633\u0628 \u0631\u0627 \u062f\u0631\u00a0<\/span><strong><span>\u0641\u0647\u0631\u0633\u062a \u0641\u06cc\u0644\u062f<\/span><\/strong><span> \u0628\u0631\u062f\u0627\u0631\u06cc\u062f.\u00a0\u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644\u060c\u00a0\u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u00a0Month<\/span><span> \u0648 Salesperson<\/span><strong><span>\u00a0\u0631\u0627 \u062d\u0630\u0641 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u0645.<\/span><\/strong><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kby7aw-e66a0a4ba92d0c7352739226b587d48d\">\n#top .hr.hr-invisible.av-l1kby7aw-e66a0a4ba92d0c7352739226b587d48d{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kby7aw-e66a0a4ba92d0c7352739226b587d48d hr-invisible  avia-builder-el-54  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-968qv8-b90f2bc966c48a7e55cd620953354006 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/504%20pivot_row_remove.png\" alt=\"\u062d\u0630\u0641 \u0633\u0637\u0631\" width=\"440\" height=\"613\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbybvf-1c2d6f97d132eafd538a75d22dfb818d\">\n#top .hr.hr-invisible.av-l1kbybvf-1c2d6f97d132eafd538a75d22dfb818d{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbybvf-1c2d6f97d132eafd538a75d22dfb818d hr-invisible  avia-builder-el-56  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kbyz59-0bbf2bbb0596b89cbdb42cd11180dd48 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 2.<\/span><strong><span><span class=\"goog-text-highlight\"> \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u062c\u062f\u06cc\u062f \u0631\u0627<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\">\u00a0\u0628\u0647\u00a0<\/span><\/span><strong><span><span class=\"goog-text-highlight\">\u0646\u0627\u062d\u06cc\u0647 \u0645\u0648\u0631\u062f \u0646\u0638\u0631<\/span><\/span><\/strong><span><span class=\"goog-text-highlight\"> \u0628\u06a9\u0634\u06cc\u062f<\/span><span class=\"goog-text-highlight\">.\u00a0<\/span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u062e\u0648\u062f\u060c\u00a0\u0641\u06cc\u0644\u062f\u00a0<\/span><strong><span>Region \u0631\u0627 \u062f\u0631 \u0632\u06cc\u0631\u00a0<\/span><\/strong><strong><span>\u0631\u062f\u06cc\u0641<\/span><\/strong><span> \u0647\u0627 \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u06cc\u0645.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbz959-9b403fb6cf49ea757b9af2e7fcaf07e0\">\n#top .hr.hr-invisible.av-l1kbz959-9b403fb6cf49ea757b9af2e7fcaf07e0{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbz959-9b403fb6cf49ea757b9af2e7fcaf07e0 hr-invisible  avia-builder-el-58  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-89cz4k-ff0dde20b6a818b78ace86e003c3f683 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/505%20pivot_row_add.png\" alt=\"\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0633\u0637\u0631\" width=\"339\" height=\"613\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kbze3n-290a265a0e42a905d5decfedad1dd7bc\">\n#top .hr.hr-invisible.av-l1kbze3n-290a265a0e42a905d5decfedad1dd7bc{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kbze3n-290a265a0e42a905d5decfedad1dd7bc hr-invisible  avia-builder-el-60  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kc0xp6-955869542ca92c17ac1f20370ee16695 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span><span class=\"goog-text-highlight\">\u00a0 \u00a0 \u00a0 \u00a03. PivotTable \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f \u06cc\u0627 \u0645\u062d\u0648\u0631 \u0627\u0635\u0644\u06cc \u06a9\u0627\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f. <\/span>\u062f\u0631 \u0645\u062b\u0627\u0644 \u0645\u0627\u060c \u0627\u06a9\u0646\u0648\u0646\u00a0<\/span><strong><span>\u0645\u0642\u062f\u0627\u0631 \u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0647\u0631 \u0645\u0646\u0637\u0642\u0647<\/span><\/strong><span> \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f.<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kc16yq-df961c93adc87ae823cfb4bd081cd24c\">\n#top .hr.hr-invisible.av-l1kc16yq-df961c93adc87ae823cfb4bd081cd24c{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kc16yq-df961c93adc87ae823cfb4bd081cd24c hr-invisible  avia-builder-el-62  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-69udxw-45a86a4a570ddcd89d7ca07099e5e94c '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/506%20pivot_row_table.png\" alt=\"\u0633\u0637\u0631 \u062c\u062f\u0648\u0644\" width=\"666\" height=\"555\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kc1cxx-407c72f3c4249a672555ea4f89497dab\">\n#top .hr.hr-invisible.av-l1kc1cxx-407c72f3c4249a672555ea4f89497dab{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kc1cxx-407c72f3c4249a672555ea4f89497dab hr-invisible  avia-builder-el-64  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kc2or3-7db72a0c44789dc0c261587bb89bb3c2 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><h5><span><span class=\"goog-text-highlight\">\u0686\u0627\u0644\u0634!<\/span><\/span><\/h5>\n<ol class=\"numbered-list\">\n<li><a href=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/workfile\/24%20excel_intropivottables_practice.xlsx\"><span>\u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u062a\u0645\u0631\u06cc\u0646\u06cc<\/span><\/a><span>\u00a0\u0645\u0627 \u0631\u0627 \u0628\u0627\u0632\u00a0\u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<li><span>\u06cc\u06a9\u00a0<\/span><strong><span>PivotTable<\/span><\/strong><span>\u00a0\u062f\u0631 \u06cc\u06a9 \u0628\u0631\u06af\u0647 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.<\/span><\/li>\n<li><span>\u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0647 \u0627\u06cc\u0646 \u0633\u0648\u0627\u0644 \u067e\u0627\u0633\u062e \u062f\u0647\u06cc\u0645\u00a0<\/span><strong><span>\u06a9\u0647 \u06a9\u0644 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u062e\u062a\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0647\u0631 \u0645\u0646\u0637\u0642\u0647 \u0686\u0642\u062f\u0631 \u0627\u0633\u062a\u061f\u00a0<\/span><\/strong><span>\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c <strong>Region<\/strong><\/span><span> \u0648 <strong>Order Amount<\/strong><\/span><span>\u00a0\u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.\u00a0\u0648\u0642\u062a\u06cc \u06a9\u0627\u0631\u062a\u0627\u0646 \u062a\u0645\u0627\u0645 \u0634\u062f\u060c \u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/span><\/li>\n<\/ol>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kc5qaj-24e252f4567bd947196a7d139bc5edca\">\n#top .hr.hr-invisible.av-l1kc5qaj-24e252f4567bd947196a7d139bc5edca{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kc5qaj-24e252f4567bd947196a7d139bc5edca hr-invisible  avia-builder-el-66  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-gso0k-53dd8bf756b201fd18b7dc27d41be13b '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/507%20screen%20shot%202015-11-27%20at%209.54.09%20am.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 \u0686\u0627\u0644\u0634 \u06cc\u06a9\" width=\"261\" height=\"118\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kc5ykk-05e86dfb7f4dbc75f31a7f279e40d043\">\n#top .hr.hr-invisible.av-l1kc5ykk-05e86dfb7f4dbc75f31a7f279e40d043{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kc5ykk-05e86dfb7f4dbc75f31a7f279e40d043 hr-invisible  avia-builder-el-68  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-l1kc7d6q-d947ecbc657b019dc53f311835ec2b85 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><span>\u00a0 \u00a0 \u00a0 4. \u062f\u0631 \u0642\u0633\u0645\u062a <\/span><strong><span>Rows\u00a0 <\/span><\/strong><strong><span>Region<\/span><\/strong><span>\u00a0\u0631\u0627 \u0628\u0631\u062f\u0627\u0631\u06cc\u062f\u00a0\u0648 \u0622\u0646 \u0631\u0627 \u0628\u0627\u00a0<\/span><strong><span>Salesperson<\/span><\/strong><span> \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<p>5.<strong><span> Month<\/span><\/strong><span>\u00a0\u0631\u0627 \u0628\u0647 \u0642\u0633\u0645\u062a\u00a0<\/span><strong><span>\u0633\u062a\u0648\u0646 \u0647\u0627<\/span><\/strong><span> \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/span><\/p>\n<p><span>\u00a0 \u00a0 \u00a0 6. \u0642\u0627\u0644\u0628 \u0634\u0645\u0627\u0631\u0647 \u0633\u0644\u0648\u0644 \u0647\u0627\u06cc <\/span><strong><span>B5:E13<\/span><\/strong><span>\u00a0\u0631\u0627 \u0628\u0647\u00a0<\/span><strong><span>\u0627\u0631\u0632<\/span><\/strong><span> \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.\u00a0<\/span><strong><span>\u062a\u0648\u062c\u0647<\/span><\/strong><span>\u00a0: \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc C \u0648 D \u0631\u0627 \u06af\u0633\u062a\u0631\u062f\u0647 \u062a\u0631 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/span><\/p>\n<p><span>\u00a0 \u00a0 \u00a0 7. \u0648\u0642\u062a\u06cc \u06a9\u0627\u0631\u062a\u0627\u0646 \u062a\u0645\u0627\u0645 \u0634\u062f\u060c \u06a9\u062a\u0627\u0628 \u06a9\u0627\u0631 \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0627\u0634\u062f:<\/span><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kc7m0e-1cded29f5041c19b1353ad1985389c3e\">\n#top .hr.hr-invisible.av-l1kc7m0e-1cded29f5041c19b1353ad1985389c3e{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kc7m0e-1cded29f5041c19b1353ad1985389c3e hr-invisible  avia-builder-el-70  el_after_av_textblock  el_before_av_textblock '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<section  class='av_textblock_section av-25d3dw-5eb95fc16b72cc940efdd1879e2a1f53 '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium\" src=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/508%20screen%20shot%202015-12-01%20at%209.09.34%20am.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 \u0686\u0627\u0644\u0634 2\" width=\"789\" height=\"602\" \/><\/p>\n<\/div><\/section>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-l1kc7qsd-0eec029f3561b81f877d06ba287fd002\">\n#top .hr.hr-invisible.av-l1kc7qsd-0eec029f3561b81f877d06ba287fd002{\nheight:25px;\n}\n<\/style>\n<div  class='hr av-l1kc7qsd-0eec029f3561b81f877d06ba287fd002 hr-invisible  avia-builder-el-72  el_after_av_textblock  avia-builder-el-last '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\n<div class=\"pld-like-dislike-wrap pld-template-1\">\r\n    <div class=\"pld-like-wrap  pld-common-wrap\">\r\n    <a href=\"javascript:void(0)\" class=\"pld-like-trigger pld-like-dislike-trigger  \" title=\"\u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f\u06cc\" data-post-id=\"1348\" data-trigger-type=\"like\" data-restriction=\"cookie\" data-already-liked=\"0\">\r\n                        <i class=\"fas fa-thumbs-up\"><\/i>\r\n                <\/a>\r\n    <span class=\"pld-like-count-wrap pld-count-wrap\">0    <\/span>\r\n<\/div><div class=\"pld-dislike-wrap  pld-common-wrap\">\r\n    <a href=\"javascript:void(0)\" class=\"pld-dislike-trigger pld-like-dislike-trigger  \" title=\"\u0639\u062f\u0645 \u0639\u0644\u0627\u0642\u0647 \u0645\u0646\u062f\u06cc\" data-post-id=\"1348\" data-trigger-type=\"dislike\" data-restriction=\"cookie\" data-already-liked=\"0\">\r\n                        <i class=\"fas fa-thumbs-down\"><\/i>\r\n                <\/a>\r\n    <span class=\"pld-dislike-count-wrap pld-count-wrap\">0<\/span>\r\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>0 0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,39,34],"tags":[],"class_list":["post-1348","post","type-post","status-publish","format-standard","hentry","category-icdl","category-doing-more-with-excel","category-third-skill"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.5 (Yoast SEO v28.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>\u0645\u0639\u0631\u0641\u06cc PivotTables - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/irtecnology.ir\/?p=1348\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0645\u0639\u0631\u0641\u06cc PivotTables\" \/>\n<meta property=\"og:description\" content=\"0 0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/irtecnology.ir\/?p=1348\" \/>\n<meta property=\"og:site_name\" content=\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-05T06:40:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-05T06:40:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png\" \/>\n<meta name=\"author\" content=\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348\"},\"author\":{\"name\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#\\\/schema\\\/person\\\/a61ed5dd4c2b305ed9d55d3eacd6a8dd\"},\"headline\":\"\u0645\u0639\u0631\u0641\u06cc PivotTables\",\"datePublished\":\"2022-04-05T06:40:06+00:00\",\"dateModified\":\"2022-04-05T06:40:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348\"},\"wordCount\":3857,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/491%20pivot_question_sheet.png\",\"articleSection\":[\"ICDL\",\"\u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u0627\u06a9\u0633\u0644\",\"\u0645\u0647\u0627\u0631\u062a \u0633\u0648\u0645\"],\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348\",\"url\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348\",\"name\":\"\u0645\u0639\u0631\u0641\u06cc PivotTables - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/491%20pivot_question_sheet.png\",\"datePublished\":\"2022-04-05T06:40:06+00:00\",\"dateModified\":\"2022-04-05T06:40:10+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#\\\/schema\\\/person\\\/a61ed5dd4c2b305ed9d55d3eacd6a8dd\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/irtecnology.ir\\\/?p=1348\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#primaryimage\",\"url\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/491%20pivot_question_sheet.png\",\"contentUrl\":\"https:\\\/\\\/files.irtecnology.ir\\\/files.irtecnology.ir\\\/image2\\\/491%20pivot_question_sheet.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/?p=1348#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0635\u0641\u062d\u0647 \u0627\u0635\u0644\u06cc\",\"item\":\"https:\\\/\\\/irtecnology.ir\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0645\u0639\u0631\u0641\u06cc PivotTables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#website\",\"url\":\"https:\\\/\\\/irtecnology.ir\\\/\",\"name\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"description\":\"\u067e\u06cc\u0634\u0641\u0631\u062a \u0631\u0627\u0647\u0628\u0631\u062f\u06cc \u0634\u0645\u0627\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/irtecnology.ir\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/irtecnology.ir\\\/#\\\/schema\\\/person\\\/a61ed5dd4c2b305ed9d55d3eacd6a8dd\",\"name\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g\",\"caption\":\"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646\"},\"sameAs\":[\"http:\\\/\\\/irtecnology.ir\"],\"url\":\"https:\\\/\\\/irtecnology.ir\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0645\u0639\u0631\u0641\u06cc PivotTables - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","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:\/\/irtecnology.ir\/?p=1348","og_locale":"fa_IR","og_type":"article","og_title":"\u0645\u0639\u0631\u0641\u06cc PivotTables","og_description":"0 0","og_url":"https:\/\/irtecnology.ir\/?p=1348","og_site_name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","article_published_time":"2022-04-05T06:40:06+00:00","article_modified_time":"2022-04-05T06:40:10+00:00","og_image":[{"url":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png","type":"","width":"","height":""}],"author":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","twitter_card":"summary_large_image","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"16 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/irtecnology.ir\/?p=1348#article","isPartOf":{"@id":"https:\/\/irtecnology.ir\/?p=1348"},"author":{"name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","@id":"https:\/\/irtecnology.ir\/#\/schema\/person\/a61ed5dd4c2b305ed9d55d3eacd6a8dd"},"headline":"\u0645\u0639\u0631\u0641\u06cc PivotTables","datePublished":"2022-04-05T06:40:06+00:00","dateModified":"2022-04-05T06:40:10+00:00","mainEntityOfPage":{"@id":"https:\/\/irtecnology.ir\/?p=1348"},"wordCount":3857,"commentCount":0,"image":{"@id":"https:\/\/irtecnology.ir\/?p=1348#primaryimage"},"thumbnailUrl":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png","articleSection":["ICDL","\u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u0627\u06a9\u0633\u0644","\u0645\u0647\u0627\u0631\u062a \u0633\u0648\u0645"],"inLanguage":"fa-IR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/irtecnology.ir\/?p=1348#respond"]}]},{"@type":"WebPage","@id":"https:\/\/irtecnology.ir\/?p=1348","url":"https:\/\/irtecnology.ir\/?p=1348","name":"\u0645\u0639\u0631\u0641\u06cc PivotTables - \u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","isPartOf":{"@id":"https:\/\/irtecnology.ir\/#website"},"primaryImageOfPage":{"@id":"https:\/\/irtecnology.ir\/?p=1348#primaryimage"},"image":{"@id":"https:\/\/irtecnology.ir\/?p=1348#primaryimage"},"thumbnailUrl":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png","datePublished":"2022-04-05T06:40:06+00:00","dateModified":"2022-04-05T06:40:10+00:00","author":{"@id":"https:\/\/irtecnology.ir\/#\/schema\/person\/a61ed5dd4c2b305ed9d55d3eacd6a8dd"},"breadcrumb":{"@id":"https:\/\/irtecnology.ir\/?p=1348#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/irtecnology.ir\/?p=1348"]}]},{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/irtecnology.ir\/?p=1348#primaryimage","url":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png","contentUrl":"https:\/\/files.irtecnology.ir\/files.irtecnology.ir\/image2\/491%20pivot_question_sheet.png"},{"@type":"BreadcrumbList","@id":"https:\/\/irtecnology.ir\/?p=1348#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0635\u0641\u062d\u0647 \u0627\u0635\u0644\u06cc","item":"https:\/\/irtecnology.ir\/"},{"@type":"ListItem","position":2,"name":"\u0645\u0639\u0631\u0641\u06cc PivotTables"}]},{"@type":"WebSite","@id":"https:\/\/irtecnology.ir\/#website","url":"https:\/\/irtecnology.ir\/","name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","description":"\u067e\u06cc\u0634\u0641\u0631\u062a \u0631\u0627\u0647\u0628\u0631\u062f\u06cc \u0634\u0645\u0627","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/irtecnology.ir\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fa-IR"},{"@type":"Person","@id":"https:\/\/irtecnology.ir\/#\/schema\/person\/a61ed5dd4c2b305ed9d55d3eacd6a8dd","name":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/secure.gravatar.com\/avatar\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/23f631a8ef5bb1ab7465514fa4d91b5c7139705dd4d8974ee66040d11dfe8f1f?s=96&d=mm&r=g","caption":"\u062a\u06a9\u0646\u0648\u0644\u0648\u0698\u06cc \u0627\u06cc\u0631\u0627\u0646"},"sameAs":["http:\/\/irtecnology.ir"],"url":"https:\/\/irtecnology.ir\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts\/1348","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1348"}],"version-history":[{"count":3,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts\/1348\/revisions"}],"predecessor-version":[{"id":1351,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=\/wp\/v2\/posts\/1348\/revisions\/1351"}],"wp:attachment":[{"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1348"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1348"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/irtecnology.ir\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1348"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}