ExcelVBAクイズ講座 初級コース

VBASYS塾

About this game

This is an Excel VBA (macro) beginner level quiz question and tutorial course.

This is the version of Excel that has been confirmed to work in this course.
Excel (Windows version) Microsoft365, 2024~97

Aimed at those who are familiar with Excel operations, this course allows you to learn VBA programming from the basics to practical content.

We will provide systematic explanations for those who can operate Excel such as creating formulas, tables, and saving workbooks, but find VBA difficult to learn and have a high barrier to entry.
This course is for those who want to thoroughly learn the basics of VBA and programming.

In the basic edition, you will learn the basic knowledge and know-how necessary for programming, and in the practical edition, you will experience actual programming by creating some simple software.
The final goal is to create simple software.

This is the course outline.

In this course, we will study the following courses at the beginner level of Excel VBA (macro).

■Excel VBA course beginner course basic edition■

Learn the basic level of programming required using Excel VBA (macro).

1. Introduction
Learn basic preparation before taking the course and how to operate Visual Basic Editor.

2. Visual Basic
Learn the beginner level of the programming language Visual Basic.

3. Excel Object
Learn basic level skills such as how to use Excel objects in Visual Basic.

4. Programming techniques
Learn the basic level of programming skills you need.

■Excel VBA course beginner course practical edition■

Learn practical programming using various case studies based on the basics.

1. Update inventory list
We will introduce an example of using macro recording based on an inventory list.

2. Checklist
We will introduce examples of using events using checklists.

3. Stopwatch
We will introduce a specific example of programming using a stopwatch as the subject.

4. SUM function imitation
Let's try the SUM function, which is a worksheet function.

5. Dialog box/value entry
Try entering values ​​through dialog boxes.

6. Arithmetic/numerical calculation
We will challenge the basics of calculation: sums and averages.

7. Date related/Calendar
Try creating a calendar.

Through this course, you will be able to acquire practical skills from the basics of Excel VBA programming at the beginner level.

What’s new

PC版 Google Play Games 対応版