【Excelパワークエリ】ファイル移動しても安心！参照エラー回避テクニック【解説】

🏆⬇Get tons of free perks⬇🏆 https://page.line.me/357xcgli [Click "Open in app")] 🏆⬇Register for free LINE and get over 10 paid perks⬇🏆 ✅2 ready-to-use Excel files "Gantt chart" ✅2 ready-to-use Excel files "Calendar" ✅Excel VBA learning roadmap (with video links) ✅Excel/Google Spreadsheets Shortcut list ✅Excel operator list ✅Excel formatting symbol list ✅E-book "100 Excel tips and tricks" https://page.line.me/357xcgli [Please click "Open with app")] +---------------------------+ ■Table of contents +---------------------------+ 00:00 Greetings 00:52 How to load 01:49 Moving a csv file 03:36 Making it possible to refer to paths on a sheet 11:23 Operation check "Moving a csv file" 12:26 Setting a relative path 15:46 Operation check "Move everything into the csv folder" 17:03 About the giveaway +---------------------------+ ■Channel content +---------------------------+ Videos are organized by category.    / @chanryo_eff   +---------------------------+ ■One-on-one lessons (StuCa) +---------------------------+ One-on-one lessons ranging from basic explanations to support for business improvement. (Support experience with over 600 people) [Excel course] https://www.street-academy.com/myclas... [Google Spreadsheet course] https://www.street-academy.com/myclas... +---------------------------+ ■SNS +---------------------------+ X (Twitter) regularly posts tips and tricks that are not posted on YouTube. [Learning site (IT Preparatory)] https://it-yobi.com/?link=1 [X (Twitter)] https://x.com/chanryo_eff [Instagram]   / chanryo_eff   [TikTok]   / program_chanryo   +---------------------------+ ■Contact information +---------------------------+ [email protected] *For individual business consultations, please take the one-on-one course Files are being distributed at #ITPreparatory