ExcelVBAクイズ講座 初級コース
1K+
Downloads
Everyone
info
About this game
This is a beginner-level Excel VBA (macro) quiz and tutorial course.
The Excel versions tested in this course are:
Excel (Windows version) Microsoft 365, 2024-97
■Exam Topics and Course Content■
The exam topics are aimed at those familiar with Excel, and cover the basics and practical aspects of VBA programming at the beginner level.
This course provides a systematic explanation for those who are familiar with Excel, such as creating formulas and tables and saving workbooks, but find VBA difficult to master.
This course is aimed at those who wish to thoroughly study the fundamentals of VBA and programming.
In the Basics section, you will learn the basic knowledge and know-how necessary for programming. In the Practical section, you will gain hands-on experience of programming by creating several simple applications.
The final goal is to "create simple applications."
■Quiz Questions■
Evaluation will be based on the following four levels:
100 points = Excellent performance.
Up to 80 points: Well done.
Up to 60 points: Keep trying.
Up to 0 points: Try harder.
If you achieve a perfect score of 100 points in all subjects, you will receive a certificate!
Only the certificate displayed in the app is official.
Try the quiz questions to earn your certificate!
■Course Overview■
= Basics =
Learn the introductory level of programming required for Excel VBA (macro).
1. Introduction
Learn basic pre-class preparations and how to use the Visual Basic Editor.
2. Visual Basic
Learn the introductory level of the programming language, Visual Basic.
3. Excel Objects
Learn the introductory level of how to use Excel objects in Visual Basic.
4. Programming Techniques
Learn the introductory level of programming skills required.
= Practical =
Learn practical programming using various case studies based on the Basics course.
1. Updating an Inventory Table
This course introduces an example of using macro recording, using an inventory table as an example.
2. Checklist
This course introduces an example of using events, using a checklist as an example.
3. Stopwatch
This course introduces a specific programming example, using a stopwatch as an example.
4. SUM Function Imitation
This course will explore the SUM function, a worksheet function.
5. Dialog Boxes/Value Input
This course will explore entering values using a dialog box.
6. Arithmetic/Numeric Calculation
This course will explore the basics of sums and averages.
7. Date-Related/Calendar
This course will explore creating a calendar.
Through this course, you will gain practical skills in Excel VBA programming, from the basics to the very basics.
The Excel versions tested in this course are:
Excel (Windows version) Microsoft 365, 2024-97
■Exam Topics and Course Content■
The exam topics are aimed at those familiar with Excel, and cover the basics and practical aspects of VBA programming at the beginner level.
This course provides a systematic explanation for those who are familiar with Excel, such as creating formulas and tables and saving workbooks, but find VBA difficult to master.
This course is aimed at those who wish to thoroughly study the fundamentals of VBA and programming.
In the Basics section, you will learn the basic knowledge and know-how necessary for programming. In the Practical section, you will gain hands-on experience of programming by creating several simple applications.
The final goal is to "create simple applications."
■Quiz Questions■
Evaluation will be based on the following four levels:
100 points = Excellent performance.
Up to 80 points: Well done.
Up to 60 points: Keep trying.
Up to 0 points: Try harder.
If you achieve a perfect score of 100 points in all subjects, you will receive a certificate!
Only the certificate displayed in the app is official.
Try the quiz questions to earn your certificate!
■Course Overview■
= Basics =
Learn the introductory level of programming required for Excel VBA (macro).
1. Introduction
Learn basic pre-class preparations and how to use the Visual Basic Editor.
2. Visual Basic
Learn the introductory level of the programming language, Visual Basic.
3. Excel Objects
Learn the introductory level of how to use Excel objects in Visual Basic.
4. Programming Techniques
Learn the introductory level of programming skills required.
= Practical =
Learn practical programming using various case studies based on the Basics course.
1. Updating an Inventory Table
This course introduces an example of using macro recording, using an inventory table as an example.
2. Checklist
This course introduces an example of using events, using a checklist as an example.
3. Stopwatch
This course introduces a specific programming example, using a stopwatch as an example.
4. SUM Function Imitation
This course will explore the SUM function, a worksheet function.
5. Dialog Boxes/Value Input
This course will explore entering values using a dialog box.
6. Arithmetic/Numeric Calculation
This course will explore the basics of sums and averages.
7. Date-Related/Calendar
This course will explore creating a calendar.
Through this course, you will gain practical skills in Excel VBA programming, from the basics to the very basics.
Updated on
Safety starts with understanding how developers collect and share your data. Data privacy and security practices may vary based on your use, region, and age. The developer provided this information and may update it over time.
No data shared with third parties
Learn more about how developers declare sharing
No data collected
Learn more about how developers declare collection
What’s new
認定証の取得 (全課目１００点満点制覇!!の場合)
オプションメニューに[動画 (講座アプリ向け)]を追加
オプションメニューにアプリの[最新バージョンの確認]を追加
イメージトレーニングの画面の向きに応じてボタンの位置を変更
講座ページでのピンチ操作によるズームイン・ズームアウト機能に対応
Android 16 対応
オプションメニューに[動画 (講座アプリ向け)]を追加
オプションメニューにアプリの[最新バージョンの確認]を追加
イメージトレーニングの画面の向きに応じてボタンの位置を変更
講座ページでのピンチ操作によるズームイン・ズームアウト機能に対応
Android 16 対応
App support
About the developer
VBASYS JUKU
juku@vbasys.net
619-455, KAMISENOCHO, AKI-KU
HIROSHIMA, 広島県 739-0302
Japan
+81 70-9096-2966