{"id":4063,"date":"2026-04-27T07:10:37","date_gmt":"2026-04-27T07:10:37","guid":{"rendered":"https:\/\/pbi.ps\/?post_type=lp_course&p=4063"},"modified":"2026-07-23T06:59:17","modified_gmt":"2026-07-23T06:59:17","slug":"%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d8%ac-%d8%a5%d9%83%d8%b3%d9%84-%d8%a7%d9%84%d9%85%d8%b3%d8%aa%d9%88%d9%89-%d8%a7%d9%84%d9%85%d8%a8%d8%aa%d8%af%d8%a6-%d9%88%d8%a7%d9%84%d9%85%d8%aa%d9%88%d8%b3%d8%b7","status":"publish","type":"lp_course","link":"https:\/\/pbi.ps\/?lp_course=%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D8%AC-%D8%A5%D9%83%D8%B3%D9%84-%D8%A7%D9%84%D9%85%D8%B3%D8%AA%D9%88%D9%89-%D8%A7%D9%84%D9%85%D8%A8%D8%AA%D8%AF%D8%A6-%D9%88%D8%A7%D9%84%D9%85%D8%AA%D9%88%D8%B3%D8%B7","title":{"rendered":"\u0628\u0631\u0646\u0627\u0645\u062c \u0625\u0643\u0633\u0644 – \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u0628\u062a\u062f\u0626 \u0648\u0627\u0644\u0645\u062a\u0648\u0633\u0637"},"content":{"rendered":"

\u0627\u0644\u0645\u062f\u0631\u0628:\u0645\u0627\u0644\u0643 \u0648\u0644\u064a\u062f \u0627\u0628\u0631\u0627\u0647\u064a\u0645 \u0637\u0648\u0645\u0627\u0631<\/span><\/strong><\/p>\n

\u0645\u0642\u062f\u0645\u0629 \u0639\u0646 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c:<\/strong><\/b><\/p>\n

\u064a\u064f\u0639\u062f \u0628\u0631\u0646\u0627\u0645\u062c Excel \u0627\u0644\u0623\u062f\u0627\u0629 \u0627\u0644\u0623\u0643\u062b\u0631 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0627\u064b \u0644\u062f\u0649 \u0645\u0648\u0638\u0641\u064a \u0627\u0644\u0642\u0637\u0627\u0639 \u0627\u0644\u0645\u0635\u0631\u0641\u064a \u0641\u064a \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0648\u0625\u0639\u062f\u0627\u062f \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u0627\u0644\u062a\u0633\u0648\u064a\u0627\u062a\u060c \u0625\u0644\u0649 \u062c\u0627\u0646\u0628 \u0627\u0644\u0623\u0646\u0638\u0645\u0629 \u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 (Core Banking Systems). \u064a\u0647\u062f\u0641 \u0647\u0630\u0627 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u062a\u062f\u0631\u064a\u0628\u064a \u0625\u0644\u0649 \u0627\u0644\u0627\u0646\u062a\u0642\u0627\u0644 \u0628\u0627\u0644\u0645\u062a\u062f\u0631\u0628\u064a\u0646 \u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\/\u0627\u0644\u0645\u062a\u0648\u0633\u0637 \u0625\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u060c \u0639\u0628\u0631 \u0645\u0633\u0627\u0631 \u0645\u062a\u0635\u0627\u0639\u062f \u0639\u0644\u0649 \u0645\u062f\u0627\u0631 \u062b\u0644\u0627\u062b\u0629 \u0623\u064a\u0627\u0645 \u062a\u062f\u0631\u064a\u0628\u064a\u0629: \u064a\u0628\u062f\u0623 \u0628\u0627\u0644\u0645\u0647\u0627\u0631\u0627\u062a \u0648\u0627\u0644\u062f\u0648\u0627\u0644 \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629\u060c \u064a\u0644\u064a\u0647 \u0623\u062f\u0648\u0627\u062a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u062d\u0633\u0627\u0628\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629 \u0648\u062f\u0639\u0645 \u0627\u062a\u062e\u0627\u0630 \u0627\u0644\u0642\u0631\u0627\u0631\u060c \u0648\u064a\u064f\u062e\u062a\u062a\u0645 \u0628\u0628\u0646\u0627\u0621 \u0644\u0648\u062d\u0629 \u062a\u062d\u0643\u0645 (Dashboard) \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u062a\u062f\u0639\u0645 \u0627\u0644\u0639\u0631\u0636 \u0639\u0644\u0649 \u0627\u0644\u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u0639\u0644\u064a\u0627 \u0648\u0644\u062c\u0627\u0646 \u0627\u0644\u0631\u0642\u0627\u0628\u0629 \u0648\u0627\u0644\u062a\u062f\u0642\u064a\u0642. \u064a\u0639\u062a\u0645\u062f \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0645\u0646\u0647\u062c\u064a\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642 \u0627\u0644\u0639\u0645\u0644\u064a \u0627\u0644\u0645\u0628\u0627\u0634\u0631 (Doing by Learning) \u0639\u0644\u0649 \u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062d\u0627\u0644\u0627\u062a \u0645\u062d\u0627\u0643\u0627\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0626\u0629 \u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629 \u0648\u0627\u0644\u0645\u0627\u0644\u064a\u0629.<\/p>\n

\u0627\u0644\u0641\u0626\u0629 \u0627\u0644\u0645\u0633\u062a\u0647\u062f\u0641\u0629:<\/strong><\/b><\/p>\n

\u0645\u0648\u0638\u0641\u0648 \u0627\u0644\u0628\u0646\u0648\u0643 \u0627\u0644\u0639\u0627\u0645\u0644\u0629 \u0641\u064a \u0641\u0644\u0633\u0637\u064a\u0646 \u0645\u0646 \u0645\u062d\u0627\u0633\u0628\u064a\u0646\u060c \u0648\u0645\u062d\u0644\u0644\u064a\u0646 \u0645\u0627\u0644\u064a\u064a\u0646\u060c \u0648\u0645\u0648\u0638\u0641\u064a \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0648\u0627\u0644\u0627\u0626\u062a\u0645\u0627\u0646 \u0648\u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u0627\u0644\u0645\u062a\u0627\u0628\u0639\u0629\u060c \u0645\u0645\u0646 \u064a\u0645\u062a\u0644\u0643\u0648\u0646 \u0645\u0633\u062a\u0648\u0649 \u0623\u0633\u0627\u0633\u064a\u0627\u064b\/\u0645\u062a\u0648\u0633\u0637\u0627\u064b \u0641\u064a Excel \u0648\u064a\u0631\u063a\u0628\u0648\u0646 \u0628\u062a\u0637\u0648\u064a\u0631 \u0645\u0647\u0627\u0631\u0627\u062a\u0647\u0645 \u0625\u0644\u0649 \u0627\u0644\u0645\u0633\u062a\u0648\u0649 \u0627\u0644\u0645\u062a\u0642\u062f\u0645 \u0641\u064a \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0644\u064a\u0644\u0647\u0627 \u0648\u0639\u0631\u0636\u0647\u0627.<\/p>\n

\u0627\u0644\u0647\u062f\u0641 \u0627\u0644\u0639\u0627\u0645 \u0644\u0644\u0628\u0631\u0646\u0627\u0645\u062c:<\/strong><\/b><\/p>\n

\u062a\u0645\u0643\u064a\u0646 \u0627\u0644\u0645\u062a\u062f\u0631\u0628\u064a\u0646 \u0645\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0623\u062f\u0648\u0627\u062a \u0648\u0627\u0644\u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a \u0628\u0631\u0646\u0627\u0645\u062c Excel \u0644\u0645\u0639\u0627\u0644\u062c\u0629 \u0648\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0648\u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629\u060c \u0648\u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u062d\u0633\u0627\u0628\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0641\u064a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0642\u0631\u0648\u0636 \u0648\u0627\u0644\u062a\u0645\u0648\u064a\u0644\u060c \u0648\u0628\u0646\u0627\u0621 \u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u0644\u0648\u062d\u0627\u062a \u062a\u062d\u0643\u0645 (Dashboard) \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u062a\u062f\u0639\u0645 \u0627\u062a\u062e\u0627\u0630 \u0627\u0644\u0642\u0631\u0627\u0631 \u0641\u064a \u0628\u064a\u0626\u0629 \u0627\u0644\u0639\u0645\u0644 \u0627\u0644\u0645\u0635\u0631\u0641\u064a.<\/p>\n

\u0623\u0647\u062f\u0627\u0641 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c:<\/strong><\/b><\/p>\n

\u0628\u0646\u0647\u0627\u064a\u0629 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c\u060c \u064a\u0643\u0648\u0646 \u0627\u0644\u0645\u062a\u062f\u0631\u0628 \u0642\u0627\u062f\u0631\u0627\u064b \u0639\u0644\u0649:<\/p>\n

1- \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0648\u0627\u0644 \u0648\u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0648\u0627\u0644\u0645\u062a\u062f\u0627\u062e\u0644\u0629 \u0641\u064a \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0648\u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629.<\/p>\n

2- \u0628\u0646\u0627\u0621 \u062a\u0642\u0627\u0631\u064a\u0631 \u0648\u062c\u062f\u0627\u0648\u0644 \u0645\u062d\u0648\u0631\u064a\u0629 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u0629\u060c \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0623\u062f\u0648\u0627\u062a \u0627\u0644\u062a\u0644\u062e\u064a\u0635 \u0627\u0644\u062c\u0627\u0647\u0632\u0629 (Consolidate\u060c Subtotal\u060c Grouping) \u0648\u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0645\u062d\u0648\u0631\u064a\u0629 PivotTables.<\/p>\n

3- \u062a\u0646\u0638\u064a\u0641 \u0648\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0645\u0635\u0627\u062f\u0631 \u0645\u062a\u0639\u062f\u062f\u0629 (\u0645\u0644\u0641\u0627\u062a \u0646\u0635\u064a\u0629\u060c \u0627\u0644\u0625\u0646\u062a\u0631\u0646\u062a\u060c \u0642\u0648\u0627\u0639\u062f \u0628\u064a\u0627\u0646\u0627\u062a) \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Query.<\/p>\n

4- \u0625\u062c\u0631\u0627\u0621 \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0633\u064a\u0646\u0627\u0631\u064a\u0648\u0647\u0627\u062a \u0648\u062a\u062d\u0644\u064a\u0644 “\u0645\u0627\u0630\u0627 \u0644\u0648” (Goal Seek\u060c Data Table\u060c Scenario Manager) \u0644\u062f\u0639\u0645 \u0627\u0644\u0642\u0631\u0627\u0631\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0648\u0627\u0644\u0627\u0626\u062a\u0645\u0627\u0646\u064a\u0629.<\/p>\n

5- \u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u062d\u0633\u0627\u0628\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 (\u0627\u0644\u0623\u0642\u0633\u0627\u0637\u060c \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u062d\u0627\u0644\u064a\u0629 \u0648\u0627\u0644\u0645\u0633\u062a\u0642\u0628\u0644\u064a\u0629\u060c \u0645\u0639\u062f\u0644 \u0627\u0644\u0639\u0627\u0626\u062f \u0627\u0644\u062f\u0627\u062e\u0644\u064a) \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629 \u0641\u064a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0642\u0631\u0648\u0636 \u0648\u0627\u0644\u062a\u0645\u0648\u064a\u0644 \u0627\u0644\u0645\u0635\u0631\u0641\u064a.<\/p>\n

6- \u062a\u0635\u0645\u064a\u0645 \u0648\u0628\u0646\u0627\u0621 \u0644\u0648\u062d\u0629 \u062a\u062d\u0643\u0645 (Dashboard) \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0648\u0645\u0631\u062a\u0628\u0637\u0629 \u062a\u0644\u0642\u0627\u0626\u064a\u0627\u064b \u0628\u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0624\u0634\u0631\u0627\u062a \u0623\u062f\u0627\u0621 \u0631\u0626\u064a\u0633\u064a\u0629 (KPIs) \u0648\u0645\u062e\u0637\u0637\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629.<\/p>\n

7- \u062f\u0645\u062c \u0627\u0644\u0645\u0647\u0627\u0631\u0627\u062a \u0627\u0644\u0645\u0643\u062a\u0633\u0628\u0629 (\u0627\u0644\u062f\u0648\u0627\u0644 \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629\u060c \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0627\u0644\u062d\u0633\u0627\u0628\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629\u060c \u0644\u0648\u062d\u0629 \u0627\u0644\u062a\u062d\u0643\u0645) \u0641\u064a \u0645\u0634\u0631\u0648\u0639 \u062a\u0637\u0628\u064a\u0642\u064a \u0645\u062a\u0643\u0627\u0645\u0644 \u0642\u0627\u0628\u0644 \u0644\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0641\u0639\u0644\u064a \u0641\u064a \u0628\u064a\u0626\u0629 \u0627\u0644\u0639\u0645\u0644 \u0627\u0644\u0645\u0635\u0631\u0641\u064a.<\/p>\n

\u0645\u062d\u062a\u0648\u064a\u0627\u062a \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c <\/strong><\/b>:<\/strong><\/b> \u0645\u0642\u0633\u0645\u0629 \u062d\u0633\u0628 \u0627\u0644\u0627\u064a\u0627\u0645 (3 \u0623\u064a\u0627\u0645 \u2013 6 \u0625\u0644\u0649 7 \u0633\u0627\u0639\u0627\u062a \u0644\u0643\u0644 \u064a\u0648\u0645)<\/strong><\/b><\/p>\n

\u0627\u0644\u064a\u0648\u0645 \u0627\u0644\u0623\u0648\u0644: \u0645\u0647\u0627\u0631\u0627\u062a \u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a \u0627\u0644\u0625\u0643\u0633\u0644<\/u><\/strong><\/b><\/p>\n

\u00fc     \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u062f\u0627\u062e\u0644 \u0627\u0644\u0625\u0643\u0633\u0644\u060c \u0648\u0623\u0646\u0648\u0627\u0639 \u0627\u0644\u0645\u0631\u0627\u062c\u0639 (\u0646\u0633\u0628\u064a\/\u0645\u0637\u0644\u0642\/\u0645\u062e\u062a\u0644\u0637) \u0648\u0643\u064a\u0641\u064a\u0629 \u062a\u0648\u0638\u064a\u0641\u0647\u0627.<\/p>\n

\u00fc     \u0627\u0644\u062a\u0646\u0633\u064a\u0642 \u0627\u0644\u0634\u0631\u0637\u064a \u0627\u0644\u0645\u062a\u0642\u062f\u0645 \u0648\u0623\u062f\u0627\u0629 Data Validation: Icon Sets\u060c Data Bar\u060c Color Scale\u060c \u0648\u0627\u0644\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0645\u062e\u0635\u0635\u0629 \u0648\u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u0642\u0648\u0627\u0639\u062f\u060c \u0644\u0631\u0635\u062f \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0634\u0627\u0630\u0629 \u0648\u0636\u0628\u0637 \u062c\u0648\u062f\u0629 \u0625\u062f\u062e\u0627\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n

\u00fc     \u0627\u0644\u062f\u0648\u0627\u0644 \u0627\u0644\u0634\u0631\u0637\u064a\u0629 \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629: IF Function (\u0627\u0644\u0645\u062a\u0639\u062f\u062f \u0648\u0627\u0644\u0645\u062a\u062f\u0627\u062e\u0644)\u060c AND\/OR\u060c \u0648\u0645\u0639\u0627\u0644\u062c\u0629 \u0623\u062e\u0637\u0627\u0621 \u0627\u0644\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0648\u0627\u0644\u0627\u0633\u062a\u0641\u0627\u062f\u0629 \u0645\u0646\u0647\u0627.<\/p>\n

\u00fc     \u062f\u0648\u0627\u0644 \u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629: VLOOKUP\u060c INDEX & MATCH\u060c XLOOKUP\u060c \u0648\u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0646\u0635\u0648\u0635 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0645\u0639\u0627\u062f\u0644\u0627\u062a.<\/p>\n

\u00fc     \u0627\u0633\u062a\u0631\u062c\u0627\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0627\u0644\u062c\u062f\u0627\u0648\u0644\u060c \u0648\u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0623\u0633\u0645\u0627\u0621 (Named Ranges).<\/p>\n

\u00fc     \u062a\u0645\u0631\u064a\u0646 \u062a\u0637\u0628\u064a\u0642\u064a \u0634\u0627\u0645\u0644: \u0628\u0646\u0627\u0621 \u0648\u0631\u0642\u0629 \u0639\u0645\u0644 \u0648\u062a\u0642\u0631\u064a\u0631 \u062a\u0633\u0648\u064a\u0629 \u0627\u062d\u062a\u0631\u0627\u0641\u064a \u0645\u0648\u062d\u0651\u062f \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u062c\u0645\u0648\u0639\u0629 \u0627\u0644\u062f\u0648\u0627\u0644 \u0648\u0627\u0644\u062a\u0646\u0633\u064a\u0642\u0627\u062a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629.<\/p>\n

 <\/p>\n

\u0627\u0644\u064a\u0648\u0645 \u0627\u0644\u062b\u0627\u0646\u064a: \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u062d\u0633\u0627\u0628\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629<\/u><\/strong><\/b><\/p>\n

\u00fc     \u0645\u062f\u062e\u0644 \u0625\u0644\u0649 \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a: \u062a\u0639\u0631\u064a\u0641\u0647\u060c \u0645\u0631\u0627\u062d\u0644\u0647\u060c \u0627\u0644\u0647\u062f\u0641 \u0645\u0646\u0647\u060c \u0648\u0623\u0633\u0627\u0644\u064a\u0628\u0647\u060c \u0648\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0625\u0643\u0633\u0644 (Excel Tables) \u0643\u0642\u0627\u0639\u062f\u0629 \u0644\u0623\u064a \u062a\u062d\u0644\u064a\u0644.<\/p>\n

\u00fc     \u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0636\u064a\u0631\u0647\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Power Query: \u0645\u0646 \u0645\u0644\u0641 \u0646\u0635\u064a \/ \u0645\u0646 \u0627\u0644\u0625\u0646\u062a\u0631\u0646\u062a \/ \u0645\u0646 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n

\u00fc     \u0627\u0644\u062c\u062f\u0627\u0648\u0644 \u0627\u0644\u0645\u062d\u0648\u0631\u064a\u0629 PivotTables (\u062c\u062f\u0648\u0644 \u0648\u0627\u062d\u062f \u0648\u0645\u062a\u0639\u062f\u062f) \u0648\u0627\u0644\u0631\u0633\u0648\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u064a\u0629 \u0627\u0644\u0645\u062d\u0648\u0631\u064a\u0629 PivotCharts\u060c \u0645\u0639 \u0623\u062f\u0648\u0627\u062a \u0627\u0644\u062a\u0644\u062e\u064a\u0635 \u0627\u0644\u0645\u0643\u0645\u0651\u0644\u0629 Consolidate \u0648Subtotal \u0648Grouping + Outline.<\/p>\n

\u00fc     \u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u062a\u0635\u0641\u064a\u0629 \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629: Slicers \u0648Timeline \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n

\u00fc     \u0623\u062f\u0648\u0627\u062a \u062a\u062d\u0644\u064a\u0644 “\u0645\u0627\u0630\u0627 \u0644\u0648”: Goal Seek\u060c Data Table\u060c Scenario Manager \u2014 \u0628\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0645\u0628\u0627\u0634\u0631\u0629 \u0639\u0644\u0649 \u0633\u064a\u0646\u0627\u0631\u064a\u0648\u0647\u0627\u062a \u0633\u062f\u0627\u062f \u0627\u0644\u0642\u0631\u0648\u0636 \u0648\u062d\u0633\u0627\u0633\u064a\u0629 \u0633\u0639\u0631 \u0627\u0644\u0641\u0627\u0626\u062f\u0629.<\/p>\n

\u00fc     \u0627\u0644\u062f\u0648\u0627\u0644 \u0627\u0644\u0645\u0627\u0644\u064a\u0629 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0641\u064a \u0627\u0644\u0639\u0645\u0644 \u0627\u0644\u0645\u0635\u0631\u0641\u064a: PMT \u0648IPMT \u0648PPMT \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u0623\u0642\u0633\u0627\u0637\u060c \u0648PV \u0648FV \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645\u0629 \u0627\u0644\u062d\u0627\u0644\u064a\u0629 \u0648\u0627\u0644\u0645\u0633\u062a\u0642\u0628\u0644\u064a\u0629\u060c \u0648NPV \u0648IRR \u0648RATE \u0644\u062a\u0642\u064a\u064a\u0645 \u062c\u062f\u0648\u0649 \u0627\u0644\u062a\u0645\u0648\u064a\u0644.<\/p>\n

\u00fc     \u062a\u0645\u0631\u064a\u0646 \u062a\u0637\u0628\u064a\u0642\u064a \u0645\u062a\u0643\u0627\u0645\u0644: \u0625\u0639\u062f\u0627\u062f \u062a\u0642\u0631\u064a\u0631 \u062a\u062d\u0644\u064a\u0644\u064a \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a \u0648\u0628\u0646\u0627\u0621 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u0647\u0644\u0627\u0643 \u0642\u0631\u0636 (Loan Amortization Schedule) \u0643\u0627\u0645\u0644 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0648\u0627\u0644 \u0627\u0644\u0645\u0627\u0644\u064a\u0629.<\/p>\n

 <\/p>\n

 <\/p>\n

\u0627\u0644\u064a\u0648\u0645 \u0627\u0644\u062b\u0627\u0644\u062b: \u0644\u0648\u062d\u0629 \u0627\u0644\u062a\u062d\u0643\u0645 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0625\u0643\u0633\u0644 (Excel Dashboard)<\/u><\/strong><\/b><\/p>\n

\u00fc     \u0645\u0641\u0647\u0648\u0645 \u0644\u0648\u062d\u0629 \u0627\u0644\u0642\u064a\u0627\u062f\u0629\u060c \u0648\u0623\u0647\u0645\u064a\u0629 \u0645\u0624\u0634\u0631\u0627\u062a \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 (KPIs) \u0641\u064a \u0627\u0644\u0628\u064a\u0626\u0629 \u0627\u0644\u0645\u0635\u0631\u0641\u064a\u0629 \u0645\u062b\u0644 \u0646\u0633\u0628\u0629 \u0627\u0644\u062a\u0639\u062b\u0631 (NPL)\u060c \u0648\u0646\u0633\u0628\u0629 \u0627\u0644\u062a\u062d\u0635\u064a\u0644\u060c \u0648\u062d\u062c\u0645 \u0627\u0644\u0645\u062d\u0641\u0638\u0629\u060c \u0648\u0643\u064a\u0641\u064a\u0629 \u0628\u0646\u0627\u0621 \u0628\u0637\u0627\u0642\u0627\u062a \u0627\u0644\u0623\u062f\u0627\u0621.<\/p>\n

\u00fc     \u0627\u0644\u0645\u062e\u0637\u0637\u0627\u062a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629: Sparklines\u060c \u0623\u0646\u0648\u0627\u0639 \u0627\u0644\u0631\u0633\u0648\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u064a\u0629\u060c \u0648\u0627\u0644\u0631\u0633\u0648\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u064a\u0629 \u0627\u0644\u0645\u0631\u062a\u0628\u0637\u0629 \u0628\u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631.<\/p>\n

\u00fc     \u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u062a\u062d\u0643\u0645 \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0627\u0644\u0645\u0646\u0627\u0633\u0628\u0629 \u0644\u0644\u0648\u062d\u0629 (Slicers\u060c \u0648\u0627\u0644\u0642\u0648\u0627\u0626\u0645 \u0627\u0644\u0645\u0646\u0633\u062f\u0644\u0629 \u0627\u0644\u0645\u0631\u062a\u0628\u0637\u0629 \u0628\u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a Data Validation Lists).<\/p>\n

\u00fc     \u0628\u0646\u0627\u0621 \u0644\u0648\u062d\u0629 \u0627\u0644\u062a\u062d\u0643\u0645: \u062a\u062c\u0647\u064a\u0632 \u0648\u0641\u062d\u0635 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0625\u0646\u0634\u0627\u0621 \u0648\u0631\u0642\u0629 \u0639\u0645\u0644 \u0628\u0627\u0644\u0645\u0639\u0627\u062f\u0644\u0627\u062a\u060c \u0648\u0631\u0628\u0637\u0647\u0627 \u0628\u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u0644\u0648\u062d\u0629.<\/p>\n

\u00fc     \u0627\u0644\u0631\u0628\u0637 \u0627\u0644\u0632\u0645\u0646\u064a (\u0627\u0644\u0648\u0642\u062a \u0648\u0627\u0644\u062a\u0627\u0631\u064a\u062e) \u062f\u0627\u062e\u0644 \u0627\u0644\u0644\u0648\u062d\u0629\u060c \u0648\u0625\u0636\u0627\u0641\u0629 \u0627\u0644\u062a\u062d\u0633\u064a\u0646\u0627\u062a \u0627\u0644\u0646\u0647\u0627\u0626\u064a\u0629 \u0639\u0644\u0649 \u0627\u0644\u062a\u0635\u0645\u064a\u0645.<\/p>\n

\u00fc     \u0645\u0634\u0631\u0648\u0639 \u062e\u062a\u0627\u0645\u064a: \u0628\u0646\u0627\u0621 \u0644\u0648\u062d\u0629 \u062a\u062d\u0643\u0645 \u0645\u0635\u0631\u0641\u064a\u0629 \u062a\u0641\u0627\u0639\u0644\u064a\u0629 \u0645\u062a\u0643\u0627\u0645\u0644\u0629 (\u062a\u062f\u0645\u062c \u0645\u062e\u0631\u062c\u0627\u062a \u0627\u0644\u064a\u0648\u0645\u064a\u0646 \u0627\u0644\u0633\u0627\u0628\u0642\u064a\u0646: \u0627\u0644\u062f\u0648\u0627\u0644\u060c \u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u0648\u0631\u064a\u060c \u0648\u0627\u0644\u062d\u0633\u0627\u0628\u0627\u062a \u0627\u0644\u0645\u0627\u0644\u064a\u0629) + \u062a\u0642\u064a\u064a\u0645 \u0646\u0647\u0627\u0626\u064a \u0648\u062a\u063a\u0630\u064a\u0629 \u0631\u0627\u062c\u0639\u0629.<\/p>\n

 <\/p>\n

 \u0639\u062f\u062f \u0627\u0644\u0633\u0627\u0639\u0627\u062a \u0627\u0644\u062a\u062f\u0631\u064a\u0628\u064a\u0629: 21 \u0633\u0627\u0639\u0629 \u062a\u062f\u0631\u064a\u0628\u064a\u0629<\/strong><\/p>\n

\n
\n
 <\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\u0627\u0644\u062c\u062f\u0648\u0644 \u0627\u0644\u0632\u0645\u0646\u064a:<\/strong><\/div>\n
\n\n\n\n\n\n\n
\u0627\u0644\u064a\u0648\u0645<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0627\u0644\u062a\u0627\u0631\u064a\u062e<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0648\u0642\u062a \u0627\u0644\u0628\u062f\u0627\u064a\u0629<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0648\u0642\u062a \u0627\u0644\u0646\u0647\u0627\u064a\u0629<\/span><\/p>\n
 <\/div>\n<\/th>\n
\u0627\u0644\u0645\u062f\u0629<\/span><\/p>\n
 <\/div>\n<\/th>\n<\/tr>\n
\u0627\u0644\u0633\u0628\u062a<\/td>\n18\/07\/2026<\/td>\n09:00<\/td>\n16:00<\/td>\n07:00<\/td>\n<\/tr>\n
\u0627\u0644\u0633\u0628\u062a<\/td>\n25\/07\/2026<\/td>\n09:00<\/td>\n16:00<\/td>\n07:00<\/td>\n<\/tr>\n
\u0627\u0644\u0633\u0628\u062a<\/td>\n01\/08\/2026<\/td>\n09:00<\/td>\n16:00<\/td>\n07:00<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n
 <\/div>\n<\/div>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u0627\u0644\u0645\u062f\u0631\u0628:\u0645\u0627\u0644\u0643 \u0648\u0644\u064a\u062f \u0627\u0628\u0631\u0627\u0647\u064a\u0645 \u0637\u0648\u0645\u0627\u0631 \u0645\u0642\u062f\u0645\u0629 \u0639\u0646 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c: \u064a\u064f\u0639\u062f \u0628\u0631\u0646\u0627\u0645\u062c Excel \u0627\u0644\u0623\u062f\u0627\u0629 \u0627\u0644\u0623\u0643\u062b\u0631 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0627\u064b \u0644\u062f\u0649 \u0645\u0648\u0638\u0641\u064a \u0627\u0644\u0642\u0637\u0627\u0639 \u0627\u0644\u0645\u0635\u0631\u0641\u064a \u0641\u064a \u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a […]<\/p>\n","protected":false},"featured_media":4050,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"course_category":[87,140],"course_tag":[205],"class_list":["post-4063","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category---ar","course_category-all-courses-porgrams-ar","course_tag-205","course"],"_links":{"self":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/types\/lp_course"}],"replies":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4063"}],"version-history":[{"count":11,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4063\/revisions"}],"predecessor-version":[{"id":5189,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/lp_course\/4063\/revisions\/5189"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=\/wp\/v2\/media\/4050"}],"wp:attachment":[{"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4063"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_category&post=4063"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/pbi.ps\/index.php?rest_route=%2Fwp%2Fv2%2Fcourse_tag&post=4063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}