How to Get Excel for Mac Pre-Release Versions – Office Insiders Program
Microsoft just released a new update to Excel 2016 for Mac with two BIG new features: PivotCharts and a new VB Editor.
31
3 Ways to Delete Entire Blank Rows + Video Tutorial
Bottom line: Learn a few ways to delete entire blank rows from a data set or table in this article and video.
Skill level: Beginner
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
37
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
34
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
73
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
16
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
84
17 Excel Shortcuts for 2017
Bottom line: Learn 17+ Excel shortcuts to help you work faster in the new year.
Skill level: Beginner
