Name Ranges In Excel To Speed Up Productivity - VLOOKUP Example
This video shows you the basics of naming ranges. Naming ranges will allow you to designate them as variables to condense your formulas making them easier to understand and maintain when changes need to be made. It's possible to define a name for a function, cell range, constant, or table. Naming ranges make it easier to duplicate large tables where the name table acts as a copy that changes when the original table changes.
Once you get used to naming ranges, they can be referenced, edited, and even created in the name manager under the formulas tab.
====== PROFILE ======
https://hubpages.com/@joshuacrowder
===== CHAPTERS =====
00:00 Start
00:18 Name A Cell
00:40 Name Manager
00:58 Name A Range Of Cells
01:19 Duplicate A Named Range
02:48 VLOOKUP Example
====== ARTICLES ======
https://turbofuture.com/computers/How-to-U...
https://medium.com/@joshuawcrowder/how-to-...
https://turbofuture.com/computers/Excel-VL...
======== TAGS ========
#exceltutorial #msexcel #excelfunctions #vlookup #excel #exceltips #vlookup #excelformula #microsoftexcel