クイズ講座 表計算マクロ 初級コース
1K+
Downloads
Everyone
info
About this game
This is a beginner-level quiz and tutorial on Excel macros (VBA), a popular spreadsheet software that runs on Windows.
This course covers versions 365, 2024, and 2097 of Excel, a popular spreadsheet software that runs on Windows.
(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 course is aimed at those who are familiar with spreadsheet operations such as creating formulas and tables and saving workbooks, but who find the scripting language (VBA) difficult and intimidating to learn.
This course is aimed at those who want to thoroughly learn the fundamentals of programming.
In the Basics section, you will learn the basic knowledge and know-how required for programming.
In the Practical section, you will gain hands-on experience of programming by creating several simple applications.
The ultimate goal is to "create simple applications."
■Quiz Questions■
Evaluation is based on the following four levels.
100 points: Excellent performance.
80 points or less: Good performance.
60 points or less: Keep trying.
0 points or less: Try harder.
Achieving a perfect score of 100 points on all subjects will result in a certificate!
Only the certificate displayed in the app is official.
Try the quiz questions to earn your [certificate]!
■Course Overview■
= Basics =
The following courses cover the beginner-level programming essentials.
1. Introduction
Learn basic pre-course preparations and how to use the Visual Basic Editor.
2. Visual Basic
Learn the programming language, Visual Basic.
3. Spreadsheet (Excel) Objects
Learn how to use spreadsheet objects in scripting languages.
4. Programming Techniques
Learn essential programming skills.
= Practical Course =
Learn practical programming using various case studies based on the Basic Course.
1. Inventory Table Update
This course introduces a case study using macro recording, using an inventory table as the subject.
2. Checklist
This course introduces a case study using events, using a checklist as the subject.
3. Stopwatch
This course introduces a specific programming example using a stopwatch as the subject.
4. SUM Function Imitation
This course tries out the SUM function, a worksheet function.
5. Dialog Box/Value Input
This course tries out value input using a dialog box.
6. Arithmetic/Numeric Calculation
This course tries out the basics of sum and average.
7. Date-Related/Calendar
This course tries out creating a calendar.
Through this course, you will acquire practical programming skills, from the beginner level fundamentals.
This course covers versions 365, 2024, and 2097 of Excel, a popular spreadsheet software that runs on Windows.
(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 course is aimed at those who are familiar with spreadsheet operations such as creating formulas and tables and saving workbooks, but who find the scripting language (VBA) difficult and intimidating to learn.
This course is aimed at those who want to thoroughly learn the fundamentals of programming.
In the Basics section, you will learn the basic knowledge and know-how required for programming.
In the Practical section, you will gain hands-on experience of programming by creating several simple applications.
The ultimate goal is to "create simple applications."
■Quiz Questions■
Evaluation is based on the following four levels.
100 points: Excellent performance.
80 points or less: Good performance.
60 points or less: Keep trying.
0 points or less: Try harder.
Achieving a perfect score of 100 points on all subjects will result in a certificate!
Only the certificate displayed in the app is official.
Try the quiz questions to earn your [certificate]!
■Course Overview■
= Basics =
The following courses cover the beginner-level programming essentials.
1. Introduction
Learn basic pre-course preparations and how to use the Visual Basic Editor.
2. Visual Basic
Learn the programming language, Visual Basic.
3. Spreadsheet (Excel) Objects
Learn how to use spreadsheet objects in scripting languages.
4. Programming Techniques
Learn essential programming skills.
= Practical Course =
Learn practical programming using various case studies based on the Basic Course.
1. Inventory Table Update
This course introduces a case study using macro recording, using an inventory table as the subject.
2. Checklist
This course introduces a case study using events, using a checklist as the subject.
3. Stopwatch
This course introduces a specific programming example using a stopwatch as the subject.
4. SUM Function Imitation
This course tries out the SUM function, a worksheet function.
5. Dialog Box/Value Input
This course tries out value input using a dialog box.
6. Arithmetic/Numeric Calculation
This course tries out the basics of sum and average.
7. Date-Related/Calendar
This course tries out creating a calendar.
Through this course, you will acquire practical programming skills, from the beginner level fundamentals.
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