{"id":907,"date":"2014-11-03T12:01:30","date_gmt":"2014-11-03T12:01:30","guid":{"rendered":"http:\/\/www.baduder.com\/?p=907"},"modified":"2015-02-22T12:04:03","modified_gmt":"2015-02-22T12:04:03","slug":"baduder-excel-egitimi","status":"publish","type":"post","link":"https:\/\/www.baduder.org\/tr\/baduder-excel-egitimi.html","title":{"rendered":"Baduder Excel E\u011fitimi"},"content":{"rendered":"<p><strong>Temel Excel E\u011fitimi<\/strong><\/p>\n<p><strong>E\u011fitimin Amac\u0131: <\/strong>Bu programda \u00e7al\u0131\u015fma ka\u011f\u0131tlar\u0131 haz\u0131rlayacak d\u00fczeye \u00e7\u0131kma, h\u0131zl\u0131 form\u00fcl \u00fcretip test etmeyi \u00f6\u011frenmek, iki mizandan kar\u015f\u0131la\u015ft\u0131rmal\u0131 mali tablo \u00fcretebilecek seviyeye gelmek temel d\u00fczeyde bilgi verilerek, kat\u0131l\u0131mc\u0131larda fark\u0131ndal\u0131k yarat\u0131lmas\u0131 sa\u011flanacakt\u0131r.<\/p>\n<p><strong>Kimler Kat\u0131lmal\u0131:<\/strong>Ba\u011f\u0131ms\u0131z Denet\u00e7iler, Excel\u2019i temel d\u00fczeyde almak isteyenler, YMM,SMMM\u2019ler.<\/p>\n<p><strong>E\u011fitimin \u0130\u00e7eri\u011fi:<\/strong><\/p>\n<ul>\n<li><strong><em>TEMEL EXCEL E\u011e\u0130T\u0130M\u0130<\/em><\/strong><\/li>\n<\/ul>\n<p><strong><em>\u00a0<\/em><\/strong><\/p>\n<ul>\n<li>EXCEL TEMEL FONKS\u0130YON TANIMLARI<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>EXCEL\u2019DE \u00c7\u00d6Z\u00dcC\u00dc VE \u00c7\u00d6Z\u00dcMLEME TANIMLARI+VBA EKLENT\u0130LER\u0130<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\u015eARTLI ARAMA VE \u0130STAT\u0130ST\u0130K\u0130 FONKS\u0130YONLARI DENET\u0130M AMA\u00c7LI<\/li>\n<\/ul>\n<p>KULLANILMASI<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>MAL\u0130 TABLO UYGULAMALARI (M\u0130ZANDAN MAL\u0130 TABLO \u00dcRET\u0130M\u0130)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>EXCEL \u00c7ALI\u015eMA K\u00c2\u011eITLARI HAZIRLAMA<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>Bu e\u011fitimler ileri d\u00fczeyde Excel bilen yan\u0131 makro kullanan veri taban\u0131ndan veri okuyup bunlar\u0131 de\u011ferlendirmeye alan ve yo\u011fun data ak\u0131\u015f\u0131 ile i\u015flem yapabilen kullan\u0131c\u0131lar i\u00e7in de\u011fildir. Ancak ba\u015flang\u0131\u00e7 d\u00fczeyinde olan meslekta\u015flar\u0131n bilgilerini geli\u015ftirmek i\u00e7indir. Ayr\u0131ca bilgisayarla te\u015friki mesaisi sadece muhasebe tutmak i\u00e7in olan meslekta\u015flar i\u00e7in biraz a\u011f\u0131r olmakla beraber bu e\u011fitim onlara hitap edecek \u015fekilde verilebilir. E\u011fitimler interaktif metotla ihtiyaca ve duruma uygun, bir ba\u015fka deyi\u015fle denetimde\u00a0\u00a0\u00a0\u00a0 tasarlad\u0131\u011f\u0131m\u0131z kontrol y\u00f6ntemlerini bilgi i\u015flemle kolayla\u015ft\u0131rmaya y\u00f6nelik olup bilgi i\u015flemden al\u0131nacak faydan\u0131n ancak ona do\u011fru ve anlaml\u0131 bilgiler girilmesiyle sa\u011flanaca\u011f\u0131n\u0131n fark\u0131nda olan ve denetimin ba\u015far\u0131s\u0131n\u0131n program\u0131n ba\u015far\u0131s\u0131 ile de\u011fil meslek mensubunun yetenekleri ile s\u0131n\u0131rl\u0131 olaca\u011f\u0131n\u0131 ba\u015ftan kabul eden herkese faydal\u0131 olaca\u011f\u0131 bilinmelidir.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Kat\u0131l\u0131mc\u0131lar e\u011fitme bilgisayarlar\u0131yla kat\u0131lmak durumundad\u0131r.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>E\u011e\u0130T\u0130M TAR\u0130H\u0130\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>30\/11\/2014-07\/12\/2014<\/strong>(Pazar g\u00fcnleri)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li>E\u011e\u0130T\u0130M SAATLER\u0130\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <strong>10:00 ile 13:00<\/strong> aras\u0131<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>E\u011e\u0130TMEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>\u0130SMET CED\u0130MA\u011eAR<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>E\u011e\u0130T\u0130M YER\u0130\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>Dernek merkezi e\u011fitim salonu<\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>E\u011e\u0130T\u0130ME KATILACAK K\u0130\u015e\u0130 SAY\u0130S\u0130\u00a0\u00a0 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>20<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>E\u011e\u0130T\u0130M \u00dcCRET\u0130\u00a0\u00a0\u00a0\u00a0 : <strong>150,00.-<\/strong>TL(<strong>dernek \u00fcyelerin %30 indirimlidir<\/strong>) E\u011e\u0130T\u0130M BEDEL\u0130 DERNEK HESAP NUMARALARINA YATIRILACAKTIR.A\u00c7IKLAMAYA AD SOYAD VE E\u011e\u0130T\u0130M BEDEL\u0130 OLARAK MUHAKKAK BEL\u0130RT\u0130LMEL\u0130D\u0130R.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Hesap Numaralar\u0131<\/strong>: <strong>Akbank ESENLER \u015eB.\u00a0\u00a0 Sube kodu:447 Hesap no:149303<\/strong><\/p>\n<p><strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Akbank Cevizliba\u011f \u015eB. Sube kodu:1335 Hesap no:1581<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>E\u011fitime kat\u0131lacak kat\u0131l\u0131mc\u0131lar rezervasyon s\u0131ras\u0131na g\u00f6re belirlenecek olup 20 ki\u015fi tamamland\u0131\u011f\u0131nda rezervasyon kapanacakt\u0131r.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Sayg\u0131lar\u0131m\u0131zla<\/strong><\/p>\n<p><strong>Ba\u011f\u0131ms\u0131z Denetim Uzmanlar\u0131 Derne\u011fi <\/strong><\/p>\n<p><strong>Y\u00f6netim Kurulu<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Temel Excel E\u011fitimi E\u011fitimin Amac\u0131: Bu programda \u00e7al\u0131\u015fma ka\u011f\u0131tlar\u0131 haz\u0131rlayacak d\u00fczeye \u00e7\u0131kma, h\u0131zl\u0131 form\u00fcl \u00fcretip test etmeyi \u00f6\u011frenmek, iki mizandan kar\u015f\u0131la\u015ft\u0131rmal\u0131 mali tablo \u00fcretebilecek seviyeye gelmek temel d\u00fczeyde bilgi verilerek, kat\u0131l\u0131mc\u0131larda fark\u0131ndal\u0131k yarat\u0131lmas\u0131 sa\u011flanacakt\u0131r. Kimler Kat\u0131lmal\u0131:Ba\u011f\u0131ms\u0131z Denet\u00e7iler, Excel\u2019i temel d\u00fczeyde almak isteyenler, YMM,SMMM\u2019ler. E\u011fitimin \u0130\u00e7eri\u011fi: TEMEL EXCEL E\u011e\u0130T\u0130M\u0130 \u00a0 EXCEL TEMEL FONKS\u0130YON TANIMLARI &nbsp; EXCEL\u2019DE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":908,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[]},"categories":[37],"tags":[130],"views":1667,"_links":{"self":[{"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/posts\/907"}],"collection":[{"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/comments?post=907"}],"version-history":[{"count":0,"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/posts\/907\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/media\/908"}],"wp:attachment":[{"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/media?parent=907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/categories?post=907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baduder.org\/tr\/wp-json\/wp\/v2\/tags?post=907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}