{"id":31317,"date":"2026-10-23T21:18:45","date_gmt":"2026-10-23T21:18:45","guid":{"rendered":"https:\/\/umang.pk\/2026\/10\/23\/%db%81%d9%85-%d9%86%db%92-%d9%85%d9%88%d8%ac%d9%88%d8%af%db%81-%d9%81%d8%b1%d9%88%d8%ae%d8%aa-%d8%b3%db%92-%da%a9%d8%a6%db%8c-%d9%85%db%81%db%8c%d9%86%d9%88%da%ba-%da%a9%db%8c-%d8%a2%d9%85%d8%af%d9%86\/"},"modified":"2026-10-23T21:18:46","modified_gmt":"2026-10-23T21:18:46","slug":"%db%81%d9%85-%d9%86%db%92-%d9%85%d9%88%d8%ac%d9%88%d8%af%db%81-%d9%81%d8%b1%d9%88%d8%ae%d8%aa-%d8%b3%db%92-%da%a9%d8%a6%db%8c-%d9%85%db%81%db%8c%d9%86%d9%88%da%ba-%da%a9%db%8c-%d8%a2%d9%85%d8%af%d9%86","status":"publish","type":"post","link":"https:\/\/umang.pk\/en_us\/2026\/10\/23\/%db%81%d9%85-%d9%86%db%92-%d9%85%d9%88%d8%ac%d9%88%d8%af%db%81-%d9%81%d8%b1%d9%88%d8%ae%d8%aa-%d8%b3%db%92-%da%a9%d8%a6%db%8c-%d9%85%db%81%db%8c%d9%86%d9%88%da%ba-%da%a9%db%8c-%d8%a2%d9%85%d8%af%d9%86\/","title":{"rendered":"\u06c1\u0645 \u0646\u06d2 \u0645\u0648\u062c\u0648\u062f\u06c1 \u0641\u0631\u0648\u062e\u062a \u0633\u06d2 \u06a9\u0626\u06cc \u0645\u06c1\u06cc\u0646\u0648\u06ba \u06a9\u06cc \u0622\u0645\u062f\u0646\u06cc \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u06a9\u0631\u0646\u06d2 \u06a9\u06d2 \u0644\u06cc\u06d2 \u0627\u06cc\u06a9 Excel \u0641\u0646\u06a9\u0634\u0646 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u06cc\u0627\u06d4"},"content":{"rendered":"<div>\n<p>\u0622\u067e \u06a9\u0648 \u0644\u06af\u062a\u0627 \u06c1\u06d2 \u06a9\u06c1 \u0622\u067e \u06a9\u0648 \u067e\u06cc\u0686\u06cc\u062f\u06c1 \u0634\u0645\u0627\u0631\u06cc\u0627\u062a\u06cc \u0633\u0627\u0641\u0679 \u0648\u06cc\u0626\u0631 \u06cc\u0627 \u0645\u06cc\u0646\u0648\u0626\u0644 \u0631\u06cc\u06af\u0631\u06cc\u0634\u0646 \u0641\u0627\u0631\u0645\u0648\u0644\u0648\u06ba \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u06c1\u06d2 \u062a\u0627\u06a9\u06c1 \u06cc\u06c1 \u0627\u0646\u062f\u0627\u0632\u06c1 \u0644\u06af\u0627\u06cc\u0627 \u062c\u0627 \u0633\u06a9\u06d2 \u06a9\u06c1 \u0622\u067e \u06a9\u0627 \u06a9\u0627\u0631\u0648\u0628\u0627\u0631 \u0627\u06af\u0644\u06d2 \u0686\u0646\u062f \u0645\u06c1\u06cc\u0646\u0648\u06ba \u0645\u06cc\u06ba \u06a9\u062a\u0646\u06cc \u0631\u0642\u0645 \u06a9\u0645\u0627\u0626\u06d2 \u06af\u0627\u06d4 \u062a\u0627\u06c1\u0645\u060c Microsoft 365 \u0627\u0648\u0631 Excel 2021 \u0627\u0648\u0631 \u0627\u0633 \u06a9\u06d2 \u0628\u0639\u062f \u06a9\u06d2 \u0644\u06cc\u06d2 Excel \u0645\u06cc\u06ba \u062a\u0627\u0632\u06c1 \u062a\u0631\u06cc\u0646 Dynamic Arrays \u06a9\u06d2 \u0633\u0627\u062a\u06be\u060c \u0622\u067e \u0633\u06cc\u0644 \u0645\u06cc\u06ba \u0627\u06cc\u06a9 \u0641\u0627\u0631\u0645\u0648\u0644\u06c1 \u062f\u0631\u062c \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba \u0627\u0648\u0631 \u0645\u0633\u062a\u0642\u0628\u0644 \u0645\u06cc\u06ba \u06a9\u0626\u06cc \u0645\u06c1\u06cc\u0646\u0648\u06ba \u06a9\u06cc \u0627\u067e\u0646\u06cc \u06a9\u0645\u0627\u0626\u06cc \u06a9\u06cc \u0641\u0648\u0631\u06cc \u0637\u0648\u0631 \u067e\u0631 \u067e\u06cc\u0634 \u06af\u0648\u0626\u06cc \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<p>    <!-- No AdsNinja v10 Client! --><!-- No AdsNinja v10 Client! --><\/p>\n<p>\u0622\u067e \u06a9\u06d2 \u067e\u0627\u0633 \u067e\u06c1\u0644\u06d2 \u0633\u06d2 \u06c1\u06cc \u0648\u06c1 \u062a\u0645\u0627\u0645 \u0688\u06cc\u0679\u0627 \u0645\u0648\u062c\u0648\u062f \u06c1\u06d2 \u062c\u0633 \u06a9\u06cc \u0622\u067e \u06a9\u0648 \u0636\u0631\u0648\u0631\u062a \u06c1\u06d2\u06d4 \u062c\u0628 \u062a\u06a9 \u0622\u067e \u06a9\u06d2 \u067e\u0627\u0633 \u06a9\u0627\u0641\u06cc \u0627\u0648\u0631 \u0645\u0633\u0644\u0633\u0644 \u0627\u062f\u0648\u0627\u0631 \u06a9\u06d2 \u0644\u06cc\u06d2 \u0622\u0645\u062f\u0646\u06cc \u06a9\u06d2 \u0627\u0639\u062f\u0627\u062f \u0648 \u0634\u0645\u0627\u0631 \u06c1\u06cc\u06ba\u060c \u0622\u067e Excel \u06a9\u06d2 TREND \u0641\u0646\u06a9\u0634\u0646 \u06a9\u0648 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<aside class=\"display-card  article article-card small  no-badge  active-content\" data-include-community-rating=\"false\" id=\"excel-data-trends-correl-function\" data-nosnippet=\"\">\n<p>                    <span data-field=\"label\" class=\"article-card-label\"><label>\u0645\u062a\u0639\u0644\u0642\u06c1<\/label><\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title\">\n<p>\t\t\tExcel \u06a9\u06d2 CORREL \u0641\u0646\u06a9\u0634\u0646 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u0648\u0626\u06d2 \u067e\u0648\u0634\u06cc\u062f\u06c1 \u0688\u06cc\u0679\u0627 \u06a9\u06d2 \u0631\u062c\u062d\u0627\u0646\u0627\u062a \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631\u06cc\u06ba\u06d4<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">\u06c1\u0631 \u062a\u062c\u0632\u06cc\u06c1 \u06a9\u0627\u0631 \u06a9\u06d2 \u0644\u06cc\u06d2 \u0636\u0631\u0648\u0631\u06cc \u0679\u0648\u0644\u06d4<\/p>\n<\/p><\/div>\n<\/aside>\n<p><!-- No AdsNinja v10 Client! --><\/p>\n<h2 id=\"forecast-revenue-with-excel-rsquo-s-trend-function\">\n<p>                        Excel \u06a9\u06d2 TREND \u0641\u0646\u06a9\u0634\u0646 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u0648\u0626\u06d2 \u0622\u0645\u062f\u0646\u06cc \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u06a9\u0631\u06cc\u06ba\u06d4<br \/>\n               <\/h2>\n<h3 id=\"one-formula-is-all-it-takes-to-project-months-of-future-sales\">\n<p>            \u0622\u067e \u06a9\u0648 \u0635\u0631\u0641 \u0627\u06cc\u06a9 \u0641\u0627\u0631\u0645\u0648\u0644\u06d2 \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u06c1\u06d2 \u062a\u0627\u06a9\u06c1 \u0645\u0633\u062a\u0642\u0628\u0644 \u06a9\u06cc \u0641\u0631\u0648\u062e\u062a \u06a9\u06cc \u06a9\u0626\u06cc \u0645\u06c1\u06cc\u0646\u06d2 \u067e\u06c1\u0644\u06d2 \u067e\u06cc\u0634 \u06af\u0648\u0626\u06cc \u06a9\u06cc \u062c\u0627 \u0633\u06a9\u06d2\u06d4<br \/>\n    <\/h3>\n<div class=\"body-img landscape\">\n<div class=\"responsive-img  image-expandable  img-article-item\" style=\"padding-bottom:53.035509736541%\" data-img-url=\"https:\/\/static0.makeuseofimages.com\/wordpress\/wp-content\/uploads\/wm\/2026\/10\/the-trend-function-in-excel.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"\"\"\">\n<figure><picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img width=\"825\" height=\"438\" loading=\"lazy\" decoding=\"async\" alt=\"\u0627\u06cc\u06a9\u0633\u0644 \u06a9\u0627 TREND \u0641\u0646\u06a9\u0634\u0646\u06d4\" data-img-url=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/10\/1792790324_742_\u06c1\u0645-\u0646\u06d2-\u0645\u0648\u062c\u0648\u062f\u06c1-\u0641\u0631\u0648\u062e\u062a-\u0633\u06d2-\u06a9\u0626\u06cc-\u0645\u06c1\u06cc\u0646\u0648\u06ba-\u06a9\u06cc-\u0622\u0645\u062f\u0646\u06cc-\u06a9\u06cc.png\" src=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/10\/1792790324_742_\u06c1\u0645-\u0646\u06d2-\u0645\u0648\u062c\u0648\u062f\u06c1-\u0641\u0631\u0648\u062e\u062a-\u0633\u06d2-\u06a9\u0626\u06cc-\u0645\u06c1\u06cc\u0646\u0648\u06ba-\u06a9\u06cc-\u0622\u0645\u062f\u0646\u06cc-\u06a9\u06cc.png\" class=\"img-brightness-opt-out\" title=\"\">\n        <\/picture><figcaption style=\"display: none;\">\u0627\u0688\u0627 \u0633\u06d2 \u0627\u06cc\u06a9 \u0627\u0633\u06a9\u0631\u06cc\u0646 \u0634\u0627\u0679<\/figcaption><\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p>    Excel \u0645\u06cc\u06ba TREND \u0641\u0646\u06a9\u0634\u0646 \u0644\u06a9\u06cc\u0631\u06cc \u0631\u06cc\u06af\u0631\u06cc\u0634\u0646 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u0627 \u06c1\u06d2 \u062a\u0627\u06a9\u06c1 \u0622\u067e \u062c\u0633 \u0646\u062a\u06cc\u062c\u06c1 \u06cc\u0627 \u0645\u06cc\u0679\u0631\u06a9 \u06a9\u06cc \u0622\u067e \u067e\u06cc\u0634 \u06af\u0648\u0626\u06cc \u06a9\u0631\u0646\u0627 \u0686\u0627\u06c1\u062a\u06d2 \u06c1\u06cc\u06ba \u0627\u0648\u0631 \u0627\u0633 \u067e\u0631 \u0627\u062b\u0631 \u0627\u0646\u062f\u0627\u0632 \u06c1\u0648\u0646\u06d2 \u0648\u0627\u0644\u06d2 \u0639\u0648\u0627\u0645\u0644 \u06a9\u06d2 \u062f\u0631\u0645\u06cc\u0627\u0646 \u062a\u0639\u0644\u0642 \u06a9\u06cc \u0646\u0634\u0627\u0646\u062f\u06c1\u06cc \u06a9\u0631\u06cc\u06ba\u06d4 \u0633\u06cc\u062f\u06be\u06d2 \u0627\u0644\u0641\u0627\u0638 \u0645\u06cc\u06ba\u060c \u06c1\u0645 \u0633\u06cc\u062f\u06be\u06cc \u0644\u06a9\u06cc\u0631 \u06a9\u0648 \u062a\u0644\u0627\u0634 \u06a9\u0631\u0646\u06d2 \u06a9\u06d2 \u0644\u06cc\u06d2 \u062f\u0631\u062c \u0630\u06cc\u0644 \u0645\u0633\u0627\u0648\u0627\u062a \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u06cc\u06ba \u062c\u0648 \u0645\u0648\u062c\u0648\u062f\u06c1 \u0688\u06cc\u0679\u0627 \u067e\u0631 \u0628\u06c1\u062a\u0631\u06cc\u0646 \u0641\u0679 \u0628\u06cc\u0679\u06be\u062a\u06cc \u06c1\u06d2\u06d4 <code>y = mx + b<\/code>. \u0627\u0633 \u0645\u0633\u0627\u0648\u0627\u062a \u0645\u06cc\u06ba\u060c <strong>\u06a9\u06cc\u0648\u06ba<\/strong> \u0645\u0646\u062d\u0635\u0631 \u0645\u062a\u063a\u06cc\u0631 \u06a9\u06cc \u0646\u0634\u0627\u0646\u062f\u06c1\u06cc \u06a9\u0631\u062a\u0627 \u06c1\u06d2 (\u0645\u062b\u0644\u0627\u064b \u0622\u0645\u062f\u0646\u06cc\u060c \u0642\u06cc\u0645\u062a\u060c \u0633\u06a9\u0648\u0631\u060c \u06cc\u0627 \u0644\u0627\u06af\u062a)\u06d4 <strong>\u0627\u06cc\u06a9\u0633<\/strong> m \u0622\u0632\u0627\u062f \u0645\u062a\u063a\u06cc\u0631 \u06a9\u06cc \u0646\u0645\u0627\u0626\u0646\u062f\u06af\u06cc \u06a9\u0631\u062a\u0627 \u06c1\u06d2 (\u0645\u062b\u0627\u0644 \u06a9\u06d2 \u0637\u0648\u0631 \u067e\u0631 \u0648\u0642\u062a\u060c \u0627\u0634\u062a\u06c1\u0627\u0631\u06cc \u0644\u0627\u06af\u062a\u060c \u0645\u0637\u0627\u0644\u0639\u06c1 \u06a9\u0627 \u0648\u0642\u062a\u060c \u0633\u0641\u0631 \u06a9\u0627 \u0641\u0627\u0635\u0644\u06c1) \u0627\u0648\u0631 m \u0688\u06be\u0644\u0648\u0627\u0646 \u06a9\u06cc \u0646\u0645\u0627\u0626\u0646\u062f\u06af\u06cc \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4 <strong>\u0628\u0627\u0631\u0634<\/strong> \u0645\u062f\u0627\u062e\u0644\u062a \u06a9\u06cc \u0646\u0634\u0627\u0646\u062f\u06c1\u06cc \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4<\/p>\n<p>\u0627\u06cc\u06a9\u0633\u0644 \u0645\u06cc\u06ba \u0627\u0633 \u062a\u0639\u0644\u0642 \u06a9\u0648 \u0642\u0627\u0626\u0645 \u06a9\u0631\u0646\u06d2 \u0633\u06d2 \u0622\u067e \u06a9\u0648 \u0627\u06cc\u06a9 \u0645\u0646\u062d\u0635\u0631 \u0645\u062a\u063a\u06cc\u0631 \u06a9\u06cc \u0646\u0626\u06cc \u0642\u062f\u0631\u0648\u06ba \u06a9\u0627 \u062a\u062e\u0645\u06cc\u0646\u06c1 \u0644\u06af\u0627\u0646\u06d2 \u06a9\u06cc \u0627\u062c\u0627\u0632\u062a \u0645\u0644\u062a\u06cc \u06c1\u06d2\u060c \u062c\u06cc\u0633\u06d2 \u0645\u0633\u062a\u0642\u0628\u0644 \u06a9\u06cc \u0622\u0645\u062f\u0646\u06cc\u060c \u0627\u06cc\u06a9 \u0622\u0632\u0627\u062f \u0645\u062a\u063a\u06cc\u0631 \u06a9\u06cc \u0646\u0626\u06cc \u0627\u0642\u062f\u0627\u0631 \u06a9\u06cc \u0628\u0646\u06cc\u0627\u062f \u067e\u0631\u060c \u062c\u06cc\u0633\u06d2 \u0645\u0633\u062a\u0642\u0628\u0644 \u06a9\u06d2 \u0645\u06c1\u06cc\u0646\u06d2\u06d4 \u0645\u062b\u0627\u0644 \u06a9\u06d2 \u0637\u0648\u0631 \u067e\u0631\u060c \u0641\u0631\u0636 \u06a9\u0631\u06cc\u06ba \u06a9\u06c1 \u0622\u067e \u06a9\u06d2 \u067e\u0627\u0633 \u0622\u067e \u06a9\u06cc \u0648\u0631\u06a9 \u0634\u06cc\u0679 \u0645\u06cc\u06ba \u0633\u06cc\u0644\u0632 \u06a9\u0627 24 \u0645\u0627\u06c1 \u06a9\u0627 \u0688\u06cc\u0679\u0627 \u06c1\u06d2\u060c \u0627\u0648\u0631 \u0622\u067e \u06a9\u06cc \u0679\u0627\u0626\u0645 \u0644\u0627\u0626\u0646 \u0627\u0633 \u0633\u06d2 \u0634\u0631\u0648\u0639 \u06c1\u0648\u062a\u06cc \u06c1\u06d2: <code>A2:A25<\/code> \u0645\u062a\u0639\u0644\u0642\u06c1 \u0622\u0645\u062f\u0646\u06cc \u06a9\u06d2 \u0627\u0639\u062f\u0627\u062f \u0648 \u0634\u0645\u0627\u0631 \u062f\u0631\u062c \u0630\u06cc\u0644 \u06c1\u06cc\u06ba: <code>B2:B25<\/code>. \u0627\u0628 \u0622\u067e \u0627\u06af\u0644\u06d2 \u0645\u06c1\u06cc\u0646\u06d2 \u0645\u06cc\u06ba \u062f\u0627\u062e\u0644 \u06c1\u0648 \u06a9\u0631 \u0627\u06af\u0644\u06d2 12 \u0645\u06c1\u06cc\u0646\u0648\u06ba \u06a9\u06d2 \u0644\u06cc\u06d2 \u0627\u067e\u0646\u06cc \u0622\u0645\u062f\u0646\u06cc \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u06a9\u0631\u0646\u0627 \u0686\u0627\u06c1\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4 <code>A26:A37<\/code>.<\/p>\n<p>\u0633\u06cc\u0644 B26 \u0645\u06cc\u06ba \u062f\u0631\u062c \u0630\u06cc\u0644 \u0641\u0627\u0631\u0645\u0648\u0644\u06c1 \u062f\u0631\u062c \u06a9\u0631\u06cc\u06ba:<\/p>\n<pre>=TREND(B2:B25,A2:A25,A26:A37)<\/pre>\n<p>\u0627\u06af\u0631 \u0622\u067e Microsoft 365 \u06cc\u0627 Excel 2021 \u06cc\u0627 \u0627\u0633 \u06a9\u06d2 \u0628\u0639\u062f \u06a9\u06d2 \u0644\u06cc\u06d2 Excel \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631 \u0631\u06c1\u06d2 \u06c1\u06cc\u06ba\u060c \u062c\u0628 \u0622\u067e Enter \u062f\u0628\u0627\u0626\u06cc\u06ba \u06af\u06d2\u060c \u062a\u0648 \u0641\u0627\u0631\u0645\u0648\u0644\u06c1 \u062e\u0648\u062f \u0628\u062e\u0648\u062f 12 \u067e\u06cc\u0634 \u06af\u0648\u0626\u06cc \u06a9\u0631\u062f\u06c1 \u0646\u0645\u0628\u0631\u0648\u06ba \u06a9\u0648 \u0646\u06cc\u0686\u06d2 \u06a9\u06d2 \u0633\u06cc\u0644\u0632 \u0645\u06cc\u06ba \u0688\u0627\u0644 \u062f\u06d2 \u06af\u0627 \u0627\u06af\u0631 \u0648\u06c1 \u0633\u06cc\u0644 \u062e\u0627\u0644\u06cc \u06c1\u0648\u06ba \u06af\u06d2\u06d4 \u0641\u0646\u06a9\u0634\u0646\u0632 \u06a9\u06d2 \u062f\u0644\u0627\u0626\u0644 \u0627\u06cc\u06a9 \u0633\u0627\u062f\u06c1 \u067e\u06cc\u0679\u0631\u0646 \u06a9\u06cc \u067e\u06cc\u0631\u0648\u06cc \u06a9\u0631\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<tbody>\n<tr>\n<th scope=\"row\">\n<p>\u0645\u0639\u0644\u0648\u0645_\u06cc \u06a9\u0627<\/p>\n<\/th>\n<td>\n<p>\u067e\u06c1\u0644\u06cc \u062f\u0644\u06cc\u0644 \u0645\u06cc\u06ba \u0645\u0648\u062c\u0648\u062f\u06c1 \u0622\u0645\u062f\u0646\u06cc \u06a9\u06d2 \u0627\u0639\u062f\u0627\u062f \u0648 \u0634\u0645\u0627\u0631 \u0634\u0627\u0645\u0644 \u06c1\u06cc\u06ba \u0627\u0648\u0631 \u0636\u0631\u0648\u0631\u06cc \u06c1\u06d2\u06d4<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">\n<p>\u0645\u0639\u0631\u0648\u0641_x \u06a9\u0627<\/p>\n<\/th>\n<td>\n<p>\u062f\u0648\u0633\u0631\u06cc \u062f\u0644\u06cc\u0644 \u0645\u06cc\u06ba \u0645\u062a\u0639\u0644\u0642\u06c1 \u0679\u0627\u0626\u0645 \u0644\u0627\u0626\u0646 \u0648\u06cc\u0644\u06cc\u0648 \u06c1\u06d2\u060c \u062c\u06cc\u0633\u06d2 \u0645\u06c1\u06cc\u0646\u06c1\u06d4 \u06cc\u06c1 \u0627\u0633\u062a\u062f\u0644\u0627\u0644 \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u06c1\u06d2\u060c \u0644\u06cc\u06a9\u0646 \u0627\u06af\u0631 \u0686\u06be\u0648\u0691 \u062f\u06cc\u0627 \u062c\u0627\u0626\u06d2 \u062a\u0648\u060c \u0627\u06cc\u06a9\u0633\u0644 \u0627\u06cc\u06a9 \u0635\u0641 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u0648\u0626\u06d2 \u0645\u0633\u0644\u0633\u0644 \u0627\u062f\u0648\u0627\u0631 \u06a9\u0648 \u0641\u0631\u0636 \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4 <code>{1, 2, 3, \u2026}<\/code>.<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">\n<p>\u0646\u06cc\u0627_x \u06a9\u0627<\/p>\n<\/th>\n<td>\n<p>\u062a\u06cc\u0633\u0631\u06cc \u062f\u0644\u06cc\u0644 \u0622\u0632\u0627\u062f \u0645\u062a\u063a\u06cc\u0631 \u0627\u0642\u062f\u0627\u0631 \u067e\u0631 \u0645\u0634\u062a\u0645\u0644 \u06c1\u06d2 \u062c\u0633 \u06a9\u06d2 \u0644\u06cc\u06d2 Excel \u0646\u0626\u06d2 \u0631\u06cc\u0648\u0646\u06cc\u0648 \u0646\u0645\u0628\u0631\u0648\u06ba \u06a9\u06cc \u067e\u06cc\u0634 \u06af\u0648\u0626\u06cc \u06a9\u0631\u06d2 \u06af\u0627\u06d4 \u0627\u0633 \u0645\u062b\u0627\u0644 \u0645\u06cc\u06ba\u060c \u0627\u06af\u0644\u0627 \u0645\u06c1\u06cc\u0646\u06c1 \u062f\u0631\u062c \u0630\u06cc\u0644 \u06c1\u06d2: <code>A26:A37<\/code>. \u06cc\u06c1 \u062f\u0644\u06cc\u0644 \u0628\u06be\u06cc \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u06c1\u06d2\u06d4 \u0627\u06af\u0631 \u0686\u06be\u0648\u0691 \u062f\u06cc\u0627 \u062c\u0627\u0626\u06d2 \u062a\u0648\u060c Excel \u0631\u062c\u062d\u0627\u0646 \u06a9\u0627 \u062d\u0633\u0627\u0628 \u0644\u06af\u0627\u0646\u06d2 \u06a9\u06d2 \u0644\u06cc\u06d2 Known_x \u0645\u06cc\u06ba \u0642\u062f\u0631 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4<\/p>\n<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\">\n<p>\u0645\u0633\u0644\u0633\u0644<\/p>\n<\/th>\n<td>\n<p>\u06cc\u06c1 \u0622\u062e\u0631\u06cc \u062f\u0644\u06cc\u0644 \u062f\u0631\u062c \u0630\u06cc\u0644 \u06c1\u06d2: <code>TRUE<\/code> \u06cc\u0627 <code>FALSE<\/code> \u0627\u0633 \u0628\u0627\u062a \u06a9\u0627 \u062a\u0639\u06cc\u0646 \u06a9\u0631\u062a\u0627 \u06c1\u06d2 \u06a9\u06c1 \u0622\u06cc\u0627 Excel \u0639\u0627\u0645 \u0637\u0648\u0631 \u067e\u0631 \u0627\u0646\u0679\u0631\u0633\u06cc\u067e\u0679 \u06a9\u0627 \u062d\u0633\u0627\u0628 \u0644\u06af\u0627\u062a\u0627 \u06c1\u06d2 \u06cc\u0627 \u0627\u0633\u06d2 \u0635\u0641\u0631 \u06c1\u0648\u0646\u06d2 \u067e\u0631 \u0645\u062c\u0628\u0648\u0631 \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4 \u0627\u06af\u0631 \u0622\u067e \u0686\u0627\u06c1\u062a\u06d2 \u06c1\u06cc\u06ba \u06a9\u06c1 Excel \u0645\u0648\u062c\u0648\u062f\u06c1 \u0688\u06cc\u0679\u0627 \u06a9\u06cc \u0628\u0646\u06cc\u0627\u062f \u067e\u0631 \u0627\u0646\u0679\u0631\u0633\u06cc\u067e\u0679 \u06a9\u0627 \u062d\u0633\u0627\u0628 \u0644\u06af\u0627\u0626\u06d2 \u062a\u0648 \u0622\u067e \u0627\u0633 \u062f\u0644\u06cc\u0644 \u06a9\u0648 \u0686\u06be\u0648\u0691 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<p>\u0627\u06af\u0631 \u0622\u067e Dynamic Array \u06a9\u06d2 \u0628\u063a\u06cc\u0631 Excel \u06a9\u0627 \u067e\u0631\u0627\u0646\u0627 \u0648\u0631\u0698\u0646 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631 \u0631\u06c1\u06d2 \u06c1\u06cc\u06ba\u060c \u062a\u0648 \u0622\u067e \u06a9\u0648 \u062a\u0645\u0627\u0645 12 \u0622\u0624\u0679 \u067e\u0679 \u0633\u06cc\u0644\u0632 \u06a9\u0648 \u0645\u0646\u062a\u062e\u0628 \u06a9\u0631\u0646\u06d2 \u0627\u0648\u0631 \u067e\u06be\u0631 \u0641\u0627\u0631\u0645\u0648\u0644\u06c1 \u062f\u0627\u062e\u0644 \u06a9\u0631\u0646\u06d2 \u0633\u06d2 \u067e\u06c1\u0644\u06d2 \u0627\u0646\u06c1\u06cc\u06ba \u0686\u06cc\u06a9 \u06a9\u0631\u0646\u06d2 \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u067e\u0691 \u0633\u06a9\u062a\u06cc \u06c1\u06d2\u06d4 <strong>Ctrl+Shift+Enter<\/strong>.<\/p>\n<p>    <!-- No AdsNinja v10 Client! --><\/p>\n<h2 id=\"common-trend-function-mistakes\">\n<p>                        TREND \u0641\u0646\u06a9\u0634\u0646 \u06a9\u06cc \u0639\u0627\u0645 \u063a\u0644\u0637\u06cc\u0627\u06ba<br \/>\n               <\/h2>\n<h3 id=\"if-your-forecast-looks-off-one-of-these-issues-could-be-to-blame\">\n<p>            \u0627\u06af\u0631 \u0622\u067e \u06a9\u06cc \u067e\u06cc\u0634\u06cc\u0646 \u06af\u0648\u0626\u06cc\u0627\u06ba \u0628\u0646\u062f \u06c1\u06cc\u06ba\u060c \u062a\u0648 \u06cc\u06c1 \u062f\u0631\u062c \u0630\u06cc\u0644 \u0645\u0633\u0627\u0626\u0644 \u0645\u06cc\u06ba \u0633\u06d2 \u06a9\u0633\u06cc \u0627\u06cc\u06a9 \u06a9\u06cc \u0648\u062c\u06c1 \u0633\u06d2 \u06c1\u0648 \u0633\u06a9\u062a\u0627 \u06c1\u06d2:<br \/>\n    <\/h3>\n<div class=\"body-img landscape\">\n<div class=\"responsive-img  image-expandable  img-article-item\" style=\"padding-bottom:41.098901098901%\" data-img-url=\"https:\/\/static0.makeuseofimages.com\/wordpress\/wp-content\/uploads\/wm\/2026\/10\/a-line-chart-with-a-trendline-in-microsoft-excel.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"\"\"\">\n<figure><picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img width=\"825\" height=\"339\" loading=\"lazy\" decoding=\"async\" alt=\"\u0645\u0627\u0626\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u0679 \u0627\u06cc\u06a9\u0633\u0644 \u0645\u06cc\u06ba \u0679\u0631\u06cc\u0646\u0688 \u0644\u0627\u0626\u0646 \u06a9\u06d2 \u0633\u0627\u062a\u06be \u0644\u0627\u0626\u0646 \u0686\u0627\u0631\u0679\u06d4\" data-img-url=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/10\/1792790325_784_\u06c1\u0645-\u0646\u06d2-\u0645\u0648\u062c\u0648\u062f\u06c1-\u0641\u0631\u0648\u062e\u062a-\u0633\u06d2-\u06a9\u0626\u06cc-\u0645\u06c1\u06cc\u0646\u0648\u06ba-\u06a9\u06cc-\u0622\u0645\u062f\u0646\u06cc-\u06a9\u06cc.png\" src=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/10\/1792790325_784_\u06c1\u0645-\u0646\u06d2-\u0645\u0648\u062c\u0648\u062f\u06c1-\u0641\u0631\u0648\u062e\u062a-\u0633\u06d2-\u06a9\u0626\u06cc-\u0645\u06c1\u06cc\u0646\u0648\u06ba-\u06a9\u06cc-\u0622\u0645\u062f\u0646\u06cc-\u06a9\u06cc.png\" class=\"img-brightness-opt-out\" title=\"\">\n        <\/picture><figcaption style=\"display: none;\">\u0627\u0688\u0627 \u0633\u06d2 \u0627\u06cc\u06a9 \u0627\u0633\u06a9\u0631\u06cc\u0646 \u0634\u0627\u0679<\/figcaption><\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p>    TREND \u0641\u06cc\u0686\u0631 \u06a9\u0648 \u06a9\u0627\u0645 \u06a9\u0631\u0646\u0627 \u0628\u06c1\u062a \u0622\u0633\u0627\u0646 \u06c1\u06d2\u06d4 \u062a\u0627\u06c1\u0645\u060c \u0686\u0646\u062f \u0622\u0633\u0627\u0646 \u063a\u0644\u0637\u06cc\u0648\u06ba \u06a9\u06d2 \u0646\u062a\u06cc\u062c\u06d2 \u0645\u06cc\u06ba \u062e\u0631\u0627\u0628 \u0646\u062a\u0627\u0626\u062c \u0628\u0631\u0622\u0645\u062f \u06c1\u0648 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<p>TREND \u0622\u067e \u06a9\u0627 \u06c1\u06d2\u06d4 <strong>\u0645\u0639\u0644\u0648\u0645_\u06cc<\/strong>\u067e\u06c1\u0644\u06d2 (\u0645\u0627\u0636\u06cc \u06a9\u0627 \u0645\u0646\u0627\u0641\u0639) \u062f\u0631\u062c \u06a9\u0631\u06cc\u06ba \u0627\u0648\u0631 <strong>\u0645\u0639\u0631\u0648\u0641_x<\/strong>(\u0679\u0627\u0626\u0645 \u0644\u0627\u0626\u0646) \u0633\u06cc\u06a9\u0646\u0688\u0632\u06d4 \u0627\u06af\u0631 \u0622\u067e \u0627\u0633\u06d2 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u06cc\u06ba\u060c \u062a\u0648 Excel \u0679\u0627\u0626\u0645 \u0644\u0627\u0626\u0646 \u06a9\u0648 \u0645\u0646\u062d\u0635\u0631 \u0645\u062a\u063a\u06cc\u0631 \u0627\u0648\u0631 \u0622\u0645\u062f\u0646\u06cc \u06a9\u0648 \u0622\u0632\u0627\u062f \u0645\u062a\u063a\u06cc\u0631 \u06a9\u06d2 \u0637\u0648\u0631 \u067e\u0631 \u0645\u0627\u0646\u06d2 \u06af\u0627\u06d4 \u06cc\u06c1 \u0627\u06cc\u06a9 \u0628\u0631\u0627 \u0631\u0634\u062a\u06c1 \u06c1\u06d2 \u0627\u0648\u0631 \u0635\u0631\u0641 \u063a\u06cc\u0631 \u062d\u0642\u06cc\u0642\u06cc \u0646\u062a\u0627\u0626\u062c \u06a9\u0627 \u0628\u0627\u0639\u062b \u0628\u0646 \u0633\u06a9\u062a\u0627 \u06c1\u06d2\u06d4 \u0627\u06af\u0631 \u0622\u067e FORECAST.LINEAR \u0633\u06d2 \u0648\u0627\u0642\u0641 \u06c1\u06cc\u06ba \u062a\u0648 \u06cc\u06c1 \u06a9\u0631\u0646\u0627 \u0627\u06cc\u06a9 \u0622\u0633\u0627\u0646 \u063a\u0644\u0637\u06cc \u06c1\u06d2\u060c \u062c\u0648 \u0627\u06cc\u06a9 \u0645\u062e\u062a\u0644\u0641 \u0622\u0631\u06af\u0648\u0645\u0646\u0679 \u0622\u0631\u0688\u0631 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4<\/p>\n<p>\u0627\u06cc\u06a9 \u0627\u0648\u0631 \u0639\u0627\u0645 \u0645\u0633\u0626\u0644\u06c1 \u0646\u0627\u0645\u06a9\u0645\u0644 \u06cc\u0627 \u0645\u062a\u0636\u0627\u062f \u0688\u06cc\u0679\u0627 \u06a9\u06d2 \u0633\u0627\u062a\u06be \u06a9\u0627\u0645 \u06a9\u0631\u0646\u0627 \u06c1\u06d2\u06d4 \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u0633\u06d2 \u067e\u06c1\u0644\u06d2 \u0648\u0642\u0641\u0648\u06ba\u060c \u063a\u0644\u0637\u06cc\u0648\u06ba\u060c \u0627\u0648\u0631 \u06af\u0645\u0634\u062f\u06c1 \u0627\u062f\u0648\u0627\u0631 \u06a9\u06d2 \u0644\u06cc\u06d2 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u0627\u067e\u0633\u06cc \u06a9\u06cc \u062d\u062f\u0648\u062f \u06a9\u06cc \u062c\u0627\u0646\u0686 \u06a9\u0631\u06cc\u06ba\u06d4 TREND \u062e\u0648\u062f \u0628\u062e\u0648\u062f \u06af\u0645\u0634\u062f\u06c1 \u0645\u0634\u0627\u06c1\u062f\u0627\u062a \u06a9\u0648 \u0646\u06c1\u06cc\u06ba \u0686\u06be\u0648\u0691\u062a\u0627\u060c \u0644\u06c1\u0630\u0627 \u0622\u067e \u06a9\u0648 \u0627\u0633 \u062e\u0635\u0648\u0635\u06cc\u062a \u06a9\u0648 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u0646\u06d2 \u0633\u06d2 \u067e\u06c1\u0644\u06d2 \u0627\u067e\u0646\u06d2 \u06af\u0646\u062f\u06d2 Excel \u0688\u06cc\u0679\u0627 \u06a9\u0648 \u0635\u0627\u0641 \u06a9\u0631\u0646\u06d2 \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u067e\u0691 \u0633\u06a9\u062a\u06cc \u06c1\u06d2\u06d4 \u0628\u0635\u0648\u0631\u062a \u062f\u06cc\u06af\u0631\u060c \u0622\u067e \u06a9\u06d2 \u0641\u0627\u0631\u0645\u0648\u0644\u06d2 \u0639\u0627\u0645 \u0627\u06cc\u06a9\u0633\u0644 \u06a9\u06cc \u063a\u0644\u0637\u06cc\u0627\u06ba \u0648\u0627\u067e\u0633 \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba \u06cc\u0627 \u0688\u06cc\u0679\u0627 \u06a9\u06cc \u0628\u0646\u06cc\u0627\u062f \u067e\u0631 \u067e\u06cc\u0634\u06cc\u0646 \u06af\u0648\u0626\u06cc\u0627\u06ba \u062a\u062e\u0644\u06cc\u0642 \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba \u062c\u0648 \u0622\u067e \u06a9\u06cc \u0641\u0631\u0648\u062e\u062a \u06a9\u06cc \u062a\u0627\u0631\u06cc\u062e \u06a9\u06cc \u062f\u0631\u0633\u062a \u0646\u0645\u0627\u0626\u0646\u062f\u06af\u06cc \u0646\u06c1\u06cc\u06ba \u06a9\u0631\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<p>\u0622\u067e \u06a9\u0648 \u06cc\u06c1 \u0628\u06be\u06cc \u06cc\u0642\u06cc\u0646\u06cc \u0628\u0646\u0627\u0646\u0627 \u06c1\u0648\u06af\u0627 \u06a9\u06c1 \u0622\u067e \u06a9\u06cc \u0679\u0627\u0626\u0645 \u0644\u0627\u0626\u0646 \u0645\u06c1\u06cc\u0646\u0648\u06ba \u06a9\u06cc \u0627\u0635\u0644 \u062a\u0639\u062f\u0627\u062f \u06a9\u06cc \u0639\u06a9\u0627\u0633\u06cc \u06a9\u0631\u062a\u06cc \u06c1\u06d2\u06d4 \u0645\u062b\u0627\u0644 \u06a9\u06d2 \u0637\u0648\u0631 \u067e\u0631\u060c \u0627\u06af\u0631 \u0622\u067e \u06a9\u06cc \u0641\u0631\u0648\u062e\u062a \u06a9\u06d2 \u0627\u0639\u062f\u0627\u062f \u0648 \u0634\u0645\u0627\u0631 \u062c\u0646\u0648\u0631\u06cc\u060c \u0641\u0631\u0648\u0631\u06cc\u060c \u0645\u0627\u0631\u0686 \u0627\u0648\u0631 \u0645\u0626\u06cc \u06a9\u06d2 \u06c1\u06cc\u06ba\u060c \u0627\u0648\u0631 \u0622\u067e \u0627\u0646 \u0645\u0634\u0627\u06c1\u062f\u0627\u062a \u06a9\u0648 \u0644\u06af\u0627\u062a\u0627\u0631 \u0686\u0627\u0631 \u0645\u06c1\u06cc\u0646\u0648\u06ba \u06a9\u06d2 \u0637\u0648\u0631 \u067e\u0631 \u062f\u06cc\u06a9\u06be\u062a\u06d2 \u06c1\u06cc\u06ba\u060c \u062a\u0648 \u0627\u067e\u0631\u06cc\u0644 \u06a9\u06d2 \u06af\u0645\u0634\u062f\u06c1 \u0627\u0639\u062f\u0627\u062f \u0648 \u0634\u0645\u0627\u0631 \u06a9\u0648 \u0646\u0638\u0631 \u0627\u0646\u062f\u0627\u0632 \u06a9\u0631 \u062f\u06cc\u0627 \u062c\u0627\u0626\u06d2 \u06af\u0627 \u0627\u0648\u0631 \u0622\u067e \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u0645\u062a\u0632\u0644\u0632\u0644 \u06c1\u0648 \u062c\u0627\u0626\u06d2 \u06af\u06cc (\u0627\u06af\u0631 \u0622\u067e \u0627\u067e\u0631\u06cc\u0644 \u0645\u06cc\u06ba \u0641\u0631\u0648\u062e\u062a \u0646\u06c1\u06cc\u06ba \u06a9\u0631\u062a\u06d2 \u06c1\u06cc\u06ba)\u06d4 \u0627\u0633 \u0628\u0627\u062a \u06a9\u0648 \u06cc\u0642\u06cc\u0646\u06cc \u0628\u0646\u0627\u0646\u06d2 \u06a9\u06d2 \u0644\u06cc\u06d2 \u06a9\u06c1 \u0622\u067e \u06a9\u0627 \u0641\u0646\u06a9\u0634\u0646 \u0645\u0634\u0627\u06c1\u062f\u0627\u062a \u06a9\u06d2 \u062f\u0631\u0645\u06cc\u0627\u0646 \u0635\u062d\u06cc\u062d \u0648\u0642\u0641\u06c1 \u06a9\u0648 \u0628\u06cc\u0627\u0646 \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u060c \u0627\u0635\u0644 \u0627\u06cc\u06a9\u0633\u0644 \u06a9\u06cc \u062a\u0627\u0631\u06cc\u062e\u06cc\u06ba \u06cc\u0627 \u0645\u0633\u0644\u0633\u0644 \u067e\u06cc\u0631\u06cc\u0688 \u0646\u0645\u0628\u0631 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u06cc\u06ba\u06d4<\/p>\n<p>\u062f\u0627\u0626\u0631\u06c1 \u06a9\u0627\u0631 \u06a9\u0648 \u0645\u0633\u0644\u0633\u0644 \u062c\u0627\u0631\u06cc \u0631\u06a9\u06be\u0646\u0627 \u0628\u06be\u06cc \u0636\u0631\u0648\u0631\u06cc \u06c1\u06d2\u06d4 \u0627\u0646\u0641\u0631\u0627\u062f\u06cc \u062e\u0644\u06cc\u0627\u062a \u06a9\u0648 \u0645\u0646\u062a\u062e\u0628 \u06a9\u0631\u06cc\u06ba \u062c\u06cc\u0633\u06d2 <code>B2<\/code>, <code>B4<\/code>\u0627\u0648\u0631 <code>B12<\/code>\u0627\u0633 \u0637\u0631\u062d \u06a9\u06cc \u0645\u0633\u0644\u0633\u0644 \u0631\u06cc\u0646\u062c \u06a9\u06d2 \u0628\u062c\u0627\u0626\u06d2: <code>B2:B12<\/code>\u0627\u06af\u0631 \u0622\u067e \u0627\u0633 \u0633\u06cc\u0644 \u06a9\u0648 \u0627\u06cc\u06a9 \u062f\u0644\u06cc\u0644 \u06a9\u06d2 \u0637\u0648\u0631 \u067e\u0631 \u067e\u0627\u0633 \u06a9\u0631\u0646\u0627 \u0686\u0627\u06c1\u062a\u06d2 \u06c1\u06cc\u06ba \u062a\u0648 \u0622\u067e \u06a9\u0648 \u067e\u0631\u06cc\u0634\u0627\u0646\u06cc \u06a9\u0627 \u0633\u0627\u0645\u0646\u0627 \u06a9\u0631\u0646\u0627 \u067e\u0691 \u0633\u06a9\u062a\u0627 \u06c1\u06d2\u06d4 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0622\u0645\u062f\u0646\u06cc\u060c \u0679\u0627\u0626\u0645 \u0644\u0627\u0626\u0646\u0632\u060c \u0627\u0648\u0631 \u0645\u0633\u062a\u0642\u0628\u0644 \u06a9\u06d2 \u0627\u062f\u0648\u0627\u0631 \u06a9\u06d2 \u0644\u06cc\u06d2 \u0645\u0646\u0627\u0633\u0628 \u062d\u062f\u0648\u062f \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u06cc\u06ba \u062a\u0627\u06a9\u06c1 \u0627\u06cc\u06a9\u0633\u0644 \u06c1\u0631 \u062f\u0644\u06cc\u0644 \u06a9\u06cc \u0635\u062d\u06cc\u062d \u062a\u0634\u0631\u06cc\u062d \u06a9\u0631 \u0633\u06a9\u06d2 \u0627\u0648\u0631 \u0645\u062a\u0648\u0642\u0639 \u067e\u06cc\u0634\u06cc\u0646 \u06af\u0648\u0626\u06cc\u0627\u06ba \u0648\u0627\u067e\u0633 \u06a9\u0631 \u0633\u06a9\u06d2\u06d4<\/p>\n<p>\u0622\u062e\u0631 \u0645\u06cc\u06ba\u060c \u06cc\u06c1 \u0646\u06c1 \u0633\u0645\u062c\u06be\u06cc\u06ba \u06a9\u06c1 \u0627\u06cc\u06a9\u0633\u0644 \u0627\u067e\u0646\u06cc \u067e\u06cc\u0634\u06cc\u0646 \u06af\u0648\u0626\u06cc\u0648\u06ba \u067e\u0631 \u0635\u0631\u0641 \u0627\u0633 \u0644\u06cc\u06d2 \u0628\u06be\u0631\u0648\u0633\u06c1 \u06a9\u0631 \u0633\u06a9\u062a\u0627 \u06c1\u06d2 \u06a9\u06c1 \u06cc\u06c1 \u0646\u0645\u0628\u0631 \u0644\u0648\u0679\u0627\u062a\u0627 \u06c1\u06d2\u06d4 \u0627\u06cc\u06a9 \u0686\u0627\u0631\u0679 \u067e\u0631 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0641\u0631\u0648\u062e\u062a \u0627\u0648\u0631 \u0645\u062a\u0648\u0642\u0639 \u0646\u0645\u0628\u0631\u0648\u06ba \u06a9\u0648 \u067e\u0644\u0627\u0679 \u06a9\u0631\u06cc\u06ba\u060c \u067e\u06be\u0631 \u0646\u062a\u0627\u0626\u062c \u06a9\u0627 \u0645\u0648\u0627\u0632\u0646\u06c1 \u0627\u06cc\u06a9 \u0644\u06a9\u06cc\u0631\u06cc \u0679\u0631\u06cc\u0646\u0688 \u0644\u0627\u0626\u0646 \u0633\u06d2 \u06a9\u0631\u06cc\u06ba\u06d4 \u0627\u06af\u0631 \u0686\u0627\u0631\u0679 \u0645\u06cc\u06ba \u062f\u06a9\u06be\u0627\u0626\u06cc \u06af\u0626\u06cc \u0645\u0633\u0627\u0648\u0627\u062a \u06a9\u06cc \u0642\u062f\u0631\u06cc\u06ba \u0642\u062f\u0631\u06d2 \u0645\u062e\u062a\u0644\u0641 \u06c1\u06cc\u06ba \u062a\u0648 \u0627\u0639\u0634\u0627\u0631\u06cc\u06c1 \u06a9\u06cc \u062f\u0631\u0633\u062a\u06af\u06cc \u06a9\u0648 \u0686\u06cc\u06a9 \u06a9\u0631\u06cc\u06ba\u06d4 \u062c\u0628\u06a9\u06c1 Excel \u0688\u06cc\u0641\u0627\u0644\u0679 \u062f\u0631\u0633\u062a\u06af\u06cc \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u0648\u0626\u06d2 TREND \u06a9\u0627 \u062d\u0633\u0627\u0628 \u0644\u06af\u0627\u062a\u0627 \u06c1\u06d2\u060c \u0686\u0627\u0631\u0679 \u0679\u0631\u06cc\u0646\u0688 \u0644\u0627\u0626\u0646 \u06a9\u06cc \u0645\u0633\u0627\u0648\u0627\u062a \u0686\u0627\u0631\u0679 \u067e\u0631 \u062f\u06a9\u06be\u0627\u0626\u06d2 \u06af\u0626\u06d2 \u0688\u06be\u0644\u0648\u0627\u0646 \u0627\u0648\u0631 \u0627\u0646\u0679\u0631\u0633\u06cc\u067e\u0679 \u06a9\u0648 \u06af\u0648\u0644 \u06a9\u0631 \u0633\u06a9\u062a\u06cc \u06c1\u06d2\u06d4 \u0627\u06af\u0631 \u0622\u067e \u0627\u0646 \u06af\u0648\u0644 \u0627\u0642\u062f\u0627\u0631 \u06a9\u0648 \u0627\u0644\u06af \u0627\u0644\u06af \u062d\u0633\u0627\u0628 \u0645\u06cc\u06ba \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u062a\u06d2 \u06c1\u06cc\u06ba\u060c \u062a\u0648 \u0622\u067e \u06a9\u0648 \u0642\u062f\u0631\u06d2 \u0645\u062e\u062a\u0644\u0641 \u0646\u062a\u0627\u0626\u062c \u0645\u0644 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<p>    <!-- No AdsNinja v10 Client! --><\/p>\n<h2 id=\"when-to-use-excel-rsquo-s-trend-function\">\n<p>                        Excel \u06a9\u0627 TREND \u0641\u0646\u06a9\u0634\u0646 \u06a9\u0628 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u06a9\u0631\u0646\u0627 \u06c1\u06d2\u06d4<br \/>\n               <\/h2>\n<h3 id=\"your-revenue-might-need-more-than-a-straight-line-forecast\">\n<p>            \u0622\u067e \u06a9\u06cc \u0648\u0627\u067e\u0633\u06cc \u06a9\u06d2 \u0644\u06cc\u06d2 \u0633\u06cc\u062f\u06be\u06d2 \u0622\u06af\u06d2 \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u0633\u06d2 \u0632\u06cc\u0627\u062f\u06c1 \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u06c1\u0648 \u0633\u06a9\u062a\u06cc \u06c1\u06d2\u06d4<br \/>\n    <\/h3>\n<div class=\"body-img landscape\">\n<div class=\"responsive-img  image-expandable  img-article-item\" style=\"padding-bottom:43.258971871969%\" data-img-url=\"https:\/\/static0.makeuseofimages.com\/wordpress\/wp-content\/uploads\/wm\/2026\/10\/a-line-chart-with-a-trendline-placed-beside-highlighted-data-in-microsoft-excel.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"\"\"\">\n<figure><picture><source media=\"(max-width: 480px)\" data- \/><source media=\"(max-width: 767px)\" data- \/><source media=\"(max-width: 1023px)\" data- \/><img width=\"825\" height=\"357\" loading=\"lazy\" decoding=\"async\" alt=\"\u0645\u0627\u0626\u06cc\u06a9\u0631\u0648\u0633\u0627\u0641\u0679 \u0627\u06cc\u06a9\u0633\u0644 \u0645\u06cc\u06ba \u0646\u0645\u0627\u06cc\u0627\u06ba \u06a9\u0631\u062f\u06c1 \u0688\u06cc\u0679\u0627 \u06a9\u06d2 \u0622\u06af\u06d2 \u0679\u0631\u06cc\u0646\u0688 \u0644\u0627\u0626\u0646 \u06a9\u06d2 \u0633\u0627\u062a\u06be \u0644\u0627\u0626\u0646 \u0686\u0627\u0631\u0679\u06d4\" data-img-url=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/10\/1792790325_952_\u06c1\u0645-\u0646\u06d2-\u0645\u0648\u062c\u0648\u062f\u06c1-\u0641\u0631\u0648\u062e\u062a-\u0633\u06d2-\u06a9\u0626\u06cc-\u0645\u06c1\u06cc\u0646\u0648\u06ba-\u06a9\u06cc-\u0622\u0645\u062f\u0646\u06cc-\u06a9\u06cc.png\" src=\"https:\/\/umang.pk\/wp-content\/uploads\/2026\/10\/1792790325_952_\u06c1\u0645-\u0646\u06d2-\u0645\u0648\u062c\u0648\u062f\u06c1-\u0641\u0631\u0648\u062e\u062a-\u0633\u06d2-\u06a9\u0626\u06cc-\u0645\u06c1\u06cc\u0646\u0648\u06ba-\u06a9\u06cc-\u0622\u0645\u062f\u0646\u06cc-\u06a9\u06cc.png\" class=\"img-brightness-opt-out\" title=\"\">\n        <\/picture><figcaption style=\"display: none;\">\u0627\u0688\u0627 \u0633\u06d2 \u0627\u06cc\u06a9 \u0627\u0633\u06a9\u0631\u06cc\u0646 \u0634\u0627\u0679<\/figcaption><\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p>    TREND \u0627\u0633 \u0648\u0642\u062a \u0628\u06c1\u062a\u0631\u06cc\u0646 \u06a9\u0627\u0645 \u06a9\u0631\u062a\u0627 \u06c1\u06d2 \u062c\u0628 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0648\u0627\u067e\u0633\u06cc \u0645\u0646\u0627\u0633\u0628 \u0637\u0648\u0631 \u067e\u0631 \u0627\u0648\u067e\u0631 \u06a9\u06cc \u0637\u0631\u0641 \u06cc\u0627 \u0646\u06cc\u0686\u06d2 \u06a9\u06cc \u0633\u0645\u062a \u06a9\u06cc \u067e\u06cc\u0631\u0648\u06cc \u06a9\u0631\u062a\u06cc \u06c1\u06d2\u06d4 \u0627\u06af\u0631 \u062a\u06c1\u0648\u0627\u0631\u0648\u06ba \u06a9\u06d2 \u0645\u0648\u0633\u0645 \u0645\u06cc\u06ba \u0622\u067e \u06a9\u06cc \u0622\u0645\u062f\u0646\u06cc \u0645\u06cc\u06ba \u0627\u0636\u0627\u0641\u06c1 \u06c1\u0648\u062a\u0627 \u06c1\u06d2\u060c \u0622\u0641 \u0633\u06cc\u0632\u0646 \u06a9\u06d2 \u062f\u0648\u0631\u0627\u0646 \u06a9\u0645\u06cc \u0622\u062a\u06cc \u06c1\u06d2\u060c \u06cc\u0627 \u0645\u0627\u06c1 \u0628\u06c1 \u0645\u06c1\u06cc\u0646\u06c1 \u0627\u062a\u0627\u0631 \u0686\u0691\u06be\u0627\u0624 \u0622\u062a\u0627 \u06c1\u06d2\u060c \u062a\u0648 \u06c1\u0648 \u0633\u06a9\u062a\u0627 \u06c1\u06d2 \u06a9\u06c1 \u0627\u06cc\u06a9 \u0633\u06cc\u062f\u06be\u06cc \u0644\u06a9\u06cc\u0631 \u0627\u0646 \u0646\u0645\u0648\u0646\u0648\u06ba \u06a9\u0648 \u062f\u0631\u0633\u062a \u0637\u0631\u06cc\u0642\u06d2 \u0633\u06d2 \u062d\u0627\u0635\u0644 \u0646\u06c1 \u06a9\u0631\u06d2\u06d4 \u0627\u0646 \u062d\u0627\u0644\u0627\u062a \u0645\u06cc\u06ba\u060c \u0622\u067e \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u0622\u067e \u06a9\u06d2 \u06a9\u0627\u0631\u0648\u0628\u0627\u0631 \u06a9\u06d2 \u0639\u0627\u0645 \u0633\u06cc\u0644\u0632 \u0633\u0627\u0626\u06cc\u06a9\u0644 \u0645\u06cc\u06ba \u0627\u06c1\u0645 \u062a\u0628\u062f\u06cc\u0644\u06cc\u0648\u06ba \u0633\u06d2 \u0645\u062d\u0631\u0648\u0645 \u06c1\u0648 \u0633\u06a9\u062a\u06cc \u06c1\u06d2\u06d4<\/p>\n<p>\u0627\u06af\u0631 \u0622\u067e \u06a9\u06cc \u0622\u0645\u062f\u0646\u06cc \u0645\u06cc\u06ba \u0627\u0636\u0627\u0641\u06c1 \u0648\u0642\u062a \u06a9\u06d2 \u0633\u0627\u062a\u06be \u0633\u0627\u062a\u06be \u062a\u06cc\u0632 \u06cc\u0627 \u0633\u0633\u062a \u06c1\u0648 \u0631\u06c1\u0627 \u06c1\u06d2\u060c \u062a\u0648 \u0622\u067e Known_x \u06a9\u06d2 \u0644\u06cc\u06d2 \u0645\u062a\u0639\u062f\u062f \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u06a9\u0631\u0646\u06d2 \u0648\u0627\u0644\u06d2 \u06a9\u0627\u0644\u0645 \u0641\u0631\u0627\u06c1\u0645 \u06a9\u0631 \u06a9\u06d2 \u06a9\u062b\u06cc\u0631 \u0627\u0644\u062c\u06c1\u062a\u06cc \u0631\u062c\u0639\u062a \u06a9\u0648 \u062f\u0631\u06cc\u0627\u0641\u062a \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u060c \u062c\u06cc\u0633\u06d2 \u06a9\u06c1 \u0648\u0642\u062a \u0627\u0648\u0631 \u0637\u0627\u0642\u062a\u06d4 <code>{(x), (x^2), and (x^3)}<\/code>. \u06cc\u06c1 \u0646\u0642\u0637\u06c1 \u0646\u0638\u0631 \u0622\u067e \u06a9\u0648 \u0633\u06cc\u062f\u06be\u06d2 \u062e\u0637\u0648\u0637 \u067e\u0631 \u0627\u0646\u062d\u0635\u0627\u0631 \u06a9\u06cc\u06d2 \u0628\u063a\u06cc\u0631 \u06af\u06be\u0645\u0627\u0624 \u0648\u0627\u0644\u06d2 \u062a\u0639\u0644\u0642\u0627\u062a \u06a9\u0648 \u0645\u0627\u0688\u0644 \u06a9\u0631\u0646\u06d2 \u06a9\u06cc \u0627\u062c\u0627\u0632\u062a \u062f\u06cc\u062a\u0627 \u06c1\u06d2\u06d4 \u0645\u0648\u0633\u0645\u06cc \u0646\u0645\u0648\u0646\u0648\u06ba \u06a9\u06d2 \u0644\u06cc\u06d2\u060c Excel \u06a9\u06cc Forecast Sheet\u060c Excel \u06a9\u06cc \u06a9\u0645 \u0645\u0639\u0631\u0648\u0641 AI \u062e\u0635\u0648\u0635\u06cc\u0627\u062a \u0645\u06cc\u06ba \u0633\u06d2 \u0627\u06cc\u06a9\u060c \u06cc\u0627 \u062f\u06cc\u06af\u0631 \u0679\u0627\u0626\u0645 \u0633\u06cc\u0631\u06cc\u0632 \u06a9\u06cc \u067e\u06cc\u0634\u0646 \u06af\u0648\u0626\u06cc \u06a9\u06d2 \u0637\u0631\u06cc\u0642\u06d2 \u0632\u06cc\u0627\u062f\u06c1 \u0645\u0646\u0627\u0633\u0628 \u06c1\u0648 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4 \u0627\u0633 \u06a9\u06cc \u0648\u062c\u06c1 \u06cc\u06c1 \u06c1\u06d2 \u06a9\u06c1 \u06cc\u06c1 \u0628\u0627\u0631 \u0628\u0627\u0631 \u0622\u0646\u06d2 \u0648\u0627\u0644\u06d2 \u0627\u062a\u0627\u0631 \u0686\u0691\u06be\u0627\u0648 \u06a9\u06cc \u0648\u0636\u0627\u062d\u062a \u06a9\u0631\u0646\u06d2 \u0645\u06cc\u06ba \u0645\u062f\u062f \u06a9\u0631 \u0633\u06a9\u062a\u0627 \u06c1\u06d2 \u062c\u0648 \u0628\u0646\u06cc\u0627\u062f\u06cc \u0644\u06a9\u06cc\u0631\u06cc \u0631\u062c\u062d\u0627\u0646 \u06a9\u06cc\u067e\u0686\u0631 \u0646\u06c1\u06cc\u06ba \u06a9\u0631\u062a\u0627 \u06c1\u06d2\u06d4<\/p>\n<p>\u0622\u067e \u06a9\u0648 \u063a\u06cc\u0631 \u0645\u0639\u0645\u0648\u0644\u06cc \u0648\u0627\u067e\u0633\u06cc \u0648\u0627\u0644\u06d2 \u0645\u06c1\u06cc\u0646\u0648\u06ba \u067e\u0631 \u0628\u06be\u06cc \u062a\u0648\u062c\u06c1 \u062f\u06cc\u0646\u06cc \u0686\u0627\u06c1\u06cc\u06d2\u06d4 \u0627\u06cc\u06a9 \u0628\u0627\u0631 \u06a9\u06d2 \u0628\u0691\u06d2 \u0622\u0631\u0688\u0631\u0632 \u06cc\u0627 \u063a\u06cc\u0631 \u0645\u0639\u0645\u0648\u0644\u06cc \u0645\u0639\u0627\u0634\u06cc \u0628\u062f\u062d\u0627\u0644\u06cc \u0631\u062c\u062d\u0627\u0646 \u06a9\u06cc \u0644\u06a9\u06cc\u0631\u0648\u06ba \u06a9\u0648 \u0639\u0627\u0645 \u06a9\u0627\u0631\u06a9\u0631\u062f\u06af\u06cc \u0633\u06d2 \u06c1\u0679\u0646\u06d2 \u06a9\u0627 \u0633\u0628\u0628 \u0628\u0646 \u0633\u06a9\u062a\u06cc \u06c1\u06d2\u06d4 \u06cc\u06c1 \u062e\u0627\u0635 \u0637\u0648\u0631 \u067e\u0631 \u0645\u062d\u062f\u0648\u062f \u062a\u0627\u0631\u06cc\u062e\u06cc \u0627\u0639\u062f\u0627\u062f \u0648 \u0634\u0645\u0627\u0631 \u06a9\u06d2 \u0633\u0627\u062a\u06be \u0633\u0686 \u06c1\u06d2\u06d4 \u06cc\u06c1 \u0641\u06cc\u0635\u0644\u06c1 \u06a9\u0631\u0646\u06d2 \u0633\u06d2 \u067e\u06c1\u0644\u06d2 \u06a9\u06c1 \u0622\u06cc\u0627 \u0648\u06c1 \u0622\u067e \u06a9\u06cc \u067e\u06cc\u0634\u06cc\u0646 \u06af\u0648\u0626\u06cc\u0648\u06ba \u06a9\u0648 \u0645\u062a\u0627\u062b\u0631 \u06a9\u0631\u06cc\u06ba \u06af\u06d2 \u0627\u0646 \u06a9\u06cc \u0686\u06be\u0627\u0646 \u0628\u06cc\u0646 \u06a9\u0631\u06cc\u06ba\u06d4 \u0627\u0633 \u06a9\u06cc \u0648\u062c\u06c1 \u06cc\u06c1 \u06c1\u06d2 \u06a9\u06c1 \u0628\u0627\u06c1\u0631 \u062c\u0627\u0646\u06d2 \u0648\u0627\u0644\u06d2 \u062f\u06c1\u0631\u0627\u0626\u06d2 \u062c\u0627\u0646\u06d2 \u0648\u0627\u0644\u06d2 \u0646\u0645\u0648\u0646\u0648\u06ba \u06a9\u06cc \u0628\u062c\u0627\u0626\u06d2 \u063a\u06cc\u0631 \u0645\u0639\u0645\u0648\u0644\u06cc \u062d\u0627\u0644\u0627\u062a \u06a9\u06cc \u0646\u0645\u0627\u0626\u0646\u062f\u06af\u06cc \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<h3 id=\"make-sure-your-numbers-tell-the-right-story\">\n<p>            \u06cc\u0642\u06cc\u0646\u06cc \u0628\u0646\u0627\u0626\u06cc\u06ba \u06a9\u06c1 \u0646\u0645\u0628\u0631 \u0635\u062d\u06cc\u062d \u067e\u06cc\u063a\u0627\u0645 \u067e\u06c1\u0646\u0686\u0627\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<br \/>\n    <\/h3>\n<p>Excel \u06a9\u06d2 TREND \u0641\u0646\u06a9\u0634\u0646 \u06a9\u0627 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0622\u067e \u06a9\u0627 \u0648\u0642\u062a \u0628\u0686\u0627\u0626\u06d2 \u06af\u0627 \u0627\u0648\u0631 \u0622\u067e \u06a9\u0648 \u0627\u067e\u0646\u06d2 \u0645\u0646\u0627\u0641\u0639 \u06a9\u06cc \u0645\u0646\u0635\u0648\u0628\u06c1 \u0628\u0646\u062f\u06cc \u06a9\u06d2 \u0644\u06cc\u06d2 \u0627\u06cc\u06a9 \u0639\u0645\u0644\u06cc \u0646\u0642\u0637\u06c1 \u0622\u063a\u0627\u0632 \u0641\u0631\u0627\u06c1\u0645 \u06a9\u0631\u06d2 \u06af\u0627\u06d4 \u0627\u06af\u0631\u0686\u06c1 \u06cc\u06c1 \u0646\u0626\u06d2 \u062d\u0631\u06cc\u0641\u0648\u06ba\u060c \u0622\u0646\u06d2 \u0648\u0627\u0644\u06cc \u0642\u06cc\u0645\u062a\u0648\u06ba \u0645\u06cc\u06ba \u06c1\u0648\u0646\u06d2 \u0648\u0627\u0644\u06cc \u062a\u0628\u062f\u06cc\u0644\u06cc\u0648\u06ba\u060c \u06cc\u0627 \u06a9\u0633\u0679\u0645\u0631 \u06a9\u06cc \u0645\u0627\u0646\u06af \u0645\u06cc\u06ba \u062a\u0628\u062f\u06cc\u0644\u06cc\u0648\u06ba \u06a9\u0627 \u062d\u0633\u0627\u0628 \u0646\u06c1\u06cc\u06ba \u062f\u06d2 \u0633\u06a9\u062a\u0627\u060c \u0644\u06cc\u06a9\u0646 \u06cc\u06c1 \u0648\u06c1 \u0628\u0646\u06cc\u0627\u062f\u06cc \u067e\u06cc\u0634\u06cc\u0646 \u06af\u0648\u0626\u06cc\u0627\u06ba \u0641\u0631\u0627\u06c1\u0645 \u06a9\u0631 \u0633\u06a9\u062a\u0627 \u06c1\u06d2 \u062c\u0646 \u06a9\u06d2 \u0633\u0627\u062a\u06be \u0622\u067e \u06a9\u0648 \u06a9\u0627\u0645 \u06a9\u0631\u0646\u06d2 \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u06c1\u06d2\u06d4<\/p>\n<p>\u0635\u062d\u06cc\u062d \u062a\u0631\u062a\u06cc\u0628 \u0645\u06cc\u06ba \u062f\u0644\u0627\u0626\u0644 \u062f\u0631\u062c \u06a9\u0631\u06cc\u06ba\u060c \u0688\u06cc\u0679\u0627 \u06a9\u06cc \u062d\u062f\u0648\u062f \u06a9\u0648 \u06cc\u06a9\u0633\u0627\u06ba \u0631\u06a9\u06be\u06cc\u06ba\u060c \u0633\u06cc\u0644\u0632 \u067e\u06cc\u0679\u0631\u0646 \u06a9\u0648 \u0627\u06cc\u06a9 \u0644\u06a9\u06cc\u0631\u06cc \u0631\u062c\u062d\u0627\u0646 \u06a9\u06cc \u067e\u06cc\u0631\u0648\u06cc \u06a9\u0648 \u06cc\u0642\u06cc\u0646\u06cc \u0628\u0646\u0627\u0626\u06cc\u06ba\u060c \u0627\u0648\u0631 \u0686\u0627\u0631\u0679 \u0679\u0631\u06cc\u0646\u0688 \u0644\u0627\u0626\u0646\u0648\u06ba \u0633\u06d2 \u0627\u0646 \u06a9\u0627 \u0645\u0648\u0627\u0632\u0646\u06c1 \u06a9\u0631\u06a9\u06d2 \u0646\u062a\u0627\u0626\u062c \u06a9\u06cc \u062a\u0635\u062f\u06cc\u0642 \u06a9\u0631\u06cc\u06ba\u06d4 \u06cc\u06c1 \u0686\u06cc\u06a9 \u0622\u067e \u06a9\u0648 \u0627\u067e\u0646\u06d2 \u0645\u0648\u062c\u0648\u062f\u06c1 \u0633\u06cc\u0644\u0632 \u0688\u06cc\u0679\u0627 \u0633\u06d2 \u0645\u0641\u06cc\u062f \u0622\u0645\u062f\u0646\u06cc \u06a9\u06d2 \u062a\u062e\u0645\u06cc\u0646\u06d2 \u0628\u0646\u0627\u0646\u06d2 \u06a9\u06cc \u0627\u062c\u0627\u0632\u062a \u062f\u06cc\u062a\u06d2 \u06c1\u06cc\u06ba\u060c \u06cc\u06c1\u0627\u06ba \u062a\u06a9 \u06a9\u06c1 \u0627\u06af\u0631 \u0622\u067e \u0627\u0646 \u062a\u0645\u0627\u0645 \u0639\u0648\u0627\u0645\u0644 \u06a9\u0627 \u0645\u062d\u0627\u0633\u0628\u06c1 \u0646\u06c1\u06cc\u06ba \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u062c\u0648 \u0645\u0633\u062a\u0642\u0628\u0644 \u06a9\u06cc \u0622\u0645\u062f\u0646\u06cc \u06a9\u0648 \u0645\u062a\u0627\u062b\u0631 \u06a9\u0631 \u0633\u06a9\u062a\u06d2 \u06c1\u06cc\u06ba\u06d4<\/p>\n<\/p><\/div>","protected":false},"excerpt":{"rendered":"<p>\u0622\u067e \u06a9\u0648 \u0644\u06af\u062a\u0627 \u06c1\u06d2 \u06a9\u06c1 \u0622\u067e \u06a9\u0648 \u067e\u06cc\u0686\u06cc\u062f\u06c1 \u0634\u0645\u0627\u0631\u06cc\u0627\u062a\u06cc \u0633\u0627\u0641\u0679 \u0648\u06cc\u0626\u0631 \u06cc\u0627 \u0645\u06cc\u0646\u0648\u0626\u0644 \u0631\u06cc\u06af\u0631\u06cc\u0634\u0646 \u0641\u0627\u0631\u0645\u0648\u0644\u0648\u06ba \u06a9\u06cc \u0636\u0631\u0648\u0631\u062a \u06c1\u06d2 \u062a\u0627\u06a9\u06c1 \u06cc\u06c1 \u0627\u0646\u062f\u0627\u0632\u06c1 \u0644\u06af\u0627\u06cc\u0627 \u062c\u0627 \u0633\u06a9\u06d2 \u06a9\u06c1 \u0622\u067e \u06a9\u0627 \u06a9\u0627\u0631\u0648\u0628\u0627\u0631 \u0627\u06af\u0644\u06d2 \u0686\u0646\u062f \u0645\u06c1\u06cc\u0646\u0648\u06ba \u0645\u06cc\u06ba \u06a9\u062a\u0646\u06cc \u0631\u0642\u0645 \u06a9\u0645\u0627\u0626\u06d2 \u06af\u0627\u06d4 \u062a\u0627\u06c1\u0645\u060c Microsoft 365 \u0627\u0648\u0631 Excel 2021 \u0627\u0648\u0631 \u0627\u0633 \u06a9\u06d2 \u0628\u0639\u062f \u06a9\u06d2 \u0644\u06cc\u06d2 Excel \u0645\u06cc\u06ba \u062a\u0627\u0632\u06c1 \u062a\u0631\u06cc\u0646 Dynamic Arrays \u06a9\u06d2 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":31318,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-31317","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"_links":{"self":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts\/31317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/comments?post=31317"}],"version-history":[{"count":1,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts\/31317\/revisions"}],"predecessor-version":[{"id":31319,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/posts\/31317\/revisions\/31319"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/media\/31318"}],"wp:attachment":[{"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/media?parent=31317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/categories?post=31317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/umang.pk\/en_us\/wp-json\/wp\/v2\/tags?post=31317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}