{"title":"MS Excel - programování v jazyku VBA a možnosti transformace dat","shortDescription":"Školení je určeno pro pokročilé uživatele Excelu, kteří si chtějí prohloubit své znalosti a dovednosti v oblasti <strong>transformace dat a automatizace úloh</strong>. \n<br>Účastníci se seznámí s <strong>editorem dotazů Power Query pro efektivní čištění a transformaci dat</strong> a naučí se <strong>základy programování ve VBA</strong>. Školení je zaměřeno na porovnání použití Power Query a VBA, aby účastníci pochopili, kdy je vhodné použít programování ve VBA a kdy postačí editor Power Query.","description":"<h2>Master VBA Programming and Data Transformation with MS Excel</h2>\n\n<p>Unlock the full potential of Excel and enhance your data processing skills with our comprehensive course on VBA programming and data transformation. Join industry experts from ICT Pro and gain hands-on experience that will elevate your career.</p>\n\n<ul>\n <li><strong>Target Audience:</strong> This course is designed for professionals and students looking to enhance their Excel capabilities with VBA programming.</li>\n <li><strong>Course Duration:</strong> 3 days</li>\n <li><strong>Course Format:</strong> Online</li>\n <li><strong>Certification:</strong> Yes</li>\n</ul>\n\n<h3>Detailed Course Description</h3>\n<ul>\n <li><strong>Skills Gained:</strong> Participants will acquire essential skills in VBA programming, data transformation techniques, and automation within MS Excel.</li>\n <li><strong>Course Outline:</strong>\n <ul>\n <li>Introduction and Basic Terms</li>\n <li>Data Transformation with Power Query</li>\n <li>Fundamental Concepts and Description of the VBA Editor Environment</li>\n <li>Writing Simple Macros</li>\n <li>Advanced Macro Techniques</li>\n </ul>\n </li>\n <li><strong>Bonuses:</strong> Access to exclusive course materials, interactive Q&A sessions, and post-course support from our expert tutors.</li>\n</ul>\n\n<p>Don't miss your chance to master Excel VBA programming and take your data skills to the next level. Sign up today and empower your professional journey!</p>","rating":0,"reviewCount":0,"reviews":[]}