☆☆☆[Only for Premium Members] Free distribution of luxurious bonuses☆☆☆ We are giving away the PowerPoint presentation used in this video for free! It's 96 pages long and packed with basic content and practical information. Feel free to use it to take notes while watching the video or to supplement your notes. ↓↓↓Click this link to get the free presentation↓↓↓ (will take you to the "CODE" website) https://urawainformation.com/excelvba... It is a compressed file, so please unzip it using the password provided in the video, which is only available to Premium Members. ☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆ ????Join the membership here / @aya14_engineer ＜Timestamp＞ 00:00 Benefits of this video00:36 Agenda01:00 Introduction of the instructor01:30 Ultimate goal of this video02:04 1-1 What is a macro? What is VBA?03:17 1-2 How to use Visual Basic Editor04:38 1-3 Relationship between workbooks and macros06:21 1-4 Important security06:55 Demonstration11:31 2-1 Let's try recording a macro11:56 2-2 How to use personal macro workbooks and recordings12:08 Demonstration18:23 3-1 What is a module?19:34 3-2 What is a procedure?20:45 3-3 What is a comment?20:55 Demonstration29:23 4-1 Object formula30:18 4-2 4-3 Statements 30:32 4-4 Functions 33:42 4-5 Operators 35:19 Demonstration 46:42 5-1 What is a variable? 50:58 5-2 Variable names and declarations 56:25 5-3 Scope of variables 56:38 5-5 What is a constant? 58:46 Demonstration 01:11:39 6-1 Specifying cells and cell ranges 01:14:18 6-2 Cell values ​​and display formats 01:16:49 Demonstration 01:22:59 6-3 Offset/Resize properties 01:26:39 6-4 Other important methods and properties 01:28:33 Demonstration 01:44:39 7-1 For ~Next statements 01:45:14 7-2 If statements 01:45:28 Demonstration 02:00:26 7-3 With statement 02:01:37 Demonstration 02:03:45 8-1 Functions for date and time manipulation 02:09:26 8-2 Functions for string manipulation 02:09:26 8-3 Functions for numeric manipulation 02:11:18 8-4 Functions for displaying dialog boxes 02:11:18 8-5 Other functions 02:12:26 Demonstration 02:37:09 9-1 Saving a workbook 02:39:01 Demonstration 9-2 Opening and closing a workbook 9-3 Working with multiple workbooks 9-4 Inserting and deleting sheets 9-5 Copying and moving sheets 9-6 Other sheet movements 02:57:09 10-1 Executing from Visual Basic Editor 02:58:30 10-2 Executing from Excel 02:58:40 10-3 Executing from the Quick Access Toolbar 02:59:49 10-3 Executing from buttons and shapes (demonstration) 03:01:44 Ending * VBA Expert "Excel VBA Basic" It corresponds to the qualification of Odyssey, but there are some parts that are different from the code content of the official text. Please note. It has been newly remade for beginners. Since I am speaking quite slowly, I would appreciate it if you could adjust the speed function of YouTube. If you have any questions, please write them in the comments and I will answer them as much as possible. If it is a question that you want to share with everyone, please note that I may make it into a video. If you are going to study, I think it is more rewarding to have the goal of obtaining a qualification, so I made this video. The scope of Excel VBA Basic qualification is almost covered in this one video, but if you are unsure, you can purchase the official textbook or practice questions on the official website, so I think you will understand it better. What is Excel VBA Macro? This is an introductory course for beginners that you can learn perfectly from! This is a recommended skill-up video for working adults, so please make use of it. ▶︎You can buy it here: "VBA Expert Official Textbook Excel VBA Basic" 3,080 yen https://amzn.to/3tPlA2o ▶︎It seems that many people buy it as a set with the official textbook "Excel 2019/2016/2013 Macro/VBA (Easy to Understand)" 2,860 yen https://amzn.to/3Oanhhy ▶︎A book by Professor Jun Tatebayashi. Highly rated with 4.4 reviews! "Excel VBA School: Beginners OK! 12 Lessons to Automate Your Work with Macros" 2,168 yen https://amzn.to/48Iayek ▶︎Click here for the "Odyssey Official Website" https://vbae.odyssey-com.co.jp/ Although it is called an introductory video, once you finish watching this video, you will have already cleared the introductory level! It is packed with information such as "I actually used it in practice" and "This part will appear in the qualification exam (predicted)". I think it's a very content-rich video, so please make use of it. I'm also making a video on getting weather forecasts. For those of you who are waiting, please wait just a little longer! It's not just VBA code, it's also packed with new knowledge, so please look forward to it. Also, I can't say much about it, but I'm making other useful full-length videos, so please look forward to them in the future!!! --------------------------------------------------------------- ●Twitter Real-time tweets and business information ［ / uis14_］ ●TikTok