{"id":80060,"date":"2021-02-05T13:30:47","date_gmt":"2021-02-05T09:30:47","guid":{"rendered":"http:\/\/aiacademy.info\/?p=80060"},"modified":"2023-01-07T01:33:10","modified_gmt":"2023-01-06T22:33:10","slug":"automating-routine-office-tasks-with-vba","status":"publish","type":"post","link":"https:\/\/aiacademy.info\/blog\/automating-routine-office-tasks-with-vba\/","title":{"rendered":"Automating routine office tasks with VBA"},"content":{"rendered":"

\u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u0645\u0647\u0627\u0645 \u0627\u0644\u0645\u0643\u062a\u0628\u064a\u0629 (VBA)<\/strong><\/span><\/p>\n

[\u00a0Automating<\/span>\u00a0routine office tasks<\/span>\u00a0with VBA (visual basic for applications) ]\n

VBA basic Concepts (can be split into basic and advanced, ) (up to 30 hours with 5-10 hours projects)<\/p>\n

\"image.png\"<\/div>\n
\n

Introduction to the Visual Basic<\/p>\n

Introduction to Macros<\/p>\n

Using Functions in VBA<\/p>\n

Events and Triggers<\/p>\n

Error Handling and Debugging<\/p>\n

Excel\u2019s Dialogs<\/p>\n

Excel\u2019s Forms and UI<\/p>\n

Automating Graphs and Charts<\/p>\n

Introduction to Macros with Word<\/p>\n

Project 1: Formal Report from Raw Data<\/p>\n

Project 2: Interactive Dashboard<\/p>\n

and also some advanced topics can be introduced as an advanced course like<\/div>\n
\n

connecting excel to an external database<\/p>\n

Web scraping using VBA<\/p>\n

Dashboards Advanced<\/p>\n

Training Hours:<\/span>30hr<\/p>\n

\u0633\u0627\u0631\u0639 \u0648 \u0627\u062d\u062c\u0632 \u0645\u0643\u0627\u0646<\/span><\/strong>
\n\u0644\u0644\u062a\u0633\u062c\u064a\u0644:
\nhttps:\/\/forms.gle\/vG7r9vpYHAiETCov6<\/a>
\n\ud83d\udca1\u0644\u062f\u064a\u0646\u0627 \u062f\u0648\u0631\u0627\u062a \u0647\u0646\u062f\u0633\u064a\u0629 \u0628\u0643\u0627\u0641\u0629 \u0627\u0644\u0627\u062e\u062a\u0635\u0627\u0635\u0627\u062a-\u0628\u0631\u0645\u062c\u0629-\u0645\u0648\u0646\u062a\u0627\u062c- \u0627\u0644\u0625\u0646\u062a\u0627\u062c \u0627\u0644\u062a\u0644\u0641\u0632\u064a\u0648\u0646\u064a – Social Media …<\/span><\/strong>
\n\ud83d\udcde \u0644\u0644\u062a\u0648\u0627\u0635\u0644 \u0648\u0627\u0644\u0627\u0633\u062a\u0641\u0633\u0627\u0631
\n0096181879459
\n\ud83d\udca5 \u0644\u064a\u0635\u0644\u0643\u0645 \u0643\u0644 \u062c\u062f\u064a\u062f \u0627\u0646\u0636\u0645\u0648\u0627 \u0627\u0644\u0649 \u0627\u0644\u0645\u062c\u0645\u0648\u0639\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629:
\nhttps:\/\/chat.whatsapp.com\/Ep9IWpHwSHG9JmPfUmiKrc<\/a>
\n:Telegram
\nhttps:\/\/t.me\/AIAcademyWorkshops<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u0645\u0647\u0627\u0645 \u0627\u0644\u0645\u0643\u062a\u0628\u064a\u0629 (VBA) [\u00a0Automating\u00a0routine office tasks\u00a0with VBA (visual basic for applications) ] VBA basic Concepts (can be split into basic and advanced, ) (up…<\/p>\n","protected":false},"author":1,"featured_media":138962,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[1513],"tags":[1518],"class_list":["post-80060","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1513","tag-automating-routine-office-tasks-with-vba"],"_links":{"self":[{"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/posts\/80060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/comments?post=80060"}],"version-history":[{"count":1,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/posts\/80060\/revisions"}],"predecessor-version":[{"id":134118,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/posts\/80060\/revisions\/134118"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/media\/138962"}],"wp:attachment":[{"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/media?parent=80060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/categories?post=80060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aiacademy.info\/blog\/wp-json\/wp\/v2\/tags?post=80060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}