Jon Acampora

Author Archives: Jon Acampora

Welcome to Excel Campus! I am excited you are here. My name is Jon and my goal is to help you learn Excel to save time with your job and advance in your career. I've been an avid Excel user and VBA developer for 10+ years. I am also a Microsoft MVP. I try to learn something new everyday, and want to share this knowledge with you to help you improve your skills. When I'm not looking at spreadsheets, I get outdoors and surf. :) more about me

8

How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists

Bottom Line: Learn to create dynamic data validation lists. These in-cell drop-down lists automatically expand to include new rows that are added to the source data range.

Skill Level: Intermediate

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

Continue reading

5

How to Create Drop-down Lists in Cells – Data Validation Lists

Bottom Line: The complete Excel guide on how to create drop-down lists in cells (data validation lists).  Includes keyboard shortcuts to select items, copying drop-downs to other cells, handling invalid inputs, updating lists with new items, and more.

Skill Level: Beginner

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

Continue reading

How to Enable the Developer Tab in Excel for Windows

Bottom Line: Learn how to enable the Developer tab on the ribbon so that you can access commonly used functions for Macros, VBA, and Add-ins. Works on all versions of Excel for Windows (Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Office 365).

Skill Level: Beginner

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

Continue reading

Keyboard Shortcuts for the VBA Intellisense Drop-down Menu

Bottom line: Learn two keyboard shortcuts for displaying the Intellisense menu, so you can autocomplete words in the VB editor.

Skill level: Intermediate

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

Continue reading

8

How to Create VBA Macro Buttons for Filters in Excel

Bottom line: Learn how to create macro buttons that apply filters to multiple columns in a filtered range or Table.

Skill level: Intermediate

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

Continue reading

1 2 3 19