{"id":9085,"date":"2025-12-05T14:15:00","date_gmt":"2025-12-05T14:15:00","guid":{"rendered":"https:\/\/euroshopkey.com\/excel-aparaitites-synartiseis-odigos-2026\/"},"modified":"2025-12-05T14:15:00","modified_gmt":"2025-12-05T14:15:00","slug":"excel-aparaitites-synartiseis-odigos-2026","status":"publish","type":"post","link":"https:\/\/euroshopkey.com\/el\/excel-essential-functions-guide-2026\/","title":{"rendered":"Microsoft Excel: \u039f\u03b9 15 \u0391\u03c0\u03b1\u03c1\u03b1\u03af\u03c4\u03b7\u03c4\u03b5\u03c2 \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u039c\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c4\u03bf 2026"},"content":{"rendered":"<p>\u03a4\u03bf Microsoft Excel \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c0\u03b9\u03bf \u03b4\u03b9\u03b1\u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03bf \u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc \u03c6\u03cd\u03bb\u03bb\u03bf \u03c3\u03c4\u03bf\u03bd \u03ba\u03cc\u03c3\u03bc\u03bf. \u03a9\u03c3\u03c4\u03cc\u03c3\u03bf, \u03b7 \u03c3\u03c5\u03bd\u03c4\u03c1\u03b9\u03c0\u03c4\u03b9\u03ba\u03ae \u03c0\u03bb\u03b5\u03b9\u03bf\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c4\u03c9\u03bd \u03c7\u03c1\u03b7\u03c3\u03c4\u03ce\u03bd \u03b1\u03be\u03b9\u03bf\u03c0\u03bf\u03b9\u03b5\u03af \u03bc\u03cc\u03bd\u03bf \u03ad\u03bd\u03b1 \u03bc\u03b9\u03ba\u03c1\u03cc \u03bc\u03ad\u03c1\u03bf\u03c2 \u03c4\u03c9\u03bd \u03b4\u03c5\u03bd\u03b1\u03c4\u03bf\u03c4\u03ae\u03c4\u03c9\u03bd \u03c4\u03bf\u03c5. \u0395\u03af\u03c4\u03b5 \u03b5\u03af\u03c3\u03c4\u03b5 \u03c6\u03bf\u03b9\u03c4\u03b7\u03c4\u03ae\u03c2, \u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03ae\u03c2, \u03b5\u03c0\u03b9\u03c7\u03b5\u03b9\u03c1\u03b7\u03bc\u03b1\u03c4\u03af\u03b1\u03c2 \u03ae \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03ae\u03c2, \u03b7 \u03b3\u03bd\u03ce\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c9\u03c3\u03c4\u03ce\u03bd \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd \u03c4\u03bf\u03c5 Excel \u03bc\u03b5\u03c4\u03b1\u03bc\u03bf\u03c1\u03c6\u03ce\u03bd\u03b5\u03b9 \u03ba\u03c5\u03c1\u03b9\u03bf\u03bb\u03b5\u03ba\u03c4\u03b9\u03ba\u03ac \u03c4\u03b7\u03bd \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03ac \u03c3\u03b1\u03c2.<\/p>\n<p>\u0391\u03c5\u03c4\u03cc\u03c2 \u03bf \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 <strong>15 \u03c0\u03b9\u03bf \u03c7\u03c1\u03ae\u03c3\u03b9\u03bc\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 Excel \u03c4\u03bf 2026<\/strong>, \u03bc\u03b5 \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b1 \u03c0\u03b1\u03c1\u03b1\u03b4\u03b5\u03af\u03b3\u03bc\u03b1\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c0\u03c4\u03ce\u03c3\u03b5\u03b9\u03c2 \u03c7\u03c1\u03ae\u03c3\u03b7\u03c2. \u0391\u03c0\u03cc \u03c4\u03bf \u03b5\u03c0\u03af\u03c0\u03b5\u03b4\u03bf \u03c4\u03bf\u03c5 \u03b1\u03c1\u03c7\u03ac\u03c1\u03b9\u03bf\u03c5 \u03ad\u03c9\u03c2 \u03c4\u03bf \u03c0\u03c1\u03bf\u03c7\u03c9\u03c1\u03b7\u03bc\u03ad\u03bd\u03bf, \u03c3\u03af\u03b3\u03bf\u03c5\u03c1\u03b1 \u03b8\u03b1 \u03b2\u03c1\u03b5\u03af\u03c4\u03b5 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03b4\u03b5\u03bd \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03b1\u03ba\u03cc\u03bc\u03b7 \u2014 \u03ba\u03b1\u03b9 \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03b1\u03bb\u03bb\u03ac\u03be\u03bf\u03c5\u03bd \u03c4\u03b7 \u03b6\u03c9\u03ae.<\/p>\n<h3>\u03a0\u03b5\u03c1\u03b9\u03b5\u03c7\u03cc\u03bc\u03b5\u03bd\u03b1<\/h3>\n<ul>\n<li><a href=\"#xl-bases\">1. \u039f\u03b9 5 \u03b1\u03c0\u03b1\u03c1\u03b1\u03af\u03c4\u03b7\u03c4\u03b5\u03c2 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/a><\/li>\n<li><a href=\"#xl-inter\">2. \u039f\u03b9 5 \u03b5\u03bd\u03b4\u03b9\u03ac\u03bc\u03b5\u03c3\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bd \u03c4\u03b7 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ac<\/a><\/li>\n<li><a href=\"#xl-avance\">3. \u039f\u03b9 5 \u03c0\u03c1\u03bf\u03b7\u03b3\u03bc\u03ad\u03bd\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03b5\u03bd\u03c4\u03c5\u03c0\u03c9\u03c3\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd<\/a><\/li>\n<li><a href=\"#xl-astuces\">4. \u0395\u03c0\u03b9\u03c0\u03bb\u03ad\u03bf\u03bd \u03c3\u03c5\u03bc\u03b2\u03bf\u03c5\u03bb\u03ad\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b1\u03c7\u03cd\u03c4\u03b5\u03c1\u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1<\/a><\/li>\n<li><a href=\"#xl-version\">5. \u03a0\u03bf\u03b9\u03b1 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel \u03bd\u03b1 \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03c4\u03b5;<\/a><\/li>\n<li><a href=\"#xl-faq\">6. \u03a3\u03c5\u03c7\u03bd\u03ad\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/a><\/li>\n<\/ul>\n<h2 id=\"xl-bases\">1. \u039f\u03b9 5 \u03b1\u03c0\u03b1\u03c1\u03b1\u03af\u03c4\u03b7\u03c4\u03b5\u03c2 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/h2>\n<h3>1. SUM \u2014 \u0386\u03b8\u03c1\u03bf\u03b9\u03c3\u03b7 \u03c4\u03b9\u03bc\u03ce\u03bd<\/h3>\n<p>\u0397 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u03bc\u03b5 \u03c4\u03b7 \u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c3\u03c4\u03bf Excel. \u0391\u03b8\u03c1\u03bf\u03af\u03b6\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae \u03ba\u03b5\u03bb\u03b9\u03ce\u03bd.<\/p>\n<p><code>=SUM(A1:A10)<\/code> \u2192 \u0391\u03b8\u03c1\u03bf\u03af\u03b6\u03b5\u03b9 \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03b1\u03c0\u03cc \u03c4\u03bf A1 \u03ad\u03c9\u03c2 \u03c4\u03bf A10<\/p>\n<p><strong>\u03a3\u03c5\u03bc\u03b2\u03bf\u03c5\u03bb\u03ae<\/strong>: \u03b7 \u03c3\u03c5\u03bd\u03c4\u03cc\u03bc\u03b5\u03c5\u03c3\u03b7 <code>Alt + =<\/code> \u03b5\u03b9\u03c3\u03ac\u03b3\u03b5\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03ad\u03bd\u03b1\u03bd \u03c4\u03cd\u03c0\u03bf SUM \u03c3\u03c4\u03b7\u03bd \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ae. \u0395\u03af\u03bd\u03b1\u03b9 \u03b7 \u03bd\u03bf\u03cd\u03bc\u03b5\u03c1\u03bf 1 \u03c3\u03c5\u03bd\u03c4\u03cc\u03bc\u03b5\u03c5\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel \u03c0\u03bf\u03c5 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5.<\/p>\n<h3>2. AVERAGE \u2014 \u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03cc\u03c2 \u03bc\u03ad\u03c3\u03bf\u03c5 \u03cc\u03c1\u03bf\u03c5<\/h3>\n<p>\u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03b7\u03c4\u03b9\u03ba\u03cc \u03bc\u03ad\u03c3\u03bf \u03cc\u03c1\u03bf \u03bc\u03b9\u03b1\u03c2 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae\u03c2 \u03c4\u03b9\u03bc\u03ce\u03bd.<\/p>\n<p><code>=AVERAGE(B2:B50)<\/code> \u2192 \u039c\u03ad\u03c3\u03bf\u03c2 \u03cc\u03c1\u03bf\u03c2 \u03b2\u03b1\u03b8\u03bc\u03bf\u03bb\u03bf\u03b3\u03b9\u03ce\u03bd, \u03bc\u03ad\u03c3\u03bf\u03c2 \u03cc\u03c1\u03bf\u03c2 \u03c0\u03c9\u03bb\u03ae\u03c3\u03b5\u03c9\u03bd \u03ba.\u03bb\u03c0.<\/p>\n<p><strong>\u03a7\u03c1\u03ae\u03c3\u03b9\u03bc\u03b7 \u03c0\u03b1\u03c1\u03b1\u03bb\u03bb\u03b1\u03b3\u03ae<\/strong>: \u03b7 <code>AVERAGEIF<\/code> \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03bc\u03ad\u03c3\u03bf \u03cc\u03c1\u03bf \u03bc\u03cc\u03bd\u03bf \u03c4\u03c9\u03bd \u03ba\u03b5\u03bb\u03b9\u03ce\u03bd \u03c0\u03bf\u03c5 \u03c0\u03bb\u03b7\u03c1\u03bf\u03cd\u03bd \u03bc\u03b9\u03b1 \u03c3\u03c5\u03bd\u03b8\u03ae\u03ba\u03b7. \u0393\u03b9\u03b1 \u03c0\u03b1\u03c1\u03ac\u03b4\u03b5\u03b9\u03b3\u03bc\u03b1: <code>=AVERAGEIF(A2:A50,\"London\",B2:B50)<\/code> \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03bc\u03ad\u03c3\u03bf \u03cc\u03c1\u03bf \u03c0\u03c9\u03bb\u03ae\u03c3\u03b5\u03c9\u03bd \u03bc\u03cc\u03bd\u03bf \u03b3\u03b9\u03b1 \u03c4\u03bf London.<\/p>\n<h3>3. COUNTIF \u2014 \u039a\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03bc\u03b5 \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03b1<\/h3>\n<p>\u039c\u03b5\u03c4\u03c1\u03ac \u03c4\u03bf \u03c0\u03bb\u03ae\u03b8\u03bf\u03c2 \u03c4\u03c9\u03bd \u03ba\u03b5\u03bb\u03b9\u03ce\u03bd \u03c0\u03bf\u03c5 \u03b1\u03bd\u03c4\u03b9\u03c3\u03c4\u03bf\u03b9\u03c7\u03bf\u03cd\u03bd \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03bf \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03bf.<\/p>\n<p><code>=COUNTIF(C2:C100,\"Paid\")<\/code> \u2192 \u039c\u03b5\u03c4\u03c1\u03ac \u03c0\u03cc\u03c3\u03b1 \u03c4\u03b9\u03bc\u03bf\u03bb\u03cc\u03b3\u03b9\u03b1 \u03ad\u03c7\u03bf\u03c5\u03bd \u03c4\u03b7\u03bd \u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7 \u00abPaid\u00bb<\/p>\n<p><code>=COUNTIF(D2:D100,\"&gt;1000\")<\/code> \u2192 \u039c\u03b5\u03c4\u03c1\u03ac \u03c0\u03cc\u03c3\u03b1 \u03c0\u03bf\u03c3\u03ac \u03be\u03b5\u03c0\u03b5\u03c1\u03bd\u03bf\u03cd\u03bd \u03c4\u03b1 1000\u20ac<\/p>\n<p><strong>\u03a0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7\u03c2<\/strong>: \u03c0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03cd\u03b8\u03b7\u03c3\u03b7 \u03c4\u03b9\u03bc\u03bf\u03bb\u03bf\u03b3\u03af\u03c9\u03bd, \u03ba\u03b1\u03c4\u03b1\u03bc\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03b9\u03ce\u03bd \u03b1\u03bd\u03ac \u03ba\u03b1\u03c4\u03ac\u03c3\u03c4\u03b1\u03c3\u03b7, \u03b1\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7 \u03b5\u03c1\u03b5\u03c5\u03bd\u03ce\u03bd.<\/p>\n<h3>4. IF \u2014 \u039b\u03bf\u03b3\u03b9\u03ba\u03ae \u03bc\u03b5 \u03c3\u03c5\u03bd\u03b8\u03ae\u03ba\u03b5\u03c2<\/h3>\n<p>\u0397 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 IF \u03b5\u03af\u03bd\u03b1\u03b9 \u03bf \u03b5\u03b3\u03ba\u03ad\u03c6\u03b1\u03bb\u03bf\u03c2 \u03c4\u03bf\u03c5 Excel. \u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03cc \u03b1\u03c0\u03bf\u03c4\u03ad\u03bb\u03b5\u03c3\u03bc\u03b1 \u03b1\u03bd\u03ac\u03bb\u03bf\u03b3\u03b1 \u03bc\u03b5 \u03c4\u03bf \u03b1\u03bd \u03bc\u03b9\u03b1 \u03c3\u03c5\u03bd\u03b8\u03ae\u03ba\u03b7 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b1\u03bb\u03b7\u03b8\u03ae\u03c2 \u03ae \u03c8\u03b5\u03c5\u03b4\u03ae\u03c2.<\/p>\n<p><code>=IF(A1&gt;=10,\"Passed\",\"Failed\")<\/code><\/p>\n<p><strong>\u0388\u03bd\u03b8\u03b5\u03c3\u03b7<\/strong>: \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03ce\u03c3\u03b5\u03c4\u03b5 \u03c0\u03bf\u03bb\u03bb\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 IF \u03c4\u03b7 \u03bc\u03af\u03b1 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03b7\u03bd \u03ac\u03bb\u03bb\u03b7 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03b1\u03bb\u03cd\u03c8\u03b5\u03c4\u03b5 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c0\u03c4\u03ce\u03c3\u03b5\u03b9\u03c2, \u03b1\u03bb\u03bb\u03ac \u03c0\u03ad\u03c1\u03b1 \u03b1\u03c0\u03cc 3 \u03b5\u03c0\u03af\u03c0\u03b5\u03b4\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03ba\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b1 \u03c4\u03b7\u03bd <code>IFS<\/code> (Excel 2024), \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03c5\u03b1\u03bd\u03ac\u03b3\u03bd\u03c9\u03c3\u03c4\u03b7.<\/p>\n<h3>5. CONCATENATE \/ CONCAT \u2014 \u0388\u03bd\u03c9\u03c3\u03b7 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5<\/h3>\n<p>\u03a3\u03c5\u03b3\u03c7\u03c9\u03bd\u03b5\u03cd\u03b5\u03b9 \u03c0\u03bf\u03bb\u03bb\u03ac \u03ba\u03b5\u03bb\u03b9\u03ac \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03c3\u03b5 \u03ad\u03bd\u03b1.<\/p>\n<p><code>=CONCAT(A1,\" \",B1)<\/code> \u2192 \u03a3\u03c5\u03b3\u03c7\u03c9\u03bd\u03b5\u03cd\u03b5\u03b9 \u03c4\u03bf \u03cc\u03bd\u03bf\u03bc\u03b1 \u03ba\u03b1\u03b9 \u03c4\u03bf \u03b5\u03c0\u03ce\u03bd\u03c5\u03bc\u03bf \u03bc\u03b5 \u03ad\u03bd\u03b1 \u03ba\u03b5\u03bd\u03cc \u03b4\u03b9\u03ac\u03c3\u03c4\u03b7\u03bc\u03b1<\/p>\n<p><strong>\u03a3\u03cd\u03b3\u03c7\u03c1\u03bf\u03bd\u03b7 \u03b5\u03bd\u03b1\u03bb\u03bb\u03b1\u03ba\u03c4\u03b9\u03ba\u03ae<\/strong>: \u03bf \u03c4\u03b5\u03bb\u03b5\u03c3\u03c4\u03ae\u03c2 <code>&amp;<\/code> \u03ba\u03ac\u03bd\u03b5\u03b9 \u03c4\u03bf \u03af\u03b4\u03b9\u03bf \u03c0\u03c1\u03ac\u03b3\u03bc\u03b1: <code>=A1&amp;\" \"&amp;B1<\/code>. \u0393\u03c1\u03ac\u03c6\u03b5\u03c4\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1.<\/p>\n<h2 id=\"xl-inter\">2. \u039f\u03b9 5 \u03b5\u03bd\u03b4\u03b9\u03ac\u03bc\u03b5\u03c3\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03ba\u03ac\u03bd\u03bf\u03c5\u03bd \u03c4\u03b7 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ac<\/h2>\n<h3>6. VLOOKUP \u2014 \u0391\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7 \u03c4\u03b9\u03bc\u03ae\u03c2 \u03c3\u03b5 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1<\/h3>\n<p>\u03a4\u03bf \u03b1\u03c3\u03c4\u03ad\u03c1\u03b9 \u03c4\u03c9\u03bd \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd \u03c4\u03bf\u03c5 Excel \u03c3\u03c4\u03bf\u03bd \u03b5\u03c0\u03b1\u03b3\u03b3\u03b5\u03bb\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03c7\u03ce\u03c1\u03bf. \u0397 VLOOKUP \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ac \u03bc\u03b9\u03b1 \u03c4\u03b9\u03bc\u03ae \u03c3\u03c4\u03b7\u03bd \u03c0\u03c1\u03ce\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03b5\u03bd\u03cc\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03b1\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03b7 \u03c4\u03b9\u03bc\u03ae \u03b1\u03c0\u03cc \u03bc\u03b9\u03b1 \u03ac\u03bb\u03bb\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7.<\/p>\n<p><code>=VLOOKUP(E2,A:D,3,FALSE)<\/code> \u2192 \u0391\u03bd\u03b1\u03b6\u03b7\u03c4\u03ac \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae \u03c4\u03bf\u03c5 E2 \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 A \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd 3\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7<\/p>\n<p><strong>\u03a3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03bf \u03c0\u03b1\u03c1\u03ac\u03b4\u03b5\u03b9\u03b3\u03bc\u03b1<\/strong>: \u03ad\u03c7\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1\u03bd \u03c4\u03b9\u03bc\u03bf\u03ba\u03b1\u03c4\u03ac\u03bb\u03bf\u03b3\u03bf \u03bc\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03ba\u03c9\u03b4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03c0\u03c1\u03bf\u03ca\u03cc\u03bd\u03c4\u03c9\u03bd \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 A \u03ba\u03b1\u03b9 \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03c3\u03c4\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7 C. \u0397 VLOOKUP \u03c3\u03b1\u03c2 \u03b5\u03c0\u03b9\u03c4\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03c0\u03bb\u03b7\u03ba\u03c4\u03c1\u03bf\u03bb\u03bf\u03b3\u03ae\u03c3\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1\u03bd \u03ba\u03c9\u03b4\u03b9\u03ba\u03cc \u03bf\u03c0\u03bf\u03c5\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03bb\u03ac\u03b2\u03b5\u03c4\u03b5 \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03c4\u03b7\u03bd \u03b1\u03bd\u03c4\u03af\u03c3\u03c4\u03bf\u03b9\u03c7\u03b7 \u03c4\u03b9\u03bc\u03ae.<\/p>\n<h3>7. XLOOKUP \u2014 \u0397 \u03c3\u03cd\u03b3\u03c7\u03c1\u03bf\u03bd\u03b7 \u03b5\u03ba\u03b4\u03bf\u03c7\u03ae \u03c4\u03b7\u03c2 VLOOKUP<\/h3>\n<p>\u0394\u03b9\u03b1\u03b8\u03ad\u03c3\u03b9\u03bc\u03b7 \u03c3\u03c4\u03bf <strong>Office 2024 \u03ba\u03b1\u03b9 \u03c3\u03c4\u03bf Microsoft 365<\/strong>, \u03b7 XLOOKUP \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03af \u03c3\u03b1\u03c6\u03ae \u03b1\u03bd\u03b1\u03b2\u03ac\u03b8\u03bc\u03b9\u03c3\u03b7 \u03c3\u03b5 \u03c3\u03c7\u03ad\u03c3\u03b7 \u03bc\u03b5 \u03c4\u03b7 VLOOKUP:<\/p>\n<p><code>=XLOOKUP(E2,A2:A100,C2:C100,\"Not found\")<\/code><\/p>\n<p><strong>\u03a0\u03bb\u03b5\u03bf\u03bd\u03b5\u03ba\u03c4\u03ae\u03bc\u03b1\u03c4\u03b1 \u03ad\u03bd\u03b1\u03bd\u03c4\u03b9 \u03c4\u03b7\u03c2 VLOOKUP<\/strong>: \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9 \u03c0\u03c1\u03bf\u03c2 \u03bf\u03c0\u03bf\u03b9\u03b1\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03ba\u03b1\u03c4\u03b5\u03cd\u03b8\u03c5\u03bd\u03c3\u03b7 (\u03cc\u03c7\u03b9 \u03bc\u03cc\u03bd\u03bf \u03b1\u03c0\u03cc \u03b1\u03c1\u03b9\u03c3\u03c4\u03b5\u03c1\u03ac \u03c0\u03c1\u03bf\u03c2 \u03c4\u03b1 \u03b4\u03b5\u03be\u03b9\u03ac), \u03b4\u03b9\u03b1\u03c7\u03b5\u03b9\u03c1\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03b5\u03b3\u03b3\u03b5\u03bd\u03ce\u03c2 \u03c4\u03b1 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1\u03c4\u03b1 \u03bc\u03b5 \u03bc\u03b9\u03b1 \u03c0\u03b1\u03c1\u03ac\u03bc\u03b5\u03c4\u03c1\u03bf \u00ab\u03c4\u03b9\u03bc\u03ae \u03b1\u03bd \u03b4\u03b5\u03bd \u03b2\u03c1\u03b5\u03b8\u03b5\u03af\u00bb \u03ba\u03b1\u03b9 \u03ad\u03c7\u03b5\u03b9 \u03c0\u03b9\u03bf \u03b4\u03b9\u03b1\u03b9\u03c3\u03b8\u03b7\u03c4\u03b9\u03ba\u03ae \u03c3\u03cd\u03bd\u03c4\u03b1\u03be\u03b7. \u0391\u03bd \u03b4\u03b9\u03b1\u03b8\u03ad\u03c4\u03b5\u03c4\u03b5 <a href=\"https:\/\/euroshopkey.com\/el\/product\/office-2024-professionnel-plus\/\">Office 2024<\/a>, \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03c4\u03b5 \u03c0\u03b1\u03bd\u03c4\u03bf\u03cd \u03c4\u03b7\u03bd XLOOKUP.<\/p>\n<h3>8. SUMIFS \u2014 \u0386\u03b8\u03c1\u03bf\u03b9\u03c3\u03bc\u03b1 \u03bc\u03b5 \u03c0\u03bf\u03bb\u03bb\u03b1\u03c0\u03bb\u03ac \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03b1<\/h3>\n<p>\u0391\u03b8\u03c1\u03bf\u03af\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03c0\u03bb\u03b7\u03c1\u03bf\u03cd\u03bd \u03c4\u03b1\u03c5\u03c4\u03cc\u03c7\u03c1\u03bf\u03bd\u03b1 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b1 \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03b1.<\/p>\n<p><code>=SUMIFS(D2:D100,A2:A100,\"London\",B2:B100,\"2026\")<\/code><\/p>\n<p>\u2192 \u0386\u03b8\u03c1\u03bf\u03b9\u03c3\u03bc\u03b1 \u03c4\u03c9\u03bd \u03c0\u03bf\u03c3\u03ce\u03bd (\u03c3\u03c4\u03ae\u03bb\u03b7 D) \u03bc\u03cc\u03bd\u03bf \u03b3\u03b9\u03b1 \u03c4\u03b9\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2 \u03cc\u03c0\u03bf\u03c5 \u03b7 \u03c0\u03cc\u03bb\u03b7 \u03b5\u03af\u03bd\u03b1\u03b9 London \u039a\u0391\u0399 \u03c4\u03bf \u03ad\u03c4\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 2026.<\/p>\n<h3>9. TEXT \u2014 \u039c\u03bf\u03c1\u03c6\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b1\u03c1\u03b9\u03b8\u03bc\u03ce\u03bd \u03c9\u03c2 \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf<\/h3>\n<p>\u039c\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c0\u03b5\u03b9 \u03ad\u03bd\u03b1\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c3\u03b5 \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf \u03bc\u03b5 \u03c0\u03c1\u03bf\u03c3\u03b1\u03c1\u03bc\u03bf\u03c3\u03bc\u03ad\u03bd\u03b7 \u03bc\u03bf\u03c1\u03c6\u03ae.<\/p>\n<p><code>=TEXT(A1,\"#,##0.00 \u20ac\")<\/code> \u2192 \u0395\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u00ab1,234.56 \u20ac\u00bb<\/p>\n<p><code>=TEXT(A1,\"dddd d mmmm yyyy\")<\/code> \u2192 \u0395\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u00ab\u0394\u03b5\u03c5\u03c4\u03ad\u03c1\u03b1 6 \u03a6\u03b5\u03b2\u03c1\u03bf\u03c5\u03b1\u03c1\u03af\u03bf\u03c5 2026\u00bb<\/p>\n<p><strong>\u03a0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7\u03c2<\/strong>: \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03c9\u03bd \u03c0\u03c1\u03bf\u03c4\u03ac\u03c3\u03b5\u03c9\u03bd (\u00ab\u03a4\u03b9\u03bc\u03bf\u03bb\u03cc\u03b3\u03b9\u03bf \u03bc\u03b5 \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1 \u0394\u03b5\u03c5\u03c4\u03ad\u03c1\u03b1 6 \u03a6\u03b5\u03b2\u03c1\u03bf\u03c5\u03b1\u03c1\u03af\u03bf\u03c5 2026\u00bb), \u03bc\u03bf\u03c1\u03c6\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03ba\u03b1\u03b8\u03b1\u03c1\u03ce\u03bd \u03b5\u03be\u03b1\u03b3\u03c9\u03b3\u03ce\u03bd.<\/p>\n<h3>10. \u03a3\u03a5\u0393\u039a\u0395\u039d\u03a4\u03a1\u03a9\u03a4\u0399\u039a\u039f\u03a3 \u03a0\u0399\u039d\u0391\u039a\u0391\u03a3<\/h3>\n<p>\u0394\u03b5\u03bd \u03c0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c3\u03c4\u03b7\u03c1\u03ac \u03b3\u03b9\u03b1 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7, \u03b1\u03bb\u03bb\u03ac \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03b9\u03c3\u03c7\u03c5\u03c1\u03cc\u03c4\u03b5\u03c1\u03bf \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03c4\u03bf\u03c5 Excel. \u0388\u03bd\u03b1\u03c2 \u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03cc\u03c2 \u03a0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2 \u03c3\u03c5\u03bd\u03bf\u03c8\u03af\u03b6\u03b5\u03b9 \u03ba\u03b1\u03b9 \u03b1\u03bd\u03b1\u03bb\u03cd\u03b5\u03b9 \u03ac\u03bc\u03b5\u03c3\u03b1 \u03c7\u03b9\u03bb\u03b9\u03ac\u03b4\u03b5\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b5 \u03ad\u03bd\u03b1\u03bd \u03c3\u03c5\u03bd\u03bf\u03c0\u03c4\u03b9\u03ba\u03cc \u03c0\u03af\u03bd\u03b1\u03ba\u03b1.<\/p>\n<p><strong>\u03a0\u03ce\u03c2 \u03bd\u03b1 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03ae\u03c3\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1\u03bd \u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03cc \u03a0\u03af\u03bd\u03b1\u03ba\u03b1<\/strong>: \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03c4\u03b5 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b1\u03c2 \u2192 \u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03ae \u2192 \u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03cc\u03c2 \u03a0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2 \u2192 \u03c3\u03cd\u03c1\u03b5\u03c4\u03b5 \u03ba\u03b1\u03b9 \u03b1\u03c0\u03bf\u03b8\u03ad\u03c3\u03c4\u03b5 \u03c4\u03b1 \u03c0\u03b5\u03b4\u03af\u03b1 \u03c3\u03c4\u03b9\u03c2 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ad\u03c2 \u0393\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2, \u03a3\u03c4\u03ae\u03bb\u03b5\u03c2 \u03ba\u03b1\u03b9 \u03a4\u03b9\u03bc\u03ad\u03c2.<\/p>\n<p><strong>\u03a0\u03b1\u03c1\u03ac\u03b4\u03b5\u03b9\u03b3\u03bc\u03b1<\/strong>: \u03b1\u03c0\u03cc \u03ad\u03bd\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03bf 10.000 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ce\u03bd \u03c0\u03c9\u03bb\u03ae\u03c3\u03b5\u03c9\u03bd, \u03ad\u03bd\u03b1\u03c2 \u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03cc\u03c2 \u03a0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2 \u03c3\u03ac\u03c2 \u03b4\u03b5\u03af\u03c7\u03bd\u03b5\u03b9 \u03c3\u03b5 30 \u03b4\u03b5\u03c5\u03c4\u03b5\u03c1\u03cc\u03bb\u03b5\u03c0\u03c4\u03b1 \u03c4\u03bf\u03bd \u03c4\u03b6\u03af\u03c1\u03bf \u03b1\u03bd\u03ac \u03bc\u03ae\u03bd\u03b1, \u03b1\u03bd\u03ac \u03c0\u03c9\u03bb\u03b7\u03c4\u03ae, \u03b1\u03bd\u03ac \u03c0\u03c1\u03bf\u03ca\u03cc\u03bd \u2014 \u03bc\u03b5 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03bc\u03b5\u03c1\u03b9\u03ba\u03ac \u03c3\u03cd\u03bd\u03bf\u03bb\u03b1.<\/p>\n<h2 id=\"xl-avance\">3. \u039f\u03b9 5 \u03c0\u03c1\u03bf\u03b7\u03b3\u03bc\u03ad\u03bd\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03b5\u03bd\u03c4\u03c5\u03c0\u03c9\u03c3\u03b9\u03ac\u03b6\u03bf\u03c5\u03bd<\/h2>\n<h3>11. INDEX + MATCH \u2014 \u039f \u03b1\u03c0\u03cc\u03bb\u03c5\u03c4\u03bf\u03c2 \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc\u03c2<\/h3>\n<p>\u03a0\u03b9\u03bf \u03b5\u03c5\u03ad\u03bb\u03b9\u03ba\u03c4\u03bf\u03c2 \u03b1\u03c0\u03cc \u03c4\u03b7 VLOOKUP, \u03bf \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc\u03c2 INDEX + MATCH \u03b5\u03c0\u03b9\u03c4\u03c1\u03ad\u03c0\u03b5\u03b9 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03c1\u03bf\u03c2 \u03ba\u03ac\u03b8\u03b5 \u03ba\u03b1\u03c4\u03b5\u03cd\u03b8\u03c5\u03bd\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03bc\u03b5 \u03c0\u03bf\u03bb\u03bb\u03b1\u03c0\u03bb\u03ac \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03b1.<\/p>\n<p><code>=INDEX(C2:C100,MATCH(E2,A2:A100,0))<\/code><\/p>\n<p>\u0397 MATCH \u03b5\u03bd\u03c4\u03bf\u03c0\u03af\u03b6\u03b5\u03b9 \u03c4\u03b7 \u03b8\u03ad\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03c4\u03b9\u03bc\u03ae\u03c2 \u03c0\u03bf\u03c5 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ac\u03c4\u03b5 \u03ba\u03b1\u03b9 \u03b7 INDEX \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae \u03c3\u03b5 \u03b1\u03c5\u03c4\u03ae \u03c4\u03b7 \u03b8\u03ad\u03c3\u03b7 \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03ac\u03bb\u03bb\u03b7 \u03c3\u03c4\u03ae\u03bb\u03b7. \u03a0\u03b9\u03bf \u03c3\u03cd\u03bd\u03b8\u03b5\u03c4\u03bf \u03c3\u03c4\u03b7 \u03c3\u03cd\u03bd\u03c4\u03b1\u03be\u03b7, \u03b1\u03bb\u03bb\u03ac \u03c0\u03bf\u03bb\u03cd \u03c0\u03b9\u03bf \u03b9\u03c3\u03c7\u03c5\u03c1\u03cc.<\/p>\n<h3>12. IFERROR \u2014 \u039a\u03b1\u03b8\u03b1\u03c1\u03ae \u03b4\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7 \u03c3\u03c6\u03b1\u03bb\u03bc\u03ac\u03c4\u03c9\u03bd<\/h3>\n<p>\u03a0\u03b5\u03c1\u03b9\u03b2\u03ac\u03bb\u03bb\u03b5\u03b9 \u03ad\u03bd\u03b1\u03bd \u03c4\u03cd\u03c0\u03bf \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03c0\u03c1\u03bf\u03c3\u03b1\u03c1\u03bc\u03bf\u03c3\u03bc\u03ad\u03bd\u03b7 \u03c4\u03b9\u03bc\u03ae \u03c3\u03b5 \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1\u03c4\u03bf\u03c2 (\u03b1\u03bd\u03c4\u03af \u03bd\u03b1 \u03b5\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 #N\/A \u03ae #DIV\/0!).<\/p>\n<p><code>=IFERROR(VLOOKUP(A1,Data,2,FALSE),\"Unknown reference\")<\/code><\/p>\n<p><strong>\u0391\u03c0\u03b1\u03c1\u03b1\u03af\u03c4\u03b7\u03c4\u03b7<\/strong> \u03b3\u03b9\u03b1 \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03ba\u03b1\u03b9 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2 \u03c0\u03bf\u03c5 \u03bc\u03bf\u03b9\u03c1\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03bc\u03b5 \u03c3\u03c5\u03bd\u03b1\u03b4\u03ad\u03bb\u03c6\u03bf\u03c5\u03c2 \u2014 \u03ba\u03b1\u03bd\u03b5\u03af\u03c2 \u03b4\u03b5\u03bd \u03b8\u03ad\u03bb\u03b5\u03b9 \u03bd\u03b1 \u03b2\u03bb\u03ad\u03c0\u03b5\u03b9 \u03c0\u03b1\u03bd\u03c4\u03bf\u03cd #N\/A.<\/p>\n<h3>13. FILTER (Office 2024 \/ 365)<\/h3>\n<p>\u0395\u03be\u03ac\u03b3\u03b5\u03b9 \u03b4\u03c5\u03bd\u03b1\u03bc\u03b9\u03ba\u03ac \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c0\u03bf\u03c5 \u03c0\u03bb\u03b7\u03c1\u03bf\u03cd\u03bd \u03ad\u03bd\u03b1 \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03bf, \u03c3\u03b5 \u03be\u03b5\u03c7\u03c9\u03c1\u03b9\u03c3\u03c4\u03ae \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae.<\/p>\n<p><code>=FILTER(A2:D100,C2:C100=\"London\",\"No results\")<\/code><\/p>\n<p>\u2192 \u0395\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2 \u03cc\u03c0\u03bf\u03c5 \u03b7 \u03c0\u03cc\u03bb\u03b7 \u03b5\u03af\u03bd\u03b1\u03b9 \u00abLondon\u00bb \u03ba\u03b1\u03b9 \u03b5\u03bd\u03b7\u03bc\u03b5\u03c1\u03ce\u03bd\u03b5\u03c4\u03b1\u03b9 \u03c3\u03b5 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03c7\u03c1\u03cc\u03bd\u03bf. \u0395\u03af\u03bd\u03b1\u03b9 \u03bc\u03b9\u03b1 \u03bc\u03af\u03bd\u03b9 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03ad\u03c3\u03b1 \u03c3\u03b5 \u03ad\u03bd\u03b1 \u03c6\u03cd\u03bb\u03bb\u03bf Excel. \u0394\u03b9\u03b1\u03b8\u03ad\u03c3\u03b9\u03bc\u03b7 \u03bc\u03cc\u03bd\u03bf \u03c3\u03c4\u03bf <a href=\"https:\/\/euroshopkey.com\/el\/microsoft-365-vs-office-2024-abonnement-ou-licence-perpetuelle\/\">Office 2024 \u03ba\u03b1\u03b9 \u03c3\u03c4\u03bf Microsoft 365<\/a>.<\/p>\n<h3>14. UNIQUE + SORT (Office 2024 \/ 365)<\/h3>\n<p>\u0397 UNIQUE \u03b5\u03be\u03ac\u03b3\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03bc\u03bf\u03bd\u03b1\u03b4\u03b9\u03ba\u03ad\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03b1\u03c0\u03cc \u03bc\u03b9\u03b1 \u03bb\u03af\u03c3\u03c4\u03b1 (\u03b1\u03c6\u03b1\u03b9\u03c1\u03b5\u03af \u03c4\u03b1 \u03b4\u03b9\u03c0\u03bb\u03cc\u03c4\u03c5\u03c0\u03b1). \u0397 SORT \u03c4\u03b9\u03c2 \u03c4\u03b1\u03be\u03b9\u03bd\u03bf\u03bc\u03b5\u03af.<\/p>\n<p><code>=SORT(UNIQUE(A2:A500))<\/code> \u2192 \u03a4\u03b1\u03be\u03b9\u03bd\u03bf\u03bc\u03b7\u03bc\u03ad\u03bd\u03b7 \u03bb\u03af\u03c3\u03c4\u03b1 \u03bc\u03b5 \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03bc\u03bf\u03bd\u03b1\u03b4\u03b9\u03ba\u03ad\u03c2 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03c4\u03b7\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b7\u03c2 A<\/p>\n<p>\u0399\u03b4\u03b1\u03bd\u03b9\u03ba\u03cc\u03c2 \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03b4\u03c5\u03bd\u03b1\u03bc\u03b9\u03ba\u03ce\u03bd \u03b1\u03bd\u03b1\u03c0\u03c4\u03c5\u03c3\u03c3\u03cc\u03bc\u03b5\u03bd\u03c9\u03bd \u03bb\u03b9\u03c3\u03c4\u03ce\u03bd \u03ae \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03b5\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c4\u03c9\u03bd \u03bc\u03bf\u03bd\u03b1\u03b4\u03b9\u03ba\u03ce\u03bd \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd \u03b1\u03c0\u03cc \u03ad\u03bd\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03b3\u03b5\u03bb\u03b9\u03ce\u03bd.<\/p>\n<h3>15. LET \u2014 \u039c\u03b5\u03c4\u03b1\u03b2\u03bb\u03b7\u03c4\u03ad\u03c2 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03c4\u03bf\u03c5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2 (Office 2024 \/ 365)<\/h3>\n<p>\u0397 LET \u03c3\u03ac\u03c2 \u03b5\u03c0\u03b9\u03c4\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03bf\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03bc\u03b5\u03c4\u03b1\u03b2\u03bb\u03b7\u03c4\u03ad\u03c2 \u03bc\u03ad\u03c3\u03b1 \u03c3\u03b5 \u03ad\u03bd\u03b1\u03bd \u03c4\u03cd\u03c0\u03bf, \u03ba\u03b1\u03b8\u03b9\u03c3\u03c4\u03ce\u03bd\u03c4\u03b1\u03c2 \u03c4\u03bf\u03c5\u03c2 \u03c3\u03cd\u03bd\u03b8\u03b5\u03c4\u03bf\u03c5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2 \u03b5\u03c5\u03b1\u03bd\u03ac\u03b3\u03bd\u03c9\u03c3\u03c4\u03bf\u03c5\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03b1\u03c7\u03cd\u03c4\u03b5\u03c1\u03bf\u03c5\u03c2.<\/p>\n<p><code>=LET(total,SUM(A:A),vat,total*0.2,total+vat)<\/code><\/p>\n<p>\u0391\u03bd\u03c4\u03af \u03bd\u03b1 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03c4\u03b5 \u03b4\u03cd\u03bf \u03c6\u03bf\u03c1\u03ad\u03c2 \u03c4\u03bf SUM(A:A), \u03c4\u03bf \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03c4\u03b5 \u03bc\u03af\u03b1 \u03c6\u03bf\u03c1\u03ac \u03ba\u03b1\u03b9 \u03c4\u03bf \u03b1\u03c0\u03bf\u03b8\u03b7\u03ba\u03b5\u03cd\u03b5\u03c4\u03b5 \u03c3\u03c4\u03b7 \u03bc\u03b5\u03c4\u03b1\u03b2\u03bb\u03b7\u03c4\u03ae \u00abtotal\u00bb. \u03a3\u03b5 \u03bc\u03b5\u03b3\u03ac\u03bb\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03b1, \u03b1\u03c5\u03c4\u03cc \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b1\u03c7\u03cd\u03c4\u03b7\u03c4\u03b1 \u03c4\u03c9\u03bd \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03ce\u03bd.<\/p>\n<h2 id=\"xl-astuces\">4. \u0395\u03c0\u03b9\u03c0\u03bb\u03ad\u03bf\u03bd \u03c3\u03c5\u03bc\u03b2\u03bf\u03c5\u03bb\u03ad\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b1\u03c7\u03cd\u03c4\u03b5\u03c1\u03b7 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1<\/h2>\n<h3>\u0391\u03c0\u03b1\u03c1\u03b1\u03af\u03c4\u03b7\u03c4\u03b5\u03c2 \u03c3\u03c5\u03bd\u03c4\u03bf\u03bc\u03b5\u03cd\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bb\u03b7\u03ba\u03c4\u03c1\u03bf\u03bb\u03bf\u03b3\u03af\u03bf\u03c5<\/h3>\n<table>\n<thead>\n<tr>\n<th>\u03a3\u03c5\u03bd\u03c4\u03cc\u03bc\u03b5\u03c5\u03c3\u03b7<\/th>\n<th>\u0395\u03bd\u03ad\u03c1\u03b3\u03b5\u03b9\u03b1<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Ctrl + Shift + L<\/td>\n<td>\u0395\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7\/\u03b1\u03c0\u03b5\u03bd\u03b5\u03c1\u03b3\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03bf\u03c5 \u03c6\u03af\u03bb\u03c4\u03c1\u03bf\u03c5<\/td>\n<\/tr>\n<tr>\n<td>Ctrl + T<\/td>\n<td>\u039c\u03b5\u03c4\u03b1\u03c4\u03c1\u03bf\u03c0\u03ae \u03c3\u03b5 \u03b4\u03bf\u03bc\u03b7\u03bc\u03ad\u03bd\u03bf \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 (\u03c0\u03bf\u03bb\u03cd \u03c7\u03c1\u03ae\u03c3\u03b9\u03bc\u03bf!)<\/td>\n<\/tr>\n<tr>\n<td>Ctrl + ;<\/td>\n<td>\u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03ae \u03c4\u03b7\u03c2 \u03c3\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ae\u03c2 \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1\u03c2<\/td>\n<\/tr>\n<tr>\n<td>Ctrl + Shift + :<\/td>\n<td>\u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03ae \u03c4\u03b7\u03c2 \u03c4\u03c1\u03ad\u03c7\u03bf\u03c5\u03c3\u03b1\u03c2 \u03ce\u03c1\u03b1\u03c2<\/td>\n<\/tr>\n<tr>\n<td>Alt + =<\/td>\n<td>\u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u03b5\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03ae \u03b1\u03b8\u03c1\u03bf\u03af\u03c3\u03bc\u03b1\u03c4\u03bf\u03c2 SUM<\/td>\n<\/tr>\n<tr>\n<td>F4<\/td>\n<td>\u0395\u03bd\u03b1\u03bb\u03bb\u03b1\u03b3\u03ae \u03bc\u03b5\u03c4\u03b1\u03be\u03cd \u03c3\u03c7\u03b5\u03c4\u03b9\u03ba\u03ce\u03bd \u03ba\u03b1\u03b9 \u03b1\u03c0\u03cc\u03bb\u03c5\u03c4\u03c9\u03bd \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ce\u03bd ($)<\/td>\n<\/tr>\n<tr>\n<td>Ctrl + Shift + +<\/td>\n<td>\u0395\u03b9\u03c3\u03b1\u03b3\u03c9\u03b3\u03ae \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae\u03c2\/\u03c3\u03c4\u03ae\u03bb\u03b7\u03c2<\/td>\n<\/tr>\n<tr>\n<td>Ctrl + D<\/td>\n<td>\u0391\u03bd\u03c4\u03b9\u03b3\u03c1\u03b1\u03c6\u03ae \u03c4\u03bf\u03c5 \u03c0\u03b1\u03c1\u03b1\u03c0\u03ac\u03bd\u03c9 \u03ba\u03b5\u03bb\u03b9\u03bf\u03cd<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u039f \u03b4\u03bf\u03bc\u03b7\u03bc\u03ad\u03bd\u03bf\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2 (Ctrl + T)<\/h3>\n<p>\u0397 \u03bc\u03b5\u03c4\u03b1\u03c4\u03c1\u03bf\u03c0\u03ae \u03c4\u03c9\u03bd \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03c3\u03b1\u03c2 \u03c3\u03b5 \u03b4\u03bf\u03bc\u03b7\u03bc\u03ad\u03bd\u03bf \u03c0\u03af\u03bd\u03b1\u03ba\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c0\u03b9\u03bf \u03c5\u03c0\u03bf\u03c4\u03b9\u03bc\u03b7\u03bc\u03ad\u03bd\u03bf \u03ba\u03cc\u03bb\u03c0\u03bf \u03c4\u03bf\u03c5 Excel. \u03a4\u03b1 \u03bf\u03c6\u03ad\u03bb\u03b7 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03bf\u03bb\u03bb\u03ac: \u03bf\u03b9 \u03c4\u03cd\u03c0\u03bf\u03b9 \u03b3\u03af\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b5\u03c5\u03b1\u03bd\u03ac\u03b3\u03bd\u03c9\u03c3\u03c4\u03bf\u03b9 (\u03b1\u03bd\u03c4\u03af \u03b3\u03b9\u03b1 A2:A100 \u03b2\u03bb\u03ad\u03c0\u03b5\u03c4\u03b5 [\u038c\u03bd\u03bf\u03bc\u03b1\u03a3\u03c4\u03ae\u03bb\u03b7\u03c2]), \u03bf\u03b9 \u03bd\u03ad\u03b5\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2 \u03c3\u03c5\u03bc\u03c0\u03b5\u03c1\u03b9\u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1, \u03c4\u03bf \u03c3\u03c4\u03c5\u03bb \u03b5\u03c6\u03b1\u03c1\u03bc\u03cc\u03b6\u03b5\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03bf\u03b9 \u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03bf\u03af \u03a0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 \u03b5\u03bd\u03b7\u03bc\u03b5\u03c1\u03ce\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03c0\u03cc \u03bc\u03cc\u03bd\u03bf\u03b9 \u03c4\u03bf\u03c5\u03c2.<\/p>\n<h2 id=\"xl-version\">5. \u03a0\u03bf\u03b9\u03b1 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel \u03bd\u03b1 \u03b5\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03c4\u03b5;<\/h2>\n<table>\n<thead>\n<tr>\n<th>\u039b\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1<\/th>\n<th>Excel 2019<\/th>\n<th>Excel 2021<\/th>\n<th>Excel 2024<\/th>\n<th>Excel 365<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>VLOOKUP<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03bf\u03af \u03a0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>XLOOKUP<\/td>\n<td>\u274c<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>FILTER \/ SORT \/ UNIQUE<\/td>\n<td>\u274c<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>LET<\/td>\n<td>\u274c<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>Copilot AI<\/td>\n<td>\u274c<\/td>\n<td>\u274c<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u03a0\u03c1\u03bf\u03b7\u03b3\u03bc\u03ad\u03bd\u03bf Power Query<\/td>\n<td>\u26a0\ufe0f \u0392\u03b1\u03c3\u03b9\u03ba\u03cc<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>Python \u03c3\u03c4\u03bf Excel<\/td>\n<td>\u274c<\/td>\n<td>\u274c<\/td>\n<td>\u274c<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0393\u03b9\u03b1 \u03bd\u03b1 \u03ad\u03c7\u03b5\u03c4\u03b5 \u03c0\u03c1\u03cc\u03c3\u03b2\u03b1\u03c3\u03b7 \u03c3\u03b5 \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03c3\u03cd\u03b3\u03c7\u03c1\u03bf\u03bd\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 (XLOOKUP, FILTER, SORT, UNIQUE, LET), \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03c4\u03bf\u03c5\u03bb\u03ac\u03c7\u03b9\u03c3\u03c4\u03bf\u03bd <strong>Excel 2021<\/strong>. \u0393\u03b9\u03b1 \u03c4\u03bf Copilot AI \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd Python, \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 <a href=\"https:\/\/euroshopkey.com\/el\/product\/office-2024-professionnel-plus\/\">Excel 2024<\/a> \u03ae <a href=\"https:\/\/euroshopkey.com\/el\/product\/office-365-12-mois-5-appareils\/\">Microsoft 365<\/a>.<\/p>\n<h2 id=\"xl-faq\">6. \u03a3\u03c5\u03c7\u03bd\u03ad\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<\/h2>\n<h4>\u03a0\u03bf\u03b9\u03b1 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03c0\u03b9\u03bf \u03c7\u03c1\u03ae\u03c3\u03b9\u03bc\u03b7 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c0\u03c1\u03ce\u03c4\u03b7;<\/h4>\n<p>\u0397 VLOOKUP (\u03ae \u03b7 XLOOKUP \u03b1\u03bd \u03b4\u03b9\u03b1\u03b8\u03ad\u03c4\u03b5\u03c4\u03b5 Office 2024 \u03ba\u03b1\u03b9 \u03bd\u03b5\u03cc\u03c4\u03b5\u03c1\u03bf). \u0395\u03af\u03bd\u03b1\u03b9 \u03b7 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u03c0\u03bf\u03c5 \u03b5\u03be\u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b5\u03af \u03c4\u03bf\u03bd \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf \u03c7\u03c1\u03cc\u03bd\u03bf \u03c3\u03c4\u03b7\u03bd \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ae \u03b5\u03c0\u03b1\u03b3\u03b3\u03b5\u03bb\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1. \u039a\u03b1\u03c4\u03b1\u03c1\u03b3\u03b5\u03af \u03c4\u03b9\u03c2 \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03b5\u03c2 \u03b1\u03bd\u03c4\u03b9\u03b3\u03c1\u03b1\u03c6\u03ad\u03c2-\u03b5\u03c0\u03b9\u03ba\u03bf\u03bb\u03bb\u03ae\u03c3\u03b5\u03b9\u03c2 \u03b1\u03bd\u03ac\u03bc\u03b5\u03c3\u03b1 \u03c3\u03b5 \u03b4\u03cd\u03bf \u03c0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 \u03ba\u03b1\u03b9 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03b5\u03af \u03c4\u03b9\u03c2 \u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd.<\/p>\n<h4>\u03a5\u03c0\u03bf\u03c3\u03c4\u03b7\u03c1\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf Excel Online (\u03b4\u03c9\u03c1\u03b5\u03ac\u03bd) \u03b1\u03c5\u03c4\u03ad\u03c2 \u03c4\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2;<\/h4>\n<p>\u039f\u03b9 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 (SUM, IF, COUNTIF, VLOOKUP) \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03bf\u03cd\u03bd \u03c3\u03c4\u03bf Excel Online. \u038c\u03bc\u03c9\u03c2 \u03bf\u03b9 \u03c0\u03c1\u03bf\u03b7\u03b3\u03bc\u03ad\u03bd\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 (FILTER, UNIQUE, LET, Power Query) \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03b4\u03b9\u03b1\u03b8\u03ad\u03c3\u03b9\u03bc\u03b5\u03c2 \u03ae \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03b5\u03c2. \u0393\u03b9\u03b1 \u03b5\u03c0\u03b1\u03b3\u03b3\u03b5\u03bb\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03c7\u03c1\u03ae\u03c3\u03b7, \u03b7 \u03b5\u03c0\u03b9\u03c4\u03c1\u03b1\u03c0\u03ad\u03b6\u03b9\u03b1 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b1\u03c0\u03b1\u03c1\u03b1\u03af\u03c4\u03b7\u03c4\u03b7.<\/p>\n<h4>\u039c\u03c0\u03bf\u03c1\u03b5\u03af \u03c4\u03bf Google Sheets \u03bd\u03b1 \u03b1\u03bd\u03c4\u03b9\u03ba\u03b1\u03c4\u03b1\u03c3\u03c4\u03ae\u03c3\u03b5\u03b9 \u03c4\u03bf Excel;<\/h4>\n<p>\u0393\u03b9\u03b1 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ae \u03c7\u03c1\u03ae\u03c3\u03b7, \u03bd\u03b1\u03b9. \u038c\u03bc\u03c9\u03c2 \u03c4\u03bf Excel \u03c0\u03b1\u03c1\u03b1\u03bc\u03ad\u03bd\u03b5\u03b9 \u03b1\u03bd\u03ce\u03c4\u03b5\u03c1\u03bf \u03c3\u03b5 \u03b5\u03c0\u03b9\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03bc\u03b5 \u03bc\u03b5\u03b3\u03ac\u03bb\u03bf\u03c5\u03c2 \u03cc\u03b3\u03ba\u03bf\u03c5\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03b5 \u03bc\u03b1\u03ba\u03c1\u03bf\u03b5\u03bd\u03c4\u03bf\u03bb\u03ad\u03c2 VBA, \u03c3\u03b5 \u03c0\u03c1\u03bf\u03b7\u03b3\u03bc\u03ad\u03bd\u03bf\u03c5\u03c2 \u03a3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03a0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 \u03ba\u03b1\u03b9 \u03c3\u03b5 \u03b5\u03be\u03b5\u03b9\u03b4\u03b9\u03ba\u03b5\u03c5\u03bc\u03ad\u03bd\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2. \u0393\u03b9\u03b1 \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03b9\u03ba\u03ae \u03c3\u03cd\u03b3\u03ba\u03c1\u03b9\u03c3\u03b7, \u03b4\u03b9\u03b1\u03b2\u03ac\u03c3\u03c4\u03b5 \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03bc\u03b1\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b9\u03c2 <a href=\"https:\/\/euroshopkey.com\/el\/office-gratuit-alternatives-microsoft-office-2026\/\">\u03b5\u03bd\u03b1\u03bb\u03bb\u03b1\u03ba\u03c4\u03b9\u03ba\u03ad\u03c2 \u03bb\u03cd\u03c3\u03b5\u03b9\u03c2 \u03c3\u03c4\u03bf Microsoft Office<\/a>.<\/p>\n<h4>\u03a0\u03ce\u03c2 \u03bc\u03b1\u03b8\u03b1\u03af\u03bd\u03b5\u03b9 \u03ba\u03b1\u03bd\u03b5\u03af\u03c2 \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03c3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ac \u03c4\u03bf Excel;<\/h4>\n<p>\u0397 \u03ba\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03b5\u03be\u03ac\u03c3\u03ba\u03b7\u03c3\u03b7 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b1 \u03b4\u03b9\u03ba\u03ac \u03c3\u03b1\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1. \u03a0\u03ac\u03c1\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03b1\u03c1\u03c7\u03b5\u03af\u03bf \u03b1\u03c0\u03cc \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03ba\u03b1\u03b9 \u03c0\u03c1\u03bf\u03c3\u03c0\u03b1\u03b8\u03ae\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03bb\u03cd\u03c3\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03c0\u03c1\u03cc\u03b2\u03bb\u03b7\u03bc\u03b1 \u03bc\u03b5 \u03bc\u03b9\u03b1 \u03bd\u03ad\u03b1 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7. \u0395\u03af\u03bd\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03c3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03b1\u03c0\u03cc \u03bf\u03c0\u03bf\u03b9\u03bf\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 \u03b8\u03b5\u03c9\u03c1\u03b7\u03c4\u03b9\u03ba\u03cc \u03bc\u03ac\u03b8\u03b7\u03bc\u03b1.<\/p>\n<h4>\u0391\u03be\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf Excel 2024 \u03c3\u03b5 \u03c3\u03cd\u03b3\u03ba\u03c1\u03b9\u03c3\u03b7 \u03bc\u03b5 \u03c4\u03bf Excel 2021;<\/h4>\n<p>\u0391\u03bd \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03c4\u03bf Excel \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ac, \u03bd\u03b1\u03b9. \u03a4\u03bf Copilot AI \u03c3\u03ac\u03c2 \u03b5\u03be\u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b5\u03af \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03cc \u03c7\u03c1\u03cc\u03bd\u03bf \u03c3\u03c4\u03b7 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c4\u03cd\u03c0\u03c9\u03bd \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b7\u03bd \u03b1\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u039a\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03b9\u03bc\u03ae <a href=\"https:\/\/euroshopkey.com\/el\/product\/office-2024-professionnel-plus\/\"><strong class=\"prix-produit\">\u03b4\u03b5\u03af\u03c4\u03b5 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae<\/strong> \u03c3\u03c4\u03bf euroshopkey.com<\/a>, \u03b7 \u03b1\u03bd\u03b1\u03b2\u03ac\u03b8\u03bc\u03b9\u03c3\u03b7 \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03af \u03b5\u03bb\u03ac\u03c7\u03b9\u03c3\u03c4\u03b7 \u03b5\u03c0\u03ad\u03bd\u03b4\u03c5\u03c3\u03b7.<\/p>\n<h3>\ud83d\udccc \u0394\u03b9\u03b1\u03b2\u03ac\u03c3\u03c4\u03b5 \u03b5\u03c0\u03af\u03c3\u03b7\u03c2<\/h3>\n<ul>\n<li><a href=\"https:\/\/euroshopkey.com\/el\/microsoft-365-vs-office-2024-abonnement-ou-licence-perpetuelle\/\">Microsoft 365 \u03ae Office 2024: \u03a4\u03b9 \u03bd\u03b1 \u0395\u03c0\u03b9\u03bb\u03ad\u03be\u03b5\u03c4\u03b5;<\/a><\/li>\n<li><a href=\"https:\/\/euroshopkey.com\/el\/comment-installer-office-2024-guide-complet\/\">\u03a0\u03ce\u03c2 \u03bd\u03b1 \u0395\u03b3\u03ba\u03b1\u03c4\u03b1\u03c3\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03bf Office 2024<\/a><\/li>\n<li><a href=\"https:\/\/euroshopkey.com\/el\/office-pour-etudiant-quelle-version-choisir-2026\/\">Office \u03b3\u03b9\u03b1 \u03a6\u03bf\u03b9\u03c4\u03b7\u03c4\u03ad\u03c2: \u03a0\u03bf\u03b9\u03b1 \u0388\u03ba\u03b4\u03bf\u03c3\u03b7;<\/a><\/li>\n<li><a href=\"https:\/\/euroshopkey.com\/el\/office-gratuit-alternatives-microsoft-office-2026\/\">\u0394\u03c9\u03c1\u03b5\u03ac\u03bd \u0395\u03bd\u03b1\u03bb\u03bb\u03b1\u03ba\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c4\u03bf\u03c5 Microsoft Office<\/a><\/li>\n<\/ul>\n<h3>\ud83d\ude80 Excel 2024 \u03bc\u03b5 Copilot AI \u2014 <strong class=\"prix-produit\">\u03b4\u03b5\u03af\u03c4\u03b5 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae<\/strong><\/h3>\n<p><a href=\"https:\/\/euroshopkey.com\/el\/product\/office-2024-professionnel-plus\/\">Office 2024 Pro Plus \u2014 <strong class=\"prix-produit\">\u03b4\u03b5\u03af\u03c4\u03b5 \u03c4\u03b7\u03bd \u03c4\u03b9\u03bc\u03ae<\/strong><\/a> | <a href=\"https:\/\/euroshopkey.com\/el\/product\/office-365-12-mois-5-appareils\/\">Microsoft 365 \u2014 9,99\u20ac\/\u03ad\u03c4\u03bf\u03c2<\/a><\/p>\n<p>\ud83d\udd12 \u0386\u03b4\u03b5\u03b9\u03b1 \u03b5\u03c6&#8217; \u03cc\u03c1\u03bf\u03c5 \u03b6\u03c9\u03ae\u03c2 \u2022 \ud83d\ude9a \u0386\u03bc\u03b5\u03c3\u03b7 \u03c0\u03b1\u03c1\u03ac\u03b4\u03bf\u03c3\u03b7 \u2022 \ud83d\udcde \u03a5\u03c0\u03bf\u03c3\u03c4\u03ae\u03c1\u03b9\u03be\u03b7 \u03c0\u03b5\u03c1\u03b9\u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03b5\u03c4\u03b1\u03b9<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u03a4\u03bf Microsoft Excel \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf \u03c0\u03b9\u03bf \u03b4\u03b9\u03b1\u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03bf \u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc \u03c6\u03cd\u03bb\u03bb\u03bf \u03c3\u03c4\u03bf\u03bd \u03ba\u03cc\u03c3\u03bc\u03bf. \u03a9\u03c3\u03c4\u03cc\u03c3\u03bf, \u03b7 \u03c3\u03c5\u03bd\u03c4\u03c1\u03b9\u03c0\u03c4\u03b9\u03ba\u03ae \u03c0\u03bb\u03b5\u03b9\u03bf\u03bd\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c4\u03c9\u03bd \u03c7\u03c1\u03b7\u03c3\u03c4\u03ce\u03bd \u03b1\u03be\u03b9\u03bf\u03c0\u03bf\u03b9\u03b5\u03af \u03bc\u03cc\u03bd\u03bf \u03ad\u03bd\u03b1 \u03bc\u03b9\u03ba\u03c1\u03cc \u03bc\u03ad\u03c1\u03bf\u03c2 \u03c4\u03c9\u03bd \u03b4\u03c5\u03bd\u03b1\u03c4\u03bf\u03c4\u03ae\u03c4\u03c9\u03bd \u03c4\u03bf\u03c5. \u0395\u03af\u03c4\u03b5 \u03b5\u03af\u03c3\u03c4\u03b5 \u03c6\u03bf\u03b9\u03c4\u03b7\u03c4\u03ae\u03c2, \u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03ae\u03c2, \u03b5\u03c0\u03b9\u03c7\u03b5\u03b9\u03c1\u03b7\u03bc\u03b1\u03c4\u03af\u03b1\u03c2 \u03ae \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03ae\u03c2, \u03b7 \u03b3\u03bd\u03ce\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c9\u03c3\u03c4\u03ce\u03bd \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd \u03c4\u03bf\u03c5 Excel \u03bc\u03b5\u03c4\u03b1\u03bc\u03bf\u03c1\u03c6\u03ce\u03bd\u03b5\u03b9 \u03ba\u03c5\u03c1\u03b9\u03bf\u03bb\u03b5\u03ba\u03c4\u03b9\u03ba\u03ac \u03c4\u03b7\u03bd \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03ac \u03c3\u03b1\u03c2. \u0391\u03c5\u03c4\u03cc\u03c2 \u03bf \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03b6\u03b5\u03b9 \u03c4\u03b9\u03c2 15 \u03c0\u03b9\u03bf \u03c7\u03c1\u03ae\u03c3\u03b9\u03bc\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 Excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2623,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[379],"tags":[],"class_list":["post-9085","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guide"],"_links":{"self":[{"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/posts\/9085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/comments?post=9085"}],"version-history":[{"count":0,"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/posts\/9085\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/media\/2623"}],"wp:attachment":[{"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/media?parent=9085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/categories?post=9085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/euroshopkey.com\/el\/wp-json\/wp\/v2\/tags?post=9085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}