Bottom line: Learn how to evenly space, align, and distribute shapes, charts, slicers, etc. Includes a manual approach using the Alignment tools built into Excel, and an automated solution using VBA macros.
Skill level: Intermediate
Bottom line: Learn how to automatically create more descriptive and dynamic chart titles that display the filter criteria with VBA macros.
Skill level: Intermediate
Bottom line: Learn how to use Chart Templates in Excel to quickly apply formatting and settings to new and existing charts. Includes instructional videos.
Skill level: Beginner
Bottom line: Learn how to create custom shortcuts to move the selection to an adjacent range. This technique is great for selecting rows or columns that contain blank cells.
Skill level: Intermediate
Bottom line: Learn 5 ways to use VBA macros to automate Excel tasks you do frequently at work.
Skill level: Beginner
Bottom line: Learn 3 tips for writing and creating formulas in your VBA macros with this article and video.
Skill level: Intermediate
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
Bottom line: Learn why the number formatting for new rows of a table doesn’t always get copied down and how to fix it.
Skill level: Beginner
Bottom line: Learn how to turn the GETPIVOTDATA formulas on/off when you create a formula that references a cell inside a pivot table.
Skill level: Beginner
Bottom line: Learn how to change the date formatting for a grouped field in a pivot table.
Skill level: Intermediate
