{"id":1609,"date":"2023-10-17T10:42:07","date_gmt":"2023-10-17T07:42:07","guid":{"rendered":"https:\/\/www.test4u.eu\/blog\/?p=1609"},"modified":"2023-10-17T10:42:08","modified_gmt":"2023-10-17T07:42:08","slug":"%ce%bf%ce%b9-38-%cf%80%ce%b9%ce%bf-%cf%83%ce%b7%ce%bc%ce%b1%ce%bd%cf%84%ce%b9%ce%ba%ce%ad%cf%82-%cf%83%cf%85%ce%bd%ce%b1%cf%81%cf%84%ce%ae%cf%83%ce%b5%ce%b9%cf%82-%cf%84%ce%bf%cf%85-excel","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/blog\/%ce%bf%ce%b9-38-%cf%80%ce%b9%ce%bf-%cf%83%ce%b7%ce%bc%ce%b1%ce%bd%cf%84%ce%b9%ce%ba%ce%ad%cf%82-%cf%83%cf%85%ce%bd%ce%b1%cf%81%cf%84%ce%ae%cf%83%ce%b5%ce%b9%cf%82-%cf%84%ce%bf%cf%85-excel\/","title":{"rendered":"\u039f\u03b9 38 \u03c0\u03b9\u03bf \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 Excel"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><em>\u0393\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03c4\u03b9\u03c2 38 \u03c0\u03b9\u03bf \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c3\u03c4\u03bf Excel;<\/em><\/p>\n\n\n\n<p>\u03a0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03ae\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b2\u03af\u03bd\u03c4\u03b5\u03bf \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03c4\u03b9\u03c2 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03b6\u03c9\u03ae \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b7!<\/p>\n\n\n\n<p>\u0395\u03bd\u03b4\u03b9\u03b1\u03c6\u03ad\u03c1\u03b5\u03c3\u03c4\u03b5 \u03b3\u03b9\u03b1 \u03c0\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03c4\u03b9\u03ba\u03cc \u03c0\u03bb\u03b7\u03c1\u03bf\u03c6\u03bf\u03c1\u03b9\u03ba\u03ae\u03c2 (\u03c0.\u03c7. \u03b3\u03b9\u03b1 <strong>ECDL<\/strong>, \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf \u03c0\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03c4\u03b9\u03ba\u03cc \u0391\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf \u03b1\u03c0\u03cc \u03c4\u03bf \u0395\u03bb\u03bb\u03b7\u03bd\u03b9\u03ba\u03cc \u0394\u03b7\u03bc\u03cc\u03c3\u03b9\u03bf); \u03a4\u03cc\u03c4\u03b5 \u03c3\u03af\u03b3\u03bf\u03c5\u03c1\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c4\u03b9\u03c2 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5!<\/p>\n\n\n\n<p><strong>\u0392\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/strong><\/p>\n\n\n\n<p>00:00:00 \u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>SUM<\/strong><\/p>\n\n\n\n<p>00:05:12 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2: <strong>AVERAGE<\/strong> (\u03bc\u03ad\u03c3\u03bf\u03c2 \u03cc\u03c1\u03bf\u03c2), <strong>MAX <\/strong>\u03ba\u03b1\u03b9 <strong>MIN<\/strong> (\u03bc\u03ad\u03b3\u03b9\u03c3\u03c4\u03b7 \u03ba\u03b1\u03b9 \u03b5\u03bb\u03ac\u03c7\u03b9\u03c3\u03c4\u03b7 \u03c4\u03b9\u03bc\u03ae)<\/p>\n\n\n\n<p>00:10:13 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 <strong>COUNT <\/strong>\u03ba\u03b1\u03b9 <strong>COUNTA <\/strong>(\u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7\u03c2)<\/p>\n\n\n\n<p>00:12:39 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>COUNTBLANK<\/strong><\/p>\n\n\n\n<p>00:13:47 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>IF<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u0397\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1\u03c2 \u03ba\u03b1\u03b9 \u038f\u03c1\u03b1\u03c2<\/strong><\/p>\n\n\n\n<p>00:21:24 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>TODAY<\/strong><\/p>\n\n\n\n<p>00:22:41 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 <strong>DAY, MONTH, YEAR<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u039c\u03b1\u03b8\u03b7\u03bc\u03b1\u03c4\u03b9\u03ba\u03ad\u03c2 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/strong><\/p>\n\n\n\n<p>00:26:43 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>SUMIF<\/strong><\/p>\n\n\n\n<p>00:30:06 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>ROUND<\/strong><\/p>\n\n\n\n<p>00:34:42 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>ROUNDUP<\/strong><\/p>\n\n\n\n<p>00:36:12 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>ROUNDDOWN<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03a3\u03c4\u03b1\u03c4\u03b9\u03c3\u03c4\u03b9\u03ba\u03ae\u03c2<\/strong><\/p>\n\n\n\n<p>00:37:34 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>COUNTIF<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u039a\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5<\/strong><\/p>\n\n\n\n<p>00:39:45 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>UPPER<\/strong><\/p>\n\n\n\n<p>00:41:14 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>LOWER<\/strong><\/p>\n\n\n\n<p>00:42:29 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>PROPER<\/strong><\/p>\n\n\n\n<p>00:43:40 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>CONCATENATE (CONCAT)<\/strong><\/p>\n\n\n\n<p>00:45:12 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>LEFT<\/strong><\/p>\n\n\n\n<p>00:46:39 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>RIGHT<\/strong><\/p>\n\n\n\n<p>00:48:04 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>MID<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u039f\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b9\u03ba\u03ad\u03c2 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/strong><\/p>\n\n\n\n<p>00:49:51 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>PMT<\/strong><\/p>\n\n\n\n<p>00:54:33 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>PV<\/strong><\/p>\n\n\n\n<p>00:58:03 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>NPV<\/strong><\/p>\n\n\n\n<p>01:05:46 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>FV<\/strong><\/p>\n\n\n\n<p>01:07:56 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>RATE<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u0391\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7\u03c2 \u03ba\u03b1\u03b9 \u0391\u03bd\u03b1\u03c6\u03bf\u03c1\u03ac\u03c2<\/strong><\/p>\n\n\n\n<p>01:10:24 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>VLOOKUP<\/strong><\/p>\n\n\n\n<p>01:14:44 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>HLOOKUP<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u0392\u03ac\u03c3\u03b5\u03c9\u03c2 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd<\/strong><\/p>\n\n\n\n<p>01:18:43 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>DSUM<\/strong><\/p>\n\n\n\n<p>01:21:54 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>DCOUNT<\/strong><\/p>\n\n\n\n<p>01:24:28 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 <strong>DMIN, DMAX<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>\u039b\u03bf\u03b3\u03b9\u03ba\u03ad\u03c2 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/strong><\/p>\n\n\n\n<p>01:31:02 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>AND<\/strong><\/p>\n\n\n\n<p>01:35:42 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>OR<\/strong><\/p>\n\n\n\n<p>01:40:07 \u03a3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 <strong>ISERROR<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"\u039f\u03b9 38 \u03c0\u03b9\u03bf \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 Excel \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03bc\u03ac\u03b8\u03b7\u03bc\u03b1.\" width=\"525\" height=\"295\" src=\"https:\/\/www.youtube.com\/embed\/yIVyHaTgFq8?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u0393\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03c4\u03b9\u03c2 38 \u03c0\u03b9\u03bf \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c3\u03c4\u03bf Excel; \u03a0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03ae\u03c3\u03c4\u03b5 \u03c4\u03bf \u03b2\u03af\u03bd\u03c4\u03b5\u03bf \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03c4\u03b9\u03c2 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03b6\u03c9\u03ae \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b7! \u0395\u03bd\u03b4\u03b9\u03b1\u03c6\u03ad\u03c1\u03b5\u03c3\u03c4\u03b5 \u03b3\u03b9\u03b1 \u03c0\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03c4\u03b9\u03ba\u03cc \u03c0\u03bb\u03b7\u03c1\u03bf\u03c6\u03bf\u03c1\u03b9\u03ba\u03ae\u03c2 (\u03c0.\u03c7. \u03b3\u03b9\u03b1 ECDL, \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf \u03c0\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03c4\u03b9\u03ba\u03cc \u0391\u03bd\u03b1\u03b3\u03bd\u03c9\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03bf \u03b1\u03c0\u03cc \u03c4\u03bf \u0395\u03bb\u03bb\u03b7\u03bd\u03b9\u03ba\u03cc \u0394\u03b7\u03bc\u03cc\u03c3\u03b9\u03bf); \u03a4\u03cc\u03c4\u03b5 \u03c3\u03af\u03b3\u03bf\u03c5\u03c1\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c4\u03b9\u03c2 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5! \u0392\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 00:00:00 \u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.test4u.eu\/blog\/%ce%bf%ce%b9-38-%cf%80%ce%b9%ce%bf-%cf%83%ce%b7%ce%bc%ce%b1%ce%bd%cf%84%ce%b9%ce%ba%ce%ad%cf%82-%cf%83%cf%85%ce%bd%ce%b1%cf%81%cf%84%ce%ae%cf%83%ce%b5%ce%b9%cf%82-%cf%84%ce%bf%cf%85-excel\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;\u039f\u03b9 38 \u03c0\u03b9\u03bf \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 Excel&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[178],"tags":[78,210,186],"class_list":["post-1609","post","type-post","status-publish","format-standard","hentry","category-youtube","tag-excel","tag-free-course","tag-youtube"],"_links":{"self":[{"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/posts\/1609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/comments?post=1609"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/posts\/1609\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/media?parent=1609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/categories?post=1609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/tags?post=1609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}