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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
- Hot
- Latest
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Create a multiuser login system in Microsoft Access
-
How To:
Make an Excel gradebook that removes the lowest score
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Find range and interquartile range in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Make a basic bar graph in Microsoft Excel
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Create an Excel inventory template with running totals
-
How To:
Find critical values with T functions in MS Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Create a Tangent Line with Excel
-
How To:
Graph the probability density function in an Excel file
-
How To:
Make an Excel gradebook that drops the 2 lowest scores
-
How To:
Work with bank checks in Microsoft Excel
-
How To:
Compare two lists in Excel with match, join and filter
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Create a multiuser login system in Microsoft Access
-
How To:
Make an Excel gradebook that removes the lowest score
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Find range and interquartile range in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Make a basic bar graph in Microsoft Excel
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Create an Excel inventory template with running totals
-
How To:
Find critical values with T functions in MS Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Create a Tangent Line with Excel
-
How To:
Graph the probability density function in an Excel file
-
How To:
Make an Excel gradebook that drops the 2 lowest scores
-
How To:
Work with bank checks in Microsoft Excel
-
How To:
Compare two lists in Excel with match, join and filter
Be the First to Comment
Share Your Thoughts