This is an intermediate-level quiz and tutorial on macros (VBA) for Microsoft Excel, the leading spreadsheet software for Windows.
This is the first in a trilogy of intermediate courses. (Part 2: User Forms, Part 3: Database Integration)

This course covers Excel versions 365, 2024-2007.

(Trademark Information)
Microsoft Excel is a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.
VBA (Visual Basic for Applications) and Visual Basic are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

■Question Scope and Course Content■

This intermediate-level course covers basic and practical topics, focusing on automating data collection, a common business process. Students will learn how to manipulate objects in spreadsheet software (Excel) and utilize scripting languages (VBA) through system development procedures. (Excel Objects × Visual Basic = Awesome)

The Basics section builds on what you learned in the Beginner's course by reinforcing programming concepts such as arrays, scope, exception handling, debugging, and system design.

The Practical section focuses on automating data collection as a case study, and teaches practical scripting (VBA) techniques to improve business efficiency.

Finally, a collection of tips categorized by scripting language (VBA) is included, which can also be used as a reverse dictionary searchable by keyword or theme.

■Quiz Questions■

Evaluation is based on the following four levels:
100 points: Excellent.
80 points or less: Good.
60 points or less: Keep trying.
0 points or less: Keep trying.

If you achieve a perfect score of 100 points on all subjects, you will receive a certificate.
Only the certificate displayed in the app is official.
Take the quiz to earn your [Certificate]!!

■Course Overview■

(Reference)
We recommend taking our "Beginner's Course" beforehand.

= Basics =
[Visual Basic]
(Volume 1): Data Types, Literal Values and Constants, Variables, Arrays, and Operations
(Volume 2): Scope, Procedures, Control Structures, Exception Handling, and Debugging

[Programming Techniques]
1. Systems Thinking
2. Programming Etiquette
3. Algorithms
4. System Development
5. Coding

[Spreadsheet (Excel) Objects]
1. What are Objects?
This course explains the true nature of objects, the core of object-oriented programming.
Learn how to use objects in the VBA scripting language and how to use object variables.

Learn how to operate each object in Excel.
2. Application
3. Workbook
4. Window
5. Worksheet
6. Cell
7. Event

= Practical Edition =
[Programming Techniques: Data Collection]
Consider the system design and program processing procedures for "Data Collection" following the steps in "Basic System Development."

[Data Collection Using Excel Objects]
Coding using Excel objects based on the system design and program processing procedures considered.

[Visual Basic Data Collection]
Utilize the functions of the VBA scripting language to integrate and expand systems, and create and replicate functions similar to the Excel objects used in this lesson.

= Visual Basic Tips: Basic Edition =
A collection of VBA scripting tips categorized by the following categories: Values, Strings, Dates, Times, Folders and Files