{"id":35500,"date":"2024-01-03T11:01:06","date_gmt":"2024-01-03T07:31:06","guid":{"rendered":"https:\/\/wpadmin.maktabkhooneh.org\/mag\/?p=35500"},"modified":"2026-04-06T16:42:06","modified_gmt":"2026-04-06T13:12:06","slug":"pivot-table-in-excel","status":"publish","type":"post","link":"https:\/\/maktabkhooneh.org\/mag\/pivot-table-in-excel\/","title":{"rendered":"pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647"},"content":{"rendered":"\n<p>Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0648 \u0645\u0631\u0639\u0648\u0628\u200c\u06a9\u0646\u0646\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0645\u0627\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u062a \u0627\u0633\u062a. pivot table \u062f\u0631 \u062e\u0644\u0627\u0635\u0647\u200c\u0633\u0627\u0632\u06cc \u0648 \u0628\u0627\u0645\u0639\u0646\u0627\u0633\u0627\u062e\u062a\u0646 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0627\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646\u200c\u062d\u0627\u0644\u060c \u0628\u0647 \u067e\u06cc\u0686\u06cc\u062f\u06af\u06cc \u0646\u06cc\u0632 \u0634\u0647\u0631\u0647 \u0627\u0633\u062a. \u062e\u0628\u0631 \u062e\u0648\u0628 \u0622\u0646\u06a9\u0647 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0627\u06cc\u062c\u0627\u062f pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0627\u0633\u062a \u0627\u0632 \u0622\u0646 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u0641\u06a9\u0631 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f. \u0645\u0627 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u06cc\u062c\u0627\u062f pivot table \u0631\u0627 \u0642\u062f\u0645 \u0628\u0647 \u0642\u062f\u0645 \u0628\u0647 \u0634\u0645\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u06cc\u0645. \u0627\u0648\u0644\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062f\u0631\u0628\u0627\u0631\u0647 \u0627\u06cc\u0646 \u0635\u062d\u0628\u062a \u06a9\u0646\u06cc\u0645 \u06a9\u0647 pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0686\u06cc\u0633\u062a \u0648 \u0686\u0631\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0686\u06cc\u0633\u062a\u061f<\/h2>\n\n\n\n<p>Pivot Table \u062e\u0644\u0627\u0635\u0647\u200c\u0627\u06cc \u0628\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc\u200c\u0634\u062f\u0647 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u062f\u0631 \u0686\u0627\u0631\u062a \u0627\u0633\u062a \u06a9\u0647 \u06af\u0632\u0627\u0631\u0634\u200c\u062f\u0647\u06cc \u0648 \u06af\u0634\u062a\u0646 \u0645\u06cc\u0627\u0646 \u0631\u0648\u0646\u062f\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u062a\u0627\u0646 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f. Pivot Tables \u062e\u0635\u0648\u0635\u0627 \u0632\u0645\u0627\u0646\u06cc \u0645\u0641\u06cc\u062f \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0631\u062f\u06cc\u0641 \u06cc\u0627 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0637\u0648\u0644\u0627\u0646\u06cc \u062d\u0627\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u062e\u0644\u0627\u0635\u0647\u200c\u0627\u0634 \u0631\u0627 \u0631\u062f\u06af\u06cc\u0631\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0647\u200c\u0633\u0627\u062f\u06af\u06cc \u0628\u0627 \u0647\u0645 \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<p>\u0628\u0647 \u0639\u0628\u0627\u0631\u062a \u062f\u06cc\u06af\u0631\u060c pivot table\u0647\u0627 \u0627\u0632 \u0635\u0641 \u0637\u0648\u0644\u0627\u0646\u06cc \u0627\u0639\u062f\u0627\u062f \u0631\u0648\u06cc \u0635\u0641\u062d\u0647\u200c\u0646\u0645\u0627\u06cc\u0634 \u0634\u0645\u0627\u060c \u0645\u0639\u0646\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u062f\u0642\u06cc\u0642\u200c\u062a\u0631 \u0628\u06af\u0648\u06cc\u06cc\u0645\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0646\u062a\u06cc\u062c\u0647\u200c\u06af\u06cc\u0631\u06cc\u200c\u0647\u0627\u06cc \u0645\u0641\u06cc\u062f\u06cc \u0628\u06af\u06cc\u0631\u06cc\u062f. \u06a9\u0644\u0645\u0647 pivot\u060c \u0628\u0647 \u0645\u0639\u0646\u0627\u06cc \u0627\u0645\u06a9\u0627\u0646 \u0686\u0631\u062e\u0627\u0646\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a \u062a\u0627 \u0628\u062a\u0648\u0627\u0646 \u0627\u0632 \u0686\u0634\u0645\u200c\u0627\u0646\u062f\u0627\u0632\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0628\u0647 \u0622\u0646\u200c\u0647\u0627 \u0646\u06af\u0627\u0647 \u06a9\u0631\u062f. \u0647\u0646\u06af\u0627\u0645 Pivot\u06a9\u0631\u062f\u0646\u060c \u0634\u0645\u0627 \u0647\u06cc\u0686 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u0645\u0627\u0646\u0646\u062f \u0627\u0636\u0627\u0641\u0647\u200c\u06a9\u0631\u062f\u0646 \u06cc\u0627 \u06a9\u0633\u0631\u06a9\u0631\u062f\u0646 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0646\u062c\u0627\u0645 \u0646\u0645\u06cc\u200c\u062f\u0647\u06cc\u062f. \u062f\u0631 \u0639\u0648\u0636\u060c \u0633\u0627\u0632\u0645\u0627\u0646\u200c\u062f\u0647\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc\u200c\u062f\u0647\u06cc\u062f \u062a\u0627 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0641\u06cc\u062f \u0631\u0627 \u06a9\u0634\u0641 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u06a9\u0627\u0631\u0628\u0631\u062f pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u0647\u062f\u0641 pivot table \u0627\u0631\u0627\u0626\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u067e\u0630\u06cc\u0631 \u0628\u0631\u0627\u06cc \u062c\u0645\u0639\u200c\u0628\u0633\u062a\u0646 \u0633\u0631\u06cc\u0639 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0632\u06cc\u0627\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u0633\u062a. \u0627\u0632 \u0627\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0628\u0631\u0627\u06cc \u062f\u0631\u06a9\u060c \u0646\u0645\u0627\u06cc\u0634 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0647\u062a\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u062c\u0632\u0626\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p>\u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0631\u0627\u06cc \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0648 \u067e\u0627\u0633\u062e \u0628\u0647 \u0633\u0648\u0627\u0644\u0627\u062a \u063a\u06cc\u0631\u0645\u0646\u062a\u0638\u0631\u0647 \u062f\u0631\u0628\u0627\u0631\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647\u0631\u0647 \u0628\u0628\u0631\u06cc\u062f. \u062f\u0631 \u0627\u062f\u0627\u0645\u0647\u060c \u067e\u0646\u062c \u0633\u0646\u0627\u0631\u06cc\u0648\u06cc \u0641\u0631\u0636\u06cc \u0645\u0637\u0631\u062d \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632&nbsp; Pivot Table \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><style><\/style><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"209\" src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/1WgZh94Zb_gVV5X3_TVdBaydZO6SU5J3W-300x209.webp\" class=\"attachment-medium size-medium wp-post-image\" alt=\"\u0622\u0645\u0648\u0632\u0634 \u062a\u0627\u0628\u0639 sln \u062f\u0631 \u0627\u06a9\u0633\u0644\" srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/1WgZh94Zb_gVV5X3_TVdBaydZO6SU5J3W-300x209.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/1WgZh94Zb_gVV5X3_TVdBaydZO6SU5J3W.webp 704w\" sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/sln-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0628\u0639 sln \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u06f1- \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0644 \u0641\u0631\u0648\u0634 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0645\u062e\u062a\u0644\u0641<\/h3>\n\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u0641\u0627\u06cc\u0644\u06cc \u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u062d\u0627\u0648\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0641\u0631\u0648\u0634 \u0645\u0627\u0647\u0627\u0646\u0647 \u0633\u0647 \u0645\u062d\u0635\u0648\u0644 \u0645\u062e\u062a\u0644\u0641 \u0627\u0633\u062a\u060c \u0645\u062d\u0635\u0648\u0644 \u06f1\u060c \u0645\u062d\u0635\u0648\u0644 \u06f2 \u0648 \u0645\u062d\u0635\u0648\u0644 \u06f3. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u062f\u0627\u0646\u06cc\u062f \u06a9\u0647 \u06a9\u062f\u0627\u0645 \u0645\u062d\u0635\u0648\u0644\u060c \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u062f\u0631\u0622\u0645\u062f \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u0633\u062a.<\/p>\n\n\n\n<p>\u06cc\u06a9 \u0631\u0627\u0647\u060c \u062c\u0645\u0639\u200c\u0628\u0633\u062a\u0646 \u062f\u0633\u062a\u06cc \u0627\u0639\u062f\u0627\u062f \u0641\u0631\u0648\u0634 \u0645\u062d\u0635\u0648\u0644 \u06f1 \u0648 \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628\u060c \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u06f2 \u0648 \u06f3 \u0627\u0633\u062a. \u0622\u0633\u0627\u0646 \u0628\u0647\u200c\u0646\u0638\u0631 \u0645\u06cc\u200c\u0631\u0633\u062f\u060c \u0627\u0645\u0627 \u0646\u0647 \u062a\u0627 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0647\u0632\u0627\u0631\u0627\u0646 \u0647\u0632\u0627\u0631\u0627\u0646 \u0631\u062f\u06cc\u0641 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0648 \u062c\u0645\u0639 \u0628\u0633\u062a\u0646 \u0622\u0646\u200c\u0647\u0627 \u0631\u0648\u0632\u0647\u0627 \u0637\u0648\u0644 \u0628\u06a9\u0634\u062f. \u0628\u0627 pivot table \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0647\u0645\u0647 \u0627\u0631\u0642\u0627\u0645 \u0641\u0631\u0648\u0634 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u06f1\u060c \u06f2 \u0648 \u06f3 \u062f\u0631 \u06a9\u0645\u062a\u0631 \u0627\u0632 \u06cc\u06a9 \u062f\u0642\u06cc\u0642\u0647 \u062c\u0645\u0639 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"602\" height=\"241\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image001-3.jpg\" alt=\"\u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0644 \u0641\u0631\u0648\u0634 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0645\u062e\u062a\u0644\u0641\" class=\"wp-image-35501 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image001-3.jpg 602w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image001-3-300x120.jpg.webp 300w\" data-sizes=\"(max-width: 602px) 100vw, 602px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 602px; --smush-placeholder-aspect-ratio: 602\/241;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u06f2- \u0646\u0645\u0627\u06cc\u0634 \u062f\u0631\u0635\u062f\u06cc \u0641\u0631\u0648\u0634 \u0645\u062d\u0635\u0648\u0644 \u0646\u0633\u0628\u062a \u0628\u0647 \u0641\u0631\u0648\u0634 \u06a9\u0644<\/h3>\n\n\n\n<p>Pivot Table \u0648\u0642\u062a\u06cc \u0633\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0630\u0627\u062a\u0627 \u0645\u0642\u062f\u0627\u0631 \u06a9\u0644 \u0647\u0631 \u0631\u062f\u06cc\u0641 \u06cc\u0627 \u0633\u062a\u0648\u0646 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0628\u0627 \u0627\u06cc\u0646\u200c\u062d\u0627\u0644\u060c \u0627\u0631\u0642\u0627\u0645 \u062f\u06cc\u06af\u0631\u06cc \u0631\u0627 \u0646\u06cc\u0632 \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u0648\u0644\u06cc\u062f \u06a9\u0646\u06cc\u062f. \u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u0627\u0639\u062f\u0627\u062f \u0641\u0631\u0648\u0634 \u0641\u0635\u0644\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0633\u0647 \u0645\u062d\u0635\u0648\u0644 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0648\u0627\u0631\u062f \u0648 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 pivot table \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f. Pivot Table \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0633\u0647 \u0631\u0642\u0645 \u06a9\u0644 \u062f\u0631 \u067e\u0627\u06cc\u06cc\u0646 \u0647\u0631 \u0633\u062a\u0648\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0645\u0642\u062f\u0627\u0631 \u0641\u0631\u0648\u0634 \u0641\u0635\u0644\u06cc \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0647\u0631 \u0645\u062d\u0635\u0648\u0644 \u0627\u0633\u062a.<\/p>\n\n\n\n<p>\u062d\u0627\u0644\u0627 \u0627\u06af\u0631 \u062f\u0631\u0635\u062f \u0641\u0631\u0648\u0634 \u0627\u06cc\u0646 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0631\u0627 \u0646\u0633\u0628\u062a \u0628\u0647 \u0641\u0631\u0648\u0634 \u06a9\u0644 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0686\u0647\u061f<\/p>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u062f\u0631\u0635\u062f \u0641\u0631\u0648\u0634 \u0645\u062d\u0635\u0648\u0644 \u0646\u0633\u0628\u062a \u0628\u0647 \u06a9\u0644 \u0641\u0631\u0648\u0634 \u062f\u0631 pivot table\u060c \u0631\u0648\u06cc \u0633\u0644\u0648\u0644\u06cc \u0631\u0627\u0633\u062a\u200c\u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0641\u0631\u0648\u0634 \u06a9\u0644 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u06af\u0632\u06cc\u0646\u0647 Show Values As &gt; % of Grand Total \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"601\" height=\"322\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image002-2.jpg\" alt=\"\u0646\u0645\u0627\u06cc\u0634 \u062f\u0631\u0635\u062f\u06cc \u0641\u0631\u0648\u0634 \u0645\u062d\u0635\u0648\u0644 \u0646\u0633\u0628\u062a \u0628\u0647 \u0641\u0631\u0648\u0634 \u06a9\u0644 Pivot Table \u0648\u0642\u062a\u06cc \u0633\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0630\u0627\u062a\u0627 \u0645\u0642\u062f\u0627\u0631 \u06a9\u0644 \u0647\u0631 \u0631\u062f\u06cc\u0641 \u06cc\u0627 \u0633\u062a\u0648\u0646 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0628\u0627 \u0627\u06cc\u0646\u200c\u062d\u0627\u0644\u060c \u0627\u0631\u0642\u0627\u0645\" class=\"wp-image-35502 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image002-2.jpg 601w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image002-2-300x161.jpg 300w\" data-sizes=\"(max-width: 601px) 100vw, 601px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 601px; --smush-placeholder-aspect-ratio: 601\/322;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u06f3- \u062a\u0631\u06a9\u06cc\u0628\u200c\u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc<\/h3>\n\n\n\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0633\u0646\u0627\u0631\u06cc\u0648\u060c \u0628\u0627\u0632\u0637\u0631\u0627\u062d\u06cc \u0628\u0644\u0627\u06af\u06cc \u0631\u0627 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0631\u0633\u0627\u0646\u062f\u0647 \u0648 \u0628\u0627\u06cc\u062f URL\u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0631\u0627 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f. \u0645\u062a\u0627\u0633\u0641\u0627\u0646\u0647\u060c \u0646\u0631\u0645\u200c\u0627\u0641\u0632\u0627\u0631 \u06af\u0632\u0627\u0631\u0634\u200c\u062f\u0647\u06cc \u0628\u0644\u0627\u06af \u0628\u0647\u200c\u062e\u0648\u0628\u06cc \u0627\u0632 \u067e\u0633 \u062a\u063a\u06cc\u06cc\u0631 \u0628\u0631\u0646\u0645\u06cc\u200c\u0622\u06cc\u062f \u0648 \u0645\u062a\u0631\u06cc\u06a9 view \u0631\u0627 \u0628\u0631\u0627\u06cc \u067e\u0633\u062a\u200c\u0647\u0627\u06cc \u062a\u06a9\u06cc \u0628\u06cc\u0646 \u062f\u0648 URL \u0645\u062a\u0641\u0627\u0648\u062a \u062c\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062d\u0627\u0644\u0627 \u062f\u0648 \u0646\u0645\u0648\u0646\u0647 \u0627\u0632 \u0647\u0631 \u067e\u0633\u062a \u0628\u0644\u0627\u06af \u062f\u0631 \u0627\u0633\u067e\u0631\u06cc\u062f\u0634\u06cc\u062a \u062e\u0648\u062f \u062f\u0627\u0631\u06cc\u062f. \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0631\u0627\u06cc \u06af\u0631\u0641\u062a\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062f\u0642\u06cc\u0642\u060c \u06a9\u0644 \u0648\u06cc\u0648\u0647\u0627\u06cc \u0647\u0631\u06a9\u062f\u0627\u0645 \u0627\u0632 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0631\u0627 \u062a\u0631\u06a9\u06cc\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"446\" height=\"319\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image003-2.png\" alt=\"\u062a\u0631\u06a9\u06cc\u0628\u200c\u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc\" class=\"wp-image-35503 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image003-2.png 446w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image003-2-300x215.png.webp 300w\" data-sizes=\"(max-width: 446px) 100vw, 446px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 446px; --smush-placeholder-aspect-ratio: 446\/319;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0628\u0647\u200c\u062c\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u062f\u0633\u062a\u06cc \u0648 \u062a\u0631\u06a9\u06cc\u0628 \u0645\u062a\u0631\u06cc\u06a9\u200c\u0647\u0627\u06cc \u0646\u0633\u062e\u0647 \u062a\u06a9\u0631\u0627\u0631\u06cc\u060c \u0627\u0632 \u0637\u0631\u06cc\u0642 pivot table \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0647\u0631 \u0639\u0646\u0648\u0627\u0646 \u067e\u0633\u062a \u0628\u0644\u0627\u06af \u0631\u0627 \u062e\u0644\u0627\u0635\u0647 \u06a9\u0646\u06cc\u062f. \u0645\u062a\u0631\u06cc\u06a9\u200c\u0647\u0627\u06cc \u0648\u06cc\u0648 \u0627\u0632 \u067e\u0633\u062a\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062a\u062c\u0645\u06cc\u0639 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"333\" height=\"230\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image004-1.png\" alt=\"\u06a9\u0627 \u0628\u0627 pivot table\" class=\"wp-image-35504 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image004-1.png 333w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image004-1-300x207.png.webp 300w\" data-sizes=\"(max-width: 333px) 100vw, 333px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 333px; --smush-placeholder-aspect-ratio: 333\/230;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u06f4- \u0634\u0645\u0631\u062f\u0646 \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u062f\u0631 \u0647\u0631 \u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646<\/h3>\n\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u0641\u0647\u0631\u0633\u062a\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u062f\u0631 \u0634\u06cc\u062a \u0627\u06a9\u0633\u0644 \u062f\u0627\u0631\u06cc\u062f. \u062f\u0631 \u06a9\u0646\u0627\u0631 \u0646\u0627\u0645 \u0647\u0631 \u06a9\u0627\u0631\u0645\u0646\u062f\u060c \u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646 \u0627\u0648 \u0646\u06cc\u0632 \u0630\u06a9\u0631 \u0634\u062f\u0647\u200c\u0627\u0633\u062a. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 pivot table \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0633\u0627\u0632\u06cc\u062f \u06a9\u0647 \u0646\u0627\u0645 \u0647\u0631 \u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646 \u0648 \u062a\u0639\u062f\u0627\u062f \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0645\u062a\u0639\u0644\u0642 \u0628\u0647 \u0647\u0631 \u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0628\u062f\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628\u060c \u0627\u0632 \u0645\u0631\u062a\u0628\u200c\u06a9\u0631\u062f\u0646 \u0634\u06cc\u062a \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u0633\u0627\u0633 \u0646\u0627\u0645 \u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646 \u0648 \u0634\u0645\u0631\u062f\u0646 \u062f\u0633\u062a\u06cc \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u062e\u0644\u0627\u0635 \u0645\u06cc\u200c\u0634\u0648\u06cc\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u06f5- \u0627\u0636\u0627\u0641\u0647\u200c\u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0628\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc<\/h3>\n\n\n\n<p>\u0647\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u06a9\u0647 \u0648\u0627\u0631\u062f \u0627\u06a9\u0633\u0644 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u062a\u0645\u0627\u0645 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u067e\u0631 \u0646\u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u06af\u0631 \u0645\u0646\u062a\u0638\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0647\u0633\u062a\u06cc\u062f\u060c \u0627\u062d\u062a\u0645\u0627\u0644\u0627 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u0632\u06cc\u0627\u062f\u06cc \u062f\u0627\u0631\u06cc\u062f \u06a9\u0647 \u06af\u0645\u0631\u0627\u0647\u200c\u06a9\u0646\u0646\u062f\u0647\u200c\u0627\u0646\u062f \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u0648\u0636\u06cc\u062d \u0628\u06cc\u0634\u062a\u0631 \u062f\u0627\u0631\u0646\u062f. \u0627\u06cc\u0646\u062c\u0627\u0633\u062a \u06a9\u0647 pivot table \u0628\u0647 \u062f\u0631\u062f \u0645\u06cc\u200c\u062e\u0648\u0631\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"443\" height=\"446\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image005-1.png\" alt=\"\u0627\u0636\u0627\u0641\u0647\u200c\u06a9\u0631\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0628\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc\" class=\"wp-image-35505 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image005-1.png 443w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image005-1-298x300.png.webp 298w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image005-1-150x150.png.webp 150w\" data-sizes=\"(max-width: 443px) 100vw, 443px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 443px; --smush-placeholder-aspect-ratio: 443\/446;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f pivot table \u0631\u0627 \u0637\u0648\u0631\u06cc \u0633\u0641\u0627\u0631\u0634\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0633\u0644\u0648\u0644 \u062e\u0627\u0644\u06cc \u0631\u0627 \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0645\u0627\u0646\u0646\u062f $\u06f0 \u06cc\u0627 TBD \u067e\u0631 \u06a9\u0646\u0646\u062f. \u0627\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0628\u0631\u0627\u06cc \u062c\u062f\u0627\u0648\u0644 \u0628\u0632\u0631\u06af \u0648 \u067e\u0631 \u0627\u0632 \u062f\u0627\u062f\u0647 \u0628\u0633\u06cc\u0627\u0631 \u0627\u0631\u0632\u0634\u0645\u0646\u062f \u0627\u0633\u062a\u060c \u0628\u0647\u200c\u062e\u0635\u0648\u0635 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0627\u0641\u0631\u0627\u062f \u062f\u06cc\u06af\u0631 \u0647\u0645 \u0622\u0646 \u0634\u06cc\u062a \u0631\u0627 \u0645\u06cc\u200c\u0628\u06cc\u0646\u0646\u062f.<\/p>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0642\u0627\u0644\u0628 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc pivot table\u060c \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u0648 PivotTable Options \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f. \u062f\u0631 \u067e\u0646\u062c\u0631\u0647 \u0628\u0627\u0632\u0634\u062f\u0647\u060c \u06af\u0632\u06cc\u0646\u0647 For Empty Cells Show \u0631\u0627 \u062a\u06cc\u06a9 \u0628\u0632\u0646\u06cc\u062f \u0648 \u0645\u0642\u062f\u0627\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0645\u062f\u0646\u0638\u0631 \u062e\u0648\u062f \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"458\" height=\"477\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image006-1.png\" alt=\"PivotTable Options\" class=\"wp-image-35506 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image006-1.png 458w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image006-1-288x300.png.webp 288w\" data-sizes=\"(max-width: 458px) 100vw, 458px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 458px; --smush-placeholder-aspect-ratio: 458\/477;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u0686\u06af\u0648\u0646\u0647 <\/strong><strong>Pivot Table<\/strong><strong> \u0628\u0633\u0627\u0632\u06cc\u0645\u061f<\/strong><\/h2>\n\n\n\n<p>\u062e\u0648\u0634\u0628\u062e\u062a\u0627\u0646\u0647\u060c \u0642\u0627\u0628\u0644\u06cc\u062a\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0628\u0647 \u0646\u0627\u0645 Recommended Pivot Table Function \u062f\u0631 \u0627\u06a9\u0633\u0644 \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0631\u062f\u0647 \u0648 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0644\u0627\u06cc\u0647\u200c\u0628\u0646\u062f\u06cc \u0645\u062e\u0635\u0648\u0635 pivot table \u0631\u0627 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/excel_J64Ia3k_1403-08-16-164603525\/59d596201990a1731aba7535ad501054.webp?expire=4893471932&#038;token=0a560b600497dbd229a8f62b5b1f709d&#038;md5=ClYLYASX29IpqPYrWx9wnQ==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C-%D9%86%D8%B1%D9%85%D8%A7%D9%81%D8%B2%D8%A7%D8%B1-%D9%85%D8%A7%DB%8C%DA%A9%D8%B1%D9%88%D8%B3%D8%A7%D9%81%D8%AA-%D8%A7%DA%A9%D8%B3%D9%84-mk760\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f6\u06f9\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f3\u06f9\u06f0,\u06f0\u06f0\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f4\u06f4%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D8%AF%DB%8C-%D9%86%D8%B1%D9%85%D8%A7%D9%81%D8%B2%D8%A7%D8%B1-%D9%85%D8%A7%DB%8C%DA%A9%D8%B1%D9%88%D8%B3%D8%A7%D9%81%D8%AA-%D8%A7%DA%A9%D8%B3%D9%84-mk760\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p>\u0628\u0627 \u0627\u06cc\u0646\u200c\u062d\u0627\u0644\u060c \u0627\u06cc\u0646 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0645\u06cc\u0634\u0647 \u062f\u0642\u06cc\u0642 \u0646\u06cc\u0633\u062a \u0648 \u062e\u0648\u062f\u062a\u0627\u0646 \u0646\u06cc\u0632 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0686\u0645 \u0648 \u062e\u0645 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0633\u0631 \u062f\u0631\u0628\u06cc\u0627\u0648\u0631\u06cc\u062f. \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0642\u062f\u0645 \u0628\u0647 \u0642\u062f\u0645 \u062f\u0631 \u0622\u0645\u0648\u0632\u0634 \u062a\u0635\u0648\u06cc\u0631\u06cc Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0627\u0648\u0644\u06cc\u0646 \u062c\u062f\u0648\u0644 \u062e\u0648\u062f \u0631\u0627 \u0628\u0633\u0627\u0632\u06cc\u0645:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0642\u062f\u0645 \u06f1. \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u062f\u0631 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/h3>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u062e\u0648\u062f \u0631\u0627 \u062f\u0631 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0645\u0627\u0646\u0646\u062f \u0645\u062b\u0627\u0644 \u0632\u06cc\u0631 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"650\" height=\"346\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-data.webp\" alt=\"\u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\" class=\"wp-image-35507 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-data.webp 650w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-data-300x160.webp 300w\" data-sizes=\"(max-width: 650px) 100vw, 650px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 650px; --smush-placeholder-aspect-ratio: 650\/346;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062f\u0631 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0627\u0644\u0627\u060c \u0641\u0647\u0631\u0633\u062a\u06cc \u0627\u0632 \u0627\u0641\u0631\u0627\u062f\u060c \u0633\u0637\u062d \u062a\u062d\u0635\u06cc\u0644\u0627\u062a \u0648 \u0648\u0636\u0639\u06cc\u062a \u062a\u0627\u0647\u0644 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f. \u0628\u0627 pivot table \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0634\u062e\u0635\u06cc \u0631\u0627 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u06a9\u0631\u062f\u061b \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644 \u0686\u0646\u062f \u0646\u0641\u0631 \u0628\u0627 \u0645\u062f\u0631\u06a9 \u0627\u0631\u0634\u062f\u060c \u0627\u0632\u062f\u0648\u0627\u062c \u06a9\u0631\u062f\u0647\u200c\u0627\u0646\u062f.<\/p>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0647\u0631 pivot table \u0628\u0627\u06cc\u062f \u0647\u062f\u0641\u06cc \u062f\u0631 \u0630\u0647\u0646 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f. \u0628\u0627 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647 \u0686\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0645\u06cc\u200c\u0631\u0633\u06cc\u062f \u0648 \u0686\u0647 \u0686\u06cc\u0632\u06cc \u06cc\u0627\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u062f\u061f<\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"200\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image-3380-1-300x200.png.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u0622\u0645\u0648\u0632\u0634 \u062a\u0627\u0628\u0639 min \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/image-3380-1-300x200.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image-3380-1.png 768w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/200;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/min-functions-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0628\u0639 min \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u0642\u062f\u0645 \u06f2. Pivot Table \u062e\u0648\u062f \u0631\u0627 \u062f\u0631\u062c \u06a9\u0646\u06cc\u062f<\/h3>\n\n\n\n<p>\u062f\u0631\u062c\u200c\u06a9\u0631\u062f\u0646 pivot table \u0631\u0627\u062d\u062a\u200c\u062a\u0631\u06cc\u0646 \u0628\u062e\u0634 \u06a9\u0627\u0631 \u0627\u0633\u062a. \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u067e\u0631\u0631\u0646\u06af \u06a9\u0646\u06cc\u062f<\/li>\n\n\n\n<li>\u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0628\u0627\u0644\u0627\u060c \u0628\u0647 \u0628\u062e\u0634 Insert \u0628\u0631\u0648\u06cc\u062f<\/li>\n\n\n\n<li>\u0631\u0648\u06cc Pivot table \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"650\" height=\"290\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-button.webp\" alt=\"Pivot Table\" class=\"wp-image-35508 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-button.webp 650w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-button-300x134.webp 300w\" data-sizes=\"(max-width: 650px) 100vw, 650px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 650px; --smush-placeholder-aspect-ratio: 650\/290;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062a\u0648\u062c\u0647: \u062f\u0631 \u0628\u0639\u0636\u06cc \u0627\u0632 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644\u060c pivot table \u0632\u06cc\u0631\u0645\u062c\u0645\u0648\u0639\u0647 Tables \u06cc\u0627 Data \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f.<\/p>\n\n\n\n<p>\u067e\u0646\u062c\u0631\u0647\u200c\u0627\u06cc \u0628\u0631\u0627\u06cc \u062a\u0627\u06cc\u06cc\u062f \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0627\u0645\u06a9\u0627\u0646 \u0627\u0636\u0627\u0641\u0647\u200c\u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u062e\u0627\u0631\u062c\u06cc \u0628\u0627\u0632 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646\u060c \u0627\u0632 \u0634\u0645\u0627 \u0645\u06cc\u200c\u067e\u0631\u0633\u062f \u06a9\u0647 pivot table \u0631\u0627 \u062f\u0631 \u06a9\u062c\u0627 \u0642\u0631\u0627\u0631 \u062f\u0647\u062f. \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u062f\u0631 \u0648\u0631\u06a9\u200c\u0634\u06cc\u062a \u062c\u062f\u06cc\u062f \u0628\u06af\u0630\u0627\u0631\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"650\" height=\"487\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-dialog.webp\" alt=\"\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0648\u0631\u062f \u0634\u06cc\u062a\" class=\"wp-image-35513 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-dialog.webp 650w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-dialog-300x225.webp 300w\" data-sizes=\"(max-width: 650px) 100vw, 650px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 650px; --smush-placeholder-aspect-ratio: 650\/487;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0627\u06af\u0631 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062a\u063a\u06cc\u06cc\u0631 \u0646\u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f\u060c \u0647\u0645\u0647\u200c\u0686\u06cc\u0632 \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f\u0647 \u0648 OK \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f. \u0633\u067e\u0633\u060c \u0646\u062a\u06cc\u062c\u0647\u200c\u0627\u06cc \u062e\u0627\u0644\u06cc \u0645\u0627\u0646\u0646\u062f \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"400\" height=\"393\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-blank.webp\" alt=\"\" class=\"wp-image-35509 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-blank.webp 400w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-blank-300x295.webp 300w\" data-sizes=\"(max-width: 400px) 100vw, 400px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 400px; --smush-placeholder-aspect-ratio: 400\/393;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062d\u0627\u0644\u0627 \u0627\u0648\u0636\u0627\u0639 \u06a9\u0645\u06cc \u0633\u0631\u062f\u0631\u06af\u0645\u200c\u06a9\u0646\u0646\u062f\u0647 \u0634\u062f\u0647\u200c\u0627\u0633\u062a. \u062a\u0627\u0632\u0647\u200c\u06a9\u0627\u0631\u0647\u0627 \u0645\u0639\u0645\u0648\u0644\u0627 \u0627\u06cc\u0646\u062c\u0627 \u0628\u0647 \u0645\u0634\u06a9\u0644 \u0645\u06cc\u200c\u062e\u0648\u0631\u0646\u062f. \u062f\u0631 \u062d\u0627\u0644 \u062d\u0627\u0636\u0631\u060c \u062c\u062f\u0648\u0644 \u0631\u0646\u062f\u0631 \u0634\u062f\u0647 \u0648 \u0628\u0627\u06cc\u062f \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc pivot table \u0631\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u0645.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0642\u062f\u0645 \u06f3. \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc Pivot Table \u0631\u0627 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f<\/h3>\n\n\n\n<p>\u0627\u0633\u06a9\u0644\u062a pivot table \u0622\u0645\u0627\u062f\u0647\u200c\u0633\u062a \u0648 \u0632\u0645\u0627\u0646 \u067e\u0631\u06a9\u0631\u062f\u0646 \u0622\u0646 \u0631\u0633\u06cc\u062f\u0647\u200c\u0627\u0633\u062a. \u067e\u0633 \u0627\u0632 \u06a9\u0644\u06cc\u06a9 \u0631\u0648 OK\u060c \u067e\u0646\u062c\u0631\u0647 \u0632\u06cc\u0631 \u0631\u0627 \u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"300\" height=\"664\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-fields.webp\" alt=\"\u0641\u06cc\u0644\u062f\u0647\u0627\u06cc Pivot Table\" class=\"wp-image-35514 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-fields.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-fields-136x300.webp 136w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/664;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u067e\u0646\u062c\u0631\u0647\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0647\u0631\u06a9\u062f\u0627\u0645 \u0627\u0632 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u0645\u0648\u062c\u0648\u062f (\u0647\u0645\u0627\u0646 \u0646\u0627\u0645\u060c \u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc\u060c \u062a\u062d\u0635\u06cc\u0644\u0627\u062a \u0648 \u0648\u0636\u0639\u06cc\u062a \u062a\u0627\u0647\u0644) \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u062f \u0648 \u0628\u0647 \u06cc\u06a9\u06cc \u0627\u0632 \u0686\u0647\u0627\u0631 \u06af\u0632\u06cc\u0646\u0647 \u0632\u06cc\u0631 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<p><strong>\u0641\u06cc\u0644\u062a\u0631:<\/strong><\/p>\n\n\n\n<p>\u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647\u060c \u0641\u06cc\u0644\u062f \u0627\u0646\u062a\u062e\u0627\u0628 \u0628\u0647 \u0641\u06cc\u0644\u062a\u0631 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647 \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0642\u0633\u0645\u062a\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u062c\u062f\u0648\u0644 pivot table \u062f\u0631 \u062c\u062f\u0648\u0644 \u0632\u06cc\u0631 \u0628\u0631\u0627\u0633\u0627\u0633 Education \u0641\u06cc\u0644\u062a\u0631 \u0634\u062f\u0647\u200c\u0627\u0633\u062a.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"650\" height=\"323\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-filter.webp\" alt=\"\u0641\u06cc\u0644\u062a\u0631\" class=\"wp-image-35515 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-filter.webp 650w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-filter-300x149.webp 300w\" data-sizes=\"(max-width: 650px) 100vw, 650px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 650px; --smush-placeholder-aspect-ratio: 650\/323;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><strong>\u0633\u062a\u0648\u0646:<\/strong><\/p>\n\n\n\n<p>\u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647\u060c \u0641\u06cc\u0644\u062f \u0627\u0646\u062a\u062e\u0627\u0628\u06cc \u0628\u0647 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0639\u0645\u0648\u062f\u06cc \u062f\u0631 Pivot Table \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0648\u0636\u0639\u06cc\u062a \u062a\u0627\u0647\u0644 \u062f\u0631 \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647\u200c\u0627\u0633\u062a.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"564\" height=\"250\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-columns.webp\" alt=\"\u0633\u062a\u0648\u0646\" class=\"wp-image-35511 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-columns.webp 564w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-columns-300x133.webp 300w\" data-sizes=\"(max-width: 564px) 100vw, 564px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 564px; --smush-placeholder-aspect-ratio: 564\/250;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u062d\u0648\u0627\u0633\u062a\u0627\u0646 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0641\u06cc\u0644\u062f \u0628\u0647 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f \u0648 \u0646\u0647 \u0639\u0646\u0648\u0627\u0646 \u0641\u06cc\u0644\u062f \u0627\u0635\u0644\u06cc. \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0627\u06cc\u0646\u062c\u0627\u060c Married \u0648 Single \u0646\u0627\u0645 \u062f\u0627\u0631\u0646\u062f.<\/p>\n\n\n\n<p><strong>\u0631\u062f\u06cc\u0641:<\/strong><\/p>\n\n\n\n<p>\u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647\u060c \u0641\u06cc\u0644\u062f \u0627\u0646\u062a\u062e\u0627\u0628\u06cc \u0628\u0647 \u0631\u062f\u06cc\u0641 \u0627\u0641\u0642\u06cc \u062f\u0631 Pivot Table \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0641\u06cc\u0644\u062f Education \u0628\u0647 \u0631\u062f\u06cc\u0641 \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647\u200c\u0627\u0633\u062a.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"560\" height=\"254\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-rows.webp\" alt=\"\u0631\u062f\u06cc\u0641\" class=\"wp-image-35516 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-rows.webp 560w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-rows-300x136.webp 300w\" data-sizes=\"(max-width: 560px) 100vw, 560px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 560px; --smush-placeholder-aspect-ratio: 560\/254;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p><strong>\u0645\u0642\u062f\u0627\u0631:<\/strong><\/p>\n\n\n\n<p>\u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647\u060c \u0641\u06cc\u0644\u062f \u0627\u0646\u062a\u062e\u0627\u0628\u06cc \u0628\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u062c\u062f\u0648\u0644 \u0631\u0627 \u067e\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062c\u0645\u0639\u200c\u0628\u0633\u062a\u0646 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0631 \u0627\u062e\u062a\u06cc\u0627\u0631 \u0634\u0645\u0627 \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u0630\u0627\u0631\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"556\" height=\"250\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-values-1.webp\" alt=\"\u0645\u0642\u062f\u0627\u0631\" class=\"wp-image-35517 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-values-1.webp 556w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-values-1-300x135.webp 300w\" data-sizes=\"(max-width: 556px) 100vw, 556px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 556px; --smush-placeholder-aspect-ratio: 556\/250;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u200c \u06af\u0631\u0641\u062a\u0647\u060c \u062c\u0645\u0639 \u0628\u0633\u062a\u0647 \u0648 \u0634\u0645\u0631\u062f\u0647 \u0634\u0648\u0646\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0645\u0642\u0627\u062f\u06cc\u0631\u060c \u0634\u0645\u0627\u0631 \u0641\u06cc\u0644\u062f First Name \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u06a9\u0647 \u0686\u0647 \u0627\u0641\u0631\u0627\u062f\u06cc\u060c \u0628\u0627 \u0686\u0647 \u062a\u062d\u0635\u06cc\u0644\u0627\u062a\u06cc\u060c \u0645\u062a\u0627\u0647\u0644 \u06cc\u0627 \u0645\u062c\u0631\u062f \u0647\u0633\u062a\u0646\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"167\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image001-1-300x167.jpg\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u062a\u0627\u0628\u0639 PPMT \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image001-1-300x167.jpg 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/image001-1.jpg 602w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/167;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/ppmt-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0646\u062d\u0648\u0647 \u0645\u062d\u0627\u0633\u0628\u0647 \u0642\u0633\u0637 \u0628\u0627 \u062a\u0627\u0628\u0639 PPMT \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u0642\u062f\u0645 \u06f4. Pivot Table \u062e\u0648\u062f \u0631\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u062f<\/h3>\n\n\n\n<p>\u062d\u0627\u0644\u0627 \u062f\u0631 \u0622\u0645\u0648\u0632\u0634 Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0642\u062f\u0645 \u0686\u0647\u0627\u0631\u0645 \u0645\u06cc\u200c\u0631\u0633\u06cc\u0645. \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 pivot table \u0631\u0627 \u0622\u0645\u0627\u062f\u0647 \u06a9\u0631\u062f\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f \u0647\u062f\u0641 \u0627\u0648\u0644\u06cc\u0647 \u062e\u0648\u062f \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f. \u0686\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u06cc \u0631\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0628\u0647\u200c\u062f\u0633\u062a \u0628\u06cc\u0627\u0648\u0631\u06cc\u062f\u061f \u0645\u062b\u0644\u0627\u060c \u062f\u0631 \u0645\u0648\u0631\u062f \u0628\u0627\u0644\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0633\u062a\u06cc\u0645 \u0628\u0641\u0647\u0645\u06cc\u0645 \u06a9\u0647 \u0686\u0646\u062f \u0646\u0641\u0631 \u062f\u0631 \u0633\u0637\u0648\u062d \u0645\u062e\u062a\u0644\u0641 \u062a\u062d\u0635\u06cc\u0644\u06cc\u060c \u0627\u0632\u062f\u0648\u0627\u062c \u06a9\u0631\u062f\u0647 \u06cc\u0627 \u0645\u062c\u0631\u062f \u0647\u0633\u062a\u0646\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/Excel2_1403-08-16-164238678\/4978163926641b3b5bf30d48d864a0f8.webp?expire=4893471932&#038;token=51652325b1548d7799bb0b0342f36f34&#038;md5=UWUjJbFUjXeZuwsDQvNvNA==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0631\u0648\u0698\u0647 \u0628\u0627 \u0627\u06a9\u0633\u0644\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0631\u0648\u0698\u0647 \u0628\u0627 \u0627\u06a9\u0633\u0644\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D8%B1%DB%8C%D8%B2%DB%8C-%D9%88-%DA%A9%D9%86%D8%AA%D8%B1%D9%84-%D9%BE%D8%B1%D9%88%DA%98%D9%87-%D8%AF%D8%B1-%D8%A7%DA%A9%D8%B3%D9%84-mk1314\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0631\u0648\u0698\u0647 \u0628\u0627 \u0627\u06a9\u0633\u0644        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f2,\u06f7\u06f9\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f1,\u06f2\u06f5\u06f9,\u06f5\u06f5\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f5\u06f5%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87-%D8%B1%DB%8C%D8%B2%DB%8C-%D9%88-%DA%A9%D9%86%D8%AA%D8%B1%D9%84-%D9%BE%D8%B1%D9%88%DA%98%D9%87-%D8%AF%D8%B1-%D8%A7%DA%A9%D8%B3%D9%84-mk1314\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 Marital Status\u060c \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 Education \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 First Name \u0686\u06cc\u062f\u06cc\u0645. \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u06af\u0631 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0639\u062f\u062f\u06cc \u0628\u0627\u0634\u0646\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062c\u0645\u0639 \u0628\u0633\u062a\u0647\u060c \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u06af\u0631\u0641\u062a\u0647 \u06cc\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0634\u0648\u0646\u062f. \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627\u060c First Name\u060c \u0645\u062a\u0646\u06cc \u0627\u0633\u062a. \u062c\u062f\u0648\u0644 \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0622\u0646 \u0631\u0627 \u0631\u0648\u06cc Count \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u06cc\u0639\u0646\u06cc \u062a\u0639\u062f\u0627\u062f \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u0645\u0646\u0637\u0628\u0642 \u0628\u0631 \u0647\u0631 \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc \u0631\u0627 \u0645\u06cc\u200c\u0634\u0645\u0631\u062f. \u0646\u062a\u06cc\u062c\u0647\u060c \u062a\u0635\u0648\u06cc\u0631 \u0632\u06cc\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"556\" height=\"250\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-values.webp\" alt=\"\" class=\"wp-image-35518 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-values.webp 556w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/excel-pivot-tables-values-300x135.webp 300w\" data-sizes=\"(max-width: 556px) 100vw, 556px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 556px; --smush-placeholder-aspect-ratio: 556\/250;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0627\u06cc\u0646\u062c\u0627\u060c \u06cc\u0627\u062f \u06af\u0631\u0641\u062a\u06cc\u0645 \u06a9\u0647 \u062f\u0631 \u0633\u0637\u0648\u062d \u062a\u062d\u0635\u06cc\u0644\u06cc \u062f\u06a9\u062a\u0631\u06cc\u060c \u0627\u0631\u0634\u062f\u060c \u062f\u0628\u06cc\u0631\u0633\u062a\u0627\u0646 \u0648 \u062f\u0628\u0633\u062a\u0627\u0646 \u0686\u0647 \u062a\u0639\u062f\u0627\u062f\u06cc \u0627\u0632 \u0627\u0641\u0631\u0627\u062f\u060c \u0645\u062a\u0627\u0647\u0644 \u06cc\u0627 \u0645\u062c\u0631\u062f \u0647\u0633\u062a\u0646\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0686\u0646\u062f \u0645\u062b\u0627\u0644 Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>Pivot Table\u0647\u0627 \u062f\u0631 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0648\u0644 \u062a\u0627 \u0646\u06af\u0647\u200c\u062f\u0627\u0631\u06cc \u0627\u0632 \u062a\u0628\u200c\u0647\u0627 \u062f\u0631 \u0641\u0639\u0627\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0628\u0627\u0632\u0627\u0631\u06cc\u0627\u0628\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647 \u0631\u062f\u06af\u06cc\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0647\u0645 \u06a9\u0645\u06a9 \u06a9\u0646\u0646\u062f. \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0628\u06cc\u200c\u067e\u0627\u06cc\u0627\u0646 \u0627\u0633\u062a. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0633\u0647 \u0645\u062b\u0627\u0644 Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0632\u06cc\u0631 \u0627\u0644\u0647\u0627\u0645 \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong> \u0627\u06cc\u062c\u0627\u062f\u06a9\u0631\u062f\u0646 <\/strong><strong>PTO Summary<\/strong><strong> \u0648 <\/strong><strong>Tracker<\/strong><\/h3>\n\n\n\n<p>\u0627\u06af\u0631 \u062c\u0632\u0648 \u0646\u06cc\u0631\u0648\u0647\u0627\u06cc \u0645\u0646\u0627\u0628\u0639 \u0627\u0646\u0633\u0627\u0646\u06cc \u0647\u0633\u062a\u06cc\u062f\u060c \u06a9\u0633\u0628 \u0648 \u06a9\u0627\u0631 \u062f\u0627\u0631\u06cc\u062f \u06cc\u0627 \u062a\u06cc\u0645 \u06a9\u0648\u0686\u06a9\u06cc \u0631\u0627 \u0631\u0647\u0628\u0631\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u0645\u062f\u06cc\u0631\u06cc\u062a \u062a\u0639\u0637\u06cc\u0644\u0627\u062a \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a. \u0628\u0627 \u0627\u06cc\u0646 Pivot \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f\u060c \u0686\u0646\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0631\u062f\u06af\u06cc\u0631\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"1024\" height=\"461\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-5-1024x461.png.webp\" alt=\"\" class=\"wp-image-35527 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-5-1024x461.png.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-5-300x135.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-5-768x346.png.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-5-1536x691.png.webp 1536w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-5.png 1600w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/461;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0647\u0645\u0647 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u0628\u062f\u0647\u06cc\u062f\u060c \u0648\u0627\u0631\u062f\u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0632\u0645\u0627\u0646 \u0628\u06cc\u0645\u0627\u0631\u06cc<\/li>\n\n\n\n<li>\u0633\u0627\u0639\u0627\u062a PTO<\/li>\n\n\n\n<li>\u062a\u0639\u0637\u06cc\u0644\u0627\u062a \u0634\u0631\u06a9\u062a<\/li>\n\n\n\n<li>\u0633\u0627\u0639\u0627\u062a \u0627\u0636\u0627\u0641\u0647\u200c\u06a9\u0627\u0631\u06cc<\/li>\n\n\n\n<li>\u0633\u0627\u0639\u0627\u062a \u0639\u0627\u062f\u06cc \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646<\/li>\n<\/ul>\n\n\n\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 \u0647\u0631\u06a9\u062f\u0627\u0645 \u0627\u0632 \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc\u200c\u0647\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0628\u0648\u062f\u062c\u0647\u200c\u0631\u06cc\u0632\u06cc<\/h3>\n\n\n\n<p>\u0686\u0647 \u062f\u0631 \u062d\u0627\u0644 \u0627\u062c\u0631\u0627\u06cc \u067e\u0631\u0648\u0698\u0647 \u0628\u0627\u0634\u06cc\u062f \u06cc\u0627 \u0641\u0642\u0637 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0648\u0644 \u062e\u0648\u062f\u060c Pivot Table \u0627\u0628\u0632\u0627\u0631\u06cc \u0641\u0648\u0642\u200c\u0627\u0644\u0639\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0631\u062f\u06af\u06cc\u0631\u06cc \u0645\u062e\u0627\u0631\u062c \u0628\u0647\u200c\u0634\u0645\u0627\u0631 \u0645\u06cc\u200c\u0631\u0648\u062f. \u0628\u0648\u062f\u062c\u0647\u200c\u0631\u06cc\u0632\u06cc \u062f\u0648\u0645\u06cc\u0646 \u0645\u062b\u0627\u0644 Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"1600\" height=\"981\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-6.png\" alt=\"\" class=\"wp-image-35528 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-6.png 1600w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-6-300x184.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-6-1024x628.png.webp 1024w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-6-768x471.png.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-6-1536x942.png.webp 1536w\" data-sizes=\"(max-width: 1600px) 100vw, 1600px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1600px; --smush-placeholder-aspect-ratio: 1600\/981;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0633\u0627\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0628\u0648\u062f\u062c\u0647\u200c\u0647\u0627 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u062f\u0627\u0631\u0646\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u062a\u0627\u0631\u06cc\u062e \u062a\u0631\u0627\u06a9\u0646\u0634<\/li>\n\n\n\n<li>\u0628\u0631\u062f\u0627\u0634\u062a \u0627\u0632 \u062d\u0633\u0627\u0628 \/ \u0645\u062e\u0627\u0631\u062c<\/li>\n\n\n\n<li>\u067e\u0633\u200c\u0627\u0646\u062f\u0627\u0632 \/ \u062f\u0631\u0622\u0645\u062f<\/li>\n\n\n\n<li>\u062a\u0648\u0636\u06cc\u062d\u0627\u062a<\/li>\n\n\n\n<li>\u0647\u0631\u06af\u0648\u0646\u0647 \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc \u062e\u0627\u0631\u062c \u0627\u0632 \u0639\u0631\u0641 \u062f\u06cc\u06af\u0631 (\u0645\u0627\u0646\u0646\u062f \u062a\u0628\u0644\u06cc\u063a\u0627\u062a \u067e\u0648\u0644\u06cc \u06cc\u0627 \u0647\u0632\u06cc\u0646\u0647 \u0642\u0631\u0627\u0631\u062f\u0627\u062f)<\/li>\n<\/ul>\n\n\n\n<p>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062e\u0631\u062c\u200c\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u062e\u0648\u062f \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f \u0648 \u0631\u0627\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0647\u0634 \u0622\u0646\u200c\u0647\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"224\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/12\/GETPIVOTDATA-1-300x224.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u062a\u0627\u0628\u0639 \u062a\u0627\u0628\u0639 getpivotdata \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/12\/GETPIVOTDATA-1-300x224.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/12\/GETPIVOTDATA-1-768x574.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/12\/GETPIVOTDATA-1.webp 910w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/224;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/getpivotdata-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u062a\u0627\u0628\u0639 getpivotdata \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u0631\u062f\u06af\u06cc\u0631\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u06a9\u0645\u067e\u06cc\u0646<\/h3>\n\n\n\n<p>Pivot Table \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u062a\u06cc\u0645 \u0634\u0645\u0627 \u062f\u0631 \u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u06a9\u0645\u067e\u06cc\u0646\u200c\u0647\u0627\u06cc \u0628\u0627\u0632\u0627\u0631\u06cc\u0627\u0628\u06cc \u06a9\u0645\u06a9 \u06a9\u0646\u062f. \u062f\u0631 \u0645\u062b\u0627\u0644 \u0628\u0627\u0644\u0627\u060c \u0639\u0645\u0644\u06a9\u0631\u062f \u06a9\u0645\u067e\u06cc\u0646 \u0628\u0631\u0627\u0633\u0627\u0633 \u0645\u0646\u0637\u0642\u0647 \u062c\u062f\u0627 \u0634\u062f\u0647\u200c\u0627\u0633\u062a. \u0634\u0645\u0627 \u0628\u0647\u200c\u0631\u0627\u062d\u062a\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u062f \u06a9\u0647 \u06a9\u062f\u0627\u0645 \u06a9\u0634\u0648\u0631 \u062f\u0627\u0631\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u062a\u0628\u062f\u06cc\u0644 \u062f\u0631 \u06a9\u0645\u067e\u06cc\u0646\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0628\u0648\u062f\u0647\u200c\u0627\u0633\u062a.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"770\" height=\"693\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-7.png\" alt=\"\u0631\u062f\u06af\u06cc\u0631\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f \u06a9\u0645\u067e\u06cc\u0646\" class=\"wp-image-35529 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-7.png 770w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-7-300x270.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-7-768x691.png.webp 768w\" data-sizes=\"(max-width: 770px) 100vw, 770px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 770px; --smush-placeholder-aspect-ratio: 770\/693;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0628\u062f\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628\u060c \u062a\u0627\u06a9\u062a\u06cc\u06a9\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0647\u0631 \u0645\u0646\u0637\u0642\u0647 \u0639\u0645\u0644\u06a9\u0631\u062f \u062e\u0648\u0628\u06cc \u062f\u0627\u0631\u0646\u062f \u0648 \u06a9\u062f\u0627\u0645 \u062a\u0628\u0644\u06cc\u063a\u0627\u062a \u0628\u0627\u06cc\u062f \u062a\u063a\u06cc\u06cc\u0631 \u06a9\u0646\u0646\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u062f\u0631\u0628\u0627\u0631\u0647 Pivot Table \u0628\u0627\u06cc\u062f \u0628\u062f\u0627\u0646\u06cc\u062f! (\u0622\u0645\u0648\u0632\u0634 \u062d\u0631\u0641\u0647 \u0627\u06cc Pivot Table)<\/h2>\n\n\n\n<p>\u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u062c\u0627\u062f \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Pivot Table\u0647\u0627 \u0627\u062c\u062a\u0646\u0627\u0628\u200c\u0646\u0627\u067e\u0630\u06cc\u0631 \u0647\u0633\u062a\u0646\u062f. \u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644\u200c \u0642\u062f\u0645 \u0628\u0647 \u0642\u062f\u0645\u06cc \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u06a9\u0631\u062f\u06cc\u0645 \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u067e\u0633 \u062a\u0633\u06a9\u200c\u0647\u0627 \u0628\u0631\u0628\u06cc\u0627\u06cc\u06cc\u062f. \u0627\u06cc\u0646 \u062a\u0633\u06a9\u200c\u0647\u0627 \u062c\u0632\u0648\u06cc \u0627\u0632 \u0622\u0645\u0648\u0632\u0634 \u062d\u0631\u0641\u0647 \u0627\u06cc pivot table \u0647\u0633\u062a\u0646\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/e1_1403-08-16-164101554\/b82ce2d47c311b9970e58eb70b90445f.webp?expire=4893471932&#038;token=0c906ba547c8d552a5f724915d63ef8e&#038;md5=DJBrpUfI1VKl9ySRXWPvjg==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u0627\u0631\u06a9\u062a\u0631\u0647\u0627\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u0627\u0631\u06a9\u062a\u0631\u0647\u0627\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A7%DA%A9%D8%B3%D9%84-%D9%85%D8%A7%D8%B1%DA%A9%D8%AA%D8%B1%D9%87%D8%A7-mk1554\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u0627\u0631\u06a9\u062a\u0631\u0647\u0627        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f2\u06f9\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f1\u06f1\u06f9,\u06f6\u06f0\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f6\u06f0%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A7%DA%A9%D8%B3%D9%84-%D9%85%D8%A7%D8%B1%DA%A9%D8%AA%D8%B1%D9%87%D8%A7-mk1554\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p>\u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0686\u0646\u062f\u06cc\u0646 \u062c\u0646\u0628\u0647 \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0627\u0632 \u0622\u0645\u0648\u0632\u0634 pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0631\u0627\u0626\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0686\u06af\u0648\u0646\u0647 Pivot Table \u0631\u0627 \u0628\u0627 \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u0628\u0633\u0627\u0632\u06cc\u0645\u061f<\/h2>\n\n\n\n<p>\u062d\u0627\u0644\u0627 \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f Pivot Table \u0628\u0633\u0627\u0632\u06cc\u062f\u060c \u0686\u0637\u0648\u0631 \u0627\u0633\u062a \u0646\u0633\u062e\u0647 \u0686\u0646\u062f \u0633\u062a\u0648\u0646\u0647 \u0622\u0646 \u0631\u0627 \u0646\u06cc\u0632 \u0627\u0645\u062a\u062d\u0627\u0646 \u06a9\u0646\u06cc\u0645\u061f \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u062d\u0627\u0644\u062a \u0686\u0646\u062f \u0633\u062a\u0648\u0646\u0647\u060c \u0628\u0627 \u0622\u0645\u0648\u0632\u0634 \u062a\u0635\u0648\u06cc\u0631\u06cc Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0647\u0645\u0631\u0627\u0647 \u0628\u0627\u0634\u06cc\u062f \u0648 \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u062f\u0627\u0645\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong> \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc\u06cc \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631 Pivot Table \u0642\u0631\u0627\u0631 \u0628\u06af\u06cc\u0631\u062f\u060c \u0645\u0627\u0646\u0646\u062f \u0633\u0631\u0628\u0631\u06af \u0633\u062a\u0648\u0646\u200c\u0647\u0627.<\/li>\n\n\n\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u062f\u0631\u062c \u06a9\u0646\u06cc\u062f. <\/strong>\u0628\u0647 \u062a\u0628 Insert \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0648\u06cc\u062f \u0648 \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 PivotTable \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u062f\u0627\u0645\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u06af\u0632\u06cc\u0646\u06cc\u062f.<\/strong> \u062f\u0631 \u067e\u0646\u062c\u0631\u0647 Create PivotTable\u060c \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u062f\u0627\u0645\u0646\u0647 \u0635\u062d\u06cc\u062d \u0628\u0647\u200c\u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0646\u062a\u062e\u0627\u0628 \u0634\u062f\u0647 \u0648 \u062f\u0631\u0628\u0627\u0631\u0647 \u0645\u06a9\u0627\u0646 \u0642\u0631\u0627\u0631\u06af\u06cc\u0631\u06cc Pivot Table \u0646\u06cc\u0632 \u062a\u0635\u0645\u06cc\u0645 \u0628\u06af\u06cc\u0631\u06cc\u062f (\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0648\u0631\u06a9\u200c\u0634\u06cc\u062a \u062c\u062f\u06cc\u062f \u06cc\u0627 \u0648\u0631\u06a9\u200c\u0634\u06cc\u062a \u0645\u0648\u062c\u0648\u062f).<\/li>\n\n\n\n<li><strong>\u0686\u0646\u062f\u06cc\u0646 \u0633\u062a\u0648\u0646 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/strong> \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc Pivot Table\u060c \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0645\u062f\u0646\u0638\u0631 \u062e\u0648\u062f \u0628\u0631\u0627\u06cc \u0628\u0631\u0686\u0633\u0628 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u062f\u0627\u062e\u0644 \u0645\u0646\u0637\u0642\u0647 Columns \u0628\u06a9\u0634\u06cc\u062f. \u0627\u06cc\u0646 \u0641\u06cc\u0644\u062f\u0647\u0627\u060c \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u062f\u0631 pivot table \u0634\u0645\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n\n\n\n<li><strong>\u0628\u0631\u0686\u0633\u0628\u200c\u0647\u0627\u06cc \u0631\u062f\u06cc\u0641 \u0648 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.<\/strong> \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0645\u062f\u0646\u0638\u0631 \u062e\u0648\u062f \u0628\u0631\u0627\u06cc \u0628\u0631\u0686\u0633\u0628 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0631\u0627 \u0646\u06cc\u0632 \u0628\u0647 \u0645\u0646\u0637\u0642\u0647 Rows \u0628\u06a9\u0634\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"800\" height=\"600\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 Pivot Table \u0631\u0627 \u0628\u0627 \u0686\u0646\u062f \u0633\u062a\u0648\u0646 \u0628\u0633\u0627\u0632\u06cc\u0645\" class=\"wp-image-35531 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media.jpg 800w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-300x225.jpg.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-768x576.jpg.webp 768w\" data-sizes=\"(max-width: 800px) 100vw, 800px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 800px; --smush-placeholder-aspect-ratio: 800\/600;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0628\u0647 \u0647\u0645\u06cc\u0646 \u0634\u06a9\u0644\u060c \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0645\u062f\u0646\u0638\u0631 \u062e\u0648\u062f \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0648 \u062a\u062c\u0645\u06cc\u0639\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0645\u0646\u0637\u0642\u0647 Values \u0628\u06a9\u0634\u06cc\u062f.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u0633\u0641\u0627\u0631\u0634\u06cc \u06a9\u0646\u06cc\u062f.<\/strong> \u0634\u0645\u0627 \u062d\u062a\u06cc \u0628\u0627 \u062a\u0646\u0638\u06cc\u0645 \u0644\u0627\u06cc\u0647\u200c\u0628\u0646\u062f\u06cc\u200c\u0647\u0627\u060c \u0627\u0639\u0645\u0627\u0644 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627\u060c \u0645\u0631\u062a\u0628\u200c\u06a9\u0631\u062f\u0646 \u0648 \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f Pivot Table \u0631\u0627 \u0633\u0641\u0627\u0631\u0634\u06cc\u200c\u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u0686\u06af\u0648\u0646\u0647 <\/strong><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u0645\u061f<\/strong><\/h3>\n\n\n\n<p>\u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u067e\u06cc\u200c\u06a9\u0631\u062f\u0646 Pivot Table \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u06a9\u0644 <\/strong><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong> \u0631\u0648\u06cc \u0647\u0631 \u0646\u0642\u0637\u0647 \u062f\u0644\u062e\u0648\u0627\u0647 \u062f\u0631 \u062f\u0627\u062e\u0644 pivot table \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f. \u0628\u0627\u06cc\u062f \u0639\u0644\u0627\u0626\u0645 \u0627\u0646\u062a\u062e\u0627\u0628\u200c\u06a9\u0631\u062f\u0646 \u0631\u0627 \u062f\u0648\u0631 \u062c\u062f\u0648\u0644 \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong> \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0641\u0647\u0631\u0633\u062a \u0628\u0627\u0632\u0634\u062f\u0647\u060c Copy \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f \u06cc\u0627 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628\u06cc Ctrl+C \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u0645\u0642\u0635\u062f \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong> \u0628\u0647 \u0648\u0631\u06a9\u200c\u0634\u06cc\u062a\u06cc \u0628\u0631\u0648\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f pivot table \u0631\u0627 \u0642\u0631\u0627\u0631 \u0628\u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u067e\u06cc\u0633\u062a \u06a9\u0646\u06cc\u062f.<\/strong> \u0631\u0648\u06cc \u0633\u0644\u0648\u0644 \u0645\u062f\u0646\u0638\u0631 \u06a9\u0644\u06cc\u06a9 \u0631\u0627\u0633\u062a \u06a9\u0631\u062f\u0647 \u0648 \u06af\u0632\u06cc\u0646\u0647 Paste \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f \u06cc\u0627 \u062f\u06a9\u0645\u0647\u200c\u0647\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628\u06cc Ctrl+V \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u062f\u0627\u0645\u0646\u0647 <\/strong><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/strong> \u0627\u06af\u0631 pivot table \u062c\u062f\u06cc\u062f\u062a\u0627\u0646 \u0628\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0642\u0628\u0644\u06cc \u0628\u0631\u062e\u0648\u0631\u062f \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u060c \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 \u0639\u0644\u0627\u0626\u0645 \u06af\u0648\u0634\u0647 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u0627\u0646\u062f\u0627\u0632\u0647 \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u0628\u062f\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0647\u0631 Pivot Table \u062f\u0644\u062e\u0648\u0627\u0647\u06cc \u0631\u0627 \u0627\u0632 \u0647\u0631 \u0645\u06a9\u0627\u0646\u06cc \u0628\u0647 \u0645\u06a9\u0627\u0646 \u062f\u0644\u062e\u0648\u0627\u0647 \u0628\u0628\u0631\u06cc\u062f. \u062c\u0627\u0628\u0647\u200c\u062c\u0627\u06cc\u06cc \u062c\u062f\u0627\u0648\u0644 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0646\u06cc\u0632 \u0628\u0631\u0627\u06cc\u062a\u0627\u0646 \u0622\u0633\u0627\u0646 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"200\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/12\/image-14576-300x200.png.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u0622\u0645\u0648\u0632\u0634 \u062a\u0627\u0628\u0639 maxa \u062f\u0631 \u0627\u06a9\u0633\u0644\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/12\/image-14576-300x200.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/12\/image-14576.png 768w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/200;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/maxa-function-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0628\u0639 maxa \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u0686\u06af\u0648\u0646\u0647 Pivot Table \u0631\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u0645\u061f<\/h3>\n\n\n\n<p>\u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u06a9\u0631\u062f\u0646 pivot table \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0645\u062f\u0646\u0638\u0631 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong><\/li>\n\n\n\n<li>\u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0631\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u062f\u060c \u0631\u0648\u06cc \u0633\u0644\u0648\u0644\u06cc \u062f\u0631 \u062f\u0627\u062e\u0644 \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u06a9\u0645 \u0628\u0647 \u0632\u06cc\u0627\u062f \u06cc\u0627 \u0632\u06cc\u0627\u062f \u0628\u0647 \u06a9\u0645 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u062f.<\/strong><\/li>\n\n\n\n<li>\u0631\u0648\u06cc \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0627\u0646\u062a\u062e\u0627\u0628\u200c\u0634\u062f\u0647 \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 Sort \u0631\u0627 \u0627\u0632 \u0641\u0647\u0631\u0633\u062a \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u062f\u0631 \u0632\u06cc\u0631\u0641\u0647\u0631\u0633\u062a Sort\u060c \u06af\u0632\u06cc\u0646\u0647 Sort A to Z (\u06a9\u0645 \u0628\u0647 \u0632\u06cc\u0627\u062f) \u06cc\u0627 Sort Z to A (\u0632\u06cc\u0627\u062f \u0628\u0647 \u06a9\u0645) \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u062f\u0631 \u0631\u0648\u0634 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062f\u06a9\u0645\u0647\u200c\u0647\u0627\u06cc \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0628\u0647 \u062a\u0628 <\/strong><strong>pivot table<\/strong><strong> \u0628\u0631\u0648\u06cc\u062f.<\/strong> \u067e\u0633 \u0627\u0632 \u0627\u0646\u062a\u062e\u0627\u0628 pivot table \u0645\u062f\u0646\u0638\u0631\u060c \u0628\u0647 \u062a\u0628 Pivot Table Analyze \u06cc\u0627 Pivot Table Tools \u0628\u0631\u0648\u06cc\u062f.<\/li>\n\n\n\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u062f.<\/strong> \u062f\u0631 \u06af\u0631\u0648\u0647 Sort\u060c \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 Sort Ascending \u06cc\u0627 Sort Descending \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"345\" height=\"302\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-1.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 Pivot Table \u0631\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u0645\" class=\"wp-image-35519 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-1.jpg 345w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-1-300x263.jpg.webp 300w\" data-sizes=\"(max-width: 345px) 100vw, 345px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 345px; --smush-placeholder-aspect-ratio: 345\/302;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062e\u0644 \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u0631\u0627 \u0645\u0631\u062a\u0628 \u06a9\u0646\u06cc\u062f. \u06cc\u0627\u062f\u062a\u0627\u0646 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0645\u0631\u062a\u0628\u200c\u0633\u0627\u0632\u06cc pivot table\u060c \u0686\u06cc\u062f\u0645\u0627\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062e\u0644 \u0641\u06cc\u0644\u062f\u06cc \u062e\u0627\u0635 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0647 \u0648 \u0631\u0648\u06cc \u0633\u0627\u062e\u062a\u0627\u0631 \u06a9\u0644\u06cc \u062c\u062f\u0648\u0644 \u062a\u0627\u062b\u06cc\u0631 \u0646\u0645\u06cc\u200c\u06af\u0630\u0627\u0631\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0686\u06af\u0648\u0646\u0647 Pivot Table \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u061f<\/h3>\n\n\n\n<p>\u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062d\u0630\u0641\u200c\u06a9\u0631\u062f\u0646 Pivot Table \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Pivot Table<\/strong><strong> \u0645\u062f\u0646\u0638\u0631 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f. <\/strong>\u0631\u0648\u06cc \u0647\u0631 \u0646\u0642\u0637\u0647 \u062f\u0644\u062e\u0648\u0627\u0647 \u0627\u0632 \u062c\u062f\u0648\u0644 \u0645\u062f\u0646\u0638\u0631 \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f.<\/strong><\/li>\n\n\n\n<li>\u062f\u06a9\u0645\u0647 Delete \u06cc\u0627 Backspace \u0631\u0627 \u0631\u0648\u06cc \u06a9\u06cc\u0628\u0648\u0631\u062f \u0641\u0634\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li>\u0631\u0648\u06cc pivot table \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 Delete \u0631\u0627 \u0627\u0632 \u0641\u0647\u0631\u0633\u062a \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0628\u0647 \u062a\u0628 PivotTable Analyze \u06cc\u0627 Pivot Table Tools \u0628\u0631\u0648\u06cc\u062f\u060c \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 Options \u06cc\u0627 Design \u0628\u0632\u0646\u06cc\u062f \u0648 \u06af\u0632\u06cc\u0646\u0647 Delete \u0631\u0627 \u0627\u0632 \u0641\u0647\u0631\u0633\u062a \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"325\" height=\"233\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-2.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 Pivot Table \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\" class=\"wp-image-35521 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-2.jpg 325w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-2-300x215.jpg.webp 300w\" data-sizes=\"(max-width: 325px) 100vw, 325px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 325px; --smush-placeholder-aspect-ratio: 325\/233;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u062d\u0630\u0641\u200c\u06a9\u0631\u062f\u0646 \u0631\u0627 \u062a\u0627\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f.<\/strong> \u0627\u06a9\u0633\u0644 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u0634\u0645\u0627 \u0628\u062e\u0648\u0627\u0647\u062f \u06a9\u0647 \u062d\u0630\u0641 pivot table \u0631\u0627 \u062a\u0627\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f. \u067e\u06cc\u0627\u0645 \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f \u0648 OK \u06cc\u0627 Yes \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0645\u0631\u0627\u062d\u0644 \u0631\u0627 \u062a\u06a9\u0645\u06cc\u0644 \u06a9\u0631\u062f\u06cc\u062f\u060c pivot table \u0648 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0622\u0646 \u0627\u0632 \u0648\u0631\u06a9\u200c\u0634\u06cc\u062a \u062d\u0630\u0641 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u062d\u0648\u0627\u0633\u062a\u0627\u0646 \u0628\u0627\u0634\u062f \u06a9\u0647 \u062d\u0630\u0641\u200c\u06a9\u0631\u062f\u0646 PivotTable\u060c \u0645\u0646\u0628\u0639 \u0627\u0635\u0644\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u06cc\u0627 \u0647\u0631\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u0631\u0627 \u062f\u0631 \u0648\u0631\u06a9\u200c\u0628\u0648\u06a9 \u062d\u0630\u0641 \u0646\u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n\n\n\n<p>\u0641\u0642\u0637 \u0646\u0645\u0627\u06cc \u0628\u0635\u0631\u06cc Pivot Table \u0631\u0627 \u0627\u0632 \u0648\u0631\u06a9\u200c\u0634\u06cc\u062a \u067e\u0627\u06a9 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0686\u06af\u0648\u0646\u0647 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 Pivot Table \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u0645\u061f<\/h3>\n\n\n\n<p>\u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0633\u062a\u0648\u0646 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u060c \u0642\u0627\u0644\u0628 \u0645\u0646\u0627\u0633\u0628 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u0631\u0627 \u062f\u0627\u0631\u062f. <\/strong>\u0627\u06af\u0631 \u0646\u062f\u0627\u0631\u062f\u060c \u0642\u0627\u0644\u0628 \u0633\u062a\u0648\u0646 \u0631\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u062f\u0631\u0628\u06cc\u0627\u0648\u0631\u06cc\u062f.<\/li>\n\n\n\n<li>\u0647\u0631\u06af\u0648\u0646\u0647 \u0633\u0644\u0648\u0644\u06cc \u0631\u0627 \u062f\u0631 \u062f\u0627\u062e\u0644 \u0633\u062a\u0648\u0646 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc PivotTable \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 Group \u0631\u0627 \u0627\u0632 \u0641\u0647\u0631\u0633\u062a \u0628\u0631\u06af\u0632\u06cc\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"667\" height=\"128\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-3.jpg\" alt=\"\u0686\u06af\u0648\u0646\u0647 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 Pivot Table \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u0645\" class=\"wp-image-35523 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-3.jpg 667w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-3-300x58.jpg.webp 300w\" data-sizes=\"(max-width: 667px) 100vw, 667px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 667px; --smush-placeholder-aspect-ratio: 667\/128;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u067e\u0646\u062c\u0631\u0647 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0638\u0627\u0647\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/strong> \u06af\u0632\u06cc\u0646\u0647 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0645\u0646\u0627\u0633\u0628 \u0628\u0627 \u0646\u06cc\u0627\u0632\u0647\u0627\u06cc\u062a\u0627\u0646 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f\u061b \u0645\u0627\u0646\u0646\u062f \u0631\u0648\u0632\u0647\u0627\u060c \u0645\u0627\u0647\u200c\u0647\u0627\u060c \u0641\u0635\u0644\u200c\u0647\u0627 \u06cc\u0627 \u0633\u0627\u0644\u200c\u0647\u0627. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0686\u0646\u062f\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0631\u0627 \u0628\u0627 \u0646\u06af\u0647\u200c\u062f\u0627\u0634\u062a\u0646 \u062f\u06a9\u0645\u0647 Ctrl \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"242\" height=\"310\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-4.jpg\" alt=\"\u067e\u0646\u062c\u0631\u0647 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc\" class=\"wp-image-35525 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2024\/01\/media-4.jpg 242w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2024\/01\/media-4-234x300.jpg.webp 234w\" data-sizes=\"(max-width: 242px) 100vw, 242px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 242px; --smush-placeholder-aspect-ratio: 242\/310;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc \u0634\u0631\u0648\u0639 \u0648 \u067e\u0627\u06cc\u0627\u0646 \u0631\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0631\u0648\u06cc OK \u0628\u0632\u0646\u06cc\u062f \u062a\u0627 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0627\u0639\u0645\u0627\u0644 \u0634\u0648\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u0627\u06a9\u0633\u0644 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 \u0646\u062d\u0648 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0627\u0646\u062a\u062e\u0627\u0628\u200c\u0634\u062f\u0647\u060c \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f. PivotTable\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<p><strong>\u062a\u0648\u062c\u0647:<\/strong> \u0645\u0631\u0627\u062d\u0644 \u06a9\u0645\u06cc \u0628\u0647 \u0646\u0633\u062e\u0647 \u0627\u06a9\u0633\u0644 \u0634\u0645\u0627 \u0628\u0633\u062a\u06af\u06cc \u062f\u0627\u0631\u062f. \u0627\u06af\u0631 \u06af\u0632\u06cc\u0646\u0647 Group \u0631\u0627 \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0646\u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f\u060c \u0628\u0627 \u0631\u0641\u062a\u0646 \u0628\u0647 \u062a\u0628 PivotTable Analyzer \u06cc\u0627 PivotTable Tools \u0646\u06cc\u0632 \u0628\u0647 \u067e\u0646\u062c\u0631\u0647 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0627\u0634\u062a. \u062f\u06a9\u0645\u0647 Group Field \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f \u0648 \u0645\u0631\u0627\u062d\u0644 \u0631\u0627 \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u06cc\u062f.<\/p>\n\n\n\n<p>\u0634\u0645\u0627 \u0628\u0627 \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627 \u062f\u0631 PivotTable \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc \u0632\u0645\u0627\u0646\u06cc \u0645\u0634\u062e\u0635\u200c\u0634\u062f\u0647 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u062f. \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc \u0632\u0645\u0627\u0646\u06cc \u0645\u0627\u0646\u0646\u062f \u0645\u0627\u0647\u06cc\u0627\u0646\u0647 \u06a9\u0647 \u062f\u0631\u06a9 \u0648\u0627\u0636\u062d\u200c\u062a\u0631\u06cc \u0627\u0632 \u0631\u0648\u0646\u062f\u0647\u0627 \u0648 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0628\u0647\u200c\u062f\u0633\u062a \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0686\u06af\u0648\u0646\u0647 \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u0631\u0627 \u0628\u0647 PivotTable \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645\u061f<\/h3>\n\n\n\n<p>\u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u062f\u0631 PivotTable \u0627\u06a9\u0633\u0644 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f\u060c \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0647\u0631 \u0633\u0644\u0648\u0644\u06cc \u0631\u0627 \u062f\u0631 Pivot Table \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0628\u0647 \u062a\u0628 PivotTable Analyzer \u06cc\u0627 PivotTable Tools \u0628\u0631\u0648\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u0628\u0647 \u06af\u0631\u0648\u0647 <\/strong><strong>Calculations<\/strong><strong> \u0628\u0631\u0648\u06cc\u062f.<\/strong> \u0631\u0648\u06cc Fields, Items &amp; Sets \u0628\u0632\u0646\u06cc\u062f \u0648 Calculated Field \u0631\u0627 \u0627\u0632 \u0641\u0647\u0631\u0633\u062a \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u067e\u0646\u062c\u0631\u0647 <\/strong><strong>Insert Calculated Field<\/strong><strong> \u0638\u0627\u0647\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/strong> \u0646\u0627\u0645\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u062e\u0648\u062f \u062f\u0631 \u062c\u0627\u06cc \u062e\u0627\u0644\u06cc Name \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0641\u0631\u0645\u0648\u0644 \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u0631\u0627 \u062f\u0631 \u062c\u0627\u06cc \u062e\u0627\u0644\u06cc Formula \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0639\u0645\u0644\u06af\u0631\u0647\u0627\u06cc \u0631\u06cc\u0627\u0636\u06cc\u060c \u0641\u0627\u0646\u06a9\u0634\u0646\u200c\u0647\u0627 \u0648 \u0627\u0631\u062c\u0627\u0639 \u0628\u0647 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 Pivot Table \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0631\u0648\u06cc OK \u0628\u0632\u0646\u06cc\u062f \u062a\u0627 \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u0628\u0647 \u062c\u062f\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u0634\u0648\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u062d\u0627\u0644\u0627 PivotTable\u060c \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u0631\u0627 \u0628\u0633\u062a\u0647 \u0628\u0647 \u0644\u0627\u06cc\u0647\u200c\u0628\u0646\u062f\u06cc \u062c\u062f\u0648\u0644\u060c \u0645\u0627\u0646\u0646\u062f \u0633\u062a\u0648\u0646 \u06cc\u0627 \u0631\u062f\u06cc\u0641 \u062c\u062f\u06cc\u062f\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u0627\u0632 \u0641\u0631\u0645\u0648\u0644 \u062a\u0639\u06cc\u06cc\u0646\u200c\u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u062c\u0627\u0644\u0628 \u0627\u0633\u062a \u0646\u0647\u061f<\/p>\n\n\n\n<p><strong>\u062a\u0648\u062c\u0647:<\/strong> \u0627\u06cc\u0646 \u0645\u0631\u0627\u062d\u0644 \u0628\u0633\u062a\u0647 \u0628\u0647 \u0646\u0633\u062e\u0647 \u0627\u06a9\u0633\u0644 \u0634\u0645\u0627\u060c \u06a9\u0645\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0627\u0631\u062f. \u0627\u06af\u0631 \u062f\u06a9\u0645\u0647 Fields, Items &amp; Sets \u0631\u0627 \u0646\u0645\u06cc\u200c\u0628\u06cc\u0646\u06cc\u062f\u060c \u0631\u0648\u06cc \u062c\u062f\u0648\u0644 \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 \u06af\u0632\u06cc\u0646\u0647 Show Field List \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f. \u0647\u0631\u062f\u0648 \u06a9\u0627\u0631 \u0645\u0634\u0627\u0628\u0647\u06cc \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u062f\u0647\u0646\u062f.<\/p>\n\n\n\n<p>\u0627\u0636\u0627\u0641\u0647\u200c\u06a9\u0631\u062f\u0646 \u0641\u06cc\u0644\u062f \u0645\u062d\u0627\u0633\u0628\u0647\u200c\u0634\u062f\u0647 \u0628\u0647 Pivot Table\u060c \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0645\u0646\u062d\u0635\u0631 \u0628\u0647\u200c\u0641\u0631\u062f\u06cc \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f \u0648 \u0628\u06cc\u0646\u0634\u200c\u0647\u0627\u06cc \u062c\u062f\u06cc\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 Pivot Table \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0686\u06af\u0648\u0646\u0647 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0644 \u0631\u0627 \u0627\u0632 PivotTable \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u061f<\/h3>\n\n\n\n<p>\u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0644 \u0627\u0632 PivotTable \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0647\u0631\u06af\u0648\u0646\u0647 \u0633\u0644\u0648\u0644\u06cc \u0631\u0627 \u062f\u0631 \u062f\u0627\u062e\u0644 \u062c\u062f\u0648\u0644 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0628\u0647 \u062a\u0628 PivotTable Analyzer \u06cc\u0627 PivotTable Tools \u0628\u0631\u0648\u06cc\u062f.<\/li>\n\n\n\n<li>\u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 Field Settings \u06cc\u0627 Options \u062f\u0631 \u06af\u0631\u0648\u0647 PivotTable Options \u0628\u0632\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u067e\u0646\u062c\u0631\u0647 PivotTable Field Settings \u06cc\u0627 PivotTable Options \u0638\u0627\u0647\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/li>\n\n\n\n<li>\u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0633\u062a\u0647 \u0628\u0647 \u0646\u0633\u062e\u0647 \u0627\u06a9\u0633\u0644 \u062e\u0648\u062f \u0637\u06cc \u06a9\u0646\u06cc\u062f:\n<ul class=\"wp-block-list\">\n<li>\u0628\u0631\u0627\u06cc \u0627\u06a9\u0633\u0644 \u06f2\u06f0\u06f1\u06f3 \u0648 \u0642\u062f\u06cc\u0645\u06cc\u200c\u062a\u0631: \u062f\u0631 \u062a\u0628 Subtotals &amp; Filters\u060c \u062a\u06cc\u06a9 \u06a9\u0646\u0627\u0631 Grand Total \u0631\u0627 \u0628\u0631\u062f\u0627\u0631\u06cc\u062f.<\/li>\n\n\n\n<li>\u0628\u0631\u0627\u06cc \u0627\u06a9\u0633\u0644 \u06f2\u06f0\u06f1\u06f6 \u0648 \u062c\u062f\u06cc\u062f\u062a\u0631: \u062f\u0631 \u062a\u0628 Totals &amp; Filters\u060c \u062a\u06cc\u06a9 \u06a9\u0646\u0627\u0631 Show Grand Totals for rows\/coumns \u0631\u0627 \u0628\u0631\u062f\u0627\u0631\u06cc\u062f.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>\u0628\u0627 \u062d\u0630\u0641 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0644 \u0627\u0632 \u062c\u062f\u0648\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0631\u0648\u06cc \u062c\u0645\u0639 \u0647\u0631 \u0631\u062f\u06cc\u0641 \u06cc\u0627 \u0633\u062a\u0648\u0646 \u062a\u0645\u0631\u06a9\u0632 \u06a9\u0631\u062f\u0647 \u0648 \u062c\u0645\u0639 \u0647\u0645\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f. \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0632\u0645\u0627\u0646\u06cc \u0628\u0647 \u06a9\u0627\u0631\u062a\u0627\u0646 \u0645\u06cc\u200c\u0622\u06cc\u062f \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0631\u0641\u062a\u0627\u0631 \u062c\u0632\u0626\u06cc\u200c\u062a\u0631\u06cc \u0646\u0633\u0628\u062a \u0628\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u06f7 \u0646\u06a9\u062a\u0647 \u0648 \u062a\u0631\u0641\u0646\u062f \u0628\u0631\u0627\u06cc Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0686\u0646\u062f \u0646\u06a9\u062a\u0647 \u0648 \u062a\u0631\u0641\u0646\u062f \u0645\u0641\u06cc\u062f \u0628\u0631\u0627\u06cc Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0639\u0631\u0641 \u06a9\u0646\u06cc\u0645.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong> \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0627\u0645\u0646\u0647 \u062f\u0627\u062f\u0647 \u0635\u062d\u06cc\u062d<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f PivotTable\u060c \u062f\u0627\u0645\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u0635\u062d\u06cc\u062d \u0627\u0633\u062a. \u0647\u0645\u0647 \u0633\u062a\u0648\u0646 \u0648 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u0636\u0631\u0648\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0628\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f \u0648 \u062d\u0648\u0627\u0633\u062a\u0627\u0646 \u0628\u0627\u0634\u062f \u06a9\u0647 \u0633\u0644\u0648\u0644 \u062e\u0627\u0644\u06cc \u062f\u0631\u0648\u0646 \u062c\u062f\u0648\u0644 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<\/p>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong> \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u062f\u0648\u0631\u06cc \u0627\u0632 \u0645\u0634\u06a9\u0644\u0627\u062a \u0627\u062d\u062a\u0645\u0627\u0644\u06cc \u062f\u0631 \u062a\u0641\u0633\u06cc\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0647\u200c\u062f\u0631\u0633\u062a\u06cc \u0642\u0627\u0644\u0628\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f. \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0632 \u0642\u0627\u0644\u0628\u06cc \u067e\u06cc\u0648\u0633\u062a\u0647 \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062a\u0627\u0631\u06cc\u062e\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0648 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u0645\u062a\u0646\u06cc \u0628\u0631\u062e\u0648\u0631\u062f\u0627\u0631\u0646\u062f.<\/p>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong> \u0627\u0646\u062a\u062e\u0627\u0628 \u0639\u0627\u0642\u0644\u0627\u0646\u0647 \u0646\u0627\u0645 \u0641\u06cc\u0644\u062f\u0647\u0627<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0627\u0632 \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u0648\u0627\u0636\u062d \u0648 \u062a\u0648\u0635\u06cc\u0641\u06cc \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0628\u062f\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628\u060c \u062f\u0631\u06a9 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc Pivot Table\u060c \u0631\u0627\u062d\u062a\u200c\u062a\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong> \u0627\u0639\u0645\u0627\u0644 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627\u06cc <\/strong><strong>Pivot Table<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631\u06a9\u0631\u062f\u0646 \u0628\u0631\u0627\u06cc \u062a\u0645\u0631\u06a9\u0632 \u0631\u0648\u06cc \u0632\u06cc\u0631\u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0647\u0627\u06cc \u0645\u0634\u062e\u0635 \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0647\u0631\u0647 \u0628\u0628\u0631\u06cc\u062f. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0641\u06cc\u0644\u062a\u0631\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062a\u06a9\u06cc \u0627\u0639\u0645\u0627\u0644 \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0633\u0644\u0627\u06cc\u0633\u0631\u060c \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0628\u0635\u0631\u06cc \u0628\u0627 Pivot Table \u062e\u0648\u062f \u062a\u0639\u0627\u0645\u0644 \u0628\u0631\u0642\u0631\u0627\u0631 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li><strong> \u0637\u0628\u0642\u0647\u200c\u0628\u0646\u062f\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0627\u06af\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0647\u062a\u0631\u060c \u06af\u0631\u0648\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f. \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u0633\u0627\u0633 \u062a\u0627\u0631\u06cc\u062e\u060c \u062f\u0627\u0645\u0646\u0647 \u0639\u062f\u062f\u06cc \u06cc\u0627 \u0637\u0628\u0642\u0647\u200c\u0628\u0646\u062f\u06cc \u062e\u0627\u0635 \u062e\u0648\u062f\u060c \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li><strong> \u0633\u0641\u0627\u0631\u0634\u06cc\u200c\u0633\u0627\u0632\u06cc \u0644\u0627\u06cc\u0647\u200c\u0628\u0646\u062f\u06cc <\/strong><strong>Pivot Table<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0628\u0627 \u0627\u06a9\u0633\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0644\u0627\u06cc\u0647\u200c\u0628\u0646\u062f\u06cc PivotTable \u0631\u0627 \u0633\u0641\u0627\u0631\u0634\u06cc \u06a9\u0646\u06cc\u062f. \u0641\u06cc\u0644\u062f\u0647\u0627 \u0631\u0627 \u0628\u06cc\u0646 \u0645\u0646\u0627\u0637\u0642 \u0645\u062e\u062a\u0644\u0641 PivotTable \u0628\u06a9\u0634\u06cc\u062f \u062a\u0627 \u0686\u06cc\u062f\u0645\u0627\u0646 \u0644\u0627\u06cc\u0647\u200c\u0628\u0646\u062f\u06cc \u0639\u0648\u0636 \u0634\u062f\u0647 \u0648 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0645\u0641\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644\u200c \u0645\u0645\u06a9\u0646 \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u06cc\u062f.<\/p>\n\n\n\n<ol start=\"7\" class=\"wp-block-list\">\n<li><strong> \u062a\u0627\u0632\u0647\u200c\u0633\u0627\u0632\u06cc \u0648 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\u0627\u06af\u0631 \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u06a9\u0631\u062f\u0647 \u06cc\u0627 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u062f\u060c \u06cc\u0627\u062f\u062a\u0627\u0646 \u0628\u0627\u0634\u062f \u06a9\u0647 \u062c\u062f\u0648\u0644 \u0631\u0627 \u0631\u0641\u0631\u0634 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0622\u062e\u0631\u06cc\u0646 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc\u200c\u0647\u0627 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f. \u0628\u0631\u0627\u06cc \u062a\u0627\u0632\u0647\u200c\u0633\u0627\u0632\u06cc \u062c\u062f\u0648\u0644 \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0637\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/strong> \u0631\u0648\u06cc \u0647\u0631 \u0642\u0633\u0645\u062a\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>Pivot Table<\/strong><strong> \u0631\u0627 \u0631\u0641\u0631\u0634 \u06a9\u0646\u06cc\u062f. <\/strong>\u0686\u0646\u062f\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f:<br><br>\u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 \u06af\u0632\u06cc\u0646\u0647 Refresh \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f.<br><br>\u0628\u0647 \u062a\u0628 PivotTable Analyzer \u06cc\u0627 PivotTable Tools \u0631\u0641\u062a\u0647 \u0648 \u0631\u0648\u06cc \u062f\u06a9\u0645\u0647 Refresh \u0628\u0632\u0646\u06cc\u062f.<br><br>\u0627\u0632 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc \u062a\u0631\u06a9\u06cc\u0628\u06cc Alt+F5 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li><strong>\u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0647\u200c\u0631\u0648\u0632\u0634\u062f\u0647 \u0631\u0627 \u062a\u0627\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f. <\/strong>\u067e\u0633 \u0627\u0632 \u0631\u0641\u0631\u0634\u200c\u06a9\u0631\u062f\u0646\u060c \u062c\u062f\u0648\u0644 \u0628\u0647 \u0622\u062e\u0631\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0648\u0631\u0648\u062f\u06cc \u0628\u0647\u200c\u0631\u0648\u0632 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06cc\u0647 \u0628\u0631\u0631\u0633\u06cc \u0628\u0631\u0627\u06cc \u062a\u0627\u06cc\u06cc\u062f \u0635\u062d\u0628\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u0628\u0627 \u0637\u06cc\u200c\u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0645\u0631\u0627\u062d\u0644\u060c \u062c\u062f\u0648\u0644 \u0634\u0645\u0627 \u0628\u0647\u200c\u0631\u0648\u0632\u0634\u062f\u0647 \u0648 \u0647\u0645\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0627\u062e\u06cc\u0631 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u200c\u06a9\u0631\u062f\u0646 \u0627\u0632 \u0627\u06cc\u0646 \u0646\u06a9\u062a\u0647\u200c\u0647\u0627 \u0648 \u062a\u0631\u0641\u0646\u062f\u0647\u0627 \u0628\u0627\u0639\u062b \u0645\u06cc\u200c\u0634\u0648\u062f \u062a\u0627 \u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0631\u0627 \u0627\u0632 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0628\u0631\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u062f\u0631\u062c Pivot Table<\/h2>\n\n\n\n<p>&nbsp;\u062f\u0631\u062c Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0641\u0631\u0622\u06cc\u0646\u062f\u06cc \u0633\u0627\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0648 \u0631\u0641\u062a\u0646 \u0628\u0647 \u0632\u0628\u0627\u0646\u0647 Insert \u0648 \u0633\u067e\u0633 \u06a9\u0644\u06cc\u06a9 \u0628\u0631 \u0631\u0648\u06cc \u06af\u0632\u06cc\u0646\u0647 PivotTable \u0622\u063a\u0627\u0632 \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0631 \u067e\u0646\u062c\u0631\u0647 \u0628\u0627\u0632 \u0634\u062f\u0647\u060c \u0645\u062d\u062f\u0648\u062f\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648 \u0645\u062d\u0644 \u0642\u0631\u0627\u0631\u06af\u06cc\u0631\u06cc Pivot Table (\u062f\u0631 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631\u06af \u062c\u062f\u06cc\u062f \u06cc\u0627 \u06a9\u0627\u0631\u0628\u0631\u06af \u0645\u0648\u062c\u0648\u062f) \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u0634\u0648\u062f. \u067e\u0633 \u0627\u0632 \u062a\u0623\u06cc\u06cc\u062f\u060c \u06cc\u06a9 PivotTable \u062e\u0627\u0644\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u0622\u0645\u0627\u062f\u0647 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0627\u0633\u062a. \u0628\u0631\u0627\u06cc \u062a\u0645\u0631\u06cc\u0646 \u0648 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0647\u062a\u0631\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0646\u0645\u0648\u0646\u0647 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062a\u0645\u0631\u06cc\u0646 pivot table \u0628\u0633\u06cc\u0627\u0631 \u0645\u0641\u06cc\u062f \u0627\u0633\u062a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0627\u062c\u0632\u0627\u06cc \u062a\u0634\u06a9\u06cc\u0644 \u062f\u0647\u0646\u062f\u0647 Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>&nbsp;\u06cc\u06a9 Pivot Table \u0627\u0632 \u0686\u0647\u0627\u0631 \u0628\u062e\u0634 \u0627\u0635\u0644\u06cc \u062a\u0634\u06a9\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Filters (\u0641\u06cc\u0644\u062a\u0631\u0647\u0627):<\/strong> \u0628\u0631\u0627\u06cc \u0641\u06cc\u0644\u062a\u0631 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0641\u06cc\u0644\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u06cc\u0644\u062a\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0645\u062d\u062f\u0648\u062f \u06a9\u0631\u062f\u0647 \u0648 \u0641\u0642\u0637 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f.<\/li>\n\n\n\n<li><strong>Columns (\u0633\u062a\u0648\u0646\u200c\u0647\u0627):<\/strong> \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0642\u0633\u0645\u062a \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u0646\u062f\u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc Pivot Table \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/li>\n\n\n\n<li><strong>Rows (\u0633\u0637\u0631\u0647\u0627):<\/strong> \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0642\u0633\u0645\u062a \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u0646\u062f\u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u0637\u0631\u0647\u0627\u06cc Pivot Table \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f.<\/li>\n\n\n\n<li><strong>Values (\u0645\u0642\u0627\u062f\u06cc\u0631):<\/strong> \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0634\u0627\u0645\u0644 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0647\u0633\u062a\u0646\u062f \u0648 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0645\u062d\u0627\u0633\u0628\u0627\u062a\u06cc \u0645\u0627\u0646\u0646\u062f \u062c\u0645\u0639\u060c \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u060c \u0634\u0645\u0627\u0631\u0634 \u0648 \u063a\u06cc\u0631\u0647 \u0628\u0631 \u0631\u0648\u06cc \u0622\u0646\u200c\u0647\u0627 \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f\u060c \u062f\u0631 \u0627\u06cc\u0646 \u0642\u0633\u0645\u062a \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u0646\u062f.<\/li>\n<\/ul>\n\n\n\n<p>\u0627\u06cc\u0646 \u0627\u062c\u0632\u0627 \u0628\u0627 \u06a9\u0634\u06cc\u062f\u0646 \u0648 \u0631\u0647\u0627 \u06a9\u0631\u062f\u0646 \u0641\u06cc\u0644\u062f\u0647\u0627 \u0627\u0632 \u0644\u06cc\u0633\u062a \u0641\u06cc\u0644\u062f\u0647\u0627 \u0628\u0647 \u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u0627\u06cc\u0646 \u0686\u0647\u0627\u0631 \u0628\u062e\u0634\u060c \u0642\u0627\u0628\u0644 \u062a\u0646\u0638\u06cc\u0645 \u0647\u0633\u062a\u0646\u062f. \u06a9\u0627\u0631 \u0628\u0627 pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0627 \u0634\u0646\u0627\u062e\u062a \u0627\u06cc\u0646 \u0628\u062e\u0634\u200c\u0647\u0627 \u0622\u0633\u0627\u0646\u200c\u062a\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>&nbsp;\u067e\u0633 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f Pivot Table\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0646\u0628\u0639 \u062a\u063a\u06cc\u06cc\u0631 \u06a9\u0646\u0646\u062f. \u0628\u0631\u0627\u06cc \u0627\u0639\u0645\u0627\u0644 \u0627\u06cc\u0646 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 Pivot Table\u060c \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u06a9\u0631\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0631 \u0631\u0648\u06cc Pivot Table \u0631\u0627\u0633\u062a \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 \u06af\u0632\u06cc\u0646\u0647 Refresh \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0632\u0628\u0627\u0646\u0647 Analyze (\u06cc\u0627 Options \u062f\u0631 \u0646\u0633\u062e\u0647\u200c\u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc\u200c\u062a\u0631 \u0627\u06a9\u0633\u0644) \u0648 \u06af\u0632\u06cc\u0646\u0647 Refresh All \u0628\u0631\u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0647\u0645\u0647 Pivot Table\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u06a9\u0627\u0631\u0628\u0631\u06af \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u06af\u0632\u0627\u0631\u0634 \u06af\u06cc\u0631\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0627 pivot table \u0647\u0645\u06cc\u0634\u0647 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0622\u062e\u0631\u06cc\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0646\u062c\u0627\u0645 \u0634\u0648\u062f.<\/p>\n\n\n\n<p>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0628\u0647 \u0633\u0631\u0639\u062a \u0648 \u0628\u0647 \u0622\u0633\u0627\u0646\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0631\u062f\u0647 \u0648 \u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u0645\u0641\u06cc\u062f \u0648 \u062e\u0644\u0627\u0635\u0647 \u0627\u0632 \u0622\u0646\u200c\u0647\u0627 \u062a\u0647\u06cc\u0647 \u06a9\u0646\u0646\u062f. \u0622\u0645\u0648\u0632\u0634 pivot table \u0648 \u067e\u06cc\u0648\u062a \u062a\u06cc\u0628\u0644 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u0645\u0646\u0627\u0628\u0639 \u0645\u062e\u062a\u0644\u0641\u06cc \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a \u0648 \u0628\u0627 \u062a\u0645\u0631\u06cc\u0646 \u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u062f\u0627\u0648\u0645\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0647 \u062a\u0633\u0644\u0637 \u06a9\u0627\u0645\u0644 \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0628\u0632\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u062f\u0633\u062a \u06cc\u0627\u0641\u062a. \u062f\u0648\u0631\u0647 <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%A7%DA%A9%D8%B3%D9%84-%D9%85%D8%B4%D8%A7%D8%BA%D9%84-%D8%A7%D8%AF%D8%A7%D8%B1%DB%8C-%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D8%A7%D9%85-mk8334\/\">\u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0647\u0627\u06cc \u0627\u062f\u0627\u0631\u06cc<\/a>&nbsp;\u0645\u06a9\u0645\u0644 \u062e\u0648\u0628\u06cc \u0628\u0631\u0627\u06cc \u0628\u062d\u062b \u0628\u0627\u0644\u0627 \u0627\u0633\u062a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u062f\u0631\u06a9 \u0639\u0645\u06cc\u0642\u200c\u062a\u0631 \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u062f\u0631 \u0645\u0628\u062d\u062b pivot table \u0628\u0647 \u0632\u0628\u0627\u0646 \u0633\u0627\u062f\u0647 \u0633\u0639\u06cc \u06a9\u0631\u062f\u06cc\u0645 \u062a\u0627 \u0647\u0645\u0647 \u062c\u0646\u0628\u0647\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0627\u0628\u0632\u0627\u0631 PivotTable \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u0645. \u0627\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f \u062a\u0627 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0634\u06a9\u0644 \u062f\u0633\u062a\u0647\u200c\u0628\u0646\u062f\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u06cc\u062f. \u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0631\u0628\u0627\u0631\u0647 \u0627\u06a9\u0633\u0644 \u0628\u06cc\u0634\u062a\u0631 \u06cc\u0627\u062f \u0628\u06af\u06cc\u0631\u06cc\u062f \u0648 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0628\u06cc\u200c\u0646\u0638\u06cc\u0631 \u0622\u0646 \u0631\u0627 \u06a9\u0634\u0641 \u06a9\u0646\u06cc\u062f\u060c \u062f\u0648\u0631\u0647 \u0647\u0627\u06cc <a href=\"https:\/\/maktabkhooneh.org\/learn\/excel\/\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/a> \u0648 <a href=\"https:\/\/maktabkhooneh.org\/learn\/excel-accounting\/\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u062d\u0633\u0627\u0628\u062f\u0627\u0631\u06cc<\/a> \u062f\u0631 \u067e\u0644\u062a\u0641\u0631\u0645 \u0645\u06a9\u062a\u0628\u200c\u062e\u0648\u0646\u0647\u060c \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u062e\u0648\u0628\u06cc \u0627\u0633\u062a.<\/p>\n\n\n<div class=\"jet-listing-grid--50121\" style=\"\"><div class=\"jet-listing-dynamic-field-block zht-maktab-khooneh-course cb-fb2qc30r\"data-is-block=\"jet-engine\/dynamic-field\"><div class=\"jet-listing-dynamic-field__content\" >\n<div class=\"course-card\">\n    <div class=\"course-card-img\">\n        <img decoding=\"async\" \n            data-src=\"https:\/\/media1.maktabkhooneh.org\/CACHE\/images\/courses\/images\/2934_1403-11-23-111625018\/9fc1471b1f9a0bae5ff1731bbb097b02.webp?expire=4893471932&#038;token=b6a0727552f1f4fe8da4d30945610e38&#038;md5=tqBydVLx9P6NpNMJRWEOOA==\" \n            alt=\"\u0622\u0645\u0648\u0632\u0634 \u062c\u0627\u0645\u0639 \u0627\u06a9\u0633\u0644\" \n            title=\"\u0622\u0645\u0648\u0632\u0634 \u062c\u0627\u0645\u0639 \u0627\u06a9\u0633\u0644\" \n            width=\"100%\" \n            height=\"auto\"\n           \n         src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\">\n    <\/div>\n\n    <div class=\"course-details\">\n        <a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%AC%D8%A7%D9%85%D8%B9-%D8%A7%DA%A9%D8%B3%D9%84-2021-mk2934\/\" class=\"course-title\" target=\"_blank\" rel=\"noopener noreferrer\">\n            \u0622\u0645\u0648\u0632\u0634 \u062c\u0627\u0645\u0639 \u0627\u06a9\u0633\u0644        <\/a>\n\n        <div class=\"course-price\">\n            \n                <span class=\"real-price\">\n                                            \u06f8\u06f4\u06f9,\u06f0\u06f0\u06f0                                    <\/span>\n\n                <span>\n                    <span class=\"discounted-price\">\n                        \u06f5\u06f5\u06f1,\u06f8\u06f5\u06f0                    <\/span>\n                    <span class=\"price-currency\">\u062a\u0648\u0645\u0627\u0646<\/span>\n                <\/span>\n\n                                    <div class=\"discount-percentage\">\n                        \u06f3\u06f5%                    <\/div>\n                \n                    <\/div>\n        <button class=\"course-cta-button\" data-course-url=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D8%AC%D8%A7%D9%85%D8%B9-%D8%A7%DA%A9%D8%B3%D9%84-2021-mk2934\/\">\n            \u0645\u0634\u0627\u0647\u062f\u0647 \u0648 \u062e\u0631\u06cc\u062f        <\/button>\n    <\/div>\n<\/div>\n<\/div><\/div><\/div>\n\n\n<p>\u0645\u0646\u0628\u0639: <a href=\"https:\/\/blog.hubspot.com\/marketing\/how-to-create-pivot-table-tutorial-ht#examples\" rel=\"nofollow noopener\" target=\"_blank\">blog.hubspot<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pivot Table \u062f\u0631 \u0627\u06a9\u0633\u0644 \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u062a\u0631\u06cc\u0646 \u0648 \u0645\u0631\u0639\u0648\u0628\u200c\u06a9\u0646\u0646\u062f\u0647\u200c\u062a\u0631\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a\u200c\u0647\u0627\u06cc \u0645\u0627\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u062a \u0627\u0633\u062a. pivot table \u062f\u0631 \u062e\u0644\u0627\u0635\u0647\u200c\u0633\u0627\u0632\u06cc \u0648 \u0628\u0627\u0645\u0639\u0646\u0627\u0633\u0627\u062e\u062a\u0646 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u06a9\u0627\u0631\u0628\u0631\u062f \u062f\u0627\u0631\u062f. \u0628\u0627 \u0627\u06cc\u0646\u200c\u062d\u0627\u0644\u060c \u0628\u0647 \u067e\u06cc\u0686\u06cc\u062f\u06af\u06cc \u0646\u06cc\u0632 \u0634\u0647\u0631\u0647 \u0627\u0633\u062a. \u062e\u0628\u0631 \u062e\u0648\u0628 \u0622\u0646\u06a9\u0647 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0627\u06cc\u062c\u0627\u062f pivot table \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0627\u0633\u062a \u0627\u0632 \u0622\u0646 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u0641\u06a9\u0631 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f. \u0645\u0627 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u06cc\u062c\u0627\u062f pivot table \u0631\u0627 \u0642\u062f\u0645 [&hellip;]<\/p>\n","protected":false},"author":28,"featured_media":35548,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[],"class_list":["post-35500","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-learn-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/35500","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/comments?post=35500"}],"version-history":[{"count":4,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/35500\/revisions"}],"predecessor-version":[{"id":65815,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/35500\/revisions\/65815"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media\/35548"}],"wp:attachment":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media?parent=35500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/categories?post=35500"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/tags?post=35500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}