Learn a Foreign Language with Excel

In this video, you will learn how to utilize Microsoft Windows Language Code Identifier (LCID) to display month names and names of weekdays in any language you prefer and, in doing so - learn a foreign language. This is not only fun but also very useful. Some uses are shown towards the end of the video. Thank you for watching, and I'll see you on the next one.

This tutorial was made using Excel 365, but all methods work with Excel 2007 and above.

File if you want to follow along:https://bit.ly/3pd5KJJ

Link to a relevant blog post:
Learn a foreign language with Excel (Excel Unplugged) - https://bit.ly/3HvGDYN

Link to list of all LCID's: https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/70feba9f-294e-491e-b6eb-56532684c37f

Chapters:
0:00​ Excel Olympics Animation
0:08 What will we learn
0:32 Cell Formating to get names of Months and Days
2:02 Introduction to Microsoft LCID codes
3:38 How to use LCID codes in Excel Cell Format
4:12 The Speak Cells command in Excel
5:43 Names of Weekdays in Italian
6:04 Conclusion - Why this is extremely useful
9:09 Outro

Gear Used:

US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7

EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y

Recorded With: Camtasia - https://www.techsmith.com/video-editor.html

Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub

Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK

Disclaimer: Some links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!

#Excel #ExcelOlympics #gasperkamensek

Видео Learn a Foreign Language with Excel канала Excel Olympics