Excel Skills Directory

Search for a value in the first column of a range and return a value in the same row from another column.

The modern, powerful alternative to VLOOKUP – faster, more flexible, and error-resistant.

Create dynamic summary tables to analyze and explore your data interactively.

Apply formatting to cells based on their values to highlight important information.

A more flexible alternative to VLOOKUP for looking up values in any direction.

Connect to, combine, and refine data from multiple sources.

Visualize your data with various chart types for better insights.

Sum values based on one or multiple criteria.

Create professional selection lists for fast and error-free data entry.

Control what data can be entered into cells to maintain data quality.

Automate repetitive tasks with recorded macros and VBA programming.