K\u00fctahya OSB Akademi\u2019de d\u00fczenlenen ileri d\u00fczey Excel e\u011fitimi yo\u011fun bir kat\u0131l\u0131mla tamamland\u0131. E\u011fitmen Semih Sungur taraf\u0131ndan verilen bu e\u011fitim, yo\u011fun kat\u0131l\u0131m\u0131yla dikkat \u00e7ekti. Kat\u0131l\u0131mc\u0131lar, Excel\u2019in ileri d\u00fczey kullan\u0131m\u0131na dair pek \u00e7ok yeni bilgi edinirken, becerilerini de \u00f6nemli \u00f6l\u00e7\u00fcde geli\u015ftirdiler.
\n
E\u011fitimde \u00f6ncelikle Excel kullan\u0131m\u0131 i\u00e7in \u00f6nemli olan k\u0131sayollar ve h\u0131zl\u0131 kullan\u0131m y\u00f6ntemleri \u00fczerinde duruldu. Kat\u0131l\u0131mc\u0131lara ayr\u0131ca otomatik doldurma, h\u0131zl\u0131 doldurma ve sayfalara doldurma teknikleri detayl\u0131 \u015fekilde anlat\u0131ld\u0131. Bu sayede i\u015f s\u00fcre\u00e7lerini h\u0131zland\u0131rman\u0131n ve verimlili\u011fi art\u0131rman\u0131n yollar\u0131 \u00f6\u011frenildi.
\n
Grafikler, Excel\u2019in en g\u00fc\u00e7l\u00fc ara\u00e7lar\u0131ndan biri olarak \u00f6ne \u00e7\u0131k\u0131yor. Bu sebeple, e\u011fitimde veriye uygun grafik t\u00fcr\u00fcn\u00fcn belirlenmesi ve uygulanmas\u0131 konusu da ayr\u0131nt\u0131l\u0131 bir \u015fekilde ele al\u0131nd\u0131. Kat\u0131l\u0131mc\u0131lar, farkl\u0131 grafik t\u00fcrlerinin nas\u0131l se\u00e7ilece\u011fini ve verilerini bu grafiklerle nas\u0131l daha etkili bir \u015fekilde g\u00f6rselle\u015ftirebileceklerini \u00f6\u011frendiler.
\n
E\u011fitimin bir di\u011fer \u00f6nemli k\u0131sm\u0131 ise form\u00fcl \u00e7ubu\u011fu ve i\u015flev ekle komutlar\u0131 ile fonksiyon kullan\u0131m\u0131 oldu. E\u011fitmen Sungur, temel fonksiyonlardan olan SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTBLANK ve SUBTOTAL gibi i\u015flevlerin kullan\u0131m alanlar\u0131n\u0131 ve p\u00fcf noktalar\u0131n\u0131 kat\u0131l\u0131mc\u0131larla payla\u015ft\u0131.
\n
Geli\u015fmi\u015f filtreleme (Advanced Filter) konusu, e\u011fitimdeki di\u011fer \u00f6nemli ba\u015fl\u0131klardan biriydi. Kat\u0131l\u0131mc\u0131lara, veri setlerini belirli kriterlere g\u00f6re nas\u0131l filtreleyebilecekleri ve bu sayede b\u00fcy\u00fck veri setlerini daha etkin bir \u015fekilde nas\u0131l analiz edebilecekleri \u00f6\u011fretildi.
\n
E\u011fitim sonunda kat\u0131l\u0131mc\u0131lar, Excel\u2019in daha etkin ve verimli kullan\u0131lmas\u0131na y\u00f6nelik bilgi ve becerilerini art\u0131rarak kursu ba\u015far\u0131 ile tamamlad\u0131lar.
<\/p>\n","protected":false},"excerpt":{"rendered":"
K\u00fctahya OSB Akademi\u2019de d\u00fczenlenen ileri d\u00fczey Excel e\u011fitimi yo\u011fun bir kat\u0131l\u0131mla tamamland\u0131. E\u011fitmen Semih Sungur taraf\u0131ndan verilen bu e\u011fitim, yo\u011fun kat\u0131l\u0131m\u0131yla dikkat \u00e7ekti. Kat\u0131l\u0131mc\u0131lar, Excel\u2019in ileri d\u00fczey kullan\u0131m\u0131na dair pek \u00e7ok yeni bilgi edinirken, becerilerini de \u00f6nemli \u00f6l\u00e7\u00fcde geli\u015ftirdiler. E\u011fitimde \u00f6ncelikle Excel kullan\u0131m\u0131 i\u00e7in \u00f6nemli olan k\u0131sayollar ve h\u0131zl\u0131 kullan\u0131m y\u00f6ntemleri \u00fczerinde duruldu. Kat\u0131l\u0131mc\u0131lara ayr\u0131ca…<\/p>\n","protected":false},"author":1,"featured_media":11974,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-11973","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-guncel"],"_links":{"self":[{"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/posts\/11973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11973"}],"version-history":[{"count":1,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/posts\/11973\/revisions"}],"predecessor-version":[{"id":11975,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/posts\/11973\/revisions\/11975"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=\/wp\/v2\/media\/11974"}],"wp:attachment":[{"href":"https:\/\/www.egemtv.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.egemtv.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}