Excel Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles and videos.

Add New Items to Drop-down Lists Automatically Thumb 640

Tables & Data, Tips, Tips & Shortcuts

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

August 13, 2018

Excel Tutorial Drop Down Lists in Cells

Tables & Data, Tips, Tips & Shortcuts

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

August 8, 2018

Macros & VBA

How to Enable the Developer Tab in Excel for Windows

July 27, 2018

Keyboard Shortcuts for Intellisense Video Thumb 2

Macros & VBA

Keyboard Shortcuts for the VBA Intellisense Drop-down Menu

July 24, 2018

Multiple Macro Buttons to Apply Filters

Macros & VBA

How to Create VBA Macro Buttons for Filters in Excel

July 19, 2018

VBA Code to Clear Filters in Excel

Macros & VBA

How to Clear Filters with VBA Macros

July 12, 2018

VBA AutoFilter Automate Color Icon Filters

Macros & VBA

How to Filter for Colors & Icons with VBA Macros in Excel

July 12, 2018

VBA AutoFilter Automate Number Filters

Macros & VBA

How to Filter for Numbers with VBA Macros in Excel

July 12, 2018

How to Filter for Blank Cells in VBA AutoFilter Method

Macros & VBA

How to Filter for Blanks and Non-Blank Cells with VBA Macros

July 12, 2018