クイズ講座 表計算マクロ 中級Ⅰ データ集計

VBASYS塾

About this game

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 focuses on the basics and practical aspects of automating data collection, a common business process, and teaches how to manipulate spreadsheet objects and utilize scripting languages ​​(VBA) through system development procedures.

The basic course builds on what was learned in the beginner's course and reinforces programming concepts such as arrays, scope, exception handling, debugging, and system design.

In the practical section, we'll use a case study to automate data collection and master practical scripting (VBA) techniques to improve business efficiency.

Finally, we've included a collection of tips categorized by scripting language (VBA), which can also be used as a reverse dictionary, allowing you to search 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 be issued a certificate.
Only the certificate displayed in the app is official.
Try the quiz questions 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?
Explain 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

What’s new

アプリのタイトル・名称の変更およびそれに伴う改訂