تقييمات الطلاب
( 5 من 5 )
١ تقييمات
فيديو شرح Creating Named Ranges in Excel Dynamic Named Range in Excel FREE Excel Course ضمن كورس اكسيل المحاسبي شرح قناة TrumpExcel، الفديو رقم 17 مجانى معتمد اونلاين
In this video of this Free online Excel Training, I will cover all that you need to know about Named Ranges in Excel.
Named Range - as the name suggests - is a range that has been named.
This can be extremely useful as it allows you to use this defined name instead of the range. For example, instead of using A1:C10, you could instead use the name SaleData in the formula.
This video will cover a brief introduction of the named range and then show you how to create one in Excel. It also covers some advanced concepts such as creating a dynamic named range - something that automatically updates in case your data changes.
A very popular use of the dynamic named range is to create dependent drop-down lists (which is covered in detail in this video). You can use functions such as INDEX or OFFSET to create dynamic named ranges.
This video also covers some important named range keyboard shortcuts that can help you save time.
It covers the following topics:
-- Creating Named Ranges
-- Managing Named Ranges
-- Important Keyboard Shortcuts
-- Creating Dynamic Named Ranges using OFFSET and INDEX formulas
Download File - https://trumpexcel.com/course-downloa.
If you find the videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: https://trumpexcel.com/learn-excel/
You can also access the Full Excel Training on YouTube here: https://www.youtube.com/watch?vUPABcYhugZk&listPLm8I8moAHiH2kkq0S9XGvIbPODrHzXRp6
Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/
Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation1
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial