New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
Get the latest from WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Create a Tangent Line with Excel
How To:
Identify the first occurrence of a value in a column in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Create an Excel inventory template with running totals
How To:
Remove empty space when converting an Excel file to a PDF document
How To:
Calculate interest rate risk in Microsoft Excel
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Calculate proportions and percentages in Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Graph the probability density function in an Excel file
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Find range and interquartile range in Microsoft Excel
How To:
Find & extract duplicate records from a data set
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Cross tabulate categorical data in Microsoft Excel
How To:
Create a Tangent Line with Excel
How To:
Identify the first occurrence of a value in a column in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Create an Excel inventory template with running totals
How To:
Remove empty space when converting an Excel file to a PDF document
How To:
Calculate interest rate risk in Microsoft Excel
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Calculate proportions and percentages in Excel
How To:
Create a multiuser login system in Microsoft Access
How To:
Graph the probability density function in an Excel file
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Find range and interquartile range in Microsoft Excel
How To:
Find & extract duplicate records from a data set
Be the First to Comment
Share Your Thoughts