17-Excel Class Define Name Manager | Live Class TLCC

TOPICS COVERED: 1. NAME MANAGER (CTRL+F3) 2. CREATE, EDIT, DELETE, AND FIND ALL THE NAMES USED IN THE WORKBOOK 3. NAMES CAN BE USED IN FORMULAS AS SUBSTITUTES FOR CELL REFERENCE 4. DEFINE NAME 5. APPLY NAME 6. USE A FORMULA BY PASTING THE NAME 7. CHOOSE A NAME USED IN THIS WORKBOOK AND INSERT IT INTO THE CURRENT FORMULA 8. CREATE FROM SELECTION (CTRL+SHIFT+F3) 9. AUTOMATICALLY GENERATE NAMES FROM THE SELECTED CELLS