23
When to Use Pie Charts – Best Practices
Bottom Line: This post explains best practices for using pie charts in your reports and dashboards based on common data visualization principles. You will also learn techniques for picking the best slice of pizza/pie. 🙂
Skill level: Beginner
12
7 Shortcuts for Working with Worksheet Tabs in Excel
Bottom line: Learn time saving tips and shortcuts for selecting and copying worksheet tabs. Includes a few simple VBA macros.
Skill level: Beginner
1
Create Keyboard Shortcuts to Select the First or Last Sheet in Excel
Bottom line: Learn how to create a keyboard shortcut to select the first or last sheet in Excel. There is no dedicated shortcut for this, so this solution uses a macro.
Skill level: Intermediate
8
7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel
Bottom Line: Save time by learning seven ways to select cells and ranges using keyboard shortcuts.
Skill Level: Beginner
20
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
7
How to Create Drop-down Lists in Excel – 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
32
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
