10

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

19

Create Dynamic Pivot Chart Titles with a VBA Macro

Bottom line: Learn how to automatically create more descriptive and dynamic chart titles that display the filter criteria with VBA macros.

Skill level: Intermediate

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

Continue reading

16

How to use Chart Templates for Default Chart Formatting

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

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

Continue reading

25

Excel Shortcuts to Move the Selected Range with the Arrow Keys

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

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

Continue reading

1

5 Uses for VBA Macros in Excel with Your Job

Bottom line: Learn 5 ways to use VBA macros to automate Excel tasks you do frequently at work.

Skill level: Beginner

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

Continue reading

9

3 Tips for Writing Formulas with VBA Macros in Excel

Bottom line: Learn 3 tips for writing and creating formulas in your VBA macros with this article and video.

Skill level: Intermediate

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

Continue reading

22

Why Table Number Formatting Doesn’t Copy Down and How to Fix It

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

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

Continue reading

4

How to Turn Off GETPIVOTDATA Formulas for Pivot Tables

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

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

Continue reading

1 2 3 17