Archive

Category Archives for "Tips"
24

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

104

Convert Text to Dates with Flash Fill – Data Cleansing Challenge

Bottom line: Learn how to convert dates stored as text to date values in Excel using Flash Fill.  There are many possible solutions to this problem, so please leave a comment below explaining the technique that you would use.

Skill level: Intermediate

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

Continue reading

37

3 Ways to Delete Entire Blank Rows + Video Tutorial

Bottom line: Learn a few ways to delete entire blank rows from a data set or table in this article and video.

Skill level: Beginner

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

Continue reading