{"id":1005,"date":"2017-12-07T14:03:47","date_gmt":"2017-12-07T14:03:47","guid":{"rendered":"https:\/\/www.test4u.eu\/blog\/?p=1005"},"modified":"2018-06-15T22:46:57","modified_gmt":"2018-06-15T22:46:57","slug":"data-analysis-with-excel-test4u","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/blog\/data-analysis-with-excel-test4u\/","title":{"rendered":"Data Analysis with Excel &#8211; TEST4U"},"content":{"rendered":"<p>\u0397 \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ae \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b5\u03bd\u03cc\u03c2 data analyst \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af \u03b5\u03c5\u03c1\u03b5\u03af\u03b1 \u03b3\u03ba\u03ac\u03bc\u03b1 \u03b4\u03b5\u03be\u03b9\u03bf\u03c4\u03ae\u03c4\u03c9\u03bd \u03ba\u03b1\u03b9 \u03ba\u03b1\u03bb\u03ae \u03b3\u03bd\u03ce\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel.<br \/>\n<span class=\"text_exposed_show\"><br \/>\n\u0395\u03ac\u03bd \u03bf \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03b1\u03ba\u03cc\u03c2 \u03c3\u03b1\u03c2 \u03c3\u03c4\u03cc\u03c7\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bd\u03b1 \u03b3\u03af\u03bd\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b5\u03c0\u03b9\u03c4\u03c5\u03c7\u03b7\u03bc\u03ad\u03bd\u03bf\u03c2 \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03ae\u03c2, \u03b1\u03bb\u03bb\u03ac \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03bb\u03af\u03b3\u03b5\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b4\u03b5\u03be\u03b9\u03cc\u03c4\u03b7\u03c4\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03bf\u03c5 MS-Excel, \u03c4\u03bf TEST4U Data Analisis \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03af \u03c4\u03bf\u03bd \u03b1\u03c0\u03cc\u03bb\u03c5\u03c4\u03bf \u03b4\u03b9\u03b1\u03b4\u03c1\u03b1\u03c3\u03c4\u03b9\u03ba\u03cc \u03bf\u03b4\u03b7\u03b3\u03cc \u03b5\u03ba\u03c0\u03b1\u03af\u03b4\u03b5\u03c5\u03c3\u03b7\u03c2!<\/span><\/p>\n<p>\u03a4\u03bf TEST4U \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03b2\u03bf\u03b7\u03b8\u03ae\u03c3\u03b5\u03b9 \u03bd\u03b1 \u03b1\u03c0\u03bf\u03ba\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c0\u03bf\u03bb\u03cd\u03c4\u03b9\u03bc\u03b5\u03c2 \u03b4\u03b5\u03be\u03b9\u03cc\u03c4\u03b7\u03c4\u03b5\u03c2, \u03ba\u03b1\u03b8\u03ce\u03c2:<br \/>\n\u2022 \u0398\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03c9\u03bd \u03b1\u03c0\u03cc 180 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd \u03c3\u03c4\u03bf Excel, \u03c0\u03bf\u03c5 \u03b1\u03c6\u03bf\u03c1\u03bf\u03cd\u03bd:<br \/>\no \u0394\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7 \u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 (text manipulation)<br \/>\no \u0391\u03c1\u03b9\u03b8\u03bc\u03b7\u03c4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03bc\u03bf\u03cd\u03c2 (mathematical calculation)<br \/>\no \u039b\u03bf\u03b3\u03b9\u03ba\u03ad\u03c2 \u03b1\u03c0\u03bf\u03c6\u03ac\u03c3\u03b5\u03b9\u03c2 (logical decisions)<br \/>\no \u038c\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 lookup (lookup functions) \u03bc\u03b5 \u03c4\u03b9\u03c2 \u03bf\u03c0\u03bf\u03af\u03b5\u03c2 \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03b1\u03bd\u03b1\u03ba\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2<br \/>\no \u03a3\u03c7\u03b5\u03b4\u03cc\u03bd \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03bf\u03b9\u03ba\u03bf\u03bd\u03bf\u03bc\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 (financial functions) \u03ba\u03b1\u03b9<br \/>\no \u03a3\u03c7\u03b5\u03b4\u03cc\u03bd \u03cc\u03bb\u03b5\u03c2 \u03c4\u03b9\u03c2 \u03c3\u03c4\u03b1\u03c4\u03b9\u03c3\u03c4\u03b9\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 (statistical functions) \u03c0\u03bf\u03c5 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf Excel<br \/>\n\u2022 \u0398\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03c9\u03bd \u03c4\u03cd\u03c0\u03c9\u03bd array and multi-sheet (array and multi-sheet formulas), \u03bf\u03b9 \u03bf\u03c0\u03bf\u03af\u03bf\u03b9 \u03c0\u03b1\u03c1\u03ad\u03c7\u03bf\u03c5\u03bd \u03c4\u03b7\u03bd \u03b5\u03c5\u03b5\u03bb\u03b9\u03be\u03af\u03b1 \u03c0\u03bf\u03c5 \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af\u03c4\u03b1\u03b9 \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03b1\u03c0\u03cc \u03c0\u03bf\u03bb\u03bb\u03b1\u03c0\u03bb\u03ad\u03c2 \u03c0\u03b7\u03b3\u03ad\u03c2 (multiple sources).<\/p>\n<p>\u03a4\u03b1 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03c9\u03bc\u03ad\u03bd\u03b1 \u0395\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03b1 \u03a0\u03c1\u03cc\u03b2\u03bb\u03b5\u03c8\u03b7\u03c2 (built-in what-if tools) \u03c4\u03bf\u03c5 Excel \u03bc\u03b1\u03b6\u03af \u03bc\u03b5 \u03c4\u03bf \u03a0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c4\u03bf \u0395\u03c0\u03af\u03bb\u03c5\u03c3\u03b7\u03c2 (Solver add-in)\u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03bf\u03cd\u03bd \u03c4\u03bf\u03bd \u03c0\u03b9\u03bf \u03c3\u03af\u03b3\u03bf\u03c5\u03c1\u03bf \u03c4\u03c1\u03cc\u03c0\u03bf \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03b1\u03c0\u03ac\u03bd\u03c4\u03b7\u03c3\u03b7 \u03c3\u03c4\u03b1 \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ac \u03b5\u03c1\u03c9\u03c4\u03ae\u03bc\u03b1\u03c4\u03b1 \u03ba\u03b1\u03b9 \u03c0\u03c1\u03bf\u03b2\u03bb\u03ae\u03bc\u03b1\u03c4\u03b1 \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03c7\u03c1\u03b5\u03b9\u03b1\u03c3\u03c4\u03b5\u03af \u03bd\u03b1 \u03b1\u03bd\u03c4\u03b9\u03bc\u03b5\u03c4\u03c9\u03c0\u03af\u03c3\u03b5\u03c4\u03b5 (\u03b3\u03b9\u03b1 \u03c0\u03b1\u03c1\u03ac\u03b4\u03b5\u03b9\u03b3\u03bc\u03b1, \u03c0\u03bf\u03b9\u03b1 \u03b8\u03b1 \u03c0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03b7 \u03b1\u03cd\u03be\u03b7\u03c3\u03b7 \u03c4\u03b7\u03c2 \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03ae\u03c2 \u03b5\u03bd\u03cc\u03c2 \u03b5\u03c1\u03b3\u03bf\u03c3\u03c4\u03b1\u03c3\u03af\u03bf\u03c5, \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03c0\u03b9\u03c4\u03b5\u03c5\u03c7\u03b8\u03b5\u03af \u03bf \u03c3\u03c4\u03cc\u03c7\u03bf\u03c2 \u03c4\u03bf\u03c5 \u03b5\u03c0\u03cc\u03bc\u03b5\u03bd\u03bf\u03c5 \u03bc\u03ae\u03bd\u03b1).<\/p>\n<p>\u039a\u03b1\u03bd\u03b5\u03af\u03c2 \u03b4\u03b5\u03bd \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b1\u03c0\u03bf\u03c6\u03cd\u03b3\u03b5\u03b9 \u03c4\u03b1 \u03bb\u03ac\u03b8\u03b7, \u03c9\u03c3\u03c4\u03cc\u03c3\u03bf \u03c4\u03bf \u03ba\u03b5\u03c6\u03ac\u03bb\u03b1\u03b9\u03bf \u03c0\u03b5\u03c1\u03af \u0395\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03c9\u03bd \u0395\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 (Auditing tools) \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03bc\u03ac\u03b8\u03b5\u03b9 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03c4\u03b1 \u03b5\u03bb\u03b1\u03c7\u03b9\u03c3\u03c4\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5.<\/p>\n<p>\u0394\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd (Data Management): \u03a4\u03bf \u03ba\u03b5\u03c6\u03ac\u03bb\u03b1\u03b9\u03bf \u03c0\u03bf\u03c5 \u03b1\u03c3\u03c7\u03bf\u03bb\u03b5\u03af\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03c4\u03b7\u03bd \u03b4\u03b9\u03b1\u03c7\u03b5\u03af\u03c1\u03b9\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03b8\u03b1 \u03b4\u03b9\u03b5\u03c5\u03c1\u03cd\u03bd\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03b3\u03bd\u03ce\u03c3\u03b5\u03b9\u03c2 \u03c3\u03b1\u03c2 \u03c3\u03c4\u03bf\u03bd \u03c7\u03b5\u03b9\u03c1\u03b9\u03c3\u03bc\u03cc \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd (data manipulation) \u03b4\u03b5\u03af\u03c7\u03bd\u03bf\u03bd\u03c4\u03ac\u03c2 \u03c3\u03b1\u03c2 \u03c4\u03c1\u03cc\u03c0\u03bf\u03c5\u03c2 \u03bd\u03b1:<\/p>\n<p>o \u0395\u03b9\u03c3\u03ac\u03b3\u03b5\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c0\u03bf\u03b9\u03ba\u03af\u03bb\u03b5\u03c2 \u03c0\u03b7\u03b3\u03ad\u03c2 (Import data from various sources)<br \/>\no \u0395\u03c6\u03b1\u03c1\u03bc\u03cc\u03b6\u03b5\u03c4\u03b5 \u03a6\u03af\u03bb\u03c4\u03c1\u03b1 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 (Filter data)<br \/>\no \u03a4\u03b1\u03be\u03b9\u03bd\u03bf\u03bc\u03b5\u03af\u03c4\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 (Sort data)<br \/>\no \u03a7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03c3\u03c4\u03bf\u03b9\u03c7\u03b5\u03af\u03b1 \u03b5\u03bb\u03ad\u03b3\u03c7\u03bf\u03c5 \u03c6\u03bf\u03c1\u03bc\u03ce\u03bd (form controls) \u03ce\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b5\u03af\u03c3\u03c4\u03b5 \u03c3\u03b5 \u03b8\u03ad\u03c3\u03b7 \u03bd\u03b1 \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 dashboard (dashboard-like sheets)<br \/>\no \u03a7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03c4\u03bf \u03c0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c4\u03bf \u0391\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7\u03c2 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd (Data Analysis Tool Pak add-in).<\/p>\n<p>\u03a4\u03bf \u03c0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c4\u03bf \u0391\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7\u03c2 \u0394\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd (Data Analysis Tool Pak add-in) \u03c3\u03b5 \u03c3\u03c5\u03bd\u03b4\u03c5\u03b1\u03c3\u03bc\u03cc \u03bc\u03b5 \u03c4\u03bf \u03c0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c4\u03bf \u0395\u03c0\u03af\u03bb\u03c5\u03c3\u03b7\u03c2 (Solver add-in)\u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03bf\u03cd\u03bd \u03c4\u03b1 \u03b2\u03b1\u03c3\u03b9\u03ba\u03ac \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03b1 \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03b1\u03c0\u03ac\u03bd\u03c4\u03b7\u03c3\u03b7 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03bf \u03b5\u03be\u03b5\u03b9\u03b4\u03b9\u03ba\u03b5\u03c5\u03bc\u03ad\u03bd\u03c9\u03bd \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03c9\u03bd, \u03c0\u03bf\u03c5 \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03bf\u03cd\u03bd \u03ba\u03bf\u03bc\u03bc\u03ac\u03c4\u03b9 \u03c4\u03b7\u03c2 \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ae\u03c2 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03cc\u03c3\u03c9\u03bd \u03b1\u03c3\u03c7\u03bf\u03bb\u03bf\u03cd\u03bd\u03c4\u03b1\u03b9 \u03bc\u03b5 \u03c3\u03c4\u03b1\u03c4\u03b9\u03c3\u03c4\u03b9\u03ba\u03ae \u03b1\u03bd\u03ac\u03bb\u03c5\u03c3\u03b7 (statistical analysis), \u03ae \u03bc\u03bf\u03bd\u03c4\u03b5\u03bb\u03bf\u03c0\u03bf\u03af\u03b7\u03c3\u03b7 \u03b5\u03c0\u03b9\u03c7\u03b5\u03b9\u03c1\u03b7\u03bc\u03b1\u03c4\u03b9\u03ba\u03ce\u03bd \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03b9\u03ce\u03bd (business modelling).<\/p>\n<p>\u0398\u03b1 \u03b5\u03ba\u03c0\u03b1\u03b9\u03b4\u03b5\u03c5\u03c4\u03b5\u03af\u03c4\u03b5 \u03c3\u03c4\u03bf\u03bd \u03c4\u03c1\u03cc\u03c0\u03bf \u03b1\u03c0\u03ac\u03bd\u03c4\u03b7\u03c3\u03b7\u03c2 \u03b1\u03c5\u03c4\u03ce\u03bd \u03c4\u03c9\u03bd \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd \u03bc\u03ad\u03c3\u03b1 \u03b1\u03c0\u03cc \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b1 \u03b1\u03c0\u03cc \u03c4\u03c1\u03b9\u03ac\u03bd\u03c4\u03b1 (30) \u03c0\u03b1\u03c1\u03b1\u03b4\u03b5\u03af\u03b3\u03bc\u03b1\u03c4\u03b1 \u03b5\u03bc\u03c0\u03bd\u03b5\u03c5\u03c3\u03bc\u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b7\u03bd \u03b5\u03c0\u03b9\u03c7\u03b5\u03b9\u03c1\u03b7\u03bc\u03b1\u03c4\u03b9\u03ba\u03ae \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03cc\u03c4\u03b7\u03c4\u03b1 (\u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7 \u03ba\u03b1\u03b9 \u03b5\u03c1\u03bc\u03b7\u03bd\u03b5\u03af\u03b1 \u03c4\u03b7\u03c2 \u03c3\u03c4\u03b1\u03c4\u03b9\u03c3\u03c4\u03b9\u03ba\u03ae\u03c2 \u03a0\u03b1\u03bb\u03b9\u03bd\u03b4\u03c1\u03cc\u03bc\u03b7\u03c3\u03b7\u03c2, \u03c0\u03c1\u03cc\u03b2\u03bb\u03b5\u03c8\u03b7 \u03b5\u03c3\u03cc\u03b4\u03c9\u03bd \u03ae \u03b5\u03ba\u03c4\u03ad\u03bb\u03b5\u03c3\u03b7 \u03c0\u03c1\u03bf\u03c3\u03bf\u03bc\u03bf\u03af\u03c9\u03c3\u03b7\u03c2 Monte Carlo).<\/p>\n<p>Power Maps! \u0388\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03c0\u03b9\u03bf \u03b5\u03bd\u03c4\u03c5\u03c0\u03c9\u03c3\u03b9\u03b1\u03ba\u03ac \u03c0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c4\u03b1 \u03c4\u03bf\u03c5 Excel, \u03c3\u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03b1\u03c6\u03b9\u03b5\u03c1\u03ce\u03c3\u03b1\u03bc\u03b5 \u03ad\u03bd\u03b1 \u03bf\u03bb\u03cc\u03ba\u03bb\u03b7\u03c1\u03bf \u03ba\u03b5\u03c6\u03ac\u03bb\u03b1\u03b9\u03bf!<\/p>\n<p>\u0398\u03b1 \u03b5\u03af\u03c3\u03c4\u03b5 \u03c3\u03b5 \u03b8\u03ad\u03c3\u03b7 \u03bd\u03b1 \u03b1\u03c0\u03bf\u03c3\u03c0\u03ac\u03c3\u03b5\u03c4\u03b5 \u03c0\u03bf\u03bb\u03cd\u03c4\u03b9\u03bc\u03b7 \u03c0\u03bb\u03b7\u03c1\u03bf\u03c6\u03cc\u03c1\u03b7\u03c3\u03b7 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b5\u03bd\u03cc\u03c2 \u03a0\u03af\u03bd\u03b1\u03ba\u03b1 Pivot (Pivot Table): \u039c\u03b5\u03c4\u03ac \u03c4\u03bf \u03c0\u03ad\u03c1\u03b1\u03c2 \u03c4\u03b7\u03c2 \u03b5\u03be\u03ac\u03c3\u03ba\u03b7\u03c3\u03b7\u03c2, \u03b8\u03b1 \u03b5\u03af\u03c3\u03c4\u03b5 \u03ad\u03c4\u03bf\u03b9\u03bc\u03bf\u03b9 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c4\u03bf\u03c5\u03c2 \u03a0\u03af\u03bd\u03b1\u03ba\u03b5\u03c2 Pivot \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03b5\u03ba\u03bc\u03b5\u03c4\u03b1\u03bb\u03bb\u03b5\u03c5\u03c4\u03b5\u03af\u03c4\u03b5 \u03cc\u03bb\u03b1 \u03c4\u03b1 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ac \u03c4\u03bf\u03c5\u03c2, \u03cc\u03c0\u03c9\u03c2 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03b5\u03c4\u03b5 \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03ad\u03c2 (slicers), \u03b3\u03c1\u03b1\u03bc\u03bc\u03ad\u03c2 \u03c4\u03ac\u03c3\u03b7\u03c2 (trendlines) \u03ba\u03b1\u03b9 \u03b4\u03b9\u03b1\u03b3\u03c1\u03ac\u03bc\u03bc\u03b1\u03c4\u03b1 pivot (pivot charts). \u0395\u03c0\u03b9\u03c0\u03bb\u03ad\u03bf\u03bd, \u03b8\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03b5\u03af\u03c4\u03b5 \u03cc\u03bb\u03b1 \u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b1\u03c2 \u03bc\u03b5 \u03c4\u03bf Power View.<\/p>\n<p>\u0397 \u03c7\u03c1\u03ae\u03c3\u03b7 \u03bc\u03b5\u03b3\u03ac\u03bb\u03bf\u03c5 \u03cc\u03b3\u03ba\u03bf\u03c5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03c0\u03bf\u03c1\u03b5\u03af \u03bd\u03b1 \u03b1\u03c0\u03bf\u03b4\u03b5\u03b9\u03c7\u03c4\u03b5\u03af \u03b4\u03cd\u03c3\u03ba\u03bf\u03bb\u03b7, \u03b5\u03b9\u03b4\u03b9\u03ba\u03ac \u03cc\u03c4\u03b1\u03bd \u03b5\u03c0\u03b9\u03b8\u03c5\u03bc\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03b1\u03c0\u03bf\u03c3\u03c0\u03ac\u03c3\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1 \u03c4\u03bc\u03ae\u03bc\u03b1 \u03c4\u03bf\u03c5\u03c2. \u03a4\u03bf Excel \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03b4\u03b7\u03bc\u03b9\u03bf\u03c5\u03c1\u03b3\u03af\u03b1 \u03b5\u03c1\u03c9\u03c4\u03b7\u03bc\u03ac\u03c4\u03c9\u03bd \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c4\u03bf\u03c5 \u03c6\u03cd\u03bb\u03bb\u03bf\u03c5 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2, \u03cc\u03c0\u03c9\u03c2 \u03c3\u03b5 \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd. \u03a4\u03bf \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf \u03b1\u03c5\u03c4\u03cc \u03bf\u03bd\u03bf\u03bc\u03b1\u03b6\u03cc\u03c4\u03b1\u03bd Power Query \u03c3\u03c4\u03b9\u03c2 \u03c0\u03b1\u03bb\u03b1\u03b9\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 Excel, \u03ba\u03b1\u03b9 \u03b1\u03c0\u03bf\u03c6\u03b1\u03c3\u03af\u03c3\u03b1\u03bc\u03b5 \u03bd\u03b1 \u03c4\u03bf\u03c5 \u03b1\u03c6\u03b9\u03b5\u03c1\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03ad\u03bd\u03b1 \u03bf\u03bb\u03cc\u03ba\u03bb\u03b7\u03c1\u03bf \u03ba\u03b5\u03c6\u03ac\u03bb\u03b1\u03b9\u03bf.<\/p>\n<p>\u039f \u03bc\u03b5\u03b3\u03ac\u03bb\u03bf\u03c2 \u03cc\u03b3\u03ba\u03bf\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03b1\u03c0\u03cc \u03c0\u03bf\u03bb\u03bb\u03b1\u03c0\u03bb\u03ad\u03c2 \u03c0\u03b7\u03b3\u03ad\u03c2 \u03b4\u03b5\u03bd \u03b8\u03b1 \u03c0\u03c1\u03bf\u03ba\u03b1\u03bb\u03b5\u03af \u03c0\u03b9\u03b1 \u03c0\u03bf\u03bd\u03bf\u03ba\u03b5\u03c6\u03ac\u03bb\u03bf\u03c5\u03c2! \u03a4\u03b1 \u03b1\u03ba\u03cc\u03bb\u03bf\u03c5\u03b8\u03b1 \u03ba\u03b5\u03c6\u03ac\u03bb\u03b1\u03b9\u03b1 \u03b8\u03b1 \u03b4\u03c1\u03ac\u03c3\u03bf\u03c5\u03bd \u03b1\u03bd\u03b1\u03bb\u03b3\u03b7\u03c4\u03b9\u03ba\u03ac:<br \/>\no \u03a0\u03c1\u03cc\u03c3\u03b8\u03b5\u03c4\u03bf Power Pivot<br \/>\no \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 Cube<br \/>\no \u03a3\u03c5\u03bd\u03b1\u03c1\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 DAX<\/p>\n<p>\u0394\u03b9\u03b1\u03bc\u03bf\u03b9\u03c1\u03b1\u03c3\u03bc\u03cc\u03c2 (Sharing): \u0397 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b4\u03b5\u03bd \u03bc\u03ad\u03bd\u03b5\u03b9 \u03ba\u03c1\u03c5\u03c6\u03ae. \u03a4\u03b7\u03bd \u03bc\u03bf\u03b9\u03c1\u03b1\u03b6\u03cc\u03bc\u03b1\u03c3\u03c4\u03b5 \u03bc\u03b5 \u03c0\u03c1\u03bf\u03ca\u03c3\u03c4\u03b1\u03bc\u03ad\u03bd\u03bf\u03c5\u03c2 \u03ba\u03b1\u03b9 \u03c3\u03c5\u03bd\u03b1\u03b4\u03ad\u03bb\u03c6\u03bf\u03c5\u03c2. \u0398\u03b1 \u03bc\u03ac\u03b8\u03b5\u03c4\u03b5 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03b1\u03c0\u03bf\u03b8\u03b7\u03ba\u03b5\u03cd\u03b5\u03c4\u03b5 \u03c4\u03bf \u03b2\u03b9\u03b2\u03bb\u03af\u03bf \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03c3\u03b1\u03c2 \u03bc\u03b5 \u03b4\u03b9\u03b1\u03c6\u03bf\u03c1\u03b5\u03c4\u03b9\u03ba\u03ac \u03c6\u03bf\u03c1\u03bc\u03ac\u03c4 (format) \u03ba\u03b1\u03b9 \u03c0\u03ce\u03c2 \u03bd\u03b1 \u03c4\u03bf \u03bc\u03bf\u03b9\u03c1\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03bc\u03b5 \u03c4\u03b7\u03bd \u03bf\u03bc\u03ac\u03b4\u03b1 \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1\u03c2 \u03c3\u03b1\u03c2.<\/p>\n<p>\u03a5\u03c0\u03ac\u03c1\u03c7\u03b5\u03b9 \u03ad\u03bd\u03b1 \u03b5\u03ba\u03c4\u03b5\u03bd\u03ad\u03c2 \u03ba\u03b5\u03c6\u03ac\u03bb\u03b1\u03b9\u03bf \u03c0\u03bf\u03c5 \u03b1\u03c6\u03bf\u03c1\u03ac \u03c4\u03b7\u03bd \u03b2\u03b1\u03c3\u03b9\u03ba\u03ae \u03b5\u03ba\u03c0\u03b1\u03af\u03b4\u03b5\u03c5\u03c3\u03b7 \u03c3\u03c4\u03bf Excel, \u03c7\u03c1\u03ae\u03c3\u03b9\u03bc\u03bf \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03cc\u03c0\u03bf\u03c5 \u03b8\u03ad\u03bb\u03b5\u03c4\u03b5 \u03bd\u03b1 \u03be\u03b5\u03c3\u03ba\u03bf\u03bd\u03af\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03b3\u03bd\u03ce\u03c3\u03b5\u03b9\u03c2 \u03c3\u03b1\u03c2, \u03ae \u03c3\u03c4\u03b7\u03bd \u03c0\u03b5\u03c1\u03af\u03c0\u03c4\u03c9\u03c3\u03b7 \u03c0\u03bf\u03c5 \u03b5\u03af\u03c3\u03c4\u03b5 \u03b1\u03c0\u03cc \u03c4\u03bf\u03c5\u03c2 \u03bd\u03ad\u03bf\u03c5\u03c2 \u03c3\u03c4\u03bf\u03bd \u03c7\u03ce\u03c1\u03bf.<\/p>\n<p>\u03a0\u03c9\u03c2 \u03bb\u03b5\u03b9\u03c4\u03bf\u03c5\u03c1\u03b3\u03b5\u03af \u03c4\u03bf TEST4U<\/p>\n<p>\u03a4\u03bf TEST4U Data Analysis Test \u03b5\u03af\u03bd\u03b1\u03b9 \u03ad\u03bd\u03b1 \u03c0\u03bb\u03ae\u03c1\u03c9\u03c2 \u03c0\u03b1\u03c1\u03b1\u03bc\u03b5\u03c4\u03c1\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03b9\u03bc\u03bf, \u03b4\u03b9\u03b1\u03b4\u03c1\u03b1\u03c3\u03c4\u03b9\u03ba\u03cc \u03b5\u03c1\u03b3\u03b1\u03bb\u03b5\u03af\u03bf, \u03c4\u03bf \u03bf\u03c0\u03bf\u03af\u03bf \u03b9\u03ba\u03b1\u03bd\u03bf\u03c0\u03bf\u03b9\u03b5\u03af \u03c4\u03bf\u03c5\u03c2 \u03c0\u03c1\u03bf\u03c3\u03c9\u03c0\u03b9\u03ba\u03bf\u03cd\u03c2 \u03b5\u03ba\u03c0\u03b1\u03b9\u03b4\u03b5\u03c5\u03c4\u03b9\u03ba\u03bf\u03cd\u03c2 \u03c3\u03b1\u03c2 \u03c3\u03c4\u03cc\u03c7\u03bf\u03c5\u03c2. \u0397 \u03c0\u03bf\u03bb\u03cd-\u03bc\u03b5\u03c3\u03b9\u03ba\u03ae \u03b5\u03bc\u03c0\u03b5\u03b9\u03c1\u03af\u03b1 \u03c0\u03bf\u03c5 \u03c0\u03b1\u03c1\u03ad\u03c7\u03b5\u03b9 \u03c4\u03bf TEST4U \u03c3\u03b1\u03c2 \u03b4\u03af\u03bd\u03b5\u03b9 \u03c4\u03b7\u03bd \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03b4\u03b9\u03b5\u03c5\u03c1\u03cd\u03bd\u03b5\u03c4\u03b5 \u03c4\u03bf\u03bd \u03b2\u03b1\u03b8\u03bc\u03cc \u03ba\u03b1\u03c4\u03b1\u03bd\u03cc\u03b7\u03c3\u03b7\u03c2 \u03c4\u03bf\u03c5 MS Excel, \u03c4\u03bf\u03c5 \u03c0\u03b1\u03c3\u03af\u03b3\u03bd\u03c9\u03c3\u03c4\u03bf\u03c5 \u03ba\u03b1\u03b9 \u03b5\u03c5\u03ad\u03bb\u03b9\u03ba\u03c4\u03bf\u03c5 \u03a5\u03c0\u03bf\u03bb\u03bf\u03b3\u03b9\u03c3\u03c4\u03b9\u03ba\u03bf\u03cd \u03a0\u03c1\u03bf\u03b3\u03c1\u03ac\u03bc\u03bc\u03b1\u03c4\u03bf\u03c2 \u03c4\u03b7\u03c2 Microsoft, \u03bc\u03b5 \u03c4\u03bf \u03bc\u03b5\u03b3\u03b1\u03bb\u03cd\u03c4\u03b5\u03c1\u03bf \u03c0\u03bb\u03ae\u03b8\u03bf\u03c2 \u03c7\u03b1\u03c1\u03b1\u03ba\u03c4\u03b7\u03c1\u03b9\u03c3\u03c4\u03b9\u03ba\u03ce\u03bd, \u03b3\u03b9\u03b1 \u03a0\u03c1\u03bf\u03c7\u03c9\u03c1\u03b7\u03bc\u03ad\u03bd\u03bf \u0395\u03c0\u03af\u03c0\u03b5\u03b4\u03bf.<\/p>\n<p>\u03a4\u03bf TEST4U Data Analysis Test \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03b2\u03bf\u03b7\u03b8\u03ae\u03c3\u03b5\u03b9 \u03bd\u03b1 \u03b2\u03b5\u03bb\u03c4\u03b9\u03ce\u03c3\u03b5\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03b4\u03b5\u03be\u03b9\u03cc\u03c4\u03b7\u03c4\u03ad\u03c2 \u03c3\u03b1\u03c2 \u03b4\u03b9\u03cc\u03c4\u03b9 \u03c0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9:<br \/>\n\u2022 729 Live in ates \u0395\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2<br \/>\n\u2022 37 \u0395\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 Quiz<\/p>\n<p>\u03a4\u03bf TEST4U Data Analysis Test \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03b5\u03bd\u03b9\u03c3\u03c7\u03cd\u03c3\u03b5\u03b9 \u03ba\u03b1\u03c4\u03ac \u03c4\u03b7\u03bd \u03b4\u03b9\u03ac\u03c1\u03ba\u03b5\u03b9\u03b1 \u03c4\u03b7\u03c2 \u03b5\u03ba\u03bc\u03ac\u03b8\u03b7\u03c3\u03b7\u03c2: \u03bc\u03ad\u03c3\u03c9 \u03c4\u03b7\u03c2 \u03c0\u03c1\u03b1\u03ba\u03c4\u03b9\u03ba\u03ae\u03c2 \u03b5\u03c6\u03b1\u03c1\u03bc\u03bf\u03b3\u03ae\u03c2 \u03c3\u03b5 \u03b1\u03c3\u03ba\u03ae\u03c3\u03b5\u03b9\u03c2 \u03ba\u03b1\u03b9 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c4\u03b9\u03c2 \u03bf\u03c0\u03bf\u03af\u03b5\u03c2 \u03ba\u03b1\u03bb\u03b5\u03af\u03c3\u03c4\u03b5 \u03bd\u03b1 \u03b1\u03c0\u03b1\u03bd\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5, \u03cc\u03c7\u03b9 \u03bc\u03b5 \u03c0\u03b1\u03b8\u03b7\u03c4\u03b9\u03ba\u03ae \u03c0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03cd\u03b8\u03b7\u03c3\u03b7 \u03ba\u03ac\u03c0\u03bf\u03b9\u03bf\u03c5 \u03c8\u03b7\u03c6\u03b9\u03b1\u03ba\u03bf\u03cd \u03c5\u03bb\u03b9\u03ba\u03bf\u03cd \u03ba\u03b1\u03b9 \u03b1\u03c0\u03ac\u03bd\u03c4\u03b7\u03c3\u03b7 \u03c3\u03b5 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03bb\u03bb\u03b1\u03c0\u03bb\u03ce\u03bd \u03b5\u03c0\u03b9\u03bb\u03bf\u03b3\u03ce\u03bd. \u0395\u03ac\u03bd \u03bf\u03b9 \u03b3\u03bd\u03ce\u03c3\u03b5\u03b9\u03c2 \u03c3\u03b1\u03c2 \u03b3\u03b9\u03b1 \u03ba\u03ac\u03c0\u03bf\u03b9\u03b1 \u03b8\u03ad\u03bc\u03b1\u03c4\u03b1 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c0\u03b5\u03c1\u03b9\u03bf\u03c1\u03b9\u03c3\u03bc\u03ad\u03bd\u03b5\u03c2, \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03c0\u03b1\u03c1\u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03b5\u03af\u03c4\u03b5 \u03c4\u03b9\u03c2 \u03c3\u03cd\u03bd\u03c4\u03bf\u03bc\u03b5\u03c2 \u03b2\u03b9\u03bd\u03c4\u03b5\u03bf\u03bb\u03cd\u03c3\u03b5\u03b9\u03c2 \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03ba\u03b1\u03b8\u03bf\u03b4\u03b7\u03b3\u03ae\u03c3\u03bf\u03c5\u03bd \u03b2\u03ae\u03bc\u03b1-\u03c0\u03c1\u03bf\u03c2-\u03b2\u03ae\u03bc\u03b1.<\/p>\n<p>\u03a4\u03bf TEST4U Data Analysis Test \u03b4\u03b9\u03b1\u03c6\u03ad\u03c1\u03b5\u03b9 \u03b1\u03c0\u03cc \u03ad\u03bd\u03b1 \u03b1\u03c0\u03bb\u03cc \u03b2\u03b9\u03bd\u03c4\u03b5\u03bf\u03bc\u03ac\u03b8\u03b7\u03bc\u03b1 \u03bc\u03b5 \u03bc\u03b5\u03c1\u03b9\u03ba\u03ad\u03c2 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2 \u03ba\u03bb\u03b5\u03b9\u03c3\u03c4\u03bf\u03cd \u03c4\u03cd\u03c0\u03bf\u03c5. \u03a0\u03b5\u03c1\u03b9\u03ad\u03c7\u03b5\u03b9 \u03b5\u03c1\u03c9\u03c4\u03ae\u03c3\u03b5\u03b9\u03c2, \u03b7 \u03b1\u03c0\u03ac\u03bd\u03c4\u03b7\u03c3\u03b7 \u03c4\u03c9\u03bd \u03bf\u03c0\u03bf\u03af\u03c9\u03bd \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af \u03bd\u03b1 \u03b5\u03ba\u03c4\u03b5\u03bb\u03b5\u03c3\u03c4\u03bf\u03cd\u03bd \u03c3\u03b5\u03b9\u03c1\u03ac \u03b5\u03bd\u03b5\u03c1\u03b3\u03b5\u03b9\u03ce\u03bd, \u03c4\u03b9\u03c2 \u03bf\u03c0\u03bf\u03af\u03b5\u03c2 \u03c4\u03bf TEST4U \u03b8\u03b1 \u03b1\u03be\u03b9\u03bf\u03bb\u03bf\u03b3\u03ae\u03c3\u03b5\u03b9. \u039c\u03b5 \u03b1\u03c5\u03c4\u03cc\u03bd \u03c4\u03bf\u03bd \u03c4\u03c1\u03cc\u03c0\u03bf \u03c4\u03bf TEST4U \u03c0\u03c1\u03bf\u03c3\u03bf\u03bc\u03bf\u03b9\u03ce\u03bd\u03b5\u03b9 \u03c4\u03b9\u03c2 \u03c0\u03c1\u03b1\u03b3\u03bc\u03b1\u03c4\u03b9\u03ba\u03ad\u03c2 \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03b1\u03ba\u03ad\u03c2 \u03c3\u03c5\u03bd\u03b8\u03ae\u03ba\u03b5\u03c2: \u0394\u03b5\u03bd \u03bc\u03c0\u03bf\u03c1\u03b5\u03af\u03c4\u03b5 \u03bd\u03b1 \u03bc\u03b1\u03bd\u03c4\u03ad\u03c8\u03b5\u03c4\u03b5! \u03a0\u03c1\u03ad\u03c0\u03b5\u03b9 \u03bd\u03b1 \u03b3\u03bd\u03c9\u03c1\u03af\u03b6\u03b5\u03c4\u03b5 \u03c0\u03bf\u03b9\u03b5\u03c2 \u03b4\u03b9\u03b1\u03b4\u03b9\u03ba\u03b1\u03c3\u03af\u03b5\u03c2 \u03bd\u03b1 \u03b1\u03ba\u03bf\u03bb\u03bf\u03c5\u03b8\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c0\u03c1\u03bf\u03ba\u03b5\u03b9\u03bc\u03ad\u03bd\u03bf\u03c5 \u03bd\u03b1 \u03b1\u03c0\u03b1\u03bd\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c3\u03c9\u03c3\u03c4\u03ac.<br \/>\n\u0397 \u03b5\u03be\u03b5\u03b9\u03b4\u03b9\u03ba\u03b5\u03c5\u03bc\u03ad\u03bd\u03b7 \u03bf\u03bc\u03ac\u03b4\u03b1 \u03bc\u03b1\u03c2 \u03ad\u03c7\u03b5\u03b9 \u03b5\u03bd\u03c3\u03c9\u03bc\u03b1\u03c4\u03ce\u03c3\u03b5\u03b9 \u03c4\u03b7\u03bd \u03bc\u03b1\u03ba\u03c1\u03cc\u03c7\u03c1\u03bf\u03bd\u03b7 \u03b5\u03ba\u03c0\u03b1\u03b9\u03b4\u03b5\u03c5\u03c4\u03b9\u03ba\u03ae \u03b5\u03bc\u03c0\u03b5\u03b9\u03c1\u03af\u03b1 \u03ba\u03b1\u03b9 \u03c4\u03b9\u03c2 \u03c4\u03b5\u03c7\u03bd\u03b9\u03ba\u03ad\u03c2 \u03b4\u03b9\u03b4\u03b1\u03c3\u03ba\u03b1\u03bb\u03af\u03b1\u03c2 \u03c3\u03c4\u03bf TEST4U.<\/p>\n<p><a href=\"https:\/\/www.test4u.eu\/el\/e-tests\/ms-excel-data-analysis-el\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" data-ft=\"{&quot;tn&quot;:&quot;-U&quot;}\" data-lynx-mode=\"asynclazy\" data-lynx-uri=\"https:\/\/l.facebook.com\/l.php?u=https%3A%2F%2Fwww.test4u.eu%2Fel%2Fe-tests%2Fms-excel-data-analysis-el&amp;h=AT3W4d8C3o13YykNnYWcBHJi0ZcwFjGx4CRAxqCivGz-5PXacnzPQWTmCk2ZXspDx1afMrphWo3tZWrWutiEW2abaf0WGDgkErvE7iH0DHlpRSalw_uwCJLqfJgnTq-DSdpdtg\">https:\/\/www.test4u.eu\/\u2026\/ms-excel-data-a\u2026<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>https:\/\/www.facebook.com\/test4u.eu\/videos\/10155974402194851\/<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Being a Data Analyst requires a variety of skills in Excel.<\/p>\n<p>If you dream of working as an analyst, but you lack a few skills in order to master MS-Excel, TEST4U Data Analyst is the ultimate know-how interactive tutor!<\/p>\n<p>We have equipped TEST4U with the following, in order to help you acquire these valuable skills:<\/p>\n<p>We will help you learn the usage of more than 180 Excel functions, about:<br \/>\n&#8211; Text manipulation<br \/>\n&#8211; Mathematical calculation<br \/>\n&#8211; Logical decisions<br \/>\n&#8211; All the lookup functions you can use to retrieve data from your sheets<br \/>\n&#8211; Almost all the financial functions and<br \/>\n&#8211; Almost all the statistical functions Excel has to offer<br \/>\n&#8211; You will learn about array and multi-sheet formulas, which will give you the needed flexibility to use data from multiple sources.<\/p>\n<p>The built-in what-if tools of Excel along with the Solver add-in are the sure way to answer everyday questions and problems you will face (for example how much should a factory increase production, to meet their quota for next month).<\/p>\n<p>No one can avoid mistakes, but the chapter about Auditing tools will teach how to minimize them<\/p>\n<p>Data Management: The chapter in data management will expand your knowledge on data manipulation showing you ways to:<br \/>\n&#8211; Import data from various sources<br \/>\n&#8211; Filter data<br \/>\n&#8211; Sort data<br \/>\n&#8211; Use form controls in order to be able to create dashboard-like sheets<br \/>\n&#8211; Use the Data Analysis Tool Pak add-in.<br \/>\n&#8211; The data analysis Tool Pak add-in along with the Solver add-in are the main tools you can use to answer to more specialized questions, which are part of the daily routine for someone who is doing statistical analysis, or business modelling. You will learn how to answer these questions with over thirty examples inspired by real life (display and interpret Regression statistics, predict a company\u2019s revenues or execute a Monte Carlo simulation).<\/p>\n<p>Power Maps! One of the most impressive add-ins of Excel, for which we have dedicated a whole chapter!<\/p>\n<p>You will be able to derive useful information from the data in a Pivot Table: Once you finish your training, you will be able to use pivot Tables at their full extent, including the use of slicers, trendlines, and pivot charts. In addition, you will learn how to use all your data with Power View.<\/p>\n<p>Using large amount of data can prove to be a lot difficult, especially if you want to extract a fragment of them. Excel provides a tool to create database like queries on your Excel data. For this tool, that was called Power Query on previous Excel versions, we decided to devote a complete chapter.<\/p>\n<p>Large amounts of data from various sources are no longer a headache! These chapters will change the way you deal with them:<br \/>\n&#8211; Power Pivot add-in<br \/>\n&#8211; Cube<br \/>\n&#8211; DAX functions<\/p>\n<p>Sharing: All professional work you do must be shared with your boss or colleagues. We will teach you how to save your workbooks in a variety of different formats and how to share your worksheets with your team.<\/p>\n<p>There is an extensive chapter on basic Excel training, in case you want to refresh on your Excel knowledge, or if you are newcomer to it<\/p>\n<p>How TEST4U works<br \/>\nTEST4U Data analyst Test is an interactive, highly customizable tool that meets your personal learning needs. During the media-rich TEST4U experience, you will amplify your understanding of MS Excel, the most famous and flexible spreadsheet software, part of Microsoft Office Suite.<\/p>\n<p>TEST4U Data analyst Test will help you improve your skills because it contains:<\/p>\n<p>729 Live in ates Questions<br \/>\n37 Quiz Questions<br \/>\nInstead of being just another e-lesson with a few multiple choice questions, TEST4U Data analyst Test makes the difference! The questions it contains require actual tasks to be performed. For each question, you are asked to take some actions, which TEST4U will evaluate. Much like the actual working conditions: you can\u2019t make educated guesses! In order to answer correctly, you must know which buttons to use.<\/p>\n<p>If your knowledge of a topic is limited, you can watch our video-solutions which guide you step-by-step.<\/p>\n<p><a href=\"https:\/\/l.facebook.com\/l.php?u=https%3A%2F%2Fwww.test4u.eu%2Fen%2Fe-tests%2Fms-excel-data-analysis-en&amp;h=AT2U7puPX9RfhV3dIqMSXY5F4dwbzA1f3nFGsGXN_OhbG4R68cQIqetjEyp8wnkosKwSG1PmFDNEKCXwUCAhbkIVJUmJwudElqUMFinNckZ30IO1aFS3_50CEFrxCNt9IttR2g\" target=\"_blank\" rel=\"nofollow noopener noreferrer\" data-ft=\"{&quot;tn&quot;:&quot;-U&quot;}\" data-lynx-mode=\"asynclazy\">https:\/\/www.test4u.eu\/en\/e-tests\/ms-excel-data-analysis-en<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0397 \u03ba\u03b1\u03b8\u03b7\u03bc\u03b5\u03c1\u03b9\u03bd\u03ae \u03b5\u03c1\u03b3\u03b1\u03c3\u03af\u03b1 \u03b5\u03bd\u03cc\u03c2 data analyst \u03b1\u03c0\u03b1\u03b9\u03c4\u03b5\u03af \u03b5\u03c5\u03c1\u03b5\u03af\u03b1 \u03b3\u03ba\u03ac\u03bc\u03b1 \u03b4\u03b5\u03be\u03b9\u03bf\u03c4\u03ae\u03c4\u03c9\u03bd \u03ba\u03b1\u03b9 \u03ba\u03b1\u03bb\u03ae \u03b3\u03bd\u03ce\u03c3\u03b7 \u03c4\u03bf\u03c5 Excel. \u0395\u03ac\u03bd \u03bf \u03b5\u03c1\u03b3\u03b1\u03c3\u03b9\u03b1\u03ba\u03cc\u03c2 \u03c3\u03b1\u03c2 \u03c3\u03c4\u03cc\u03c7\u03bf\u03c2 \u03b5\u03af\u03bd\u03b1\u03b9 \u03bd\u03b1 \u03b3\u03af\u03bd\u03b5\u03c4\u03b5 \u03ad\u03bd\u03b1\u03c2 \u03b5\u03c0\u03b9\u03c4\u03c5\u03c7\u03b7\u03bc\u03ad\u03bd\u03bf\u03c2 \u03b1\u03bd\u03b1\u03bb\u03c5\u03c4\u03ae\u03c2, \u03b1\u03bb\u03bb\u03ac \u03c7\u03c1\u03b5\u03b9\u03ac\u03b6\u03b5\u03c3\u03c4\u03b5 \u03bb\u03af\u03b3\u03b5\u03c2 \u03c0\u03b5\u03c1\u03b9\u03c3\u03c3\u03cc\u03c4\u03b5\u03c1\u03b5\u03c2 \u03b4\u03b5\u03be\u03b9\u03cc\u03c4\u03b7\u03c4\u03b5\u03c2 \u03b3\u03b9\u03b1 \u03c4\u03b7\u03bd \u03c7\u03c1\u03ae\u03c3\u03b7 \u03c4\u03bf\u03c5 MS-Excel, \u03c4\u03bf TEST4U Data Analisis \u03b1\u03c0\u03bf\u03c4\u03b5\u03bb\u03b5\u03af \u03c4\u03bf\u03bd \u03b1\u03c0\u03cc\u03bb\u03c5\u03c4\u03bf \u03b4\u03b9\u03b1\u03b4\u03c1\u03b1\u03c3\u03c4\u03b9\u03ba\u03cc \u03bf\u03b4\u03b7\u03b3\u03cc \u03b5\u03ba\u03c0\u03b1\u03af\u03b4\u03b5\u03c5\u03c3\u03b7\u03c2! \u03a4\u03bf TEST4U \u03b8\u03b1 \u03c3\u03b1\u03c2 \u03b2\u03bf\u03b7\u03b8\u03ae\u03c3\u03b5\u03b9 \u03bd\u03b1 \u03b1\u03c0\u03bf\u03ba\u03c4\u03ae\u03c3\u03b5\u03c4\u03b5 \u03c0\u03bf\u03bb\u03cd\u03c4\u03b9\u03bc\u03b5\u03c2 \u03b4\u03b5\u03be\u03b9\u03cc\u03c4\u03b7\u03c4\u03b5\u03c2, &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.test4u.eu\/blog\/data-analysis-with-excel-test4u\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Data Analysis with Excel &#8211; TEST4U&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[166],"tags":[],"class_list":["post-1005","post","type-post","status-publish","format-standard","hentry","category-data-analysis"],"_links":{"self":[{"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/posts\/1005","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=1005"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/posts\/1005\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/media?parent=1005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/categories?post=1005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/blog\/wp-json\/wp\/v2\/tags?post=1005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}