Loading...

Course Description

This course will provide you with the skills needed to create powerful and customized solutions within Excel that improve the user experience. You will discover how to write your own custom functions in VBA, allowing you to perform calculations and automate repetitive tasks that go beyond the built-in Excel functions. You’ll then delve into importing data from external files, understanding how to access data from various sources. Practical examples will guide you through importing worksheets and handling multiple external files efficiently.

You will also practice designing and coding interactive forms that communicate with users. From basic form design to retrieving information and handling user input with VBA code, you’ll gain confidence in creating user-friendly solutions. Finally, you’ll explore workbook settings, sheet navigation, and access restrictions, enabling you to zoom in on specific content, protect your workbook, or control user access. By the end of this course, you’ll be equipped with the confidence to design user-friendly solutions.

Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.

You are required to have completed the following courses or have equivalent experience before taking this course:

  • Automating Processes With Macros and Excel VBA
  • Applying Logic for Efficient Processing of Tasks

Faculty Author

Reza Moghimi

Benefits to the Learner

  • Create user-defined Excel functions
  • Develop a VBA solution for working with external files
  • Design and code forms to communicate with the user
  • Control user activity in Excel

Target Audience

  • Excel users looking to automate tasks
  • Business analysts
  • Office administrators and managers
  • IT and technical support professionals
  • Educators and trainers
  • Project managers
  • Small business owners
  • Individuals transitioning to data-driven roles
  • Anyone interested in learning a new programming language

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
Sep 17, 2025 to Sep 30, 2025
Total Number of Hours
20.0
Course Fee(s)
Contract Fee $100.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Type
2 week
Dates
Dec 10, 2025 to Dec 23, 2025
Total Number of Hours
20.0
Course Fee(s)
Contract Fee $100.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Type
2 week
Dates
Mar 04, 2026 to Mar 17, 2026
Total Number of Hours
20.0
Course Fee(s)
Contract Fee $100.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Type
2 week
Dates
May 27, 2026 to Jun 09, 2026
Total Number of Hours
20.0
Course Fee(s)
Contract Fee $100.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Required fields are indicated by .