The new school year is just around the corner. Let's not waste time and effort on pointless Excel work. I hope we can learn something from the methods of Bucho, Reimu, and Marisa. <Table of contents> Contents (Key points) 0:00 Opening 1:39 Creating sequential numbers (jump function, SEQUENCE function) 6:00 Deleting blank cells (working column, F4) 11:27 Column numbers for VLOOKUP function (COLUMNS function, XLOOKUP function) 17:12 Days of the week (TEXT function, display format) 21:31 Creating a calendar (IF function, template function) 27:27 Selecting A1 for all sheets (select all sheets function, considering opportunities to use macros) 32:10 Sequential numbers from A to B to C (CHAR function, the importance of questioning the method in the first place) 37:35 Transferring image data to cells (get data function, insert from image function) 42:53 Deleting cells that do not contain formulas (jump function (again), the importance of having a database) 48:00 Splitting names (MID function, FIND function, TEXTSPLIT function) 53:51 Multiple or condition filters (advanced filter settings, the importance of work columns) 59:54 Overly detailed formatting (add-in functions, shortcut keys) <Respect> F-rank University Employment Channel / @user-ys6bh5zc3k <Wachon's website> https://wachi-yon.jp/exceldlpage/exce... <Twitter> Wachon / wachi_yukkuri <Video editing software> Yukkuri MovieMaker4 https://manjubox.net/ymm4/ <Music and sound effects> Amacha Music Studio https://amachamusic.chagasi.com/terms... Sound Effect Lab https://soundeffect-lab.info/sound/an... Maoudamashii https://maou.audio/ <Advertisement below> Books and online schools that teach Excel and programming-related technologies. This is an affiliate link, so if you purchase something from the link below, Wachon will also receive a reward. Please forgive me. ■Books・Excel Super Time-Saving Methods Taught by Charismatic YouTubersAmazon: (1,870 yen) https://px.a8.net/svt/ejp?a8mat=3NCUS... ・Excel Work Techniques for Learning Functions Properly What if Excel Functions Used in Work were Personified? (1,760 yen) https://px.a8.net/svt/ejp?a8mat=3NCUS... ・Perfect Excel VBA (3,608 yen) https://px.a8.net/svt/ejp?a8mat=3NCUS... ・Programming Techniques to Make Excel VBA Development Super Efficient - Development Tips to Eliminate Wasteful Work [Yuji Fukami] https://px.a8.net/svt/ejp?a8mat=3NCUS...