8
How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists
Bottom Line: Learn to create dynamic data validation lists. These in-cell drop-down lists automatically expand to include new rows that are added to the source data range.
Skill Level: Intermediate
5
How to Create Drop-down Lists in Cells – Data Validation Lists
Bottom Line: The complete Excel guide on how to create drop-down lists in cells (data validation lists). Includes keyboard shortcuts to select items, copying drop-downs to other cells, handling invalid inputs, updating lists with new items, and more.
Skill Level: Beginner
8
5 Ways to Select Multiple Shapes
Bottom Line: Learn how to select several shapes at once, including charts, slicers, images, etc. These techniques will help you save time when working with reports and dashboards that contain multiple objects on the same worksheet.
Skill Level: Beginner
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
29
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
26
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
20
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.
