The Name Box in Excel - Excel A to Z Series
The Name Box in Excel is what I chose for Part one of the Excel A-Z Series. A Series of videos that presents a topic in Excel in its entirety. This video looks at everything you can do with the Name Box in Excel. From moving around an Excel Sheet, Selecting Ranges in Excel, Nesting Functions, and shockingly, Naming cells or Ranges in Excel.
Links to blog posts and videos that are relevant:
Who Knew - Just another Day in Excel - https://excelunplugged.com/2014/09/12...
Using Named Ranges in Excel (Excel Unplugged) - https://excelunplugged.com/2015/05/05...
Chapters:
0:00 Intro
0:08 Introduction to the RANDARRAY
0:42 1. Identify Active Cell
0:58 2. Move Around the Excel Sheet
1:46 3. Selecting in Excel
2:57 4. Advanced Continuous Range Selection
3:54 5. Advanced non-continuous Range Selection
4:46 6. F8 plus the Name Box
6:02 7. Nesting Functions with the Name Box
7:20 8. Naming Cells or Ranges with the Name Box
9:37 9. Name Box Dropdown
11:24 10. Selecting Another Way with the Name Box
12:53 11. Few things to keep in mind with the Name Manager
14:52 Conclusion
15:08 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-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe to 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