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, the 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT function.
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:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in 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:
Clear data & cell contents in Excel using a macro
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:
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:
Add drawings and free-form shapes in MS Word 2007
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in 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:
Clear data & cell contents in Excel using a macro
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:
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
How To:
Create a dynamic weekly chart in Microsoft Excel
Be the First to Comment
Share Your Thoughts