{"id":56177,"date":"2025-01-19T15:28:47","date_gmt":"2025-01-19T15:28:47","guid":{"rendered":"https:\/\/masartech.com.sa\/?p=56177"},"modified":"2025-01-19T15:28:47","modified_gmt":"2025-01-19T15:28:47","slug":"%d8%a3%d9%87%d9%85%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d8%a7%d9%84%d8%b5%d9%8a%d8%ba-%d8%a7%d9%84%d9%85%d8%aa%d9%82%d8%af%d9%85%d8%a9-%d9%81%d9%8a-excel-%d9%84%d8%aa%d8%ad%d9%84","status":"publish","type":"post","link":"https:\/\/mostafaweb.info\/masartechwp\/%d8%a3%d9%87%d9%85%d9%8a%d8%a9-%d8%a7%d8%b3%d8%aa%d8%ae%d8%af%d8%a7%d9%85-%d8%a7%d9%84%d8%b5%d9%8a%d8%ba-%d8%a7%d9%84%d9%85%d8%aa%d9%82%d8%af%d9%85%d8%a9-%d9%81%d9%8a-excel-%d9%84%d8%aa%d8%ad%d9%84\/","title":{"rendered":"\u0623\u0647\u0645\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a Excel \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629"},"content":{"rendered":"<div class=\"flex-1 overflow-hidden @container\/thread\">\n<div class=\"h-full\">\n<div class=\"react-scroll-to-bottom--css-vjovc-79elbk h-full\">\n<div class=\"react-scroll-to-bottom--css-vjovc-1n7m0yu\">\n<div class=\"flex flex-col text-sm md:pb-9\">\n<article class=\"w-full scroll-mb-[var(--thread-trailing-height,150px)] text-token-text-primary focus-visible:outline-2 focus-visible:outline-offset-[-4px]\" dir=\"auto\" data-testid=\"conversation-turn-33\" data-scroll-anchor=\"true\">\n<div class=\"m-auto text-base py-[18px] px-3 md:px-4 w-full md:px-5 lg:px-4 xl:px-5\">\n<div class=\"mx-auto flex flex-1 gap-4 text-base md:gap-5 lg:gap-6 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem]\">\n<div class=\"group\/conversation-turn relative flex w-full min-w-0 flex-col agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex max-w-full flex-col flex-grow\">\n<div class=\"min-h-8 text-message flex w-full flex-col items-end gap-2 whitespace-normal break-words text-start [.text-message+&amp;]:mt-5\" dir=\"auto\" data-message-author-role=\"assistant\" data-message-id=\"6f17e046-3a2c-4914-a74a-e4ec87d5e87d\" data-message-model-slug=\"gpt-4o\">\n<div class=\"flex w-full flex-col gap-1 empty:hidden first:pt-[3px]\">\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\n<h3><span style=\"color: #000000;\"><strong>\u0623\u0647\u0645\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a Excel \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">\u064a\u064f\u0639\u062f <strong>Excel<\/strong> \u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0644\u0643\u0646 \u062a\u062d\u0642\u064a\u0642 \u0623\u0642\u0635\u0649 \u0627\u0633\u062a\u0641\u0627\u062f\u0629 \u0645\u0646\u0647 \u064a\u062a\u0637\u0644\u0628 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>\u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629<\/strong> \u0627\u0644\u062a\u064a \u062a\u0633\u0627\u0639\u062f\u0643 \u0639\u0644\u0649 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629 \u0648\u062f\u0642\u0629. \u0627\u0644\u0635\u064a\u063a \u0645\u062b\u0644 <strong>VLOOKUP<\/strong>\u060c <strong>INDEX-MATCH<\/strong>\u060c \u0648<strong>IF Functions<\/strong> \u0644\u064a\u0633\u062a \u0645\u062c\u0631\u062f \u0623\u062f\u0648\u0627\u062a \u0644\u0644\u0642\u064a\u0627\u0645 \u0628\u0639\u0645\u0644\u064a\u0627\u062a \u062d\u0633\u0627\u0628\u064a\u0629 \u0628\u0633\u064a\u0637\u0629\u060c \u0628\u0644 \u062a\u062a\u064a\u062d \u062a\u0646\u0641\u064a\u0630 \u062a\u062d\u0644\u064a\u0644\u0627\u062a \u0645\u0639\u0642\u062f\u0629 \u0628\u0633\u0631\u0639\u0629 \u0648\u0641\u0639\u0627\u0644\u064a\u0629. \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0645\u0642\u0627\u0644\u060c \u0633\u0646\u0633\u0644\u0637 \u0627\u0644\u0636\u0648\u0621 \u0639\u0644\u0649 \u0623\u0647\u0645\u064a\u0629 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a \u0648\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627 \u0641\u064a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><\/p>\n<hr \/>\n<h3><span style=\"color: #000000;\"><strong>1. \u0623\u0647\u0645\u064a\u0629 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/span><\/h3>\n<h4><span style=\"color: #000000;\"><strong>\u0623. \u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0625\u0646\u062a\u0627\u062c\u064a\u0629 \u0648\u062a\u0642\u0644\u064a\u0644 \u0627\u0644\u0648\u0642\u062a<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u062a\u062a\u064a\u062d \u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0645\u0639\u0642\u062f\u0629 \u0628\u0643\u0641\u0627\u0621\u0629 \u0639\u0627\u0644\u064a\u0629.<\/span><\/li>\n<li><span style=\"color: #000000;\">\u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0642\u0636\u0627\u0621 \u0633\u0627\u0639\u0627\u062a \u0641\u064a \u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648 \u0627\u0644\u062a\u062d\u0642\u0642 \u0645\u0646\u0647\u0627 \u064a\u062f\u0648\u064a\u064b\u0627\u060c \u064a\u0645\u0643\u0646\u0643 \u0625\u0646\u062c\u0627\u0632 \u0630\u0644\u0643 \u0628\u062b\u0648\u0627\u0646\u064d \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u0646\u0627\u0633\u0628\u0629.<\/span><\/li>\n<\/ul>\n<h4><span style=\"color: #000000;\"><strong>\u0628. \u062a\u0639\u0632\u064a\u0632 \u062f\u0642\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u062a\u0642\u0644\u0644 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0645\u0646 \u0627\u0644\u0623\u062e\u0637\u0627\u0621 \u0627\u0644\u0628\u0634\u0631\u064a\u0629 \u0641\u064a \u0625\u062f\u062e\u0627\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0648 \u062a\u062d\u0644\u064a\u0644\u0647\u0627.<\/span><\/li>\n<li><span style=\"color: #000000;\">\u062a\u062a\u064a\u062d \u0635\u064a\u0627\u063a\u0629 \u0627\u0644\u0645\u0639\u0627\u062f\u0644\u0627\u062a \u0628\u0637\u0631\u064a\u0642\u0629 \u062f\u0642\u064a\u0642\u0629 \u0644\u0636\u0645\u0627\u0646 \u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0646\u062a\u0627\u0626\u062c \u0635\u062d\u064a\u062d\u0629.<\/span><\/li>\n<\/ul>\n<h4><span style=\"color: #000000;\"><strong>\u062c. \u0627\u0644\u0645\u0631\u0648\u0646\u0629 \u0641\u064a \u0627\u0644\u062a\u062d\u0644\u064a\u0644<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u062a\u0648\u0641\u0631 \u0627\u0644\u0635\u064a\u063a \u0645\u062b\u0644 <strong>VLOOKUP<\/strong> \u0648<strong>INDEX-MATCH<\/strong> \u0637\u0631\u0642\u064b\u0627 \u0645\u0631\u0646\u0629 \u0644\u0631\u0628\u0637 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0645\u0635\u0627\u062f\u0631 \u0645\u062a\u0639\u062f\u062f\u0629.<\/span><\/li>\n<li><span style=\"color: #000000;\">\u064a\u0645\u0643\u0646 \u062a\u0639\u062f\u064a\u0644 \u0627\u0644\u0635\u064a\u063a \u0628\u0633\u0647\u0648\u0644\u0629 \u0644\u062a\u0646\u0627\u0633\u0628 \u0627\u062d\u062a\u064a\u0627\u062c\u0627\u062a \u0627\u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629.<\/span><\/li>\n<\/ul>\n<h4><span style=\"color: #000000;\"><strong>\u062f. \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0631\u0624\u0649 \u0623\u0639\u0645\u0642<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a \u0645\u062b\u0644 <strong>IF<\/strong> \u0648<strong>SUMIF<\/strong>\u060c \u064a\u0645\u0643\u0646\u0643 \u062a\u0635\u0646\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0644\u064a\u0644\u0647\u0627 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0634\u0631\u0648\u0637 \u0645\u0639\u064a\u0646\u0629.<\/span><\/li>\n<\/ul>\n<hr \/>\n<h3><span style=\"color: #000000;\"><strong>2. \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0627\u0644\u0623\u0633\u0627\u0633\u064a\u0629 \u0648\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0647\u0627<\/strong><\/span><\/h3>\n<h4><span style=\"color: #000000;\"><strong>\u0623. VLOOKUP<\/strong><\/span><\/h4>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u063a\u0631\u0636:<\/strong> \u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0642\u064a\u0645\u0629 \u0641\u064a \u0639\u0645\u0648\u062f \u0645\u0639\u064a\u0646 \u0648\u0625\u0631\u062c\u0627\u0639 \u0642\u064a\u0645\u0629 \u0645\u0642\u0627\u0628\u0644\u0629 \u0645\u0646 \u0639\u0645\u0648\u062f \u0622\u062e\u0631.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u0639\u0627\u0645\u0629:<\/strong><\/span><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645:<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062c\u062f\u0648\u0644\u064a\u0629:<\/strong> \u0645\u062b\u0644 \u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0627\u0633\u0645 \u0645\u0648\u0638\u0641 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0631\u0642\u0645 \u0627\u0644\u0645\u0648\u0638\u0641.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\u062a\u0648\u062d\u064a\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a:<\/strong> \u062f\u0645\u062c \u062c\u062f\u0627\u0648\u0644 \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0645\u062e\u062a\u0644\u0641\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0641\u062a\u0627\u062d \u0645\u0634\u062a\u0631\u0643.<\/span><\/li>\n<\/ul>\n<p><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644:<\/strong> \u0644\u0644\u0628\u062d\u062b \u0639\u0646 <strong>\u0627\u0644\u0631\u0627\u062a\u0628<\/strong> \u0644\u0645\u0648\u0638\u0641 \u0645\u0639\u064a\u0646 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0631\u0642\u0645 \u0627\u0644\u0645\u0648\u0638\u0641:<\/span><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=VLOOKUP(101, A2:C10, 3, FALSE)<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<h4><span style=\"color: #000000;\"><strong>\u0628. INDEX-MATCH<\/strong><\/span><\/h4>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u063a\u0631\u0636:<\/strong> \u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0645\u0631\u0648\u0646\u0629 \u0623\u0643\u062b\u0631 \u0645\u0642\u0627\u0631\u0646\u0629 \u0628\u0640 <strong>VLOOKUP<\/strong>.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u0635\u064a\u063a:<\/strong><\/span><\/p>\n<ol>\n<li><span style=\"color: #000000;\"><strong>INDEX:<\/strong> \u0625\u0631\u062c\u0627\u0639 \u0642\u064a\u0645\u0629 \u0645\u0646 \u0646\u0637\u0627\u0642 \u0645\u0639\u064a\u0646 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0631\u0642\u0645 \u0627\u0644\u0635\u0641 \u0648\u0627\u0644\u0639\u0645\u0648\u062f.<\/span>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=INDEX(array, row_num, [column_num])<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>MATCH:<\/strong> \u0625\u0631\u062c\u0627\u0639 \u0645\u0648\u0642\u0639 \u0639\u0646\u0635\u0631 \u062f\u0627\u062e\u0644 \u0646\u0637\u0627\u0642.<\/span>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=MATCH(lookup_value, lookup_array, [match_type])<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0639\u064b\u0627:<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u062a\u062c\u0627\u0648\u0632 \u0642\u064a\u0648\u062f VLOOKUP:<\/strong> \u0645\u062b\u0644 \u0627\u0644\u0628\u062d\u062b \u0641\u064a \u0627\u062a\u062c\u0627\u0647\u0627\u062a \u0645\u062e\u062a\u0644\u0641\u0629 (\u0645\u0646 \u0627\u0644\u064a\u0645\u064a\u0646 \u0625\u0644\u0649 \u0627\u0644\u064a\u0633\u0627\u0631).<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a:<\/strong> \u0625\u0630\u0627 \u062a\u063a\u064a\u0631\u062a \u0623\u0639\u0645\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><\/li>\n<\/ul>\n<p><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644:<\/strong> \u0644\u0644\u0639\u062b\u0648\u0631 \u0639\u0644\u0649 <strong>\u0627\u0633\u0645 \u0627\u0644\u0639\u0645\u064a\u0644<\/strong> \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0645\u0639\u0631\u0641\u0647:<\/span><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=INDEX(B2:B10, MATCH(101, A2:A10, 0))<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<h4><span style=\"color: #000000;\"><strong>\u062c. IF Functions<\/strong><\/span><\/h4>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u063a\u0631\u0636:<\/strong> \u062a\u0646\u0641\u064a\u0630 \u0639\u0645\u0644\u064a\u0629 \u0645\u0646\u0637\u0642\u064a\u0629 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0634\u0631\u0637 \u0645\u0639\u064a\u0646.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u0639\u0627\u0645\u0629:<\/strong><\/span><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=IF(logical_test, value_if_true, value_if_false)<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645:<\/strong><\/span><\/p>\n<ul>\n<li><span style=\"color: #000000;\"><strong>\u062a\u0635\u0646\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a:<\/strong> \u0645\u062b\u0644 \u062a\u062d\u062f\u064a\u062f \u0645\u0627 \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u0642\u064a\u0645\u0629 \u0645\u0639\u064a\u0646\u0629 \u0623\u0639\u0644\u0649 \u0623\u0648 \u0623\u0642\u0644 \u0645\u0646 \u0645\u062a\u0648\u0633\u0637 \u0645\u0639\u064a\u0646.<\/span><\/li>\n<li><span style=\"color: #000000;\"><strong>\u0625\u0636\u0627\u0641\u0629 \u0634\u0631\u0648\u0637 \u0645\u062a\u0639\u062f\u062f\u0629:<\/strong> \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0635\u064a\u063a \u0645\u062b\u0644 <strong>IF-AND<\/strong> \u0648<strong>IF-OR<\/strong>.<\/span><\/li>\n<\/ul>\n<p><span style=\"color: #000000;\"><strong>\u0645\u062b\u0627\u0644:<\/strong> \u0644\u0625\u0631\u062c\u0627\u0639 <strong>&#8220;\u0646\u0627\u062c\u062d&#8221;<\/strong> \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u0627\u0644\u062f\u0631\u062c\u0629 \u0623\u0643\u0628\u0631 \u0645\u0646 50\u060c \u0648**&#8221;\u0631\u0627\u0633\u0628&#8221;** \u0625\u0630\u0627 \u0643\u0627\u0646\u062a \u0623\u0642\u0644:<\/span><\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=IF(A2&gt;50, \"\u0646\u0627\u062c\u062d\", \"\u0631\u0627\u0633\u0628\")<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<h4><span style=\"color: #000000;\"><strong>\u062f. \u0635\u064a\u063a \u0645\u062a\u0642\u062f\u0645\u0629 \u0623\u062e\u0631\u0649<\/strong><\/span><\/h4>\n<ol>\n<li><span style=\"color: #000000;\"><strong>SUMIF \u0648 COUNTIF:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u062c\u0645\u0639 \u0627\u0644\u0642\u064a\u0645 \u0623\u0648 \u0639\u062f \u0627\u0644\u0639\u0646\u0627\u0635\u0631 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0634\u0631\u0648\u0637 \u0645\u062d\u062f\u062f\u0629.<\/span><\/li>\n<\/ul>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=SUMIF(range, criteria, [sum_range])<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>TEXT Functions:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0645\u0639\u0627\u0644\u062c\u0629 \u0627\u0644\u0646\u0635\u0648\u0635 \u0645\u062b\u0644 \u062f\u0645\u062c \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0623\u0648 \u062a\u0642\u0633\u064a\u0645\u0647\u0627.<\/span><\/li>\n<\/ul>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\"><span style=\"color: #000000;\">excel<\/span><\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><span style=\"color: #000000;\"><span class=\"\" data-state=\"closed\"><button class=\"flex gap-1 items-center select-none px-4 py-1\" aria-label=\"Copy\">Copy<\/button><\/span><span class=\"\" data-state=\"closed\"><button class=\"flex select-none items-center gap-1\">Edit<\/button><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><span style=\"color: #000000;\"><code class=\"!whitespace-pre hljs language-excel\">=CONCATENATE(A2, \" \", B2)<br \/>\n<\/code><\/span><\/div>\n<\/div>\n<\/li>\n<\/ol>\n<hr \/>\n<h3><span style=\"color: #000000;\"><strong>3. \u0645\u0642\u0627\u0631\u0646\u0629 \u0628\u064a\u0646 \u0627\u0644\u0635\u064a\u063a: \u0645\u062a\u0649 \u062a\u0633\u062a\u062e\u062f\u0645 \u0643\u0644 \u0635\u064a\u063a\u0629\u061f<\/strong><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th><span style=\"color: #000000;\"><strong>\u0627\u0644\u0635\u064a\u063a\u0629<\/strong><\/span><\/th>\n<th><span style=\"color: #000000;\"><strong>\u0627\u0644\u063a\u0631\u0636<\/strong><\/span><\/th>\n<th><span style=\"color: #000000;\"><strong>\u0627\u0644\u0645\u0632\u0627\u064a\u0627<\/strong><\/span><\/th>\n<th><span style=\"color: #000000;\"><strong>\u0627\u0644\u0642\u064a\u0648\u062f<\/strong><\/span><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><span style=\"color: #000000;\"><strong>VLOOKUP<\/strong><\/span><\/td>\n<td><span style=\"color: #000000;\">\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u0639\u0645\u0648\u062f\u064a \u0641\u064a \u062c\u062f\u0627\u0648\u0644 \u062b\u0627\u0628\u062a\u0629<\/span><\/td>\n<td><span style=\"color: #000000;\">\u0633\u0647\u0644\u0629 \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645<\/span><\/td>\n<td><span style=\"color: #000000;\">\u0645\u062d\u062f\u0648\u062f\u0629 \u0628\u0627\u0644\u0628\u062d\u062b \u0645\u0646 \u0627\u0644\u064a\u0633\u0627\u0631 \u0625\u0644\u0649 \u0627\u0644\u064a\u0645\u064a\u0646<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #000000;\"><strong>INDEX-MATCH<\/strong><\/span><\/td>\n<td><span style=\"color: #000000;\">\u0627\u0644\u0628\u062d\u062b \u0627\u0644\u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a \u0641\u064a \u0627\u0644\u0627\u062a\u062c\u0627\u0647\u064a\u0646<\/span><\/td>\n<td><span style=\"color: #000000;\">\u0645\u0631\u0648\u0646\u0629 \u0639\u0627\u0644\u064a\u0629<\/span><\/td>\n<td><span style=\"color: #000000;\">\u062a\u062a\u0637\u0644\u0628 \u0641\u0647\u0645\u064b\u0627 \u0623\u0643\u0628\u0631<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #000000;\"><strong>IF Functions<\/strong><\/span><\/td>\n<td><span style=\"color: #000000;\">\u062a\u0646\u0641\u064a\u0630 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u0634\u0631\u0637\u064a\u0629<\/span><\/td>\n<td><span style=\"color: #000000;\">\u0645\u0646\u0627\u0633\u0628\u0629 \u0644\u0644\u0642\u0631\u0627\u0631\u0627\u062a \u0627\u0644\u0628\u0633\u064a\u0637\u0629<\/span><\/td>\n<td><span style=\"color: #000000;\">\u062a\u0635\u0628\u062d \u0645\u0639\u0642\u062f\u0629 \u0641\u064a \u0627\u0644\u062d\u0627\u0644\u0627\u062a \u0627\u0644\u0645\u062a\u062f\u0627\u062e\u0644\u0629<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #000000;\"><strong>SUMIF\/COUNTIF<\/strong><\/span><\/td>\n<td><span style=\"color: #000000;\">\u062c\u0645\u0639 \u0623\u0648 \u0639\u062f \u0627\u0644\u0642\u064a\u0645 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0634\u0631\u0648\u0637 \u0645\u062d\u062f\u062f\u0629<\/span><\/td>\n<td><span style=\"color: #000000;\">\u0633\u0647\u0644\u0629 \u0648\u0645\u0628\u0627\u0634\u0631\u0629<\/span><\/td>\n<td><span style=\"color: #000000;\">\u063a\u064a\u0631 \u0645\u0646\u0627\u0633\u0628\u0629 \u0644\u0644\u062a\u062d\u0644\u064a\u0644\u0627\u062a \u0645\u062a\u0639\u062f\u062f\u0629 \u0627\u0644\u0623\u0628\u0639\u0627\u062f<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr \/>\n<h3><span style=\"color: #000000;\"><strong>4. \u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/span><\/h3>\n<h4><span style=\"color: #000000;\"><strong>\u0623. \u062a\u0648\u062d\u064a\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0645\u0635\u0627\u062f\u0631 \u0645\u062a\u0639\u062f\u062f\u0629<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>VLOOKUP<\/strong> \u0648<strong>INDEX-MATCH<\/strong>\u060c \u064a\u0645\u0643\u0646 \u062f\u0645\u062c \u062c\u062f\u0627\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0645\u062a\u0641\u0631\u0642\u0629.<\/span><\/li>\n<\/ul>\n<h4><span style=\"color: #000000;\"><strong>\u0628. \u0625\u0639\u062f\u0627\u062f \u0627\u0644\u062a\u0642\u0627\u0631\u064a\u0631 \u0627\u0644\u062a\u0641\u0627\u0639\u0644\u064a\u0629<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u0645\u0639 <strong>IF Functions<\/strong> \u0648<strong>SUMIF<\/strong>\u060c \u064a\u0645\u0643\u0646\u0643 \u0625\u0639\u062f\u0627\u062f \u062a\u0642\u0627\u0631\u064a\u0631 \u0645\u0631\u0646\u0629 \u062a\u064f\u062d\u062f\u062b \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0627\u0633\u062a\u0646\u0627\u062f\u064b\u0627 \u0625\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062c\u062f\u064a\u062f\u0629.<\/span><\/li>\n<\/ul>\n<h4><span style=\"color: #000000;\"><strong>\u062c. \u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0623\u062f\u0627\u0621<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u062a\u062d\u0644\u064a\u0644 \u0645\u0642\u0627\u064a\u064a\u0633 \u0627\u0644\u0623\u062f\u0627\u0621 (KPIs) \u0645\u062b\u0644 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a \u0627\u0644\u0634\u0647\u0631\u064a\u0629 \u0623\u0648 \u0627\u0644\u0631\u0628\u062d\u064a\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>IF Functions<\/strong> \u0644\u062a\u0635\u0646\u064a\u0641 \u0627\u0644\u0623\u062f\u0627\u0621.<\/span><\/li>\n<\/ul>\n<h4><span style=\"color: #000000;\"><strong>\u062f. \u062a\u0646\u0638\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/span><\/h4>\n<ul>\n<li><span style=\"color: #000000;\">\u062a\u0635\u062d\u064a\u062d \u0627\u0644\u0642\u064a\u0645 \u063a\u064a\u0631 \u0627\u0644\u0645\u062a\u0633\u0642\u0629 \u0623\u0648 \u0627\u0633\u062a\u0628\u062f\u0627\u0644 \u0627\u0644\u0646\u0635\u0648\u0635 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>TEXT Functions<\/strong>.<\/span><\/li>\n<\/ul>\n<hr \/>\n<h3><span style=\"color: #000000;\"><strong>5. \u0646\u0635\u0627\u0626\u062d \u0644\u062a\u062d\u0642\u064a\u0642 \u0623\u0642\u0635\u0649 \u0627\u0633\u062a\u0641\u0627\u062f\u0629 \u0645\u0646 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629<\/strong><\/span><\/h3>\n<ol>\n<li><span style=\"color: #000000;\"><strong>\u0627\u0644\u062a\u062e\u0637\u064a\u0637 \u0627\u0644\u0645\u0633\u0628\u0642:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0642\u0628\u0644 \u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0635\u064a\u063a\u060c \u062d\u062f\u062f \u0627\u0644\u0647\u062f\u0641 \u0627\u0644\u0646\u0647\u0627\u0626\u064a \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>\u0627\u0644\u0628\u0633\u0627\u0637\u0629:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0627\u0628\u062f\u0623 \u0628\u0635\u064a\u063a \u0628\u0633\u064a\u0637\u0629 \u0648\u0642\u0645 \u0628\u062a\u0637\u0648\u064a\u0631\u0647\u0627 \u062a\u062f\u0631\u064a\u062c\u064a\u064b\u0627.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>\u0627\u0644\u062a\u062d\u0642\u0642 \u0645\u0646 \u0627\u0644\u0623\u062e\u0637\u0627\u0621:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0623\u062f\u0648\u0627\u062a Excel \u0645\u062b\u0644 <strong>Evaluate Formula<\/strong> \u0644\u0641\u062d\u0635 \u0635\u064a\u063a\u0643 \u062e\u0637\u0648\u0629 \u0628\u062e\u0637\u0648\u0629.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>\u062a\u0639\u0644\u0645 \u0627\u0644\u0627\u062e\u062a\u0635\u0627\u0631\u0627\u062a:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0627\u062e\u062a\u0635\u0631 \u0627\u0644\u0648\u0642\u062a \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0627\u062e\u062a\u0635\u0627\u0631\u0627\u062a \u0645\u062b\u0644 <strong>Ctrl + Enter<\/strong> \u0648<strong>Alt + =<\/strong>.<\/span><\/li>\n<\/ul>\n<\/li>\n<li><span style=\"color: #000000;\"><strong>\u0627\u0644\u062a\u062f\u0631\u064a\u0628 \u0627\u0644\u0645\u0633\u062a\u0645\u0631:<\/strong><\/span>\n<ul>\n<li><span style=\"color: #000000;\">\u0645\u0627\u0631\u0633 \u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0635\u064a\u063a \u0639\u0644\u0649 \u0628\u064a\u0627\u0646\u0627\u062a \u062d\u0642\u064a\u0642\u064a\u0629 \u0644\u062a\u0639\u0632\u064a\u0632 \u0645\u0647\u0627\u0631\u0627\u062a\u0643.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<hr \/>\n<h3><span style=\"color: #000000;\"><strong>6. \u062e\u0644\u0627\u0635\u0629<\/strong><\/span><\/h3>\n<p><span style=\"color: #000000;\">\u0627\u0633\u062a\u062e\u062f\u0627\u0645 <strong>\u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a Excel<\/strong> \u064a\u064f\u0639\u062f \u0623\u0633\u0627\u0633\u064b\u0627 \u0644\u062a\u062d\u0644\u064a\u0644 \u0628\u064a\u0627\u0646\u0627\u062a \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629 \u0648\u062f\u0642\u0629. \u0633\u0648\u0627\u0621 \u0643\u0646\u062a \u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062d\u062b \u0639\u0646 \u0645\u0639\u0644\u0648\u0645\u0627\u062a\u060c \u062a\u0635\u0646\u064a\u0641 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0623\u0648 \u0625\u0639\u062f\u0627\u062f \u062a\u0642\u0627\u0631\u064a\u0631 \u0634\u0627\u0645\u0644\u0629\u060c \u062a\u0648\u0641\u0631 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0623\u062f\u0648\u0627\u062a \u0627\u0644\u0644\u0627\u0632\u0645\u0629 \u0644\u0625\u0646\u062c\u0627\u0632 \u0627\u0644\u0645\u0647\u0627\u0645 \u0628\u0633\u0631\u0639\u0629 \u0648\u0645\u0631\u0648\u0646\u0629. \u0645\u0639 \u0627\u0644\u062a\u062f\u0631\u064a\u0628 \u0648\u0627\u0644\u0645\u0645\u0627\u0631\u0633\u0629\u060c \u0633\u062a\u0635\u0628\u062d \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a \u062c\u0632\u0621\u064b\u0627 \u0644\u0627 \u064a\u062a\u062c\u0632\u0623 \u0645\u0646 \u0623\u062f\u0648\u0627\u062a\u0643 \u0627\u0644\u064a\u0648\u0645\u064a\u0629 \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>\u0627\u0628\u062f\u0623 \u0627\u0644\u0622\u0646 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a \u0648\u0627\u0631\u062a\u0642\u0650 \u0628\u0645\u0633\u062a\u0648\u0649 \u062a\u062d\u0644\u064a\u0644\u0643 \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a!<\/strong> \ud83d\ude80<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/article>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0623\u0647\u0645\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0641\u064a Excel \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629 \u064a\u064f\u0639\u062f Excel \u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u0644\u062a\u062d\u0644\u064a\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0644\u0643\u0646 \u062a\u062d\u0642\u064a\u0642 \u0623\u0642\u0635\u0649 \u0627\u0633\u062a\u0641\u0627\u062f\u0629 \u0645\u0646\u0647 \u064a\u062a\u0637\u0644\u0628 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0627\u0644\u062a\u064a \u062a\u0633\u0627\u0639\u062f\u0643 \u0639\u0644\u0649 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0623\u0643\u062b\u0631 \u0643\u0641\u0627\u0621\u0629 \u0648\u062f\u0642\u0629. \u0627\u0644\u0635\u064a\u063a \u0645\u062b\u0644 VLOOKUP\u060c INDEX-MATCH\u060c \u0648IF Functions \u0644\u064a\u0633\u062a \u0645\u062c\u0631\u062f \u0623\u062f\u0648\u0627\u062a \u0644\u0644\u0642\u064a\u0627\u0645 \u0628\u0639\u0645\u0644\u064a\u0627\u062a \u062d\u0633\u0627\u0628\u064a\u0629 \u0628\u0633\u064a\u0637\u0629\u060c \u0628\u0644 \u062a\u062a\u064a\u062d \u062a\u0646\u0641\u064a\u0630 \u062a\u062d\u0644\u064a\u0644\u0627\u062a \u0645\u0639\u0642\u062f\u0629 \u0628\u0633\u0631\u0639\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-56177","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts\/56177","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=56177"}],"version-history":[{"count":1,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts\/56177\/revisions"}],"predecessor-version":[{"id":56178,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/posts\/56177\/revisions\/56178"}],"wp:attachment":[{"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/media?parent=56177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/categories?post=56177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mostafaweb.info\/masartechwp\/wp-json\/wp\/v2\/tags?post=56177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}