In this hands-on course, learn how to automate repetitive tasks in Microsoft Excel using VBA programming. Develop macros, custom commands, and new worksheet functions to streamline your Excel workflow and increase productivity.
Featured course from
This 2-day Excel Visual Basic for Applications (VBA) course is designed to help individuals automate their workflow and reduce user errors in Excel. This course covers a range of VBA topics and is mainly structured around learning and writing code for macros. The first day of the course introduces students to macros and the VBA editor, teaches students how to write VBA code, provides an overview of objects, outlines logic and looping statements, and shows students how to make their code interactive. Day two focuses on the VBA editor and editing code, how to invoke macros, revisits objects and logic statements, shows students how to handle errors, and more. By the end of the course, students will feel confident using macros to make their workflow in Excel more seamless and less error-prone.
Learn how to increase your daily productivity by learning VBA (Visual Basic for Applications), Excel’s programming language. In this practical, instructor-led VBA training workshop, students will work on real-world applications of Macros and Excel programming with hands-on exercises. Learn how to write code to develop new macros and update existing macros to improve their functionality. Create custom buttons and automate repetitive tasks, and master the VBA programming language to accelerate your workflow and reduce your daily workload by several hours. Tuition includes hands-on training, a free retake, and a course manual. The course has flexible scheduling options and is available live online or in NYC.
This course is meant to teach individuals how to code with Excel VBA. Students will learn to create macros and code with Excel to boost their Excel efficiency. Topics covered include building macros, writing VBA code, and financial applications for VBA programming.
This 3-day course on VBA programming in Microsoft Excel is intended for experienced users. The program covers topics such as debugging, the use of expressions, variables and intrinsic functions, and error handling procedures. Students will also learn how to use Visual Basic for Applications, work with forms, controls, procedures, and PivotTable objects.
This 1-day course teaches experienced Excel users how to use advanced Excel features. They will learn how to use the Visual Basic Editor, the basics of Procedure, Public, and Module-Level Scope. Students will work with decision and loop structures and learn how to create custom dialog boxes. They will also learn how to debug code and handle errors.
Participants in this classwill learn how to use Visual Basic for Application programming language to automate their data analysis.
showing 6 of 6 courses