25
Reverse Partial Match Lookup to Filter for a List in Excel
Bottom line: Learn how to filter for a list of items using a reverse partial match lookup.
Skill level: Intermediate
18
2 Ways to Filter for List of Items in Excel + Video Tutorial
Bottom line: Learn 2 ways to filter for a list of multiple items in Excel in this article and video tutorial.
Skill level: Beginner
14
3 Tips to Save and Close All Open Excel Workbook Files + Macro
Bottom line: Learn a few shortcuts and tips to save and close all open Excel workbooks.
Skill level: Beginner
32
How to Create a List of Random Numbers with No Duplicates or Repeats
Bottom line: Learn how to create a list of unique random numbers with no duplicates or repeats.
Skill level: Easy
33
2 Ways to Use the Ctrl+Enter Keyboard Shortcut in Excel
Bottom line: Learn a few quick ways to use the Ctrl+Enter keyboard shortcut to save time with entering data or formulas.
Skill level: Beginner
71
3 Tips for Calculating Week Numbers from Dates in Excel
Bottom line: Learn a few tips and techniques for calculating week numbers from dates, the number of weeks between dates, and how to display the week number in cells for reporting.
Skill level: Beginner
15
2 Ways to Reverse Number Signs Positive Negative in Excel
Bottom line: Learn 2 ways to reverse the sign of a number from positive to negative or negative to positive in Excel.
Skill level: Beginner
81
17 Excel Shortcuts for 2017
Bottom line: Learn 17+ Excel shortcuts to help you work faster in the new year.
Skill level: Beginner
10
How to Prevent Excel from Freezing or Taking A Long Time when Deleting Rows
Bottom line: This quick tip will save you a lot of time when deleting rows from a filtered range or table in Excel. Learn how to prevent Excel from freezing or crashing when deleting rows.
Skill level: Beginner
29
How to Properly Filter Zeros and Numbers with the Filter Drop-down Menus
Bottom line: Learn the correct way to filter out zeros and numbers with the filter drop-down menus in Excel, and avoid embarrassing mistakes.
Skill level: Intermediate
