107
Formula Challenge: Find the First Transaction for Each Month
Bottom line: In this Excel formula challenge you will learn how to write a formula to find the first date for each month in a set of data.
Skill level: Intermediate
28
18 Excel VBA Macro Shortcuts for 2018
Bottom line: Learn 18 tips & shortcuts to save time with writing VBA macros for Excel or other Office applications.
Skill level: Intermediate
24
3 Ways to Add or Subtract Days to a Date
Bottom line: Learn 3 different ways to add or subtract days to dates in Excel using formulas, copy & paste, and VBA macros. Includes video tutorial.
Skill level: Beginner
6
Resize & Align Dashboard Elements with Snap to Shape
Bottom line: Learn how to resize & align the charts, slicers, images, and other shapes in your dashboards with the Snap to Shape feature in Excel.
Skill level: Beginner
17
The Best Mouse for Excel? Logitech MX Master Review
If you use Excel all day every day like I do, then you know it’s important to have a keyboard and mouse you love. I’ve talked about the best keyboards for Excel before, and in this article we’ll take a look at a great mouse that can help us get our job done faster.
104
Convert Text to Dates with Flash Fill – Data Cleansing Challenge
Bottom line: Learn how to convert dates stored as text to date values in Excel using Flash Fill. There are many possible solutions to this problem, so please leave a comment below explaining the technique that you would use.
Skill level: Intermediate
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.
37
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
