This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errorsLive face-to-face instructor. No minimum class size - all classes guaranteed to run!PrerequisiteStudents are expected to have completed Excel Advanced or have the equivalent experience prior to attending this class. Suitable for Excel 2010/2013/2016 users.What's IncludedCertificate of Course CompletionTraining ManualFREE Class RepeatCourse OutlineVBA ConceptsThe Object Model HierarchyUnderstanding Object Properties, Methods and EventsVBA Module and Procedure TypesAccessing VBA FunctionalityMacro Security OptionsUsing the Macro RecorderWriting and Editing MacrosEssential VB Editor ComponentsExploring the Object BrowserUsing VBA Comments and Formatting to Write Solid CodeDebugging and Error HandlingTypes of Programming ErrorsVBE Debugging ToolsError Handling CodeUsing Variables to Store DataVBA Data Types and Naming RulesDeclaring VariablesVBA Looping and Decision StructuresFor...and Do...Loops for Repetitive ActionsIf..then StatementsSelect Case StatementsUser-Interactive WorksheetsCapturing User InputDialog Box TypesPerforming Calculations with VBAUsing VBA’s Built-in FunctionsWriting User-Defined Functions for Custom CalculationsCode to Automate Inserting SUM FunctionsNote:Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
Overview
Taught by
Training Connection
