{"id":91,"date":"2017-05-30T16:40:26","date_gmt":"2017-05-30T16:40:26","guid":{"rendered":"http:\/\/abdullahkoc.com.tr\/?page_id=91"},"modified":"2017-10-18T10:19:19","modified_gmt":"2017-10-18T10:19:19","slug":"ileri-excel-ve-makro-vba-programlama-kursu","status":"publish","type":"page","link":"http:\/\/abdullahkoc.com.tr\/index.php\/microsoft-excel\/ileri-excel-ve-makro-vba-programlama-kursu\/","title":{"rendered":"\u0130leri D\u00fczey Excel Kursu E\u011fitimi (Uygulamal\u0131)"},"content":{"rendered":"<h1>E\u011e\u0130T\u0130M KONULARI<\/h1>\n<h4>GENEL EXCEL<\/h4>\n<ul>\n<li>Microsoft Excel genel klavye k\u0131sayol tu\u015flar\u0131, \u00e7izelgeler, sat\u0131r, s\u00fctun, h\u00fccre i\u015flemleri<\/li>\n<li>Sayfa d\u00fczeni ve yazd\u0131rma i\u015flemleri, G\u00f6r\u00fcn\u00fcm, b\u00f6lmeleri dondurma, ba\u015fl\u0131klar\u0131 yazd\u0131rma<\/li>\n<li>Filtre uygulama, veri do\u011frulama, ko\u015fullu bi\u00e7imlendirme, ad tan\u0131mlama<\/li>\n<li>Grafik ekleme ve k\u00f6pr\u00fc (link) i\u015flemleri<\/li>\n<li>\u00d6zet Tablo (pivot table) ekleme, \u00f6zet grafik ekleme(pivot chart)<\/li>\n<li>\u00d6zel listeler olu\u015fturma ve kullanma, Tablo ekleme ve kullanma<\/li>\n<li>Yinelenen de\u011ferleri kald\u0131rma, metni s\u00fctunlara b\u00f6lme<\/li>\n<li>\u00d6zel bi\u00e7imleri bulma (Ko\u015fullu bi\u00e7im, veri do\u011frulama vb)<\/li>\n<li>S\u0131ralama i\u015flemleri ve \u00d6zel s\u0131ralama<\/li>\n<li>Say\u0131lar \u00fczerinde \u00e7al\u0131\u015fma, \u0130\u015fle\u00e7ler ve kullan\u0131mlar\u0131<\/li>\n<li>Form\u00fcl kullanma, mutlak ve g\u00f6receli ba\u015fvuru kullanma<\/li>\n<li>Dosyalar ve Sayfalar aras\u0131 form\u00fcl kullan\u0131m\u0131<\/li>\n<\/ul>\n<h4>FORM\u00dcLLER<\/h4>\n<ul>\n<li>Mant\u0131ksal fonksiyonlar (E\u011fer, Ve, Yada, vb)<\/li>\n<li>Tarih fonksiyonlar\u0131 (\u015eimdi, Bug\u00fcn, Y\u0131l, Ay, G\u00fcn vb)<\/li>\n<li>Matematik ve Trigonometri (Topla, Etopla, \u00c7oketopla, Yuvarla vb)<\/li>\n<li>Metin Fonksiyonlar\u0131 (Soldan, Sa\u011fdan, uzunluk, Metne\u00e7evir, Yaz\u0131md\u00fczeni, B\u00fcy\u00fckharf, Par\u00e7aal vb)<\/li>\n<li>\u0130statistiksel Fonksiyonlar (Ortalama,Ba\u011f_de\u011f_say,Bo\u015fluksay,E\u011fersay,\u00c7oke\u011fersay,\u00c7oke\u011ferortalama\u00a0 vb)<\/li>\n<li>Arama ve Ba\u015fvuru (Ka\u00e7\u0131nc\u0131, D\u00fc\u015feyara, Yatayara, \u0130ndis vb)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Raporlama ve analiz i\u00e7in Sakarya Adapazar\u0131 genelinde her i\u015fletmenin kulland\u0131\u011f\u0131 vazge\u00e7ilmez program olan Microsoft Excel ile ileri d\u00fczey form\u00fcl ve ara\u00e7 kullan\u0131m\u0131 ile birlikte makro kodlar\u0131 olu\u015fturma ve yazma.<\/p>\n<p>\u0130leri Excel ve Makro Programlama Kursu&#8217;na kat\u0131lmak isteyen kursiyerlerimizin \u00f6n kay\u0131t yapt\u0131rmalar\u0131 gerekmektedir. Sakarya (Adapazar\u0131) ili genelinde faaliyet g\u00f6steren T\u00fcm i\u015fletmeler ve Sakarya \u00dcniversitesi \u00d6\u011frencileri kat\u0131labilir. E\u011fitim tarihleri talep durumuna g\u00f6re ilan edilecektir.<\/p>\n<p>\u0130LER\u0130 EXCEL<\/p>\n<p>MAKRO<\/p>\n<p>Programlama Dili Nedir ve VBA nas\u0131l bir ortamd\u0131r?<\/p>\n<p>VBA\u2019de Program Yazma&#8230;<\/p>\n<p>Genel Program Yap\u0131s\u0131<\/p>\n<p>Makro Kaydetme<\/p>\n<p>Do\u011frudan Mod\u00fclden Program yazma<\/p>\n<p>Program A\u00e7\u0131klama Sat\u0131rlar\u0131<\/p>\n<p>Sabitlerin Kullan\u0131m\u0131<\/p>\n<p>De\u011fi\u015fkenlerin Kullan\u0131m\u0131<\/p>\n<p>De\u011fi\u015fken adland\u0131rma kurallar\u0131<\/p>\n<p>De\u011fi\u015fkenlerin Kapsam\u0131 ve \u00d6mr\u00fc<\/p>\n<p>Yerel De\u011fi\u015fkenler ve Global (Mod\u00fcl) D\u00fczeyinde De\u011fi\u015fkenler<\/p>\n<p>Statik de\u011fi\u015fkenler<\/p>\n<p>Diziler<\/p>\n","protected":false},"excerpt":{"rendered":"<p>E\u011e\u0130T\u0130M KONULARI GENEL EXCEL Microsoft Excel genel klavye k\u0131sayol tu\u015flar\u0131, \u00e7izelgeler, sat\u0131r, s\u00fctun, h\u00fccre i\u015flemleri Sayfa d\u00fczeni ve yazd\u0131rma i\u015flemleri, G\u00f6r\u00fcn\u00fcm, b\u00f6lmeleri dondurma, ba\u015fl\u0131klar\u0131 yazd\u0131rma Filtre uygulama, veri do\u011frulama, ko\u015fullu bi\u00e7imlendirme, ad tan\u0131mlama Grafik ekleme ve k\u00f6pr\u00fc (link) i\u015flemleri \u00d6zet Tablo (pivot table) ekleme, \u00f6zet grafik ekleme(pivot chart) \u00d6zel listeler&hellip;<\/p>\n","protected":false},"author":1,"featured_media":337,"parent":58,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-91","page","type-page","status-publish","has-post-thumbnail","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P91l8e-1t","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":6,"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/91\/revisions"}],"predecessor-version":[{"id":329,"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/91\/revisions\/329"}],"up":[{"embeddable":true,"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/pages\/58"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/media\/337"}],"wp:attachment":[{"href":"http:\/\/abdullahkoc.com.tr\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}