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

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

21

How to Calculate Daily Averages with a Pivot Table

Bottom line: Learn how to calculate the average of a daily total amount across month, quarters, years, or even categories with a pivot table.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

12

How to Arrange Panel Charts or Shape Grids in Excel with a VBA Macro

Bottom line: Learn how to quickly arrange your charts in a panel chart or shape grid layout with a VBA macro in Excel.  Applies to all types of shapes including slicers, images, charts, etc.

Skill level: Intermediate

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading

8

2 Ways to Align & Space Shapes, Charts, or Slicers + VBA Macro

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

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

Continue reading