VBA (Visual Basic for Applications) is a programing language we can use to streamline our work and automate frequent and repetitive actions. Using this language, we can improve our day-to-day work by customizing Microsoft Excel to our individual needs. In this course, the participants will learn how to automate actions such as, creating reports, managing databases, and countless other tasks that are performed manually in Excel. The result will allow for more time to focus on data analysis and drawing conclusions that are required for their organization.
Duration: Hours 40
Who should attend? Economists, Accountants, and Excel users that require customized automation of actions to streamline workflow and save time.
The course will illustrate Excel's efficiency in data management, analysis, performing complex calculations, setting up scenarios, producing reports and more. Students will practice data management of tables and databases while manipulating the data. Also, during the course, students will acquire practical skills combined with professional tips that will assist in streamlining their work and save time. In the end of the course, graduates will be able to create professional looking spreadsheets that can be manipulated easily for data analysis, they will Learn how to incorporate advanced functions and calculations in their database, and Create charts and pivot tables that visualize relevant data sets.
Duration: Hours 24
Who should attend? People that manage databases in their workday who have a familiarization with Excel (basic functions and tools)
Advanced Excel skills are highly relevant in business. No matter which role you’re currently in or you’re planning to take on. Whether you’ll be in Finance, consulting, IT, in project management, your advanced Excel skills will set you apart from the competition. An advanced Microsoft Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation. Advanced Excel users always find the optimal solution for every task. This Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast. Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases.
Duration: Hours 60
Who should attend? Microsoft Excel users who have basic skills, willing to improve their skills and build strong analytical thinking and business intelligence skills.