New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the very first installment in their joint series of digital spreadsheet magic tricks, you'll learn how to do a two-way lookup on a table 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:
Clear data & cell contents in Excel using a macro
How To:
Conditionally format at every change in value in Excel
How To:
Create a Tangent Line with Excel
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:
Find a P-Value with Excel
How To:
Change Excel options directly in the Registry
How To:
Build a 15-minute schedule in Microsoft Excel
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:
Add drawings and free-form shapes in MS Word 2007
How To:
Multiply column times row with Transpose in MS Excel
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Conditionally format at every change in value in Excel
How To:
Create a Tangent Line with Excel
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:
Find a P-Value with Excel
How To:
Change Excel options directly in the Registry
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:
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
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Enter formulas in Excel with a macro
How To:
Work with math equations in Microsoft Excel 2010
Be the First to Comment
Share Your Thoughts