Bottom line: Learn how to apply color and icon filters with VBA. Includes examples for filtering for font color, fill color, and conditional formatting icons.
Skill level: Intermediate
Bottom line: Learn how to apply number filters with VBA. Includes examples for filtering for a range between two numbers, top/bottom 10, above/below average, etc.
Skill level: Intermediate
Bottom line: Learn how to apply filters for blank cells with VBA. Includes examples for filtering blanks and non-blank cells using the AutoFilter method.
Skill level: Intermediate
Bottom line: Learn how to create macros that apply filters to ranges and Tables with the AutoFilter method in VBA. The post contains links to examples for filtering different data types including text, numbers, dates, colors, and icons.
Skill level: Intermediate
Bottom line: Learn how to apply date filters with VBA. Includes examples for filtering for a range between two dates, date groups from filter drop-down list, dynamic dates in period, etc.
Skill level: Intermediate
Bottom line: Learn how to apply text filters with VBA. Includes examples for filtering for multiple items, begins with, contains, wildcards, etc.
Skill level: Intermediate
Bottom Line: Learn how to select several shapes at once, including charts, slicers, images, etc. These techniques will help you save time when working with reports and dashboards that contain multiple objects on the same worksheet.
Skill Level: Beginner
Bottom line: Learn how to calculate the average of a daily total amount across month, quarters, years, or even categories with a pivot table.
Skill level: Intermediate
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
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
