{"id":56678,"date":"2025-02-03T14:15:33","date_gmt":"2025-02-03T14:15:33","guid":{"rendered":"https:\/\/masartech.com.sa\/?p=56678"},"modified":"2025-02-03T14:15:33","modified_gmt":"2025-02-03T14:15:33","slug":"%d8%aa%d8%b5%d9%85%d9%8a%d9%85-%d9%84%d9%88%d8%ad%d8%a7%d8%aa-%d9%85%d8%b9%d9%84%d9%88%d9%85%d8%a7%d8%aa-%d8%aa%d9%81%d8%a7%d8%b9%d9%84%d9%8a%d8%a9-%d8%a8%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-exc","status":"publish","type":"post","link":"https:\/\/mostafaweb.info\/masartechwp\/%d8%aa%d8%b5%d9%85%d9%8a%d9%85-%d9%84%d9%88%d8%ad%d8%a7%d8%aa-%d9%85%d8%b9%d9%84%d9%88%d9%85%d8%a7%d8%aa-%d8%aa%d9%81%d8%a7%d8%b9%d9%84%d9%8a%d8%a9-%d8%a8%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-exc\/","title":{"rendered":"\u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Excel: \u0645\u0627 \u064a\u062d\u062a\u0627\u062c\u0647 \u0627\u0644\u0645\u062d\u062a\u0631\u0641\u0648\u0646 \u0641\u064a \u0627\u0644\u0633\u0639\u0648\u062f\u064a\u0629"},"content":{"rendered":"<h1><span style=\"color: #000000;\"><strong>\u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Excel: \u0645\u0627 \u064a\u062d\u062a\u0627\u062c\u0647 \u0627\u0644\u0645\u062d\u062a\u0631\u0641\u0648\u0646 \u0641\u064a \u0627\u0644\u0633\u0639\u0648\u062f\u064a\u0629<\/strong><\/span><\/h1>\n<p><span style=\"color: #000000;\">\u0641\u064a \u0639\u0627\u0644\u0645 \u064a\u0639\u062a\u0645\u062f \u0628\u0634\u0643\u0644 \u0645\u062a\u0632\u0627\u064a\u062f \u0639\u0644\u0649 <strong>\u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0630\u0643\u064a\u0629<\/strong>\u060c \u0623\u0635\u0628\u062d <strong>Excel<\/strong> \u0623\u062f\u0627\u0629 \u0623\u0633\u0627\u0633\u064a\u0629 \u0644\u062a\u0635\u0645\u064a\u0645 <strong>\u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629 (Dashboards)<\/strong> \u062a\u0648\u0641\u0631 <strong>\u0631\u0624\u0649 \u0639\u0645\u064a\u0642\u0629 \u062a\u0633\u0627\u0639\u062f \u0641\u064a \u0627\u062a\u062e\u0627\u0630 \u0627\u0644\u0642\u0631\u0627\u0631\u0627\u062a \u0627\u0644\u0641\u0639\u0627\u0644\u0629<\/strong>. \u062a\u0639\u062f <strong>\u0644\u0648\u062d\u0627\u062a \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629<\/strong> \u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u062a\u0633\u0627\u0639\u062f \u0627\u0644\u0634\u0631\u0643\u0627\u062a \u0641\u064a <strong>\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u0642\u062f\u064a\u0645\u0647\u0627 \u0628\u0637\u0631\u064a\u0642\u0629 \u0645\u0631\u0626\u064a\u0629 \u0648\u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629<\/strong>\u060c \u0645\u0645\u0627 \u064a\u062f\u0639\u0645 \u0623\u0647\u062f\u0627\u0641 <strong>\u0631\u0624\u064a\u0629 \u0627\u0644\u0645\u0645\u0644\u0643\u0629 2030<\/strong> \u0644\u0644\u062a\u062d\u0648\u0644 \u0627\u0644\u0631\u0642\u0645\u064a \u0648\u062a\u0639\u0632\u064a\u0632 \u0627\u0644\u0643\u0641\u0627\u0621\u0629 \u0627\u0644\u062a\u0634\u063a\u064a\u0644\u064a\u0629.<\/span><\/p>\n<p><span style=\"color: #000000;\">\u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0645\u0642\u0627\u0644\u060c \u0633\u0646\u0634\u0631\u062d <strong>\u062e\u0637\u0648\u0629 \u0628\u062e\u0637\u0648\u0629 \u0643\u064a\u0641\u064a\u0629 \u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u062d\u062a\u0631\u0627\u0641\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0623\u062f\u0648\u0627\u062a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a Excel<\/strong> \u0645\u062b\u0644:<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Power Query<\/strong> \u0644\u062a\u0646\u0638\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0648\u064a\u0644\u0647\u0627.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Power Pivot<\/strong> \u0644\u0625\u0646\u0634\u0627\u0621 \u0646\u0645\u0627\u0630\u062c \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Pivot Tables \u0648Pivot Charts<\/strong> \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0639\u0631\u0636\u0647\u0627 \u0628\u0637\u0631\u0642 \u0645\u0631\u0626\u064a\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Slicers &amp; Timelines<\/strong> \u0644\u062c\u0639\u0644 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0648\u0633\u0647\u0644\u0629 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645.<\/span><\/p>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>1\ufe0f\u20e3 \u0645\u0627 \u0647\u064a \u0644\u0648\u062d\u0627\u062a \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0648\u0644\u0645\u0627\u0630\u0627 \u062a\u062d\u062a\u0627\u062c\u0647\u0627 \u0627\u0644\u0634\u0631\u0643\u0627\u062a \u0641\u064a \u0627\u0644\u0633\u0639\u0648\u062f\u064a\u0629\u061f<\/strong><\/span><\/h2>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0645\u0627 \u0647\u064a Dashboard \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>\u0644\u0648\u062d\u0629 \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629 (Interactive Dashboard)<\/strong> \u0647\u064a \u062a\u0642\u0631\u064a\u0631 \u0645\u0631\u0626\u064a \u064a\u0639\u0631\u0636 <strong>\u0627\u0644\u0645\u0624\u0634\u0631\u0627\u062a \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 \u0644\u0644\u0623\u062f\u0627\u0621 (KPIs)<\/strong> \u0628\u0637\u0631\u064a\u0642\u0629 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629\u060c \u0645\u0645\u0627 \u064a\u0633\u0645\u062d \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 <strong>\u0628\u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u062a\u0641\u0627\u0639\u0644 \u0645\u0639\u0647\u0627 \u0645\u0628\u0627\u0634\u0631\u0629\u064b<\/strong> \u062f\u0648\u0646 \u0627\u0644\u062d\u0627\u062c\u0629 \u0625\u0644\u0649 \u062a\u062d\u0631\u064a\u0631 \u0627\u0644\u0645\u0644\u0641\u0627\u062a \u064a\u062f\u0648\u064a\u064b\u0627.<\/span><\/p>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0641\u0648\u0627\u0626\u062f \u0644\u0648\u062d\u0627\u062a \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0644\u0644\u0634\u0631\u0643\u0627\u062a<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">\u2705 <strong>\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0641\u0639\u0644\u064a<\/strong> \u062f\u0648\u0646 \u0627\u0644\u062d\u0627\u062c\u0629 \u0625\u0644\u0649 \u062a\u062d\u062f\u064a\u062b \u064a\u062f\u0648\u064a \u0645\u0633\u062a\u0645\u0631.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>\u0627\u062a\u062e\u0627\u0630 \u0642\u0631\u0627\u0631\u0627\u062a \u0623\u0633\u0631\u0639 \u0648\u0623\u0643\u062b\u0631 \u062f\u0642\u0629<\/strong> \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0641\u0639\u0644\u064a\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>\u062a\u0648\u0641\u064a\u0631 \u0639\u0631\u0636 \u0645\u0631\u0626\u064a \u0648\u0627\u0636\u062d \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0639\u0642\u062f\u0629<\/strong> \u0628\u0637\u0631\u064a\u0642\u0629 \u0633\u0647\u0644\u0629 \u0627\u0644\u0641\u0647\u0645.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>\u062a\u062d\u0633\u064a\u0646 \u0643\u0641\u0627\u0621\u0629 \u0627\u0644\u0639\u0645\u0644<\/strong> \u0645\u0646 \u062e\u0644\u0627\u0644 \u062a\u0642\u0644\u064a\u0644 \u0627\u0644\u0648\u0642\u062a \u0627\u0644\u0644\u0627\u0632\u0645 \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u064a\u0645\u0643\u0646 \u0644\u0634\u0631\u0643\u0629 \u062a\u062c\u0632\u0626\u0629 \u0633\u0639\u0648\u062f\u064a\u0629 \u062a\u0635\u0645\u064a\u0645 <strong>\u0644\u0648\u062d\u0629 \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629<\/strong> \u062a\u0639\u0631\u0636 <strong>\u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u062d\u0633\u0628 \u0627\u0644\u0645\u0646\u0627\u0637\u0642\u060c \u0627\u0644\u0645\u0646\u062a\u062c\u0627\u062a \u0627\u0644\u0623\u0643\u062b\u0631 \u0645\u0628\u064a\u0639\u064b\u0627\u060c \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0645\u0627\u0644\u064a<\/strong> \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Excel.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>2\ufe0f\u20e3 \u062a\u062c\u0647\u064a\u0632 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Query<\/strong><\/span><\/h2>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0645\u0627 \u0647\u0648 Power Query\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\"><strong>Power Query<\/strong> \u0647\u0648 \u0623\u062f\u0627\u0629 \u0641\u064a Excel \u062a\u062a\u064a\u062d \u0644\u0643 <strong>\u062a\u0646\u0638\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0648\u064a\u0644\u0647\u0627 \u0645\u0646 \u0645\u0635\u0627\u062f\u0631 \u0645\u062a\u0639\u062f\u062f\u0629<\/strong> \u0645\u062b\u0644 <strong>\u0645\u0644\u0641\u0627\u062a CSV\u060c \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0627\u0644\u0648\u064a\u0628<\/strong>\u060c \u062f\u0648\u0646 \u0627\u0644\u062d\u0627\u062c\u0629 \u0625\u0644\u0649 \u062a\u062d\u0631\u064a\u0631 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u064a\u062f\u0648\u064a\u064b\u0627.<\/span><\/p>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u062e\u0637\u0648\u0627\u062a \u062a\u0646\u0638\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Query:<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">1\ufe0f\u20e3 \u0627\u0646\u062a\u0642\u0644 \u0625\u0644\u0649 <strong>Data \u2192 Get &amp; Transform \u2192 Get Data<\/strong> \u0644\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><br \/>\n<span style=\"color: #000000;\">2\ufe0f\u20e3 \u0627\u0633\u062a\u062e\u062f\u0645 <strong>Remove Duplicates<\/strong> \u0644\u0625\u0632\u0627\u0644\u0629 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u062a\u0643\u0631\u0631\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">3\ufe0f\u20e3 \u0627\u0633\u062a\u062e\u062f\u0645 <strong>Replace Values<\/strong> \u0644\u062a\u0635\u062d\u064a\u062d \u0627\u0644\u0623\u062e\u0637\u0627\u0621 \u0641\u064a \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><br \/>\n<span style=\"color: #000000;\">4\ufe0f\u20e3 \u0642\u0645 \u0628\u062a\u063a\u064a\u064a\u0631 \u062a\u0646\u0633\u064a\u0642 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 <strong>\u0623\u0631\u0642\u0627\u0645\u060c \u062a\u0648\u0627\u0631\u064a\u062e\u060c \u0648\u0646\u0635\u0648\u0635<\/strong> \u062d\u0633\u0628 \u0627\u0644\u062d\u0627\u062c\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">5\ufe0f\u20e3 \u0627\u0636\u063a\u0637 <strong>Close &amp; Load<\/strong> \u0644\u062a\u062d\u0645\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 Excel \u0628\u0639\u062f \u062a\u0646\u0638\u064a\u0641\u0647\u0627.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0645\u0646 <strong>\u0645\u0644\u0641\u0627\u062a CSV \u0648\u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a SQL<\/strong> \u0648\u062a\u0646\u0638\u064a\u0641\u0647\u0627 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Query \u0644\u0625\u0646\u0634\u0627\u0621 <strong>\u0644\u0648\u062d\u0629 \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u062d\u0644\u064a\u0644\u064a\u0629 \u0644\u0644\u0645\u0628\u064a\u0639\u0627\u062a<\/strong>.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>3\ufe0f\u20e3 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Pivot \u0644\u0625\u0646\u0634\u0627\u0621 \u0646\u0645\u0627\u0630\u062c \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629<\/strong><\/span><\/h2>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0645\u0627 \u0647\u0648 Power Pivot\u061f<\/strong><\/span><\/h3>\n<ul>\n<li><span style=\"color: #000000;\"><strong>Power Pivot<\/strong> \u0647\u0648 \u0623\u062f\u0627\u0629 \u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a Excel \u062a\u0633\u0645\u062d \u0644\u0643 \u0628\u0625\u0646\u0634\u0627\u0621 <strong>\u0639\u0644\u0627\u0642\u0627\u062a \u0628\u064a\u0646 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629<\/strong> \u0648\u0625\u062c\u0631\u0627\u0621 \u062a\u062d\u0644\u064a\u0644\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>DAX (Data Analysis Expressions)<\/strong>.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\u064a\u0633\u0627\u0639\u062f \u0641\u064a \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0645\u062c\u0645\u0648\u0639\u0627\u062a \u0628\u064a\u0627\u0646\u0627\u062a \u0636\u062e\u0645\u0629<\/strong> \u0648\u062a\u062d\u0644\u064a\u0644\u0647\u0627 \u0628\u0643\u0641\u0627\u0621\u0629 \u0639\u0627\u0644\u064a\u0629.<\/span><\/li>\n<\/ul>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Pivot\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">1\ufe0f\u20e3 \u0642\u0645 \u0628\u062a\u062d\u0645\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 Power Pivot \u0639\u0646 \u0637\u0631\u064a\u0642 <strong>Data \u2192 Manage Data Model<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">2\ufe0f\u20e3 \u0627\u0631\u0628\u0637 \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0628\u0628\u0639\u0636\u0647\u0627 \u0644\u0625\u0646\u0634\u0627\u0621 \u0639\u0644\u0627\u0642\u0627\u062a <strong>(Relationships)<\/strong> \u0628\u064a\u0646 \u0627\u0644\u062d\u0642\u0648\u0644 \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">3\ufe0f\u20e3 \u0627\u0633\u062a\u062e\u062f\u0645 DAX \u0644\u0625\u0646\u0634\u0627\u0621 <strong>\u0645\u0642\u0627\u064a\u064a\u0633 \u0645\u062e\u0635\u0635\u0629 \u0645\u062b\u0644 \u0625\u062c\u0645\u0627\u0644\u064a \u0627\u0644\u0625\u064a\u0631\u0627\u062f\u0627\u062a\u060c \u0645\u062a\u0648\u0633\u0637 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a\u060c \u0648\u0646\u0633\u0628\u0629 \u0627\u0644\u0646\u0645\u0648<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">4\ufe0f\u20e3 \u062d\u0645\u0651\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 Excel \u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 \u0641\u064a <strong>Pivot Tables \u0648Pivot Charts<\/strong>.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0631\u0628\u0637 <strong>\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a\u060c \u0627\u0644\u0645\u0646\u062a\u062c\u0627\u062a\u060c \u0648\u0627\u0644\u0639\u0645\u0644\u0627\u0621<\/strong> \u0644\u0625\u0646\u0634\u0627\u0621 <strong>\u0644\u0648\u062d\u0629 \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0639\u0631\u0636 \u0627\u0644\u0625\u064a\u0631\u0627\u062f\u0627\u062a \u0644\u0643\u0644 \u0645\u0646\u062a\u062c \u0648\u0645\u0646\u0637\u0642\u0629 \u062c\u063a\u0631\u0627\u0641\u064a\u0629<\/strong>.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>4\ufe0f\u20e3 \u0625\u0646\u0634\u0627\u0621 Pivot Tables \u0648Pivot Charts \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/span><\/h2>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0644\u0645\u0627\u0630\u0627 \u0646\u0633\u062a\u062e\u062f\u0645 Pivot Tables \u0648Pivot Charts\u061f<\/strong><\/span><\/h3>\n<ul>\n<li><span style=\"color: #000000;\">\u062a\u0633\u0627\u0639\u062f <strong>Pivot Tables<\/strong> \u0641\u064a <strong>\u062a\u0644\u062e\u064a\u0635 \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong> \u0628\u0633\u0647\u0648\u0644\u0629\u060c \u0628\u064a\u0646\u0645\u0627 \u062a\u0648\u0641\u0631 <strong>Pivot Charts<\/strong> \u0639\u0631\u0636\u064b\u0627 \u0645\u0631\u0626\u064a\u064b\u0627 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u064b\u0627 \u0644\u0647\u0627.<\/span><\/li>\n<\/ul>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0643\u064a\u0641\u064a\u0629 \u0625\u0646\u0634\u0627\u0621 Pivot Table\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">1\ufe0f\u20e3 \u062d\u062f\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0637\u0644\u0648\u0628\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">2\ufe0f\u20e3 \u0627\u0646\u062a\u0642\u0644 \u0625\u0644\u0649 <strong>Insert \u2192 Pivot Table<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">3\ufe0f\u20e3 \u0627\u0633\u062d\u0628 \u0627\u0644\u062d\u0642\u0648\u0644 \u0627\u0644\u0645\u0646\u0627\u0633\u0628\u0629 \u0625\u0644\u0649 \u0627\u0644\u0623\u0642\u0633\u0627\u0645 \u0627\u0644\u062a\u0627\u0644\u064a\u0629:<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Rows:<\/strong> (\u0627\u0644\u0645\u0646\u062a\u062c\u0627\u062a\u060c \u0627\u0644\u0645\u0646\u0627\u0637\u0642 \u0627\u0644\u062c\u063a\u0631\u0627\u0641\u064a\u0629).<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Columns:<\/strong> (\u0627\u0644\u0623\u0634\u0647\u0631\u060c \u0627\u0644\u0633\u0646\u0648\u0627\u062a).<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Values:<\/strong> (\u0625\u062c\u0645\u0627\u0644\u064a \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a\u060c \u0645\u062a\u0648\u0633\u0637 \u0627\u0644\u0623\u0631\u0628\u0627\u062d).<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Filters:<\/strong> (\u0646\u0648\u0639 \u0627\u0644\u0645\u0646\u062a\u062c\u060c \u0627\u0644\u0645\u0646\u0637\u0642\u0629).<\/span><\/p>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0643\u064a\u0641\u064a\u0629 \u0625\u0646\u0634\u0627\u0621 Pivot Chart\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">1\ufe0f\u20e3 \u0628\u0639\u062f \u0625\u0646\u0634\u0627\u0621 Pivot Table\u060c \u0627\u0636\u063a\u0637 \u0639\u0644\u0649 <strong>Insert \u2192 Pivot Chart<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">2\ufe0f\u20e3 \u0627\u062e\u062a\u0631 \u0627\u0644\u0645\u062e\u0637\u0637 \u0627\u0644\u0645\u0646\u0627\u0633\u0628\u060c \u0645\u062b\u0644:<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Column Chart<\/strong>: \u0645\u0642\u0627\u0631\u0646\u0629 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0628\u064a\u0646 \u0627\u0644\u0645\u0646\u062a\u062c\u0627\u062a.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Line Chart<\/strong>: \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0627\u062a\u062c\u0627\u0647\u0627\u062a \u0627\u0644\u0632\u0645\u0646\u064a\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>Pie Chart<\/strong>: \u0639\u0631\u0636 \u0627\u0644\u062d\u0635\u0635 \u0627\u0644\u0633\u0648\u0642\u064a\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">3\ufe0f\u20e3 \u0627\u0631\u0628\u0637 \u0627\u0644\u0645\u062e\u0637\u0637 \u0628\u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0645\u062d\u0648\u0631\u064a\u0629 \u0644\u062c\u0639\u0644\u0647 <strong>\u062a\u0641\u0627\u0639\u0644\u064a\u064b\u0627 \u0648\u0642\u0627\u0628\u0644\u064b\u0627 \u0644\u0644\u062a\u0635\u0641\u064a\u0629<\/strong>.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0625\u0646\u0634\u0627\u0621 <strong>\u0645\u062e\u0637\u0637 \u064a\u0639\u0631\u0636 \u0646\u0645\u0648 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0627\u0644\u0634\u0647\u0631\u064a<\/strong> \u0648\u064a\u062a\u064a\u062d \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 \u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062d\u0633\u0628 <strong>\u0627\u0644\u0645\u0646\u062a\u062c\u0627\u062a \u0623\u0648 \u0627\u0644\u0645\u0646\u0627\u0637\u0642<\/strong>.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>5\ufe0f\u20e3 \u0625\u0636\u0627\u0641\u0629 Slicers \u0648Timelines \u0644\u062c\u0639\u0644 \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u062a\u0641\u0627\u0639\u0644\u064a\u0629<\/strong><\/span><\/h2>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0645\u0627 \u0647\u064a Slicers \u0648Timelines\u061f<\/strong><\/span><\/h3>\n<ul>\n<li><span style=\"color: #000000;\"><strong>Slicers<\/strong> \u0647\u064a <strong>\u0639\u0646\u0627\u0635\u0631 \u062a\u062d\u0643\u0645 \u0645\u0631\u0626\u064a\u0629<\/strong> \u062a\u0633\u0645\u062d \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646 <strong>\u0628\u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0633\u0647\u0648\u0644\u0629<\/strong>.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>Timelines<\/strong> \u062a\u0633\u0627\u0639\u062f \u0641\u064a <strong>\u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0641\u0642 \u0627\u0644\u0641\u062a\u0631\u0627\u062a \u0627\u0644\u0632\u0645\u0646\u064a\u0629<\/strong> \u0628\u0637\u0631\u064a\u0642\u0629 \u0645\u0631\u0626\u064a\u0629 \u0648\u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629.<\/span><\/li>\n<\/ul>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0643\u064a\u0641\u064a\u0629 \u0625\u0636\u0627\u0641\u0629 Slicers\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">1\ufe0f\u20e3 \u062d\u062f\u062f <strong>Pivot Table \u0623\u0648 Pivot Chart<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">2\ufe0f\u20e3 \u0627\u0646\u062a\u0642\u0644 \u0625\u0644\u0649 <strong>Insert \u2192 Slicer<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">3\ufe0f\u20e3 \u0627\u062e\u062a\u0631 \u0627\u0644\u062d\u0642\u0648\u0644 \u0627\u0644\u062a\u064a \u062a\u0631\u064a\u062f \u062a\u0635\u0641\u064a\u062a\u0647\u0627 \u0645\u062b\u0644 <strong>\u0627\u0644\u0645\u0646\u062a\u062c\u060c \u0627\u0644\u0645\u0646\u0637\u0642\u0629\u060c \u0627\u0644\u0639\u0645\u064a\u0644<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">4\ufe0f\u20e3 \u0636\u0639 Slicers \u0641\u064a \u0645\u0643\u0627\u0646 \u0645\u0646\u0627\u0633\u0628 \u062f\u0627\u062e\u0644 \u0644\u0648\u062d\u0629 \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a.<\/span><\/p>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0643\u064a\u0641\u064a\u0629 \u0625\u0636\u0627\u0641\u0629 Timelines\u061f<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">1\ufe0f\u20e3 \u062d\u062f\u062f <strong>Pivot Table \u0623\u0648 Pivot Chart<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">2\ufe0f\u20e3 \u0627\u0646\u062a\u0642\u0644 \u0625\u0644\u0649 <strong>Insert \u2192 Timeline<\/strong>.<\/span><br \/>\n<span style=\"color: #000000;\">3\ufe0f\u20e3 \u0627\u062e\u062a\u0631 <strong>\u062d\u0642\u0644 \u0627\u0644\u062a\u0627\u0631\u064a\u062e<\/strong> \u0644\u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0632\u0645\u0646\u064a\u064b\u0627.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0625\u0636\u0627\u0641\u0629 <strong>Slicers \u0644\u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u0625\u064a\u0631\u0627\u062f\u0627\u062a \u062d\u0633\u0628 \u0627\u0644\u0641\u0631\u0648\u0639 \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629<\/strong>\u060c \u0648\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>Timeline \u0644\u062a\u062d\u062f\u064a\u062f \u0645\u0628\u064a\u0639\u0627\u062a \u0627\u0644\u0623\u0634\u0647\u0631 \u0627\u0644\u0633\u0627\u0628\u0642\u0629<\/strong> \u0628\u0633\u0631\u0639\u0629.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>6\ufe0f\u20e3 \u062a\u062d\u0633\u064a\u0646 \u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0644\u062c\u0639\u0644\u0647\u0627 \u0627\u062d\u062a\u0631\u0627\u0641\u064a\u0629<\/strong><\/span><\/h2>\n<h3><span style=\"color: #000000;\"><strong>\ud83d\udd39 \u0623\u0641\u0636\u0644 \u0645\u0645\u0627\u0631\u0633\u0627\u062a \u062a\u0635\u0645\u064a\u0645 Dashboards \u0641\u064a Excel<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">\u2705 <strong>\u0627\u0633\u062a\u062e\u062f\u0645 \u0623\u0644\u0648\u0627\u0646 \u0645\u062a\u0646\u0627\u0633\u0642\u0629 \u0648\u0648\u0627\u0636\u062d\u0629<\/strong> \u0648\u0644\u0627 \u062a\u0641\u0631\u0637 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0623\u0644\u0648\u0627\u0646 \u0627\u0644\u0632\u0627\u0647\u064a\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>\u0636\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0647\u0645\u0629 \u0641\u064a \u0627\u0644\u0645\u0642\u062f\u0645\u0629<\/strong> \u0645\u062b\u0644 KPIs \u0648\u0625\u062c\u0645\u0627\u0644\u064a \u0627\u0644\u0625\u064a\u0631\u0627\u062f\u0627\u062a.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>\u0627\u0633\u062a\u062e\u062f\u0645 Conditional Formatting \u0644\u062a\u0645\u064a\u064a\u0632 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u062d\u0631\u062c\u0629<\/strong> \u0645\u062b\u0644 \u0627\u0644\u0623\u0631\u0628\u0627\u062d \u0627\u0644\u0633\u0644\u0628\u064a\u0629 \u0623\u0648 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0627\u0644\u0645\u0631\u062a\u0641\u0639\u0629.<\/span><br \/>\n<span style=\"color: #000000;\">\u2705 <strong>\u0642\u0645 \u0628\u062a\u0623\u0645\u064a\u0646 \u0648\u062d\u0645\u0627\u064a\u0629 \u0648\u0631\u0642\u0629 \u0627\u0644\u0639\u0645\u0644<\/strong> \u0644\u062a\u062c\u0646\u0628 \u0627\u0644\u062a\u0639\u062f\u064a\u0644\u0627\u062a \u063a\u064a\u0631 \u0627\u0644\u0645\u0631\u063a\u0648\u0628 \u0641\u064a\u0647\u0627.<\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644 \u0639\u0645\u0644\u064a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>Conditional Formatting<\/strong> \u0644\u062a\u0645\u064a\u064a\u0632 <strong>\u0627\u0644\u0641\u0631\u0648\u0639 \u0627\u0644\u062a\u064a \u062a\u062c\u0627\u0648\u0632\u062a \u0647\u062f\u0641 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0628\u0627\u0644\u0644\u0648\u0646 \u0627\u0644\u0623\u062e\u0636\u0631<\/strong>\u060c \u0648\u0627\u0644\u0641\u0631\u0648\u0639 \u0627\u0644\u062a\u064a \u0644\u0645 \u062a\u062d\u0642\u0642 \u0627\u0644\u0647\u062f\u0641 \u0628\u0627\u0644\u0644\u0648\u0646 \u0627\u0644\u0623\u062d\u0645\u0631.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<hr \/>\n<h2><span style=\"color: #000000;\"><strong>\ud83d\udca1 \u0627\u0644\u062e\u0627\u062a\u0645\u0629: Excel \u0643\u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u0644\u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629<\/strong><\/span><\/h2>\n<p><span style=\"color: #000000;\">\u062a\u0648\u0641\u0631 <strong>\u0644\u0648\u062d\u0627\u062a \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0641\u064a Excel<\/strong> \u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u0644\u0644\u0634\u0631\u0643\u0627\u062a \u0641\u064a \u0627\u0644\u0633\u0639\u0648\u062f\u064a\u0629 \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a <strong>\u0648\u0627\u062a\u062e\u0627\u0630 \u0642\u0631\u0627\u0631\u0627\u062a \u0623\u0633\u0631\u0639 \u0648\u0623\u0643\u062b\u0631 \u062f\u0642\u0629<\/strong>. \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>Power Query\u060c Power Pivot\u060c Pivot Tables\u060c \u0648Slicers<\/strong>\u060c \u064a\u0645\u0643\u0646 \u0644\u0644\u0645\u062d\u062a\u0631\u0641\u064a\u0646 \u062a\u0635\u0645\u064a\u0645 <strong>\u062a\u0642\u0627\u0631\u064a\u0631 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629 \u0648\u0633\u0647\u0644\u0629 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645<\/strong> \u062a\u062f\u0639\u0645 <strong>\u0627\u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0641\u0648\u0631\u064a \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0645\u0624\u0633\u0633\u064a<\/strong>.<\/span><\/p>\n<p><span style=\"color: #000000;\">\ud83c\udfaf <strong>\u0627\u0628\u062f\u0623 \u0627\u0644\u064a\u0648\u0645 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0623\u062f\u0648\u0627\u062a \u0644\u0625\u0646\u0634\u0627\u0621 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629\u060c \u0648\u0633\u0627\u0647\u0645 \u0641\u064a \u0627\u0644\u062a\u062d\u0648\u0644 \u0627\u0644\u0631\u0642\u0645\u064a \u0644\u0634\u0631\u0643\u062a\u0643 \u0648\u0641\u0642 \u0631\u0624\u064a\u0629 \u0627\u0644\u0645\u0645\u0644\u0643\u0629 2030!<\/strong> \ud83d\ude80<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Excel: \u0645\u0627 \u064a\u062d\u062a\u0627\u062c\u0647 \u0627\u0644\u0645\u062d\u062a\u0631\u0641\u0648\u0646 \u0641\u064a \u0627\u0644\u0633\u0639\u0648\u062f\u064a\u0629 \u0641\u064a \u0639\u0627\u0644\u0645 \u064a\u0639\u062a\u0645\u062f \u0628\u0634\u0643\u0644 \u0645\u062a\u0632\u0627\u064a\u062f \u0639\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0630\u0643\u064a\u0629\u060c \u0623\u0635\u0628\u062d Excel \u0623\u062f\u0627\u0629 \u0623\u0633\u0627\u0633\u064a\u0629 \u0644\u062a\u0635\u0645\u064a\u0645 \u0644\u0648\u062d\u0627\u062a \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u062a\u0641\u0627\u0639\u0644\u064a\u0629 (Dashboards) \u062a\u0648\u0641\u0631 \u0631\u0624\u0649 \u0639\u0645\u064a\u0642\u0629 \u062a\u0633\u0627\u0639\u062f \u0641\u064a \u0627\u062a\u062e\u0627\u0630 \u0627\u0644\u0642\u0631\u0627\u0631\u0627\u062a \u0627\u0644\u0641\u0639\u0627\u0644\u0629. \u062a\u0639\u062f \u0644\u0648\u062d\u0627\u062a \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u062a\u0633\u0627\u0639\u062f \u0627\u0644\u0634\u0631\u0643\u0627\u062a \u0641\u064a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u0642\u062f\u064a\u0645\u0647\u0627 \u0628\u0637\u0631\u064a\u0642\u0629 \u0645\u0631\u0626\u064a\u0629 \u0648\u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629\u060c \u0645\u0645\u0627 \u064a\u062f\u0639\u0645 \u0623\u0647\u062f\u0627\u0641 \u0631\u0624\u064a\u0629 [&#8230;]\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-56678","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts\/56678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/comments?post=56678"}],"version-history":[{"count":1,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts\/56678\/revisions"}],"predecessor-version":[{"id":56679,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts\/56678\/revisions\/56679"}],"wp:attachment":[{"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/media?parent=56678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/categories?post=56678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/tags?post=56678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}