In this video, I will explain the difference between cell references and structured references in Excel formulas.

Yuichi Chiba

━━━━━━━━━━━━━━━━━━━━━━━━━
■　Reference
━━━━━━━━━━━━━━━━━━━━━━━━━

🔗 A thorough explanation of Excel's basics [Tables]
   • 【Excel】まずはテーブル。スピルだのショートカットキーだの言う前に、と...  

━━━━━━━━━━━━━━━━━━━━━━━━
■　File download
━━━━━━━━━━━━━━━━━━━━━━━━

[Members only] You can download from the link below.
youtube.com/post/UgkxSiQfoZ-4sZmu8kxr9oal02LHkdS1H…

━━━━━━━━━━━━━━━━━━━━━━━━
■　Membership
━━━━━━━━━━━━━━━━━━━━━━━━━

You can check out the member-only benefits from the link below.
youtube.com/channel/UCNKBO4Aqf650ZT1jECqIeQA/join

━━━━━━━━━━━━━━━━━━━━━━━━━
■　Excel Dokata Gathering Place
━━━━━━━━━━━━━━━━━━━━━━━━━

We post videos explaining Excel, including Power Query, Power Pivot, and DAX.
excel-dokata.mish.tv/

▼Latest video at time of posting

Power Query Practical Techniques
#0695. [Part 2] Automatically update queries when opening a workbook [with macros]

🎞️Watch on [Members-only videos]
   • #0695.【Part2】ブックを開いたときにクエリを自動で更新する【マク...  

🎞️Watch on [Excel Dokata Gathering Place]
excel-dokata.mish.tv/ja/videos/Jud4ffQA7JQErAm3Jow…

━━━━━━━━━━━━━━━━━━━━━━━━━
■　X (formerly Twitter)
━━━━━━━━━━━━━━━━━━━━━━━━━━

I tweet about video updates, etc.
twitter.com/Chiba_U1

━━━━━━━━━━━━━━━━━━━━━━━━
■　Online individual consultation on Excel
━━━━━━━━━━━━━━━━━━━━━━━━

Apply for an online individual consultation on Excel using Zoom.
bit.ly/3IZTwxF

━━━━━━━━━━━━━━━━━━━━━━━━
■　Online lessons on Storaka
━━━━━━━━━━━━━━━━━━━━━━━━

Storaka is hosting an online course using Zoom where you can learn how to use Excel.

▼Excel Power Query [Beginner]
bit.ly/3rrU3gB

▼Excel Power Query [Beginner]
bit.ly/3cA0UQO

▼Excel Power Pivot [Beginner]
bit.ly/3cA0UQO

▼Excel Pivot Table [For Beginners]
bit.ly/36GoKXs

▼List of online courses
bit.ly/3tvkMKG

━━━━━━━━━━━━━━━━━━━━━━━━━
■　I post articles on note
━━━━━━━━━━━━━━━━━━━━━━━━━

I post articles about Excel functions, Power Query, Power Pivot, and DAX.
note.com/excel_dokata

━━━━━━━━━━━━━━━━━━━━━━━━━
■　Business-related inquiries
━━━━━━━━━━━━━━━━━━━━━━━━━

For business-related inquiries such as outsourcing, contract work, instructor requests, consulting, and private lessons, please contact us here.
mailofelgiss+youtube@gmail.com

━━━━━━━━━━━━━━━━━━━━━━━━━
■　Excel version
━━━━━━━━━━━━━━━━━━━━━━━━━

The Excel used in the video is Microsoft365 Personal (Office Insider Beta, latest version at the time of video release).

━━━━━━━━━━━━━━━━━━━━━━━━━
■　Timestamp
━━━━━━━━━━━━━━━━━━━━━━━━━

[ 00:00 ] Introduction
[ 00:28 ] Cell references
[ 01:33 ] Structured references
[ 05:58 ] XLOOKUP
[ 12:43 ] Disadvantages of structured references
[ 17:06 ] Conclusion

#Excel #Excel #Formulas #Cell references #Structured references #Beginners #Skill improvement #Video tutorial #Formulas #Functions #Business #Working adu