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 hav
Skills you'll learn
We may earn a commission if you enroll through our links — it never affects the price you pay.
Similar courses
Visualize BI Data
Visualize BI Data: From Raw Data to Insightful Reports is an intermediate-level course designed for marketers, analysts, and anyone looking to turn spreadsheets into compelling data stories. In today's data-driven world, the ability to clearly visualize business metrics is a crucial skill for communicating insights and influencing strategy. This course provides a practical, hands-on introduction to the world of Business Intelligence (BI) using a leading, free-to-use platform: Google Looker Studio. You will start by understanding the core purpose of BI and learn how powerful platforms like Loo
All levels
Excel Skills for Business: Intermediate I
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digitals skills lead to higher income and better employment opportunities at a time when digital skills job are growing much faster than non-digital jobs. In this second course of our Excel specializat
All levels
AI-First Professional Skills
By the end of this course, you'll be able to tell your career story clearly, make sense of data without a background in analytics, learn new skills faster with AI as your tutor, and walk into interviews and tough conversations already prepared. This course is built for complete beginners — no prior AI experience needed. Instead of abstract theory, every concept is paired with a short, practical demonstration you can try yourself, covering the real tasks professionals face every day: resumes, LinkedIn profiles, spreadsheets, learning plans, interview prep, and negotiations. Rather than teachin
All levels
AI Tools for the Workplace
This course unlocks productivity in the workplace by demonstrating the power of generative artificial intelligence (AI) to reduce workload, increase efficiency, and improve employee performance. From managing the dread of a blank page to complex spreadsheets, Dr. Sharma guides you through short, interactive lessons that can immediately be applied in a workplace setting to optimize workflows and increase on-the-job performance. By completing this course, you will transition from basic AI curiosity to operational mastery, saving hours on repetitive tasks. You will gain the skills to confidently
All levels