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

2

VBA Assumes the Active Workbook and Active Worksheet in Excel

Bottom line: Learn 2 critical assumptions that VBA makes when running our macros in Excel, and avoid errors & disaster.

Skill level: Beginner

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

Continue reading

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

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

Continue reading

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

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

Continue reading