{"id":6138,"date":"2021-09-01T08:25:52","date_gmt":"2021-09-01T08:25:52","guid":{"rendered":"http:\/\/www.hsu.ac.ir\/azad\/?p=6138"},"modified":"2021-11-17T04:24:30","modified_gmt":"2021-11-17T05:24:30","slug":"%d8%af%d9%88%d8%b1%d9%87-%d8%aa%d8%ae%d8%b5%d8%b5%db%8c-%d8%a7%da%a9%d8%b3%d9%84-%d9%85%d9%82%d8%af%d9%85%d8%a7%d8%aa%db%8c-%d8%8c-%d9%be%db%8c%d8%b4%d8%b1%d9%81%d8%aa%d9%87","status":"publish","type":"post","link":"https:\/\/www.hsu.ac.ir\/azad\/2021\/09\/01\/%d8%af%d9%88%d8%b1%d9%87-%d8%aa%d8%ae%d8%b5%d8%b5%db%8c-%d8%a7%da%a9%d8%b3%d9%84-%d9%85%d9%82%d8%af%d9%85%d8%a7%d8%aa%db%8c-%d8%8c-%d9%be%db%8c%d8%b4%d8%b1%d9%81%d8%aa%d9%87\/","title":{"rendered":"\u062f\u0648\u0631\u0647 \u062a\u062e\u0635\u0635\u06cc \u0627\u06a9\u0633\u0644 (\u0645\u0642\u062f\u0645\u0627\u062a\u06cc \u060c \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 &#8211; \u0627\u062a\u0645\u0627\u0645 \u0645\u0647\u0644\u062a \u062b\u0628\u062a \u0646\u0627\u0645"},"content":{"rendered":"<table border=\"2\" width=\"1056\">\n<tbody>\n<tr>\n<td colspan=\"7\" width=\"737\">\n<h2 style=\"text-align: center\">\u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646 \u0641\u0646\u06cc \u0648 \u0645\u0647\u0646\u062f\u0633\u06cc<\/h2>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"137\">\n<h2 style=\"text-align: center\"><strong>\u0639\u0646\u0648\u0627\u0646<\/strong><\/h2>\n<\/td>\n<td width=\"110\">\n<h2 style=\"text-align: center\"><strong>\u0627\u0633\u062a\u0627\u062f \u062f\u0648\u0631\u0647<\/strong><\/h2>\n<\/td>\n<td width=\"95\">\n<h2 style=\"text-align: center\"><strong>\u0632\u0645\u0627\u0646 \u0628\u0631\u06af\u0632\u0627\u0631\u06cc<\/strong><\/h2>\n<\/td>\n<td width=\"97\">\n<h2 style=\"text-align: center\"><strong>\u0645\u062f\u062a<\/strong><\/h2>\n<\/td>\n<td width=\"101\">\n<h2 style=\"text-align: center\"><strong>\u0646\u062d\u0648\u0647 \u0628\u0631\u06af\u0632\u0627\u0631\u06cc<\/strong><\/h2>\n<\/td>\n<td width=\"100\">\n<h2 style=\"text-align: center\"><strong>\u0634\u0647\u0631\u06cc\u0647 (\u0631\u06cc\u0627\u0644)<\/strong><\/h2>\n<\/td>\n<td width=\"96\">\n<h2>\u0645\u0647\u0644\u062a \u062b\u0628\u062a \u0646\u0627\u0645<\/h2>\n<\/td>\n<\/tr>\n<tr>\n<td width=\"137\">\n<h3 style=\"text-align: center\"><strong><span style=\"color: #0000ff\">\u062f\u0648\u0631\u0647 \u062a\u062e\u0635\u0635\u06cc excel<\/span><\/strong><\/h3>\n<p>&nbsp;<\/td>\n<td width=\"110\">\n<h3 style=\"text-align: center\"><strong>\u062c\u0646\u0627\u0628 \u0622\u0642\u0627\u06cc \u0645\u0647\u0646\u062f\u0633 \u0639\u0644\u06cc \u06a9\u0641\u0627\u0634<\/strong><\/h3>\n<\/td>\n<td width=\"95\">\n<h3><\/h3>\n<h3 style=\"text-align: center\"><strong><span style=\"color: #ff0000\">\u062a\u0627\u0631\u06cc\u062d \u0634\u0631\u0648\u0639 \u0627\u0648\u0644\u06cc\u0646 \u062c\u0644\u0633\u0647 20 \u0622\u0628\u0627\u0646 <\/span><\/strong><\/h3>\n<h3 style=\"text-align: center\"><span style=\"color: #ff0000\"><strong>\u0633\u0627\u0639\u062a 16 \u0627\u0644\u06cc 20\u00a0<\/strong><\/span><\/h3>\n<p>&nbsp;<\/td>\n<td width=\"97\">\n<h3 style=\"text-align: center\"><strong><span style=\"color: #ff0000\">30 \u0633\u0627\u0639\u062a\u00a0<\/span><\/strong><\/h3>\n<h3 style=\"text-align: center\"><\/h3>\n<\/td>\n<td width=\"101\">\n<h3><span style=\"color: #0000ff\"><strong>\u00a0 \u00a0\u0645\u062c\u0627\u0632\u06cc (\u0622\u0646\u0644\u0627\u06cc\u0646 )<\/strong><\/span><\/h3>\n<\/td>\n<td width=\"100\">\n<h3><\/h3>\n<h3 style=\"text-align: center\"><strong>\u00a0\u062f\u0627\u0646\u0634\u062c\u0648\u06cc\u0627\u0646 \u062d\u06a9\u06cc\u0645 \u0633\u0628\u0632\u0648\u0627\u0631\u06cc<\/strong><\/h3>\n<h3 style=\"text-align: center\"><span style=\"color: #ff0000\">200 \u0647\u0632\u0627\u0631\u062a\u0648\u0645\u0627\u0646\u00a0<\/span><\/h3>\n<h3 style=\"text-align: center\"><strong>\u0633\u0627\u06cc\u0631 \u0627\u0641\u0631\u0627\u062f:<\/strong><\/h3>\n<h3 style=\"text-align: center\"><span style=\"color: #ff0000\"><strong>250 \u0647\u0632\u0627\u0631 \u062a\u0648\u0645\u0627\u0646\u00a0<\/strong><\/span><\/h3>\n<h3><\/h3>\n<h3><\/h3>\n<h4><\/h4>\n<\/td>\n<td style=\"text-align: center\" width=\"96\">\n<h3><strong><span style=\"color: #ff0000\">\u0627\u062a\u0645\u0627\u0645 \u0645\u0647\u0644\u062a \u062b\u0628\u062a \u0646\u0627\u0645<\/span><\/strong><\/h3>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3 style=\"text-align: center\"><span style=\"color: #ff0000\">\u0633\u0631\u0641\u0635\u0644 \u0647\u0627\u06cc \u062f\u0648\u0631\u0647 :<\/span><\/h3>\n<ul>\n<li>\u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0645\u062d\u06cc\u0637 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 (\u0645\u0639\u0631\u0641\u06cc \u0646\u0648\u0627\u0631\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0635\u0641\u062d\u0647 \u06a9\u0627\u0631\u06cc)<br \/>\n\u0646\u062d\u0648\u0647 \u0648\u0631\u0648\u062f \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0639\u062f\u0627\u062f (\u0645\u062a\u0648\u0627\u0644\u06cc \u2013 \u0632\u0648\u062c \u2013 \u0641\u0631\u062f \u2013 \u067e\u0644\u0647 \u0627\u06cc )<br \/>\n\u0645\u062f\u06cc\u0631\u06cc\u062a \u0628\u0631 \u0635\u0641\u062d\u0627\u062a \u06af\u0633\u062a\u0631\u062f\u0647 (\u0645\u062f\u06cc\u0631\u06cc\u062a Sheet \u062f\u0631 Sheet Bar)<br \/>\n\u0646\u062d\u0648\u0647 \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0631\u06cc\u0627\u0636\u06cc \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 ( \u0639\u0645\u0644\u06cc\u0627\u062a \u062c\u0645\u0639- \u062a\u0641\u0631\u06cc\u0642 \u2013 \u062a\u0642\u0633\u06cc\u0645 \u0648 \u2026)<br \/>\n\u0646\u062d\u0648\u0647 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u062e\u0627\u0646\u0647 \u0647\u0627 ( Format Cell )<br \/>\n\u0646\u062d\u0648\u0647 \u06a9\u0627\u0631 \u0628\u0627 \u062a\u0648\u0627\u0628\u0639 \u0627\u0635\u0644\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 (Sum \u2013 Average \u2013 Min \u2013 Max \u2013 Count \u2013 If)<br \/>\n\u0646\u062d\u0648\u0647 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u0634\u0631\u0637\u06cc \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 ( Conditional Formatting )<br \/>\n\u0646\u062d\u0648\u0647 \u062c\u062f\u0648\u0644 \u06a9\u0631\u062f\u0646 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u062f\u0631 \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 (Table )<br \/>\n\u0646\u062d\u0648\u0647 \u0628\u0631\u0642\u0631\u0627\u0631\u06cc \u0644\u06cc\u0646\u06a9 \u062f\u0631 \u0627\u06a9\u0633\u0644 ( Hyper Link )<br \/>\n\u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc (validation)<br \/>\n\u0627\u0628\u0632\u0627\u0631 (Goal seek)<br \/>\n\u0645\u0646\u0633\u062c\u0645 \u0633\u0627\u0632\u06cc \u0648 \u06cc\u06a9\u06cc \u06a9\u0631\u062f\u0646 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0627 Consolidate<br \/>\n\u062c\u062f\u0627\u0648\u0644 \u0648 \u0646\u0645\u0648\u062f\u0627\u0631\u0647\u0627\u06cc \u0645\u062d\u0648\u0631\u06cc Pivot Table \u0648 PivotChart<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center\"><a href=\"http:\/\/www.hsu.ac.ir\/azad\/product\/%d8%a7%da%a9%d8%b3%d9%84-%d9%88%db%8c%da%98%d9%87-%d8%af%d8%a7%d9%86%d8%b4%d8%ac%d9%88%db%8c%d8%a7%d9%86-%d8%ad%da%a9%db%8c%d9%85-%d8%b3%d8%a8%d8%b2%d9%88%d8%a7%d8%b1%db%8c\/\"><span style=\"color: #0000ff\">\u067e\u0631\u062f\u0627\u062e\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9\u06cc \u0648\u06cc\u0698\u0647 \u062f\u0627\u0646\u0634\u062c\u0648\u06cc\u0627\u0646 \u062d\u06a9\u06cc\u0645 \u0633\u0628\u0632\u0648\u0627\u0631\u06cc\u00a0<\/span><\/a><\/h2>\n<h2 style=\"text-align: center\"><span style=\"color: #ff0000\"><a style=\"color: #ff0000\" href=\"http:\/\/www.hsu.ac.ir\/azad\/product\/%d8%a7%da%a9%d8%b3%d9%84-%d9%88%db%8c%da%98%d9%87-%d8%b3%d8%a7%db%8c%d8%b1-%d8%a7%d9%81%d8%b1%d8%a7%d8%af\/\">\u067e\u0631\u062f\u0627\u062e\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9\u06cc \u0648\u06cc\u0698\u0647 \u0633\u0627\u06cc\u0631 \u0627\u0641\u0631\u0627\u062f\u00a0<\/a><\/span><\/h2>\n<p style=\"text-align: center\">\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u067e\u0627\u0631\u062a\u0645\u0627\u0646 \u0641\u0646\u06cc \u0648 \u0645\u0647\u0646\u062f\u0633\u06cc \u0639\u0646\u0648\u0627\u0646 \u0627\u0633\u062a\u0627\u062f \u062f\u0648\u0631\u0647 \u0632\u0645\u0627\u0646 \u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0645\u062f\u062a \u0646\u062d\u0648\u0647 \u0628\u0631\u06af\u0632\u0627\u0631\u06cc \u0634\u0647\u0631\u06cc\u0647 (\u0631\u06cc\u0627\u0644) \u0645\u0647\u0644\u062a \u062b\u0628\u062a \u0646\u0627\u0645 \u062f\u0648\u0631\u0647 \u062a\u062e\u0635\u0635\u06cc excel &nbsp; \u062c\u0646\u0627\u0628 \u0622\u0642\u0627\u06cc \u0645\u0647\u0646\u062f\u0633 \u0639\u0644\u06cc \u06a9\u0641\u0627\u0634 \u062a\u0627\u0631\u06cc\u062d \u0634\u0631\u0648\u0639 \u0627\u0648\u0644\u06cc\u0646 \u062c\u0644\u0633\u0647 20 \u0622\u0628\u0627\u0646 \u0633\u0627\u0639\u062a 16 \u0627\u0644\u06cc 20\u00a0 &nbsp; 30 \u0633\u0627\u0639\u062a\u00a0 \u00a0 \u00a0\u0645\u062c\u0627\u0632\u06cc (\u0622\u0646\u0644\u0627\u06cc\u0646 ) \u00a0\u062f\u0627\u0646\u0634\u062c\u0648\u06cc\u0627\u0646 \u062d\u06a9\u06cc\u0645 \u0633\u0628\u0632\u0648\u0627\u0631\u06cc 200 \u0647\u0632\u0627\u0631\u062a\u0648\u0645\u0627\u0646\u00a0 \u0633\u0627\u06cc\u0631 \u0627\u0641\u0631\u0627\u062f: 250 \u0647\u0632\u0627\u0631 \u062a\u0648\u0645\u0627\u0646\u00a0 \u0627\u062a\u0645\u0627\u0645 \u0645\u0647\u0644\u062a [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":6145,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[4],"tags":[],"class_list":["post-6138","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/posts\/6138","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/comments?post=6138"}],"version-history":[{"count":26,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/posts\/6138\/revisions"}],"predecessor-version":[{"id":6603,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/posts\/6138\/revisions\/6603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/media\/6145"}],"wp:attachment":[{"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/media?parent=6138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/categories?post=6138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hsu.ac.ir\/azad\/wp-json\/wp\/v2\/tags?post=6138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}