Excel VBA Macros: Forms, Files, and Data Handling

To round out your data-analysis skills in VBA for Excel, you'll display a custom dialog box and program form events. You'll also use VBA to get file and directory structure, read from text files, and write to text files. Then, you'll clean and transform data by automating Power Query, transform data using VBA and workbook functions, using regular expressions, and managing errors in data. Lastly, you'll run other programs and commands and share your VBA projects. This is the third and final course in a multi-course Specialization. All of the courses in this Specialization require that you have a recent version of Microsoft Excel installed. The course setup instructions provided in the first course go into more detail about the hardware and software requirements

• Use VBA to develop custom forms
• Read and write data in text files
• Clean and transform data automatically
• Manage errors during processing
• Run programs and commands outside Excel
• Share VBA projects

• Basic computer and internet skills
• Ability to read course instructions in English
• Complete short practice activities