Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Change Excel options directly in the Registry
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Create a bond discount or premium amortization table in Excel
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Clear data & cell contents in Excel using a macro
How To:
Find a P-Value with Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Graph the probability density function in an Excel file
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Measure the spread of a data set with Excel's AVEDEV
How To:
Create a table for the VLOOKUP function in Excel
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Change Excel options directly in the Registry
How To:
Create a bond discount or premium amortization table in Excel
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Clear data & cell contents in Excel using a macro
How To:
Find a P-Value with Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Graph the probability density function in an Excel file
How To:
Measure the spread of a data set with Excel's AVEDEV
How To:
Create a table for the VLOOKUP function in Excel
How To:
Add drawings and free-form shapes in MS Word 2007
Be the First to Comment
Share Your Thoughts