{"id":5601,"date":"2026-02-22T11:44:11","date_gmt":"2026-02-22T09:44:11","guid":{"rendered":"https:\/\/www.techhacks.gr\/?p=5601"},"modified":"2026-02-22T11:44:12","modified_gmt":"2026-02-22T09:44:12","slug":"%ce%bf%ce%b4%ce%b7%ce%b3%cf%8c%cf%82-%ce%b5%cf%80%ce%b9%ce%b2%ce%af%cf%89%cf%83%ce%b7%cf%82-%cf%83%cf%84%ce%bf-excel-%ce%bf%ce%b9-30-%cf%80%ce%b9%ce%bf-%cf%87%cf%81%ce%ae%cf%83%ce%b9%ce%bc%ce%b5","status":"publish","type":"post","link":"https:\/\/www.techhacks.gr\/?p=5601","title":{"rendered":"\u039f\u03b4\u03b7\u03b3\u03cc\u03c2 \u0395\u03c0\u03b9\u03b2\u03af\u03c9\u03c3\u03b7\u03c2 \u03c3\u03c4\u03bf Excel: \u039f\u03b9 30 \u03a0\u03b9\u03bf \u03a7\u03c1\u03ae\u03c3\u03b9\u03bc\u03b5\u03c2 \u03a6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b5\u03c2 \u03b3\u03b9\u03b1 \u039a\u03ac\u03b8\u03b5 \u03a7\u03c1\u03ae\u03c3\u03c4\u03b7"},"content":{"rendered":"\n

\u03a3\u03c4\u03bf\u03bd \u03c3\u03cd\u03b3\u03c7\u03c1\u03bf\u03bd\u03bf \u03b5\u03c0\u03b1\u03b3\u03b3\u03b5\u03bb\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03ba\u03cc\u03c3\u03bc\u03bf, \u03c4\u03bf Microsoft Excel \u03c0\u03b1\u03c1\u03b1\u03bc\u03ad\u03bd\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03c0\u03b9\u03bf \u03b9\u03c3\u03c7\u03c5\u03c1\u03ac \u03ba\u03b1\u03b9 \u03b5\u03c5\u03ad\u03bb\u03b9\u03ba\u03c4\u03b1 \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03b1 \u03b4\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u0391\u03c0\u03cc \u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b9\u03ba\u03ad\u03c2 \u03b1\u03bd\u03b1\u03bb\u03cd\u03c3\u03b5\u03b9\u03c2 \u03ba\u03b1\u03b9 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2 \u03c0\u03c9\u03bb\u03ae\u03c3\u03b5\u03c9\u03bd \u03bc\u03ad\u03c7\u03c1\u03b9 \u03bb\u03af\u03c3\u03c4\u03b5\u03c2 \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1\u03c4\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03b1, \u03b7 \u03c3\u03c9\u03c3\u03c4\u03ae \u03b1\u03be\u03b9\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd \u03c4\u03bf\u03c5 Excel \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c8\u03b5\u03b9 \u03ce\u03c1\u03b5\u03c2 \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03b7\u03c2 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03c3\u03b5 \u03b4\u03b5\u03c5\u03c4\u03b5\u03c1\u03cc\u03bb\u03b5\u03c0\u03c4\u03b1 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03b7\u03c2 \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2.<\/p>\n\n\n\n

\u0394\u03b5\u03bd \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03b5\u03ba\u03b1\u03c4\u03bf\u03bd\u03c4\u03ac\u03b4\u03b5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2. \u03a3\u03c4\u03b7\u03bd \u03c0\u03c1\u03ac\u03be\u03b7, \u03c0\u03b5\u03c1\u03af\u03c0\u03bf\u03c5 30 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03c6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b5\u03c2 \u03ba\u03b1\u03bb\u03cd\u03c0\u03c4\u03bf\u03c5\u03bd \u03c4\u03bf 90% \u03c4\u03c9\u03bd \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ce\u03bd \u03b1\u03bd\u03b1\u03b3\u03ba\u03ce\u03bd<\/strong>. \u039f\u03b9 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03bf\u03cd\u03bd \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03bf\u03cd\u03bd \u03c4\u03bf\u03bd \u00ab\u03b5\u03bb\u03b2\u03b5\u03c4\u03b9\u03ba\u03cc \u03c3\u03bf\u03c5\u03b3\u03b9\u03ac\u00bb \u03ba\u03ac\u03b8\u03b5 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b7 Excel \u2013 \u03b5\u03af\u03c4\u03b5 \u03b5\u03af\u03c3\u03c4\u03b5 \u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03ae\u03c2, \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03ae\u03c2, \u03c6\u03bf\u03b9\u03c4\u03b7\u03c4\u03ae\u03c2 \u03ae \u03b5\u03c0\u03b9\u03c7\u03b5\u03b9\u03c1\u03b7\u03bc\u03b1\u03c4\u03af\u03b1\u03c2.<\/p>\n\n\n\n

\n\n\n\n

\u039f\u03b9 30 \u0392\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03a6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b5\u03c2 Excel \u03c0\u03bf\u03c5 \u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u0393\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5<\/h2>\n\n\n\n

\u03a0\u03b1\u03c1\u03b1\u03ba\u03ac\u03c4\u03c9 \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03ad\u03bd\u03b1\u03c2 \u03c3\u03c5\u03b3\u03ba\u03b5\u03bd\u03c4\u03c1\u03c9\u03c4\u03b9\u03ba\u03cc\u03c2 \u03bf\u03b4\u03b7\u03b3\u03cc\u03c2 \u03bc\u03b5 \u03c4\u03b9\u03c2 \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03b7 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03bf\u03c5\u03c2:<\/p>\n\n\n\n

\u0391\/\u0391<\/strong><\/td>\u039b\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1<\/strong><\/td>\u03a4\u03cd\u03c0\u03bf\u03c2 \/ \u03a6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b1<\/strong><\/td>\u03a7\u03c1\u03ae\u03c3\u03b7<\/strong><\/td><\/tr><\/thead>
1<\/strong><\/td>\u039c\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03bc\u03b5 \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03bf<\/td>=COUNTIF(A2:A20,\"Yes\")<\/code><\/td>\u039c\u03b5\u03c4\u03c1\u03ac \u03ba\u03b5\u03bb\u03b9\u03ac \u03bc\u03b5 \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03bf \u03c0\u03b5\u03c1\u03b9\u03b5\u03c7\u03cc\u03bc\u03b5\u03bd\u03bf.<\/td><\/tr>
2<\/strong><\/td>\u0386\u03b8\u03c1\u03bf\u03b9\u03c3\u03bc\u03b1 \u03bc\u03b5 \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03bf<\/td>=SUMIF(A2:A20,\"Apple\",B2:B20)<\/code><\/td>\u03a0\u03c1\u03bf\u03c3\u03b8\u03ad\u03c4\u03b5\u03b9 \u03c4\u03b9\u03bc\u03ad\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c3\u03c5\u03bd\u03b8\u03ae\u03ba\u03b7\u03c2.<\/td><\/tr>
3<\/strong><\/td>\u039c\u03ad\u03c3\u03bf\u03c2 \u038c\u03c1\u03bf\u03c2 \u03bc\u03b5 \u03ba\u03c1\u03b9\u03c4\u03ae\u03c1\u03b9\u03bf<\/td>=AVERAGEIF(A2:A20,\"North\",B2:B20)<\/code><\/td>\u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03b9 \u03bc\u03ad\u03c3\u03bf \u03cc\u03c1\u03bf \u03b2\u03ac\u03c3\u03b5\u03b9 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae\u03c2\/\u03cc\u03c1\u03bf\u03c5.<\/td><\/tr>
4<\/strong><\/td>\u03a3\u03c5\u03bd\u03ad\u03bd\u03c9\u03c3\u03b7 \u039a\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5<\/td>=A2 & \", \" & B2<\/code><\/td>\u0395\u03bd\u03ce\u03bd\u03b5\u03b9 \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf \u03b1\u03c0\u03cc \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03ba\u03b5\u03bb\u03b9\u03ac.<\/td><\/tr>
5<\/strong><\/td>\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c0\u03c1\u03ce\u03c4\u03b7\u03c2 \u03bb\u03ad\u03be\u03b7\u03c2<\/td>=LEFT(A2,FIND(\" \",A2)-1)<\/code><\/td>\u0391\u03c0\u03bf\u03bc\u03bf\u03bd\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c0\u03c1\u03ce\u03c4\u03b7 \u03bb\u03ad\u03be\u03b7 \u03bc\u03b9\u03b1\u03c2 \u03c0\u03c1\u03cc\u03c4\u03b1\u03c3\u03b7\u03c2.<\/td><\/tr>
6<\/strong><\/td>\u0395\u03be\u03b1\u03b3\u03c9\u03b3\u03ae \u03c4\u03b5\u03bb\u03b5\u03c5\u03c4\u03b1\u03af\u03b1\u03c2 \u03bb\u03ad\u03be\u03b7\u03c2<\/td>=RIGHT(A2,LEN(A2)-...<\/code><\/td>\u0391\u03c0\u03bf\u03bc\u03bf\u03bd\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03c4\u03b5\u03bb\u03b5\u03c5\u03c4\u03b1\u03af\u03b1 \u03bb\u03ad\u03be\u03b7 (\u03c3\u03cd\u03bd\u03b8\u03b5\u03c4\u03bf\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c2).<\/td><\/tr>
7<\/strong><\/td>\u03a4\u03c1\u03ad\u03c7\u03bf\u03c5\u03c3\u03b1 \u038f\u03c1\u03b1<\/td>=NOW()<\/code><\/td>\u0395\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1 \u03ba\u03b1\u03b9 \u03ce\u03c1\u03b1.<\/td><\/tr>
8<\/strong><\/td>\u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03cc\u03c2 \u0397\u03bb\u03b9\u03ba\u03af\u03b1\u03c2<\/td>=DATEDIF(A2,TODAY(),\"y\")<\/code><\/td>\u0392\u03c1\u03af\u03c3\u03ba\u03b5\u03b9 \u03c4\u03b7 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03ac \u03b5\u03c4\u03ce\u03bd \u03bc\u03b5\u03c4\u03b1\u03be\u03cd \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03b9\u03ce\u03bd.<\/td><\/tr>
9<\/strong><\/td>\u03a0\u03c1\u03ce\u03c4\u03b7 \u03bc\u03ad\u03c1\u03b1 \u03bc\u03ae\u03bd\u03b1<\/td>=DATE(YEAR(A2),MONTH(A2),1)<\/code><\/td>\u039c\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c0\u03b5\u03b9 \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1 \u03c3\u03c4\u03b7\u03bd 1\u03b7 \u03c4\u03bf\u03c5 \u03bc\u03b7\u03bd\u03cc\u03c2.<\/td><\/tr>
10<\/strong><\/td>\u0397\u03bc\u03ad\u03c1\u03b5\u03c2 \u03bc\u03ae\u03bd\u03b1<\/td>=DAY(EOMONTH(A2,0))<\/code><\/td>\u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03b7\u03bc\u03b5\u03c1\u03ce\u03bd \u03c4\u03bf\u03c5 \u03bc\u03ae\u03bd\u03b1.<\/td><\/tr>
11<\/strong><\/td>\u0388\u03bb\u03b5\u03b3\u03c7\u03bf\u03c2 \u0394\u03b9\u03c0\u03bb\u03cc\u03c4\u03c5\u03c0\u03c9\u03bd<\/td>=COUNTIF(A:A,A2)>1<\/code><\/td>\u0395\u03bd\u03c4\u03bf\u03c0\u03af\u03b6\u03b5\u03b9 \u03b1\u03bd \u03bc\u03b9\u03b1 \u03c4\u03b9\u03bc\u03ae \u03c5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03c0\u03ac\u03bd\u03c9 \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03c6\u03bf\u03c1\u03ac.<\/td><\/tr>
12<\/strong><\/td>\u039a\u03b1\u03c4\u03ac\u03c4\u03b1\u03be\u03b7<\/td>=RANK(A2,A2:A20)<\/code><\/td>\u039a\u03b1\u03c4\u03b1\u03c4\u03ac\u03c3\u03c3\u03b5\u03b9 \u03ad\u03bd\u03b1\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03bb\u03af\u03c3\u03c4\u03b1.<\/td><\/tr>
13<\/strong><\/td>k-\u03bc\u03b9\u03ba\u03c1\u03cc\u03c4\u03b5\u03c1\u03b7 \u03c4\u03b9\u03bc\u03ae<\/td>=SMALL(A2:A20,3)<\/code><\/td>\u0392\u03c1\u03af\u03c3\u03ba\u03b5\u03b9 \u03c4\u03b7\u03bd 3\u03b7 (\u03ae \u03bd-\u03bf\u03c3\u03c4\u03ae) \u03bc\u03b9\u03ba\u03c1\u03cc\u03c4\u03b5\u03c1\u03b7 \u03c4\u03b9\u03bc\u03ae.<\/td><\/tr>
14<\/strong><\/td>k-\u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03c4\u03b9\u03bc\u03ae<\/td>=LARGE(A2:A20,3)<\/code><\/td>\u0392\u03c1\u03af\u03c3\u03ba\u03b5\u03b9 \u03c4\u03b7\u03bd 3\u03b7 (\u03ae \u03bd-\u03bf\u03c3\u03c4\u03ae) \u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03b7 \u03c4\u03b9\u03bc\u03ae.<\/td><\/tr>
15<\/strong><\/td>\u0394\u03b9\u03b1\u03af\u03c1\u03b5\u03c3\u03b7 \u03c7\u03c9\u03c1\u03af\u03c2 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1<\/td>=IF(B2=0,\"\",A2\/B2)<\/code><\/td>\u0391\u03c0\u03bf\u03c6\u03b5\u03cd\u03b3\u03b5\u03b9 \u03c4\u03bf \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1 #DIV\/0!.<\/td><\/tr>
16<\/strong><\/td>\u0394\u03c5\u03bd\u03b1\u03bc\u03b9\u03ba\u03ae \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1<\/td>=TODAY()+7<\/code><\/td>\u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03af\u03b6\u03b5\u03b9 \u03c4\u03b7\u03bd \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1 \u03bc\u03b5\u03c4\u03ac \u03b1\u03c0\u03cc 7 \u03bc\u03ad\u03c1\u03b5\u03c2.<\/td><\/tr>
17<\/strong><\/td>\u0391\u03c1\u03b9\u03b8\u03bc\u03cc\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae\u03c2<\/td>=ROW(A2)<\/code><\/td>\u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c4\u03b7\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae\u03c2.<\/td><\/tr>
18<\/strong><\/td>\u0391\u03c1\u03b9\u03b8\u03bc\u03cc\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b7\u03c2<\/td>=COLUMN(B2)<\/code><\/td>\u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c4\u03b7\u03c2 \u03c3\u03c4\u03ae\u03bb\u03b7\u03c2.<\/td><\/tr>
19<\/strong><\/td>\u039c\u03bf\u03c1\u03c6\u03ae \u0397\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1\u03c2<\/td>=TEXT(A2,\"dd\/mm\/yyyy\")<\/code><\/td>\u039c\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c0\u03b5\u03b9 \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc \u03c3\u03b5 \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1 (\u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf).<\/td><\/tr>
20<\/strong><\/td>\u0397\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03af\u03b1 \u03c3\u03b5 \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf<\/td>=TEXT(A2,\"mmmm d, yyyy\")<\/code><\/td>\u0395\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03c4\u03bf\u03bd \u03bc\u03ae\u03bd\u03b1 \u03bf\u03bd\u03bf\u03bc\u03b1\u03c3\u03c4\u03b9\u03ba\u03ac.<\/td><\/tr>
21<\/strong><\/td>\u039a\u03ac\u03b8\u03b5\u03c4\u03b7 \u0391\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7<\/td>=VLOOKUP(A2,A2:C20,2,FALSE)<\/code><\/td>\u0391\u03bd\u03b1\u03b6\u03b7\u03c4\u03ac \u03c4\u03b9\u03bc\u03ae \u03c3\u03b5 \u03c3\u03c4\u03ae\u03bb\u03b5\u03c2.<\/td><\/tr>
22<\/strong><\/td>\u03a3\u03cd\u03b3\u03c7\u03c1\u03bf\u03bd\u03b7 \u0391\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7<\/td>=XLOOKUP(A2,A2:A20,B2:B20)<\/code><\/td>\u0397 \u03bd\u03ad\u03b1, \u03b2\u03b5\u03bb\u03c4\u03b9\u03c9\u03bc\u03ad\u03bd\u03b7 \u03ad\u03ba\u03b4\u03bf\u03c3\u03b7 \u03c4\u03bf\u03c5 VLOOKUP.<\/td><\/tr>
23<\/strong><\/td>INDEX<\/td>=INDEX(A2:C20,5,2)<\/code><\/td>\u0395\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c6\u03b5\u03b9 \u03c4\u03b9\u03bc\u03ae \u03b1\u03c0\u03cc \u03c3\u03c5\u03b3\u03ba\u03b5\u03ba\u03c1\u03b9\u03bc\u03ad\u03bd\u03b7 \u03c4\u03bf\u03bc\u03ae.<\/td><\/tr>
24<\/strong><\/td>MATCH<\/td>=MATCH(A2,A2:A20,0)<\/code><\/td>\u0392\u03c1\u03af\u03c3\u03ba\u03b5\u03b9 \u03c4\u03b7 \u03b8\u03ad\u03c3\u03b7 \u03bc\u03b9\u03b1\u03c2 \u03c4\u03b9\u03bc\u03ae\u03c2 \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c7\u03ae.<\/td><\/tr>
25<\/strong><\/td>\u0394\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7 \u03a3\u03c6\u03b1\u03bb\u03bc\u03ac\u03c4\u03c9\u03bd<\/td>=IFERROR(A2\/B2,\"\u03a3\u03c6\u03ac\u03bb\u03bc\u03b1\")<\/code><\/td>\u0395\u03bc\u03c6\u03b1\u03bd\u03af\u03b6\u03b5\u03b9 \u03b4\u03b9\u03ba\u03cc \u03bc\u03b1\u03c2 \u03bc\u03ae\u03bd\u03c5\u03bc\u03b1 \u03b1\u03bd\u03c4\u03af \u03b3\u03b9\u03b1 \u03c3\u03c6\u03ac\u03bb\u03bc\u03b1.<\/td><\/tr>
26<\/strong><\/td>\u039c\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03b1\u03c1\u03b9\u03b8\u03bc\u03ce\u03bd<\/td>=COUNT(A2:A20)<\/code><\/td>\u039c\u03b5\u03c4\u03c1\u03ac \u03bc\u03cc\u03bd\u03bf \u03c4\u03b1 \u03ba\u03b5\u03bb\u03b9\u03ac \u03c0\u03bf\u03c5 \u03ad\u03c7\u03bf\u03c5\u03bd \u03b1\u03c1\u03b9\u03b8\u03bc\u03bf\u03cd\u03c2.<\/td><\/tr>
27<\/strong><\/td>\u039c\u03ad\u03c4\u03c1\u03b7\u03c3\u03b7 \u03bc\u03b7 \u03ba\u03b5\u03bd\u03ce\u03bd<\/td>=COUNTA(A2:A20)<\/code><\/td>\u039c\u03b5\u03c4\u03c1\u03ac \u03cc\u03bb\u03b1 \u03c4\u03b1 \u03ba\u03b5\u03bb\u03b9\u03ac \u03c0\u03bf\u03c5 \u03b4\u03b5\u03bd \u03b5\u03af\u03bd\u03b1\u03b9 \u03ac\u03b4\u03b5\u03b9\u03b1.<\/td><\/tr>
28<\/strong><\/td>\u039c\u03ae\u03ba\u03bf\u03c2 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5<\/td>=LEN(A2)<\/code><\/td>\u039c\u03b5\u03c4\u03c1\u03ac \u03c4\u03bf\u03c5\u03c2 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03ae\u03c1\u03b5\u03c2 \u03b5\u03bd\u03cc\u03c2 \u03ba\u03b5\u03bb\u03b9\u03bf\u03cd.<\/td><\/tr>
29<\/strong><\/td>\u0391\u03c6\u03b1\u03af\u03c1\u03b5\u03c3\u03b7 \u03ba\u03b5\u03bd\u03ce\u03bd<\/td>=TRIM(A2)<\/code><\/td>\u0394\u03b9\u03b1\u03b3\u03c1\u03ac\u03c6\u03b5\u03b9 \u03c0\u03b5\u03c1\u03b9\u03c4\u03c4\u03ac \u03ba\u03b5\u03bd\u03ac \u03c0\u03c1\u03b9\u03bd\/\u03bc\u03b5\u03c4\u03ac \u03c4\u03bf \u03ba\u03b5\u03af\u03bc\u03b5\u03bd\u03bf.<\/td><\/tr>
30<\/strong><\/td>\u03a0\u03c1\u03bf\u03b7\u03b3\u03bc\u03ad\u03bd\u03b7 \u03c3\u03c5\u03bd\u03ad\u03bd\u03c9\u03c3\u03b7<\/td>=TEXTJOIN(\", \",TRUE,A2:A5)<\/code><\/td>\u0395\u03bd\u03ce\u03bd\u03b5\u03b9 \u03ba\u03b5\u03bb\u03b9\u03ac \u03bc\u03b5 \u03b4\u03b9\u03b1\u03c7\u03c9\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03cc (\u03c0.\u03c7. \u03ba\u03cc\u03bc\u03bc\u03b1).<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u03a3\u03c5\u03bc\u03c0\u03ad\u03c1\u03b1\u03c3\u03bc\u03b1<\/h2>\n\n\n\n

\u0397 \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03c3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel \u03b4\u03b5\u03bd \u03b2\u03b1\u03c3\u03af\u03b6\u03b5\u03c4\u03b1\u03b9 \u03c3\u03c4\u03b7\u03bd \u03b1\u03c0\u03bf\u03bc\u03bd\u03b7\u03bc\u03cc\u03bd\u03b5\u03c5\u03c3\u03b7 \u03b4\u03b5\u03ba\u03ac\u03b4\u03c9\u03bd \u03c0\u03bf\u03bb\u03cd\u03c0\u03bb\u03bf\u03ba\u03c9\u03bd \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd, \u03b1\u03bb\u03bb\u03ac \u03c3\u03c4\u03b7\u03bd \u03bf\u03c5\u03c3\u03b9\u03b1\u03c3\u03c4\u03b9\u03ba\u03ae \u03ba\u03b1\u03c4\u03b1\u03bd\u03cc\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03b2\u03b1\u03c3\u03b9\u03ba\u03ce\u03bd \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03c9\u03bd \u03c0\u03bf\u03c5 \u03b5\u03c0\u03b9\u03bb\u03cd\u03bf\u03c5\u03bd \u03c4\u03bf \u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03bf \u03bc\u03ad\u03c1\u03bf\u03c2 \u03c4\u03c9\u03bd \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ce\u03bd \u03c0\u03c1\u03bf\u03b2\u03bb\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd.<\/p>\n\n\n\n

\u039f\u03b9 \u03c0\u03b1\u03c1\u03b1\u03c0\u03ac\u03bd\u03c9 30 \u03c6\u03cc\u03c1\u03bc\u03bf\u03c5\u03bb\u03b5\u03c2 \u03ba\u03b1\u03bb\u03cd\u03c0\u03c4\u03bf\u03c5\u03bd \u03c3\u03c7\u03b5\u03b4\u03cc\u03bd \u03ba\u03ac\u03b8\u03b5 \u03b1\u03bd\u03ac\u03b3\u03ba\u03b7:<\/p>\n\n\n\n

    \n
  • \u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03bf\u03cd\u03c2<\/li>\n\n\n\n
  • \u0391\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd<\/li>\n\n\n\n
  • \u0394\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7 \u03b7\u03bc\u03b5\u03c1\u03bf\u03bc\u03b7\u03bd\u03b9\u03ce\u03bd<\/li>\n\n\n\n
  • \u039a\u03b1\u03b8\u03b1\u03c1\u03b9\u03c3\u03bc\u03cc \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5<\/li>\n\n\n\n
  • \u0388\u03bb\u03b5\u03b3\u03c7\u03bf \u03c3\u03c6\u03b1\u03bb\u03bc\u03ac\u03c4\u03c9\u03bd<\/li>\n\n\n\n
  • \u0391\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7 \u03bb\u03b9\u03c3\u03c4\u03ce\u03bd<\/li>\n<\/ul>\n\n\n\n

    \u039c\u03b5 \u03c3\u03c5\u03c3\u03c4\u03b7\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03b5\u03be\u03ac\u03c3\u03ba\u03b7\u03c3\u03b7, \u03b8\u03b1 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03b5\u03af\u03c4\u03b5 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c0\u03bf\u03c5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b3\u03c1\u03ae\u03b3\u03bf\u03c1\u03b1, \u03b1\u03be\u03b9\u03cc\u03c0\u03b9\u03c3\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03b5\u03c0\u03b1\u03b3\u03b3\u03b5\u03bb\u03bc\u03b1\u03c4\u03b9\u03ba\u03ac \u2014 \u03b1\u03c5\u03be\u03ac\u03bd\u03bf\u03bd\u03c4\u03b1\u03c2 \u03c3\u03b7\u03bc\u03b1\u03bd\u03c4\u03b9\u03ba\u03ac \u03c4\u03b7\u03bd \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03ac \u03c3\u03b1\u03c2 \u03ba\u03b1\u03b9 \u03c4\u03b7\u03bd \u03b1\u03be\u03af\u03b1 \u03c3\u03b1\u03c2 \u03c3\u03b5 \u03ba\u03ac\u03b8\u03b5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03b1\u03ba\u03cc \u03c0\u03b5\u03c1\u03b9\u03b2\u03ac\u03bb\u03bb\u03bf\u03bd.<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u03a3\u03c4\u03bf\u03bd \u03c3\u03cd\u03b3\u03c7\u03c1\u03bf\u03bd\u03bf \u03b5\u03c0\u03b1\u03b3\u03b3\u03b5\u03bb\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc \u03ba\u03cc\u03c3\u03bc\u03bf, \u03c4\u03bf Microsoft Excel \u03c0\u03b1\u03c1\u03b1\u03bc\u03ad\u03bd\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03c0\u03b9\u03bf \u03b9\u03c3\u03c7\u03c5\u03c1\u03ac \u03ba\u03b1\u03b9 \u03b5\u03c5\u03ad\u03bb\u03b9\u03ba\u03c4\u03b1 \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03b1 \u03b4\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u0391\u03c0\u03cc \u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b9\u03ba\u03ad\u03c2 \u03b1\u03bd\u03b1\u03bb\u03cd\u03c3\u03b5\u03b9\u03c2 \u03ba\u03b1\u03b9 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2 \u03c0\u03c9\u03bb\u03ae\u03c3\u03b5\u03c9\u03bd \u03bc\u03ad\u03c7\u03c1\u03b9 \u03bb\u03af\u03c3\u03c4\u03b5\u03c2 \u03c0\u03b5\u03bb\u03b1\u03c4\u03ce\u03bd \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1\u03c4\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03b1, \u03b7 \u03c3\u03c9\u03c3\u03c4\u03ae \u03b1\u03be\u03b9\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd \u03c4\u03bf\u03c5 Excel \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03bc\u03b5\u03c4\u03b1\u03c4\u03c1\u03ad\u03c8\u03b5\u03b9 \u03ce\u03c1\u03b5\u03c2 \u03c7\u03b5\u03b9\u03c1\u03bf\u03ba\u03af\u03bd\u03b7\u03c4\u03b7\u03c2 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03c3\u03b5 \u03b4\u03b5\u03c5\u03c4\u03b5\u03c1\u03cc\u03bb\u03b5\u03c0\u03c4\u03b1 \u03b1\u03c5\u03c4\u03bf\u03bc\u03b1\u03c4\u03bf\u03c0\u03bf\u03b9\u03b7\u03bc\u03ad\u03bd\u03b7\u03c2 \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2. \u0394\u03b5\u03bd \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03b5\u03ba\u03b1\u03c4\u03bf\u03bd\u03c4\u03ac\u03b4\u03b5\u03c2 \u03c4\u03cd\u03c0\u03bf\u03c5\u03c2. \u03a3\u03c4\u03b7\u03bd \u03c0\u03c1\u03ac\u03be\u03b7, […]<\/p>\n","protected":false},"author":1,"featured_media":5604,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[6432,6426,683,6427,6429,6434,6433,6431,6435,684,686,6430,6425,6428],"class_list":["post-5601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-averageif","tag-countif","tag-excel","tag-excel--","tag-excel-","tag-iferror","tag-index-match","tag-sumif","tag-textjoin","tag-vlookup","tag-xlookup","tag---excel","tag--excel","tag--excel--"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2026\/02\/Gemini_Generated_Image_74ukqk74ukqk74uk.png?fit=1024%2C1024&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3364,"url":"https:\/\/www.techhacks.gr\/?p=3364","url_meta":{"origin":5601,"position":0},"title":"VLOOKUP \u03a4\u0399 \u0395\u0399\u039d\u0391\u0399 ? \u03a0\u039f\u03a5 \u03a7\u03a1\u0397\u03a3\u0399\u039c\u039f\u03a0\u039f\u0399\u0395\u0399\u03a4\u0391\u0399 ?","author":"maximus","date":"26\/05\/2025","format":false,"excerpt":"\u0397\u00a0VLOOKUP\u00a0(\u03ba\u03ac\u03b8\u03b5\u03c4\u03b7 \u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7 -\u00a0Vertical Lookup) \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03b9\u03b1 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7 \u03c4\u03bf\u03c5\u00a0Excel\u00a0(\u03ba\u03b1\u03b9 \u03ac\u03bb\u03bb\u03c9\u03bd \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03b9\u03ba\u03ce\u03bd \u03c6\u03cd\u03bb\u03bb\u03c9\u03bd \u03cc\u03c0\u03c9\u03c2 \u03c4\u03bf Google Sheets) \u03c0\u03bf\u03c5 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03bd\u03b1\u00a0\u03b1\u03bd\u03b1\u03b6\u03b7\u03c4\u03ae\u03c3\u03b5\u03b9 \u03bc\u03b9\u03b1 \u03c4\u03b9\u03bc\u03ae \u03c3\u03b5 \u03bc\u03b9\u03b1 \u03c3\u03c4\u03ae\u03bb\u03b7 \u03b5\u03bd\u03cc\u03c2 \u03c0\u03af\u03bd\u03b1\u03ba\u03b1\u00a0\u03ba\u03b1\u03b9 \u03bd\u03b1 \u03b5\u03c0\u03b9\u03c3\u03c4\u03c1\u03ad\u03c8\u03b5\u03b9 \u03bc\u03b9\u03b1 \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 \u03c4\u03b7\u03c2 \u03af\u03b4\u03b9\u03b1\u03c2 \u03b3\u03c1\u03b1\u03bc\u03bc\u03ae\u03c2. \ud83d\udd0d \u0394\u03bf\u03bc\u03ae \u03c4\u03b7\u03c2 \u03c3\u03c5\u03bd\u03ac\u03c1\u03c4\u03b7\u03c3\u03b7\u03c2 VLOOKUP: =VLOOKUP(\u03c4\u03b9\u03bc\u03ae_\u03c0\u03c1\u03bf\u03c2_\u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7, \u03c0\u03af\u03bd\u03b1\u03ba\u03b1\u03c2, \u03b1\u03c1\u03b9\u03b8\u03bc\u03cc\u03c2_\u03c3\u03c4\u03ae\u03bb\u03b7\u03c2, [\u03b5\u03cd\u03c1\u03bf\u03c2_\u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7\u03c2]) \ud83d\udca1 \u03a0\u03b1\u03c1\u03ac\u03bc\u03b5\u03c4\u03c1\u03bf\u03b9: \u03c4\u03b9\u03bc\u03ae_\u03c0\u03c1\u03bf\u03c2_\u03b1\u03bd\u03b1\u03b6\u03ae\u03c4\u03b7\u03c3\u03b7:\u2026","rel":"","context":"\u03c3\u03b5 "How-To"","block_context":{"text":"How-To","link":"https:\/\/www.techhacks.gr\/?cat=3"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/05\/aa33b800-5eaa-40d9-8ea2-55d96d593ff0.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/05\/aa33b800-5eaa-40d9-8ea2-55d96d593ff0.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/05\/aa33b800-5eaa-40d9-8ea2-55d96d593ff0.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/05\/aa33b800-5eaa-40d9-8ea2-55d96d593ff0.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3994,"url":"https:\/\/www.techhacks.gr\/?p=3994","url_meta":{"origin":5601,"position":1},"title":"\u039d\u03ad\u03b1 \u0394\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03c3\u03c4\u03bf Excel: \u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u0391\u03bd\u03b1\u03bd\u03ad\u03c9\u03c3\u03b7 (Auto Refresh) \u03b3\u03b9\u03b1 PivotTables!","author":"Jimcrow","date":"27\/07\/2025","format":false,"excerpt":"\u0397 Microsoft \u03b1\u03bd\u03b1\u03ba\u03bf\u03af\u03bd\u03c9\u03c3\u03b5 \u03c0\u03c1\u03cc\u03c3\u03c6\u03b1\u03c4\u03b1 \u03bc\u03b9\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b9\u03c2 \u03c0\u03b9\u03bf \u03c0\u03bf\u03bb\u03c5\u03b1\u03bd\u03b1\u03bc\u03b5\u03bd\u03cc\u03bc\u03b5\u03bd\u03b5\u03c2 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03bf\u03c5\u03c2 \u03c7\u03c1\u03ae\u03c3\u03c4\u03b5\u03c2 \u03c4\u03bf\u03c5 Microsoft Excel: \u03c4\u03b7\u03bd \u0391\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b7 \u0391\u03bd\u03b1\u03bd\u03ad\u03c9\u03c3\u03b7 (Auto Refresh) \u03c4\u03c9\u03bd PivotTables! \u03a0\u03c1\u03cc\u03ba\u03b5\u03b9\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03bc\u03b9\u03b1 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03c0\u03bf\u03c5 \u03b5\u03be\u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b5\u03af \u03c7\u03c1\u03cc\u03bd\u03bf \u03ba\u03b1\u03b9 \u03bc\u03b5\u03b9\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b1 \u03bb\u03ac\u03b8\u03b7, \u03b1\u03c6\u03bf\u03cd \u03c0\u03bb\u03ad\u03bf\u03bd \u03c4\u03b1 PivotTables \u03bc\u03c0\u03bf\u03c1\u03bf\u03cd\u03bd \u03bd\u03b1 \u03b1\u03bd\u03b1\u03bd\u03b5\u03ce\u03bd\u03bf\u03bd\u03c4\u03b1\u03b9 \u03b1\u03c5\u03c4\u03cc\u03bc\u03b1\u03c4\u03b1 \u03ba\u03ac\u03b8\u03b5 \u03c6\u03bf\u03c1\u03ac \u03c0\u03bf\u03c5 \u03b1\u03bb\u03bb\u03ac\u03b6\u03bf\u03c5\u03bd \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c0\u03b7\u03b3\u03ae\u03c2. \u2705\u2026","rel":"","context":"\u03c3\u03b5 "Tips"","block_context":{"text":"Tips","link":"https:\/\/www.techhacks.gr\/?cat=4"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/Auto-Refresh-PivotTables.png?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/Auto-Refresh-PivotTables.png?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/Auto-Refresh-PivotTables.png?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/Auto-Refresh-PivotTables.png?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3918,"url":"https:\/\/www.techhacks.gr\/?p=3918","url_meta":{"origin":5601,"position":2},"title":"Office 365","author":"maximus","date":"19\/07\/2025","format":false,"excerpt":"\u03a4\u03b1\u00a0Office 365\u00a0(\u03c0\u03bb\u03ad\u03bf\u03bd \u03bf\u03bd\u03bf\u03bc\u03ac\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9\u00a0Microsoft 365) \u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03b9\u03b1\u00a0\u03c3\u03c5\u03bd\u03b4\u03c1\u03bf\u03bc\u03b7\u03c4\u03b9\u03ba\u03ae \u03c5\u03c0\u03b7\u03c1\u03b5\u03c3\u03af\u03b1\u00a0\u03c4\u03b7\u03c2 Microsoft \u03c0\u03bf\u03c5 \u03c3\u03bf\u03c5 \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c0\u03c1\u03cc\u03c3\u03b2\u03b1\u03c3\u03b7 \u03c3\u03b5 \u03b5\u03c6\u03b1\u03c1\u03bc\u03bf\u03b3\u03ad\u03c2 \u03b3\u03c1\u03b1\u03c6\u03b5\u03af\u03bf\u03c5, cloud \u03c5\u03c0\u03b7\u03c1\u03b5\u03c3\u03af\u03b5\u03c2 \u03ba\u03b1\u03b9 \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03b1 \u03c3\u03c5\u03bd\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2,\u00a0\u03c3\u03b5 \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03c3\u03c5\u03c3\u03ba\u03b5\u03c5\u03ad\u03c2 \u03c3\u03bf\u03c5\u00a0(PC, \u03ba\u03b9\u03bd\u03b7\u03c4\u03cc, tablet, browser). \ud83e\uddf0 \u03a4\u03b9 \u03c0\u03b5\u03c1\u03b9\u03bb\u03b1\u03bc\u03b2\u03ac\u03bd\u03b5\u03b9 \u03c4\u03bf Office 365; \ud83d\udce6 \u0392\u03b1\u03c3\u03b9\u03ba\u03ad\u03c2 \u03b5\u03c6\u03b1\u03c1\u03bc\u03bf\u03b3\u03ad\u03c2 \u03b3\u03c1\u03b1\u03c6\u03b5\u03af\u03bf\u03c5: Word\u00a0\u2013 \u03b5\u03c0\u03b5\u03be\u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 Excel\u00a0\u2013 \u03c5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03c6\u03cd\u03bb\u03bb\u03b1 PowerPoint\u00a0\u2013 \u03c0\u03b1\u03c1\u03bf\u03c5\u03c3\u03b9\u03ac\u03c3\u03b5\u03b9\u03c2 Outlook\u00a0\u2013 email & \u03b7\u03bc\u03b5\u03c1\u03bf\u03bb\u03cc\u03b3\u03b9\u03bf OneNote\u00a0\u2013\u2026","rel":"","context":"\u03c3\u03b5 "\u039d\u03ad\u03b1"","block_context":{"text":"\u039d\u03ad\u03b1","link":"https:\/\/www.techhacks.gr\/?cat=2"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/0b5288fe-6037-48bf-98cb-fb76c015fd82.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/0b5288fe-6037-48bf-98cb-fb76c015fd82.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/0b5288fe-6037-48bf-98cb-fb76c015fd82.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/07\/0b5288fe-6037-48bf-98cb-fb76c015fd82.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":4460,"url":"https:\/\/www.techhacks.gr\/?p=4460","url_meta":{"origin":5601,"position":3},"title":"Dead Again in the Building","author":"Bon Ale","date":"06\/10\/2025","format":false,"excerpt":"Only Murders in the Building \u2013 \u03a3\u03b5\u03b6\u03cc\u03bd 4: \u039d\u03ad\u03b1 \u03a0\u03cc\u03bb\u03b7, \u038a\u03b4\u03b9\u03bf \u03a4\u03c1\u03af\u03bf, \u03a6\u03c1\u03ad\u03c3\u03ba\u03bf \u039c\u03c5\u03c3\u03c4\u03ae\u03c1\u03b9\u03bf. \u0397 \u03c4\u03ad\u03c4\u03b1\u03c1\u03c4\u03b7 \u03c3\u03b5\u03b6\u03cc\u03bd \u03c4\u03bf\u03c5 Only Murders in the Building \u03b5\u03c0\u03ad\u03c3\u03c4\u03c1\u03b5\u03c8\u03b5 \u03ba\u03b1\u03b9 \u03bc\u03b1\u03c2 \u03b8\u03c5\u03bc\u03af\u03b6\u03b5\u03b9 \u03b3\u03b9\u03b1\u03c4\u03af \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf comedy-mystery \u03ad\u03c7\u03b5\u03b9 \u03b1\u03c0\u03bf\u03ba\u03c4\u03ae\u03c3\u03b5\u03b9 \u03c6\u03b1\u03bd\u03b1\u03c4\u03b9\u03ba\u03cc \u03ba\u03bf\u03b9\u03bd\u03cc \u03c3\u03b5 \u03cc\u03bb\u03bf \u03c4\u03bf\u03bd \u03ba\u03cc\u03c3\u03bc\u03bf. \u039f\u03b9 Charles (Steve Martin), Oliver (Martin Short) \u03ba\u03b1\u03b9 Mabel (Selena Gomez)\u2026","rel":"","context":"\u03c3\u03b5 "\u0398\u03ad\u03b1\u03c4\u03c1\u03bf-\u03a4\u03b1\u03b9\u03bd\u03af\u03b5\u03c2-\u03a3\u03b5\u03b9\u03c1\u03ad\u03c2"","block_context":{"text":"\u0398\u03ad\u03b1\u03c4\u03c1\u03bf-\u03a4\u03b1\u03b9\u03bd\u03af\u03b5\u03c2-\u03a3\u03b5\u03b9\u03c1\u03ad\u03c2","link":"https:\/\/www.techhacks.gr\/?cat=594"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/09\/images-1-1.jpeg?fit=225%2C225&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3558,"url":"https:\/\/www.techhacks.gr\/?p=3558","url_meta":{"origin":5601,"position":4},"title":"“TRACKER”","author":"maximus","date":"14\/06\/2025","format":false,"excerpt":"\u039a\u03ac\u03b8\u03b5 \u03b5\u03b2\u03b4\u03bf\u03bc\u03ac\u03b4\u03b1 \u03c3\u03b1\u03c2 \u03c0\u03c1\u03bf\u03c4\u03b5\u03af\u03bd\u03bf\u03c5\u03bc\u03b5 \u03bc\u03b9\u03b1 \u03c3\u03b5\u03b9\u03c1\u03ac ,\u03c0\u03bf\u03c5 \u03b1\u03be\u03af\u03b6\u03b5\u03b9 \u03bd\u03b1 \u03b4\u03ce\u03c3\u03b5\u03c4\u03b5 \u03bb\u03af\u03b3\u03bf \u03b1\u03c0\u03cc \u03c4\u03bf\u03bd \u03c7\u03c1\u03cc\u03bd\u03bf \u03c3\u03b1\u03c2, \u03b1\u03c5\u03c4\u03ae \u03c4\u03b7\u03bd \u03b5\u03b2\u03b4\u03bf\u03bc\u03ac\u03b4\u03b1 \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03c0\u03c1\u03bf\u03c4\u03b5\u03af\u03bd\u03bf\u03c5\u03bc\u03b5 \u03c4\u03b7\u03bd \u03c3\u03b5\u03b9\u03c1\u03ac Tracker . \u0397 \u03c3\u03b5\u03b9\u03c1\u03ac\u00a0Tracker\u00a0\u03b5\u03af\u03bd\u03b1\u03b9 \u03bc\u03b9\u03b1 \u03b1\u03bc\u03b5\u03c1\u03b9\u03ba\u03b1\u03bd\u03b9\u03ba\u03ae \u03b4\u03c1\u03b1\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03c3\u03b5\u03b9\u03c1\u03ac \u03c0\u03bf\u03c5 \u03ad\u03ba\u03b1\u03bd\u03b5 \u03c0\u03c1\u03b5\u03bc\u03b9\u03ad\u03c1\u03b1 \u03c3\u03c4\u03b9\u03c2 11 \u03a6\u03b5\u03b2\u03c1\u03bf\u03c5\u03b1\u03c1\u03af\u03bf\u03c5 2024 \u03c3\u03c4\u03bf CBS, \u03b1\u03bc\u03ad\u03c3\u03c9\u03c2 \u03bc\u03b5\u03c4\u03ac \u03c4\u03bf\u03bd \u03c4\u03b5\u03bb\u03b9\u03ba\u03cc \u03c4\u03bf\u03c5 Super Bowl LVIII. \u03a0\u03c1\u03c9\u03c4\u03b1\u03b3\u03c9\u03bd\u03b9\u03c3\u03c4\u03b5\u03af \u03bf\u2026","rel":"","context":"\u03c3\u03b5 "\u0398\u03ad\u03b1\u03c4\u03c1\u03bf-\u03a4\u03b1\u03b9\u03bd\u03af\u03b5\u03c2-\u03a3\u03b5\u03b9\u03c1\u03ad\u03c2"","block_context":{"text":"\u0398\u03ad\u03b1\u03c4\u03c1\u03bf-\u03a4\u03b1\u03b9\u03bd\u03af\u03b5\u03c2-\u03a3\u03b5\u03b9\u03c1\u03ad\u03c2","link":"https:\/\/www.techhacks.gr\/?cat=594"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/06\/%CE%A3%CF%84%CE%B9%CE%B3%CE%BC%CE%B9%CF%8C%CF%84%CF%85%CF%80%CE%BF-%CE%BF%CE%B8%CF%8C%CE%BD%CE%B7%CF%82-2025-06-05-10.27.06.png?fit=1200%2C682&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/06\/%CE%A3%CF%84%CE%B9%CE%B3%CE%BC%CE%B9%CF%8C%CF%84%CF%85%CF%80%CE%BF-%CE%BF%CE%B8%CF%8C%CE%BD%CE%B7%CF%82-2025-06-05-10.27.06.png?fit=1200%2C682&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/06\/%CE%A3%CF%84%CE%B9%CE%B3%CE%BC%CE%B9%CF%8C%CF%84%CF%85%CF%80%CE%BF-%CE%BF%CE%B8%CF%8C%CE%BD%CE%B7%CF%82-2025-06-05-10.27.06.png?fit=1200%2C682&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/06\/%CE%A3%CF%84%CE%B9%CE%B3%CE%BC%CE%B9%CF%8C%CF%84%CF%85%CF%80%CE%BF-%CE%BF%CE%B8%CF%8C%CE%BD%CE%B7%CF%82-2025-06-05-10.27.06.png?fit=1200%2C682&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2025\/06\/%CE%A3%CF%84%CE%B9%CE%B3%CE%BC%CE%B9%CF%8C%CF%84%CF%85%CF%80%CE%BF-%CE%BF%CE%B8%CF%8C%CE%BD%CE%B7%CF%82-2025-06-05-10.27.06.png?fit=1200%2C682&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":5608,"url":"https:\/\/www.techhacks.gr\/?p=5608","url_meta":{"origin":5601,"position":5},"title":"iOS 27 \u2013 \u039d\u03ad\u03b1 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac, Siri AI & \u03ba\u03c5\u03ba\u03bb\u03bf\u03c6\u03bf\u03c1\u03af\u03b1","author":"maximus","date":"23\/02\/2026","format":false,"excerpt":"\u03a4\u03b9 \u03bd\u03b1 \u03c0\u03b5\u03c1\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b1\u03c0\u03cc \u03c4\u03bf iOS 27 \u2013 \u03a4\u03bf \u03b5\u03c0\u03cc\u03bc\u03b5\u03bd\u03bf \u03bc\u03b5\u03b3\u03ac\u03bb\u03bf update \u03b3\u03b9\u03b1 \u03c4\u03bf iPhone \u03a4\u03bf iOS 27 \u03b8\u03b5\u03c9\u03c1\u03b5\u03af\u03c4\u03b1\u03b9 \u03c4\u03bf \u03bc\u03b5\u03b3\u03ac\u03bb\u03bf \u03b5\u03c0\u03cc\u03bc\u03b5\u03bd\u03bf \u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03b9\u03ba\u03cc \u03c4\u03b7\u03c2 Apple \u03b3\u03b9\u03b1 \u03c4\u03b1 iPhone \u03ba\u03b1\u03b9 \u03bf\u03b9 \u03c0\u03c1\u03bf\u03c3\u03b4\u03bf\u03ba\u03af\u03b5\u03c2 \u03c7\u03c4\u03af\u03b6\u03bf\u03bd\u03c4\u03b1\u03b9 \u03c3\u03c4\u03b1\u03b4\u03b9\u03b1\u03ba\u03ac \u03bc\u03b5 \u03c6\u03ae\u03bc\u03b5\u03c2, leaks \u03ba\u03b1\u03b9 \u03b1\u03be\u03b9\u03cc\u03c0\u03b9\u03c3\u03c4\u03b5\u03c2 \u03c4\u03b5\u03c7\u03bd\u03bf\u03bb\u03bf\u03b3\u03b9\u03ba\u03ad\u03c2 \u03b1\u03bd\u03b1\u03c6\u03bf\u03c1\u03ad\u03c2. \u0391\u03bd \u03ba\u03b1\u03b9 \u03b7 Apple \u03b4\u03b5\u03bd \u03ad\u03c7\u03b5\u03b9 \u03b1\u03c0\u03bf\u03ba\u03b1\u03bb\u03cd\u03c8\u03b5\u03b9 \u03b1\u03ba\u03cc\u03bc\u03b1 \u03b5\u03c0\u03af\u03c3\u03b7\u03bc\u03b1 \u03cc\u03bb\u03b5\u03c2\u2026","rel":"","context":"\u03c3\u03b5 "\u039d\u03ad\u03b1"","block_context":{"text":"\u039d\u03ad\u03b1","link":"https:\/\/www.techhacks.gr\/?cat=2"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2026\/02\/4da56e4a-bee0-47f7-ac63-d700a283c47e.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2026\/02\/4da56e4a-bee0-47f7-ac63-d700a283c47e.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2026\/02\/4da56e4a-bee0-47f7-ac63-d700a283c47e.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.techhacks.gr\/wp-content\/uploads\/2026\/02\/4da56e4a-bee0-47f7-ac63-d700a283c47e.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/posts\/5601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5601"}],"version-history":[{"count":2,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/posts\/5601\/revisions"}],"predecessor-version":[{"id":5603,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/posts\/5601\/revisions\/5603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=\/wp\/v2\/media\/5604"}],"wp:attachment":[{"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techhacks.gr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}