2,445,086 views
????⬇︎5 introductory books to help you get beyond being a PC beginner⬇︎???? https://liff.line.me/1655218894-Gm8x0... [Please click "Open in app")] ????⬇︎15 bonuses for free LINE registration⬇︎???? ✅A complete guide to getting beyond being a PC beginner: a total of 916 slides ✅Video lectures: about 100 minutes https://liff.line.me/1655218894-Gm8x0... [Please click "Open in app") ✅Comments from students taking computer classes https://ultralearning.co.jp/koe1/ ✅Ultra Learning Computer Class (2,990 yen per month) https://ultralearning.co.jp/pc ✅MOS certification course https://ultralearning.co.jp/clp/mos ◆━━━━━━━━━━━━━━━━━━━◆ ⬇︎Akiyuki Kaneko's Official LINE⬇︎ ◆━━━━━━━━━━━━━━━━━━◆ ╋━━━━━━━━━╋ ????First luxurious bonus???? Video lecture on the reasons why you aren't improving at PCs and smartphones and how to deal with them╋━━━━━━━━╋ ????Second luxurious bonus???? A 260-page thorough explanation of the textbook on computer basics to learn from zero knowledge╋━━━━━━━━╋ ????Third luxurious bonus???? A 119-page thorough explanation of the Word introductory book╋━━━━━━━━╋ ????Fourth luxurious bonus???? A 105-page thorough explanation of the Excel introductory book╋━━━━━━━━╋ ????Fifth luxurious bonus???? A 135-page thorough explanation of the PowerPoint introductory book╋━━━━━━━━╋ ????6th Luxury Bonus???? 97-page thorough explanation of PC basic technique strategy book ╋━━━━━━━━╋ ????7th Luxury Bonus???? Shortcut list table - 4 types each for 3 subjects: Windows, Word, and Excel ╋━━━━━━━━╋ [⬇️Register for free here⬇️] https://liff.line.me/1655218894-Gm8x0... [Click "Open in app")] ✅Rich menu benefits (can be displayed from the bottom of the screen after registration) ╋━━━━━━━━╋ ????8th Luxury Bonus???? Complete video lecture explaining what MOS qualification is, from zero knowledge ╋━━━━━━━━╋ ????9th Luxury Bonus???? 106-page thorough explanation of Excel function complete strategy book for MOS qualification preparation ╋━━━━━━━━╋ ????10th Luxury Bonus???? 41-page thorough explanation book on important Excel functions ╋━━━━━━━━╋ ????11th Luxury Bonus???? 53-page thorough explanation book on important Word functions ╋━━━━━━━━╋ ????12th Luxury Bonus???? List of important shortcuts for MOS certification ╋━━━━━━━━╋ ????13th Luxury Bonus???? Video explanation on how to check the version of Word, Excel ╋━━━━━━━━╋ ????14th Luxury Bonus???? Video explanation on how to install the latest versions of Word, Excel ╋━━━━━━━━╋ ????15th Luxury Bonus???? ・Comments from participants ・Self-introduction by Kaneko Teruyuki ╋━━━━━━━━╋ We will give away [15] of these for free! [⬇️Sign up for free here⬇️] https://liff.line.me/1655218894-Gm8x0... [Click "Open in app")] Or search for the friend ID "@akiyuki"! [Don't forget the "@"!!] ◆━━━━━━━━━━━━━━━━━━━◆ We are giving away 5 e-books for free: "Learn Computer Basics from Zero Textbook", "Word Introductory Book", "Excel Introductory Book", "PowerPoint Introductory Book", and "PC Basic Techniques Strategy Book". You can get the e-books for free from the official LINE account below. [⬇️Register for free here⬇️] https://liff.line.me/1655218894-Gm8x0... [Click "Open in app")] ◆━━━━━━━━━━━━━━━━━━◆ [Sales courses] ✅ Ultra Learning Computer School https://ultralearning.co.jp/pc ✅ MOS Certification Course https://ultralearning.co.jp/clp/mos ◆━━━━━━━━━━━━━━━━━━━◆ [Table of contents] 2021 Excel VBA / Macro / Beginner's Introductory Course [Complete version] 0:00 Introduction 2:00 What is VBA? 2:08 What is a programming language? 3:40 What is a macro? 4:10 What is VBE? 4:50 How to learn programming6:45 Benefits of VBA7:00 Enabling macros9:18 How to bring up the Developer tab10:15 How to bring up standard modules11:25 How to enter a macro title12:30 Creating a message box13:40 How to change the text size in VBA15:03 Getting cell text16:15 How to run VBA [F5]16:25 Compile errors and how to erase them17:00 Displaying cell text19:05 What is an object?19:35 What is a property?20:53 Entering text into a cell23:15 Switching screens [ALT+Tab]24:15 Entering text from another cell into a cell25:10 The difference between Range and Cells27:36 Using the macro recorder32:50 Running a macro with a button35:00 Causes of compile errors37:10 Inserting comments40:55 Specifying a worksheet41:50 Using worksheet abbreviations43:00 About parent and child objects43:45 Entering text from one cell into another cell on another sheet45:15 Displaying today's date47:05 Creating sales registration and sales lists50:10 Creating a sales registration macro50:55 How to halve the screen52:30 Common mistakes when specifying text in VBA54:40 Creating a macro to transfer sales registration57:05 Deleting cell values58:20 How to select multiple cells1:00:50Executing a macro one row at a time [F8]1:04:00 How to comment on multiple lines at the same time1:05:00 Understanding If - Then1:07:20 Understanding E